Google Sheets Essentials
USD29.00
Struggling to find your way around Google Sheets and make them do the things you need? Time to dip your toes into the essentials course!
The Important Stuff
- Module 1: Filtering, Sorting and Freezing
- Module 2: Using functions to split, join and more
- Module 3: Cleaning Data
- Module 4: Conditional Formatting
- Module 5: Data Validation
- Module 6: Protecting Sheets and Ranges
- Module 7: Using the Explore tool
- Module 8: Graphs or Charts
- Module 9: Scatter Plots
- Module 10: VLookUp
- Module 11: Importing External Data
Who Is This
Course For?
- Not knowing you way around sheets
- What formulas can I use from Excel
- How to quickly draw a chart
- How to combine formulas together to v=create efficient workflows
What Will You Learn?
- This course will bring you up to speed in using the essential features of Google Sheets in your workplace.
- You will learn how to easily find things in data, how to filter your data.
- Drawing and embedding live charts in Docs.
- How to use the amazing explore tool.
- How to colour code you sheets.
- How to use more complex formulas like vlookup and how to import data from other sheets
Want More For Less?
Sign Up for Learn On Demand
#nevernotlearning
Learn On Demand
The only tech tool training subscription you’ll need to keep being awesome!-
Access to over 40 courses in a range of tech tools, including G Suite, Microsoft 365, Apple iPad + more
-
Access to a public forum to chat with like minded people who are working on their tech skills (learning together is always better)
-
Access to our Skills Checklist to identify your current skillset and where your opportunities for growth are
-
Get notified of the latest updates and new features available in the tech tools (because our team nerds out on this stuff - for real)
Learn On
Demand Plus
The only tech tool training subscription you’ll need to keep being awesome! PLUS a stack of extra bonuses.
-
Access to over 40 courses in a range of tech tools, including G Suite, Microsoft 365, Apple iPad + more
-
Access to our certified trainers through the private forum to help you out, solve tech headaches and be your sideline cheerleader
-
Access to our Skills Checklist to identify your current skillset and where your opportunities for growth are
-
Get notified of the latest updates and new features available in the tech tools (because our team nerds out on this stuff - for real)
-
Access to resource packs that are ready to download and use immediately
-
Saving the best to las... You'll also receive access to our MONTHLY LIVE CALLS where we will be delivering fresh new training and also be available for live Q & A!
Some of our FAQ's
You can choose to pay by credit card, or request an invoice that can be paid by your organisation. Select the option you require on the course payment page.
No, this is an introductory course with no prerequisites skills. It is perfect for beginners or those who have been fumbling their way through using Google Sheets!
This is not required, however it is useful for you to have a Google account that you can use to practice with the tools covered in the course. If your organisation does not provide you with a G Suite account, you may like to use a personal Google (Gmail) account.
This course is presented by the Google Certified Trainers and Google Certified Innovators that are part of the Using Technology Better Team. You can read more about us here.
Yes. You can request a certificate after completing all of the course modules.
Yes, this course is accredited with NESA. After completing the course, you can receive these hours by filling in the course feedback form and providing us with your NESA number.
Your registration includes 12 months access to the course materials.
Yes. The course platform includes a discussion forum and a private chat facility.
Yes! You might like to check out our Google Drive Deep Dive, Google Slides Deep Dive, Google Forms Deep Dive and Google Sheets Essentials or Deep Dive.
You can contact us anytime via this contact page.

Money Back
Guarantee
It’s pretty unlikely you’re going to need this. But we just want to make sure you have no excuses to join. So with this one out of the way, what are you waiting for? Sign up and let’s do this.
What Our Recent Course
Participants Have To Say
It really gets you thinking about ‘why’ you do what you do. Great to have time out from the classroom to experiment and have time to think and discuss different ideas.
Abbey Howard
Higlands Intermidiate
Thank you Mike! I really found the 4 week course on ‘How to Motivate, Manage & Engage Your Students’ really interesting and great food for thought on how to improve my class routines and student engagement.
KiKi Tsoli
Banks Town Senior College
Mike, awesome course, fantastic resources and a real wake-up for someone who considers himself technically astute but not necessarily updated!
Shaun Hardy
Technological Teacher