Course by

Adrian Francis

Wasting hours fumbling around Google Sheets is frustrating, to say the least.

With the UTB Google Sheets Deep Dive: Educator Edition course in just four hours, you could be slaying those spreadsheets with zero wasted time.

To dominate Google Sheets in the classroom; take the course.

What you'll get

4 hour on-demand video course
12 course modules
12 month access
course chat forum
accessible on any device
certificate of completion

Designed for

teachers

Do any of these statements fit the bill for you?

I don’t fully understand how to utilise features and functions in Sheets.
I would love to save time with Sheets to analyse student progress.
I want to learn tricks that I can apply to other Sheets.
I want to master aspects of Sheets so I can save by automating repetitive tasks.
I want to become efficient by utilising named ranges.
I want to build confidence using formulas to build my own sheets.
I want to create a data summary dashboard using filters and data validation.

Then this course is the right fit for you.

What you'll learn

How to build a teacher mark book that automatically allocates grades.
How to use advanced functions in Sheets to add power to your Sheets so you can chart trends in student progress.
How to use tick boxes to not only track the progress of tasks but to enable automatic formatting in your Sheets to improve workflow.
How to embed filters within pivot tables so that you can analyse data easier.
Time-saving tips and tricks that you can apply to any Sheet.

Course Modules

Introduction: Google Sheets Deep Dive (Educator Edition).
Module 1: Splitting & joining text & removing duplicates.
Module 2: Calculating percentages & automatically allocating grades using VLOOKUP.
Module 3: Calculating average marks & ranking member achievement.
Module 4: Conditional formatting, inserting images & using checkboxes to trigger conditional formatting.
Module 5: Data validation & using named ranges.
Module 6: Creating & using filters.
Module 7: Protecting sheets & ranges.
Module 8: Creating a data summary section by using data validation, VLOOKUP & match.
Module 9: Analysing data using pivot tables & slicers.
Module 10: Importing data from other Sheets.
Module 11: Automating your work with macros.
Module 12: Making your Sheets visually compelling with formatting & custom number formatting.

Course Trainer

Adrian Francis
Technology Trainer
Creative Spreadsheet Ninja

With a colourful career spanning three decades in the education sector, Adrian brings a wealth of tech know-how to the table. Armed with the knowledge of what tools to use when, and how, Adrian thrives on seeing teachers’ confidence and competence soar.

As an accredited Google Certified Trainer, Google Certified Innovator, Google Level 1 & 2 Educator Adrian enjoys helping teachers create environments where students are engaged and self-motivated, and learning outcomes are maximised.