Google Sheets Fundamentals

R5000 excluding VAT for a maximum of 20 people
R400 per person with a minimum of 6 people

Google Sheets is a powerful tool for visualising and organising data. This session focuses upskilling you in your Google Sheets skills. We explore was that you are able to protect, analyse and present data. We will also look at Google Sheets essential skills conditional formatting, data validation, filtering and filter view, formula fundamentals and more. By the end of the session, you will have a good strategy to getting on top of your data.

2 hour session

In this session we cover the following

•  Sheets layout and fundamental formatting skills
•  Sharing Sheets and managing security
•  Using machine learning with the Explore Tool
•  Visualising data by inserting and editing charts
•  Conditional formatting
•  Minimising errors with data validation
•  Viewing data with filters and filter views
•  Formula fundamentals to add to your formula bank

After the session, we give you resources!

Course Notes

Not only do you get a series of videos, you will also get access to a presentation with screenshots of what was covered in the sessions. These will make as a great visual reminder as to what you covered and any top tips that may have been shared in the session!

Video Series

Not only will you receive these notes but you will also get access to part of our new video product for 3 months, a series of videos we created to help you master these tools.

These videos cover all you need to know to continue your learning and will help you to revise concepts covered in the session at your own pace with the ability to press pause or double the speed!

Google Sheets video topics

01 Getting started with Google Sheets 12 min 25 sec
02 Formatting fundamentals in Google Sheets 7 min 04 sec
03 Formulas 101 in Google Sheets 14 min 47 sec
04 Formulas 102 in Google Sheets 11 min 08 sec
05 Visualising your data with charts 16 min 05 sec
06 Importing & Linking Data in Google Sheets 6 min 51 sec
07 Interpreting data with Pivot Tables 5 min 13 sec
08 Protected Sheets and Ranges 3 min 54 sec
09 Validating Data in Google Sheets 5 min 31 sec
10 Conditional Formatting to automate highlights 6 min 41 sec
11 Explore Tool and Macro Recording 5 min 13 sec
12 Visualising data with filters & filter views 4 min 50 sec
13 Working with images in Google Sheets 1 min 51 sec

Get a certificate!

At the end of the session, you will get a certificate to prove that you attended the course and are now a master in these tools. We look forward to joining you online!

Top Tip

Due to the nature of our sessions, we recommend that you join the session with two screens or from two devices. That way, you can see your trainer as well as work in your Drive at the same time. Alternatively, you could always split your screen. Watch this video by our EduOn department to learn how to do just that if this is how you will be joining.