
Course by
- Last updated 08/2020
- English
- English [Auto]
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.
- Course Duration : 4 hours
- Level : Intermediate, Advanced
-
Course Duration : 4 Hour(s)
-
Level : Intermediate and Advanced
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.

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.
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
Related products
-
Chromebook Essentials: Education Edition
GOOGLECourse Duration : 1.5 Hour(s)
VIEW COURSE DETAILS $120.00Level : Beginner
Add to cart -
Gmail Essentials
GOOGLECourse Duration : 1.5 Hour(s)
VIEW COURSE DETAILS $120.00Level : Beginner
Add to cart -
Learn On Demand
GOOGLECourse Duration : Hour(s)
VIEW COURSE DETAILS From: $29.00 / month with a 7-day free trialLevel : Beginner
Select options -
Google Workspace Deep Dive (Educator Edition) – BUNDLE
GOOGLECourse Duration : Hour(s)
VIEW COURSE DETAILS $179.00Level : Beginner
Add to cart

Google Sheets Deep Dive





(1 Reviews)
|enrolled students
$49.00
We are trusted by smart commpanies like






