Learn how to use built-in functions like sum, average, product, quotient, and count in Google Sheets, starting with the essential equal sign and range inputs.

Explore the new raw data tab format in Google Sheets, understand why large datasets become practice data ranges for analysis, pivot tables, and best practices for separating raw data.

Explore building pivot tables to analyze Amex customer data by day, calculating total orders, unique customers, average purchase price, gross revenue, and average cost per order to reveal trends.

This lecture demonstrates creating amazing visuals in Google Sheets, including geo heat maps, population maps, column and bar charts, and histograms with color scales and buckets.

Practice data validation in Google Sheets, validating dates, URLs, and a checkbox to-do list, with optional progress; then apply what-if analyses and a dropdown filter for dynamic data slicing.

Learn to identify and fix common Google Sheets errors, from hash tag errors to divide by zero, practice with lookups, and use the if error function to keep spreadsheets pristine.

Learn how to use vlookup and hlookup in Google Sheets to pull the year moved in and rent increase for housing data, with examples using named ranges and exact matches.

Learn how to combine text in Google Sheets using concatenate, cat, and ampersand, and master upper, lower, and proper casing for clean titles and sentences.

Master the trim function in Google Sheets to remove leading and trailing spaces, then split, transpose, and join with a bar delimiter before sorting data.

Explore date functions in Google Sheets, including today, day, month, year, weekday, and end of month, and learn to apply edate and eomonth for monthly date calculations.

Create an interactive Google Sheets calendar using date functions such as today and today plus one, with filter and join to map to-dos like dentist visits, doctor appointments, and holidays.