Try MagicTask: Your AI-Powered Task Assistant!

Google Sheets - Full Course

By - freeCodeCamp.org
Overview
Certification
Reminders

Description

Learn how to use Google Sheets to create spreadsheets and work with data. 💻 Download course files: https://drive.google.com/drive/folders/1iDnxkyh4fx_55adKMQrt0Q8u544fxenZ?usp=sharing ✏️ Course created by Barton Poulson from datalab.cc. 🔗 Check out the datalab.cc YouTube channel: https://www.youtube.com/user/datalabcc 🔗 Watch more free data science courses at http://datalab.cc/ ⭐️ Course Contents ⭐️ (Time codes coming soon.) ⌨️ Welcome ⌨️ Pictures first ⌨️ Anatomy of a spreadsheet ⌨️ Data types ⌨️ Formatting cells ⌨️ Tidy data ⌨️ Sharing files ⌨️ Sharing folders ⌨️ Entering data ⌨️ Importing data ⌨️ Copying & pasting data ⌨️ Notes ⌨️ Comments ⌨️ Chat ⌨️ Selecting & moving data ⌨️ Sorting data ⌨️ Filtering data ⌨️ Filter views ⌨️ Publishing files ⌨️ Version history ⌨️ REPT charts ⌨️ Bar charts with table data ⌨️ Bar charts with raw data ⌨️ Grouped bar charts ⌨️ Bar charts with highlighting ⌨️ Pie charts ⌨️ Histograms ⌨️ Line charts ⌨️ Timelines ⌨️ Sparklines ⌨️ Scatterplots ⌨️ Scatterplots with highlighting ⌨️ Automatic charts with Explore ⌨️ Publishing charts ⌨️ Cell references ⌨️ Counts, sums, & means ⌨️ Dates & times ⌨️ Selecting text ⌨️ Combining text & data ⌨️ Conditional formatting ⌨️ Next steps 🎉 Thanks to our Champion and Sponsor supporters: 👾 Wong Voon jinq 👾 hexploitation 👾 Katia Moran 👾 BlckPhantom 👾 Nick Raker 👾 Otis Morgan 👾 DeezMaster 👾 AppWrite -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

Course Content

Introduction Section (0 sec - 22 min)
1
22 min

Introduction Section (0 sec - 22 min)

5 Questions Ready
Main Content Section 1 (22 min - 45 min)
2
22 min

Main Content Section 1 (22 min - 45 min)

5 Questions Locked
Main Content Section 2 (45 min - 1 hour 8 min)
3
22 min

Main Content Section 2 (45 min - 1 hour 8 min)

5 Questions Locked
Main Content Section 3 (1 hour 8 min - 1 hour 31 min)
4
22 min

Main Content Section 3 (1 hour 8 min - 1 hour 31 min)

5 Questions Locked
Main Content Section 4 (1 hour 31 min - 1 hour 54 min)
5
22 min

Main Content Section 4 (1 hour 31 min - 1 hour 54 min)

5 Questions Locked
Main Content Section 5 (1 hour 54 min - 2 hour 17 min)
6
22 min

Main Content Section 5 (1 hour 54 min - 2 hour 17 min)

5 Questions Locked
Main Content Section 6 (2 hour 17 min - 2 hour 40 min)
7
22 min

Main Content Section 6 (2 hour 17 min - 2 hour 40 min)

5 Questions Locked
Final Section (2 hour 40 min - 3 hour 3 min)
8
23 min

Final Section (2 hour 40 min - 3 hour 3 min)

5 Questions Locked
AI Mentor