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.

author image

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.

Read more about Adrian

Prerequisites

This course will be most valuable to those who already have a sound understanding of Google Sheets.

Reviews

5

(1 Reviews)

5 Stars

100%

4 Stars

0%

3 Stars

0%

2 Stars

0%

1 Stars

0%

“I enjoyed the content, especially discovering how to use the pivot table, filters, slicers, and macros.”

Kavita Gounder

Secondary School Teacher

Related Training

Google Sheets Deep Dive: Educator Edition

(1 Reviews)

  |  

enrolled students

USD49.00

30-day money-back guarantee

We are trusted by smart commpanies like

Scroll to Top

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