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
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news