
Course by
- Last updated 08/2020
- English
- English [Auto]
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.
- Course Duration : 120 minutes
- Level : Beginner
-
Course Duration : 2 Hour(s)
-
Level : Beginner
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.
Prerequisites
This course is suited to those who have just started to explore spreadsheets and want to learn the essential skills.
Reviews
4.75





(4 Reviews)
5 Stars
75%
4 Stars
25%
3 Stars
0%
2 Stars
0%
1 Stars
0%
“Great tips and tricks to work with Google Sheets efficiently. Essential information about Google Sheets is explained very well and suitable for any user to explore.”
Kavita Gounder
Secondary School Teacher
“This course is well worth it. I now have a better understanding of what can be achieved.”
Ziyad Dizdarevic
Technical Support
“Very good and easy-to-understand instructions. If you’ve been considering this course my advice would be, go for it!”
Georgios Mitropoulos
Teacher Aide
“The presentation was clear and backed up well with visuals.”
James Wiltsher
Staff Representative
Related Training
Related products
-
Chromebook Essentials: Education Edition
GOOGLE WORKSPACECourse Duration : 1.5 Hour(s)
VIEW COURSE DETAILS $120.00Level : Beginner
Add to cart -
Learn on Demand Subscription
GOOGLE WORKSPACECourse Duration : Hour(s)
VIEW COURSE DETAILS From: $14.50 / month with a 7-day free trialLevel : Beginner
Select options -
Google Certified Educator Exam Code Level 1 (Boot Camp)
GOOGLECourse Duration : Hour(s)
VIEW COURSE DETAILS $0.00Level : Beginner
Add to cart -
Learn On Demand Plus
GOOGLE WORKSPACECourse Duration : Hour(s)
VIEW COURSE DETAILS From: $49.00 / month with a 7-day free trialLevel : Beginner
Select options

Google Sheets Essentials





(4 Reviews)
|200 enrolled students
$29.00
We are trusted by smart commpanies like






