Learn Google Sheets – Full Course for Beginners

Channel:

freeCodeCamp.org

Subscribers:

10,700,000

Published on December 2, 2024 5:28:35 PM ● Video Link: https://www.youtube.com/watch?v=cWGQncQxaHI

Duration: 0:00

37,526 views

1,393

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 Huhttps://www.freecodecamp.org/ee and get a developer job: https://www.freehttps://freecodecamp.org/newsf articles on programming: https://freecodecamp.org/news