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

Chapters

Intro
Intro
17 sec
Data
Data
4 min
Visual Analysis
Visual Analysis
5 min
Anatomy
Anatomy
19 min
Tidy Data
Tidy Data
6 min
Collaborate
Collaborate
3 min
Share
Share
2 min
Entering Data
Entering Data
4 min
Importing
Importing
5 min
Paste as Plain Text
Paste as Plain Text
1 min
Paste Transpose
Paste Transpose
1 min
Notes
Notes
1 min
Comments
Comments
2 hour 7 min
AI Mentor