Course by

Adrian Francis

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

You could be slaying those spreadsheets with zero wasted time in just two hours with the UTB Google Sheets Essentials course.

Dominate Google Sheets; take the course.

What you'll get

  • 2 hours on-demand video course
  • 11 course modules
  • 12 month access
  • Course chat forum
  • Accessible on any device
  • Certificate of completion

Designed for

  • teachers
  • school administrators
  • school leaders
  • professionals

Do any of these statements fit the bill for you?

  • I am new to Google Sheets (or any spreadsheet tool for that matter!) and want to know what it can do to make life easier.
  • I used to use Excel, and now that I’ve moved to Google Sheets I’m struggling to adjust to the differences.
  • I am keen to learn how to use the features and formulas I liked in Excel in Google Sheets.
  • I am keen to simplify my life by developing an efficient workflow using the power of Google Sheets.

Then this course is the right fit for you.

What you'll learn

  • How to use Google Sheets’ essential features.
  • How to easily sort, filter, and freeze data to find exactly what you need.
  • How to use integrations between Google Sheets and Google Docs.
  • How to automatically colour code sheets for a quick visual interpretation.
  • How to use more complex formulas like VLOOKUP with confidence.
  • How to use the Explore tool to save time.
  • How to import data from other sheets.

Course Modules

Introduction: Google Sheets Essentials
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 Explore
Module 8: Graphs or Charts
Module 9: Scatter Plots
Module 10: Vlookup
Module 11: Importing External Data

Course Trainer

Adrian Francis
Technology Trainer
Creative Spreadsheet Ninja

With a colorful 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 teacher create environments where students are engaged and self-motivated, and learning outcomes are maximized.


This course is suited to those who have just started to explore spreadsheets and want to learn the essential skills.



(4 Reviews)

5 Stars


4 Stars


3 Stars


2 Stars


1 Stars


Google Sheets Essentials

(4 Reviews)


200 enrolled students


30-day money-back guarantee

We are trusted by smart commpanies like

Scroll to Top

Download your skills checklist to see how you score...