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
Do any of these statements fit the bill for you?
Then this course is the right fit for you.
What you'll learn
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.
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.
This course will be most valuable to those who already have a sound understanding of Google Sheets.
Google Sheets Deep Dive
We are trusted by smart commpanies like