The Complete Google Sheets Course: Beginner to Advanced!

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 nested if statements and the IFS function in Google Sheets, learn how to evaluate multiple conditions and return specific results with practical examples.

Master conditional formatting in Google Sheets by building if statements, nested ifs, and ifs with custom formulas, then highlight and format cells to visualize data.

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.

Discover how pivot tables and pivot charts analyze data quickly, create instant tables and charts, and weigh the pros and cons for segmentation, cross tab analysis, and reporting.

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.

Learn to sort and filter in Google Sheets with both the old toolbar and the new sort, sortn, and filter functions, including top ten and conditional views.

Explore dynamic sorting and filtering in Google Sheets, using a mobile gaming data example to build reusable, user friendly filters and sortable views for others.

Explore visualizing data in Google Sheets with line, area, column, bar, pie, histogram, scatterplot, heat map, and geo map charts, and learn to choose visuals by your data goals.

Discover how to create and customize charts in Google Sheets, from selecting data and data ranges to inserting charts and choosing bar, pie, histogram, or geo map visuals.

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.

Master dynamic data validation and interactive dashboards in Google Sheets, using date and URL validation, checkboxes, and dynamic dropdowns for category-based analyses.

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 the iferror function cleans spreadsheets by replacing any error with a chosen value or text, using lookups, filters, and divide-by-zero scenarios to keep data tidy.

Name and use named ranges in a dumpling stand dataset. Compute total customers, dumplings, revenue, and averages like order size and tip, then prepare for vlookup and index match.

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.

Explore Google Sheets text functions join, split, and transpose to efficiently extract first and last names from a cell, using delimiters and orientation changes.

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.