Google Sheets Deep Dive (Educator Edition)
USD49.00
Do you want to know how to use Google sheets and organise your data and become that person that knows ‘all things spreadsheets’?
Watch this two minute course overview from your presenter and trainer, Adrian, to get an overview of the 12 modules within this course.
The Important Stuff
- Module 1: Splitting and joining text and removing duplicates so you can create email lists from a class list.
- Module 2: Calculating percentages and automatically allocating grades using vlookup to win back time.
- Module 3: Calculating average marks and ranking student achievement to easily analyse student progress.
- Module 4: Conditional formatting, inserting images to add clarity to your sheets. Learn how to insert checkboxes to automatically format cells so that you can track student progress and manage workflows.
- Module 5: Data validation so you can make drop down lists in your sheets and to correctly enter dates. Explore how named ranges can be used to help write more complex formulas and build more functional sheets.
- Module 6: Creating and customising filters to empower you analyse the data in your sheets.
- Module 7: Protecting sheets and ranges so that your data and formulas aren’t accidently changed when working collaboratively.
- Module 8: Bring more functionality to your sheet by building a customised data summary section. This helps you drill down into your data easily and brings insights into the learning journey of your students by combining skills learnt in previous modules.
- Module 9: Use pivot tables to analyse data and combine this with slicers to add more functionality to your sheets. This will help you be able to find trends in large data sets and track student progress.
- Module 10: Increase the power of your sheets by importing data from external sheets so you can add even more functionality to your sheets.
- Module 11: Add that extra spark and automation to your sheets by using macros. These will help speed up your workflow amazingly.
- Module 12: Take a bland sheet and make them look fantastic so you can visualise your data better. Also use custom number formats to visualise trends in your data even quicker.

Who Is This
Course For?
- Anyone who is feeling like they don’t fully understand how to utilise features and functions in Sheets.
- Anyone who is feeling that they want to be able to use sheets to analyse student progress.
- Anyone who wants to learn tricks that they can apply to other sheets.
- Anyone who wants to master aspects of sheets so they can automate repetitive tasks and save time.
- Anyone who creates a data summary dashboard using filters and data validation.
What Will You Learn?
- How to build a teacher markbook that automatically allocates grades.
- How to use advanced functions in sheets to add power to your sheets so you can pick trends in student progress.
- Use tick boxes to not only track the progress of tasks, but to enable automatic formatting in your sheets to improve workflow. Embed filters within pivot tables so that you can analyse data far easier.
- A bunch of time saving tips and tricks that you can apply to any sheet.
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.
This course assumes you have some basic knowledge of accessing and using Google Sheets. It is suitable for those who have only recently started using Google Sheets, and for those who have been using Google Sheets for years but are wondering if there is more they can do with it.
You will get the most value from this course if you already have access to Google Sheets. If your school or 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 Adrian Francis, a G Suite Trainer and Sheets nerd at Using Technology Better. Adrian is a Google Certified Educator, Google Certified Trainer and Google Certified Innovator. You can read more about Adrian 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 Calendar Deep Dive, Introduction to G Suite for Education, Get Efficient with Gmail the SMART Way course, Google Certified Educator Level 1 and Level 2 online boot camps.
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