Zoom Logo

Excel Essentials 2.0 - Shared screen with speaker view
Dan Stillerman
01:33
Welcome everyone!
Bev Seidle
01:55
Hi from Bev from Morningside
Dan Stillerman
01:56
Where in the world are you?
Dan Stillerman
02:03
I am in Orchards JHB
COMENSA KZN
02:03
Hello From Durban
Illan Dubb
02:04
israel
collins
02:05
Hi from Centurion.
Ronald Furman
02:12
I am in London
Avi Levy
02:12
I am in Excel
Theo Snitcher
02:15
Morning All. New clean Look Avi, for Shabbos? Theo in Cape Town.
Steve Marks
02:20
Hey - Steve Marks - Morningside Sandton
Faheema
02:29
Hi there, Centurion
Kevin Olivier
02:50
Randfontein west of JHB
Colleen Herman
03:03
Cape Town, RSA
Galaxy A30
03:08
morning from Elaine Ziman Highlands North
Hayley Snoyman
03:37
hello elaine
Barry Lipman
03:50
Barry Lipman Morningside
Hayley Snoyman
03:52
im in sunningdale
Ronald Furman
04:02
london
Gail Sinai
04:06
Gail :: Glenhazel
Shad Abdul Wahid
04:06
Shad from Saudi Arabia
Riska Kooiker
04:41
Tried to download the video but I couldn't save it
Firoze
04:48
Firoze in River Club
Avi Levy
04:57
Hi Emelda - welcome!
Avi Levy
05:10
From wework?
Avi Levy
05:49
Probably only possible to post recordings on our website I think
Avi Levy
05:58
There will be 1 file towards the end
Avi Levy
06:50
It is recorded - and might be better to watch that session first before today's session. Then you can do today's session via the recording
Avi Levy
07:04
We do them in depth in Excel 202 - and we will do a taste today!
Jonas Holtermann
08:00
Cologne, Germany
Dean Furman
08:05
Hi Guys, Dean in JHB
sandra ellis
08:17
sandra melrose jhb
Taryn Seidle
08:29
Taryn from London 👋
Dan Stillerman
00:08:41
Recording from Wednesday:https://www.excelacademyinc.com/essentials-recording
Dore’ Kleinberger
08:42
Hi Dore’ from Cape Town
Shmuklers!
08:42
hello from The Gardens
Dan Stillerman
00:10:55
Please share this with people:NEW Zoom Link: https://zoom.us/j/97735160730NEW Webinar ID: 977-3516-0730No password required:
Dan Stillerman
11:35
Thanks Robyn your no is missing a digit
Dan Stillerman
11:41
Please WhatsApp me on 0741416275
Dan Stillerman
12:01
We'll give you a way to download it shortly
Dan Stillerman
00:14:19
Undo:Ctrl + Z
Dan Stillerman
00:14:51
Welcome to those of you who have just joined!
Dan Stillerman
00:15:07
We are just doing a quick recap of Wednesday's session
Dan Stillerman
17:59
Thanks
MILNERE
21:24
*
heatherrush
21:28
*
Dhanveer Tauckoor
21:29
Asterisk
Hayley Snoyman
21:30
asterix
Colleen Herman
21:32
*
Bev Seidle
21:34
Above 8
Dan Stillerman
22:14
Haha yip!
lisa
23:35
A gregle appears in the top left corner of a cell - what is this?en trial
Dan Stillerman
00:23:37
Edit the cell contents:F2
lisa
24:04
A green triangle appears in the top left corner of cell - what does this mean?
Dan Stillerman
00:28:15
Activate or deactivate the Total Row:Ctrl + Shift + T
Dan Stillerman
00:31:21
Insert today's date:Ctrl + ;
Dan Stillerman
31:32
Yes! Well spotted
Dan Stillerman
31:51
The SUBTOTAL function has the flexibility to handle different calculations
Dan Stillerman
33:10
You need to redo the fill
Dan Stillerman
33:35
Turn the Total Row on and off
Dan Stillerman
34:01
Or insert a column to the left of the table and use that for the word "Total"
Hayley Snoyman
37:21
yes
Dan Stillerman
37:30
Probably till 30 April
Dan Stillerman
37:50
Great idea to be taking notes! :)
Dan Stillerman
38:07
We've got a cool cheat sheet for you as well - stay tuned
Dan Stillerman
39:26
Quite challenging!
Dan Stillerman
40:55
Thank you Robyn!
Dan Stillerman
42:03
Yes absolutely, or post in the Q&A section
Dan Stillerman
47:36
We'll post shortly
Dan Stillerman
00:48:14
Please note: You can access ALL of our recent webinar recordings here:https://www.excelacademyinc.com/ea-recordings
lisa
50:13
PLEASE SHOW US HOW TO PRINT - tx
Ronald Furman
53:18
this is brilliant
Dan Stillerman
53:37
Yes!
Dan Stillerman
55:46
Our pleasure!
Dan Stillerman
59:05
Yes! You go to Page Setup and click on "Sheet" and then "Rows to repeat at the top"
Dan Stillerman
59:13
Thanks Bern will do
MILNERE
59:30
format, custom and make it 10 zeros
MILNERE
59:52
Evan
Theo Snitcher
01:02:13
The leading 0 is awesome , what a win!!!!!
Colleen Herman
01:02:42
love the leading 0 formatting
lisa
01:02:45
What does it mean of there is a green triangle at top left of cell?
Dan Stillerman
01:03:16
All Recent recordings:https://www.excelacademyinc.com/ea-recordings
Ronald Furman
01:03:18
you guys are great. thanks
Riska Kooiker
01:03:50
Share this link on WhatsApp
Riska Kooiker
01:03:57
Group
Avi Levy
01:05:18
After about week, yes!
Avi Levy
01:07:12
80% discount is very generous for all types of people - if not, email info@excelacademy.co.za and we'll see if we can help
Avi Levy
01:09:04
We're on our own!
Sharon
01:09:48
Brilliant presentation, will look at previous presentations.
Avi Levy
01:11:15
1. Email us here for more info on our workshops:info@excelacademy.co.za2. Click here to sign up to our HOME Bootcamp:HOME Bootcamp:https://bit.ly/HOMEBootcamp803. If you want to sign up to any of our online workshops:https://www.excelacademyinc.com/plans-and-pricing80% Discount code: EXCELATHOME4. Click here to join our Admin only Excel Academy Lockdown WhatsApp group for updates:https://chat.whatsapp.com/Dp3vBTzGTgC5KLijV7ZWw
Avi Levy
01:17:43
CTRL + SPACEBAR ----> SELECT ENTIRE COLUMN
Avi Levy
01:21:11
Correct!
Avi Levy
01:21:49
It can be - just takes some work!
Avi Levy
01:22:29
oh - sorry!
Avi Levy
01:22:40
Yeah it was from last night's webinar, sorry!
Avi Levy
01:27:16
Apologies - that is not our intention...
Avi Levy
01:29:47
Sorry Robin!
Avi Levy
01:33:08
1. Email us here for more info on our workshops:info@excelacademy.co.za2. If you want to sign up to any of our online workshops:https://www.excelacademyinc.com/plans-and-pricing80% Discount code: EXCELATHOME3. Click here to join our Admin only Excel Academy Lockdown WhatsApp group for updates:https://chat.whatsapp.com/Dp3vBTzGTgC5KLijV7ZWw
Vivienne Press
01:33:56
Thanks so much., Dan and Avi