Learn Google Sheets – Full Course for Beginners

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

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

--

[EamonnCottrell]

Grateful to give back to the freeCodeCamp community. Hope this is helpful for you!

[hq]

I just started my google analytics certification course and this could not have came at a better time.

[jortor]

One for Excel and btw ur all videos are helpful that got me into Google and am a ex-Amazon, ex-Microsoft

[LazerEyeX_X]

My office uses sheets.
This was very helpful.
Hope to get one on Excel as well.

[giveaway]

i just completed this, it was awesome.

[TheYou]

Just a small recommendation to you guys, try to do some kind of collaboration with Dr Jonas Birch, and maybe bring some low-level language tutorial for Assembly Language, or say "Learn GHIDRA and Assembly for malware detection", something like that.

[kssthmn]

Very much appreciate the course.

I have to say though this dude's voice was difficult to endure

[sallysally]

If you compare MS XCEL with GS which is better.

[holdmeon]

Thanks for the video, the next stop is how to integrate ai with the table

[NamritaSingh-zb]

Nice video, can you make a video on novartis, it is organizing a challenge called NEST & hiring students through it

[kssthmn]

15:06 forgot the 'shift' text

[KushalSaxena-my]

When you are soo desperate to launch content but nothing comes up related to coding 😅

[vinayteja]

💯 it is helpful to us, thankyou so much ❤🙏🏻🫰
Do more like this...