Intro

Data

Visual Analysis

Anatomy

Tidy Data

Collaborate

Share

Entering Data

Importing

Paste as Plain Text

Paste Transpose

Notes

Comments

freeCodeCamp.org

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

Google Sheets - Full Course

Google Sheets - Full Course

Google Sheets - Full Course

Get Full Course Access

Highly Recommended Courses

Explore top skills

In-demand Careers

Popular Topics

Creative Skills

Business Skills

Choose your learning path