Google Sheets - Advanced

Learn named ranges in Google Sheets, assign names to cell ranges, and use them in formulas for readability and navigation, with syntax rules like starting with a letter or underscore.

Demonstrates building an if statement in Google Sheets to calculate commissions: use a logical test for greater than or equal to 2 million to apply 3%, else 2%, with autofill.

Learn to use and and or with if in Google Sheets to test conditions. Nest functions to decide city bonuses based on sales and CEU thresholds, producing yes or no.

Learn how to build nested if statements and use the ifs function in google sheets to implement tiered commissions with descending thresholds, using classic and ifs approaches.

Explore how sumif, countifs, averageif, maxifs, and minifs compute totals, counts, and averages by line criteria in Google Sheets, with named ranges and optional pivot tables.

Explore three text-joining functions in Google Sheets: concat, concatenate, and textjoin. Learn how each differs, including delimiters and ignoring blanks, to combine names and data efficiently.

Discover how the Len function returns the number of characters in a text string and supports data validation and length checks. See examples counting characters in employee codes and emails.

Clean data in Google Sheets by removing duplicates and trimming whitespace. Highlight the range, remove duplicates by employee name and shirt size, and trim whitespace to ensure 17 unique values.

Learn to calculate tenure and remaining workdays in Google Sheets using year frac and net work days, accounting for holidays and absolute references, and compare calendar days to work days.

Learn to apply conditional formatting in google sheets, using a single color, color scales, and custom formulas to highlight low stock, out-of-stock items, and total thresholds.

Master grouping and ungrouping in Google Sheets to collapse or expand columns and rows, keeping related data together and making totals easier to read.

Discover how macros automate repetitive tasks in Google Sheets by recording actions and replaying them, then learn where to find and use the recorder.

Record and save a macro in Google Sheets to apply uniform formatting using absolute references, then replay it on weeks 23, 24, and 25.