Google Sheets - Learn the useful stuff in 30 minutes or less (Full Course)

Learn how you can conquer formulas, charts, and pivot tables. Oh my!
Let's get it started in here! ... with freeze frames and formulas
Introduction
1 min
Spreadsheet Basics
4 mins
Using Formulas
3 mins
Worksheet
Splitting and Filtering
Splitting comma separated strings into columns
2 mins
Using filters and saving them as 'views'
2 mins
Combining two datasets
Introducing the index match formula
2 mins
Index Match... revisited
3 mins
Conditional Formatting
Color code a todo list implemented as a spreadsheet
3 mins
Highlight duplicate items
5 mins
Pivot Tables and Charts
Use a Pivot table to count occurrences
1 min
Use a Pivot table for real (i.e. when you have "types" in your data set)
2 mins
Publishing Charts
2 mins
All Done!
Conclusion
1 min
Bonus Lectures
Bonus: Publish Google Analytics Charts (external video)
1 min
Bonus: Creating a survey in Google Sheets
4 mins
Bonus: Splitting Birthday Party costs fairly
5 mins