freecodecamporg 2 years ago
Learn to code for free #Web Development

Full Course | Google Sheets

Learn how to use Google Sheets to create spreadsheets and work with data.

Course created by Barton Poulson from datalab.cc.


COURSE CONTENTS

⌨️ 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


💻 Download course files:

https://drive.google.com/drive/folders/1iDnxkyh4fx_55adKMQrt0Q8u544fxenZ




freeCodeCamp.org
7.21M subscribers