Learn Google Sheets – Full Course for Beginners

Post Content

In this project-based Google Sheets course from @EamonnCottrell you’ll learn the fundamentals of Google Sheets. By the end of the course, you’ll learn:
⟿ navigation
⟿ sharing
⟿ collaboration
⟿ functions
⟿ custom formulas
⟿ conditional formatting
⟿ dropdown lists
⟿ data validation
⟿ advanced function combinations
⟿ data visualization and charts

Grab the course spreadsheet here: https://docs.google.com/spreadsheets/d/1GCpuy607uIK_B0-uS6WZI-6IOA3Wk9wr6ewygbY1GFw/template/preview

Contents:
(0:00:00) Course Overview
(0:00:59) Module 1 – Interface
(0:02:20) Navigation
(0:07:31) Toolbar
(0:10:09) Collaboration
(0:13:29) Module 2 – Categories Table
(0:15:55) Import Data
(0:18:03) Basic Functions
(0:22:53) Balance Formula
(0:29:56) Module 3 – Formatting
(0:31:08) Table Format
(0:32:45) Conditional Formatting
(0:37:27) Module 4 – Data Intro
(0:38:25) Dropdowns
(0:44:57) Module 5 – Advanced Functions
(0:46:11) Type Column
(0:52:40) Filtering
(0:56:27) Slicers
(0:58:48) Search Bar
(1:02:13) Module 6 – Data Visualization
(1:03:27) Balance IF Column Cleanup
(1:05:36) Pie Chart
(1:11:10) Column Chart
(1:16:48) Line Chart
(1:21:56) Module 7 – Apps Script
(1:23:17) Custom Functions
(1:29:14) Custom Menu
(1:34:31) Got Sheet

Thanks to our Champion and Sponsor supporters:
Drake Milly
Ulises Moralez
Goddard Tan
David MG
Matthew Springman
Claudio
Oscar R.
jedi-or-sith
Nattira Maneerat
Justin Hual