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