Spreadsheet Basics! What are they and how do they work?
  • Introduction: MANDATORY PLEASE READ
  • Pre-Work: Creating a Google Drive Account
  • Pre-Work: Creating a copy of my Spreadsheet Templates!
  • Spreadsheet Basics! What are they and how do they work?
  • Toolbar Walkthrough
  • Data Types in a Spreadsheet
  • Navigating Spreadsheets with Shortcuts!
  • Simple Formatting Tricks - Beautify your Spreadsheets!
Introduction to Functions!
  • Get Familiar with SUM, COUNT, AVERAGE, & MORE!
  • More Simple Functions: COUNTA, MIN & MAX
  • Intro to Activity: Your First Day at the Dumpling Stand
  • Solution to Activity: Your First Day at the Dumpling Stand
Conditional Functions
  • The IF Statement
  • AND/OR Statements
  • Nesting IF Statements & the IFS Statement
  • Solution to Activity & Crash Course in Conditional Formatting!
  • Conditional Arithmetic Functions (ie. SUM + IF)
  • HW Problem Solution & Wrap Up
Pivot Tables, Sorting, and Filtering!
  • Introduction to Raw data and the new Section Format
  • Crash Course in Pivot Tables Part I
  • Crash Course in Pivot Tables Part II
  • Intro to Activity: Building a Pivot Table for the Dumpling Business
  • Sorting & Filtering Part I
  • Sorting & Filtering Part II
  • Sorting & Filtering Part III
  • NOTE: There is a small error in the next lecture!
  • Solution to Activity: Sorting & Filtering!
  • Wrapping Up: Cool Applications of Sort & Filter
Charts & Graphs: Visualizing Data in Spreadsheets!
  • Intro to Charts & Graphs
  • Creating Charts in Google Sheets
  • Intro to Activity: Creating AMAZING Visuals
  • Solution to Activity: Creating AMAZING Visuals
Data Validation & an Introduction to Dynamic Models
  • What is Data Validation?
  • Data Validation: Hands on Activities
  • Creating Basic Dynamic Models
  • Intro to Activity: Beginner Data Validation & Intermediate Modeling
  • Solution to Activity: Beginner Data Validation & Intermediate Modeling
Errors, IFERROR, and creating Named Ranges
  • Every error you need to know, and how to fix 'em
  • The IFERROR formula. A machine to keep your spreadsheets clean!
  • Named Ranges - Prehabbing before you mess up your formulas!
  • Activity with Solutions - Another Day at the Dumpling Stand!
The Infamous VLOOKUP, Lookups, and INDEX(MATCH(),MATCH())
  • Let's get into the VLOOKUP Function! Also HLOOKUP...I guess
  • Activity: Housing Info with VLOOKUP & HLOOKUP
  • The BEST Lookup Formula! (INDEX(MATCH()MATCH()))
  • Activity: Finding Information with VLOOKUP & INDEX(MATCH,MATCH())
Working with Text Functions: Becoming a Wordsmith!
  • Introduction to Text Functions: Adding words together and changing their case!
  • Using LEFT, RIGHT, LEN and more to extract characters from cells!
  • Activity: Extracting First & Last Names from a cell!
  • TRIM & Final Activity with Solutions!
Date & Time Functions
  • Simple, but essential date & time functions: TODAY & NOW!
  • Date Functions Continued! EDATE, EOMONTH, and MORE!
  • Exercise Solution: The Countdown Clock!
  • Synthesizing Sections: An Interactive Calendar
Rounding & Randomizing: Keeping your spreadsheets SPICY!
  • Randomizing using RAND & RANDBETWEEN!
  • Rounding Out the Numbers with ROUND, ROUNDUP, and ROUNDDOWN!
  • Activity Intro: Build a Meal Randomizer!
  • Activity Solutions: Build a Meal Randomizer!
Stock Picking & Real-time Translators with GOOGLEFINANCE & GOOGLETRANSLATE!
  • Introduction to GOOGLEFINANCE: Get Stock Information INSTANTLY!
  • Introduction to GOOGLETRANSLATE: Become a Polyglot!
  • Activity: Creating the Stock Picker & Translator!
The Final Quest: IMPORTRANGE & QUERY!
  • Pull Spreadsheets together from ALL OVER the Google sheets universe!
  • CRASH Course in SQL! Introduction to SQL jargon and logic!
  • Building QUERY() in your Spreadsheet!
  • Mixing QUERY() with IMPORTRANGE(): Achieve Greatness.
  • QUERY() with IMPORTRANGE() Activity: Apply EVERYTHING to Analyze some Data!
  • The Final Lecture: Create Cell References within QUERY()!