Excel Essentials 2.0 - Shared screen with speaker view
Hi from Bev from Morningside
Where in the world are you?
I am in Orchards JHB
Hello From Durban
Hi from Centurion.
I am in London
I am in Excel
Morning All. New clean Look Avi, for Shabbos? Theo in Cape Town.
Hey - Steve Marks - Morningside Sandton
Hi there, Centurion
Randfontein west of JHB
Cape Town, RSA
morning from Elaine Ziman Highlands North
Barry Lipman Morningside
im in sunningdale
Gail :: Glenhazel
Shad Abdul Wahid
Shad from Saudi Arabia
Tried to download the video but I couldn't save it
Firoze in River Club
Hi Emelda - welcome!
Probably only possible to post recordings on our website I think
There will be 1 file towards the end
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
We do them in depth in Excel 202 - and we will do a taste today!
Hi Guys, Dean in JHB
sandra melrose jhb
Taryn from London 👋
Recording from Wednesday:https://www.excelacademyinc.com/essentials-recording
Hi Dore’ from Cape Town
hello from The Gardens
Please share this with people:NEW Zoom Link: https://zoom.us/j/97735160730NEW Webinar ID: 977-3516-0730No password required:
Thanks Robyn your no is missing a digit
Please WhatsApp me on 0741416275
We'll give you a way to download it shortly
Undo:Ctrl + Z
Welcome to those of you who have just joined!
We are just doing a quick recap of Wednesday's session
A gregle appears in the top left corner of a cell - what is this?en trial
Edit the cell contents:F2
A green triangle appears in the top left corner of cell - what does this mean?
Activate or deactivate the Total Row:Ctrl + Shift + T
Insert today's date:Ctrl + ;
Yes! Well spotted
The SUBTOTAL function has the flexibility to handle different calculations
You need to redo the fill
Turn the Total Row on and off
Or insert a column to the left of the table and use that for the word "Total"
Probably till 30 April
Great idea to be taking notes! :)
We've got a cool cheat sheet for you as well - stay tuned
Thank you Robyn!
Yes absolutely, or post in the Q&A section
We'll post shortly
Please note: You can access ALL of our recent webinar recordings here:https://www.excelacademyinc.com/ea-recordings
PLEASE SHOW US HOW TO PRINT - tx
this is brilliant
Yes! You go to Page Setup and click on "Sheet" and then "Rows to repeat at the top"
Thanks Bern will do
format, custom and make it 10 zeros
The leading 0 is awesome , what a win!!!!!
love the leading 0 formatting
What does it mean of there is a green triangle at top left of cell?
All Recent recordings:https://www.excelacademyinc.com/ea-recordings
you guys are great. thanks
Share this link on WhatsApp
After about week, yes!
80% discount is very generous for all types of people - if not, email firstname.lastname@example.org and we'll see if we can help
We're on our own!
Brilliant presentation, will look at previous presentations.
1. Email us here for more info on our workshops:email@example.com. 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
CTRL + SPACEBAR ----> SELECT ENTIRE COLUMN
It can be - just takes some work!
oh - sorry!
Yeah it was from last night's webinar, sorry!
Apologies - that is not our intention...
1. Email us here for more info on our workshops:firstname.lastname@example.org. 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
Thanks so much., Dan and Avi