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.

Learn to tally non empty cells with the count function and count to function, including text labels, then identify the smallest and largest values with min and max.

Apply Google Sheets functions to analyze a dumpling stand’s first day sales, using sum and nested formulas to synthesize data and answer practical questions.

Learn to analyze a dumpling stand dataset with Excel functions such as sum, average, min, max, and count, apply currency formatting, lock cell references, and calculate costs and workday length.

Learn the if statement in google sheets, a logical formula that tests a condition and returns a value, using true/false cases, quotas, and nested ifs.

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.

Learn to analyze data with multiple criteria in Google Sheets using ifs, averageifs, and countifs, applying them to real examples like hot, cold, and perfect days and dynamic unit conversion.

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.

Create geo type charts, heat maps, bar and column charts from world population data to visualize 2017 changes and histograms of percent changes across 25 countries.

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.

Build dynamic models in Google Sheets with dropdowns to slice data by state, region, and credit card, using data validation to yield unique values and compute counts, averages, and revenue.

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 ranges in Google Sheets to pre tab before rehabbing, reducing mistakes by using consistent range names like range one, range two, and range three in your formulas.

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.

Master VLOOKUP and HLOOKUP in Sheets by locating values across rows or columns using a lookup value, range lookup, index, and exact match; handle errors with if error.

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.

Discover how to use left, right, len, find, and search to extract characters from cells and split names into first and last names using space as the delimiter.

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.

Use today and now functions in Google Sheets to get dates and times, to calculate days since an event. Extend these to future dates, to-do lists, deadlines, and revenue-per-day calculations.

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 a countdown clock in Google Sheets by calculating days, hours, and minutes from now, applying rounding and mod logic, and enabling refresh with a checkbox and data validation.

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.