All Tutorials
Every Google Sheets tutorial on Sheets Bootcamp, organized by topic. Start with a pillar guide for the full picture, then dive into specific techniques.
Google Sheets Charts: The Complete Guide
Learn how to create charts in Google Sheets with bar, line, pie, and combo chart examples. Covers chart types, SPARKLINE formulas, and custo...
Conditional Formatting in Google Sheets: Guide
Learn how to use conditional formatting in Google Sheets to highlight cells by value, color-code data, and create custom formula rules. Step...
Conditional Formatting in Google Sheets: Guide
Conditional Formatting Entire Row in Google Sheets
Learn how to highlight an entire row with conditional formatting in Google Sheets. Custom formula ex...
Custom Formula in Conditional Formatting (Google Sheets)
Learn how to write custom formula rules for conditional formatting in Google Sheets. Covers relative...
Format Cells Based on Another Cell (Google Sheets)
Learn how to use conditional formatting based on another cell in Google Sheets. Step-by-step custom ...
Highlight Duplicates in Google Sheets (Easy Guide)
Learn to highlight duplicate values in Google Sheets with conditional formatting and COUNTIF. Find d...
Data Validation in Google Sheets: Complete Guide
Learn how to use data validation in Google Sheets to create dropdown lists, restrict input, add checkboxes, and write custom rules. Step-by-...
Data Validation in Google Sheets: Complete Guide
Checkboxes in Google Sheets: Complete Guide
Learn how to insert a checkbox in Google Sheets and use it in formulas. Count, filter, and format ro...
Create a Drop-Down List in Google Sheets
Learn how to create a dropdown list in Google Sheets with data validation. Restrict input, reduce er...
Dependent Drop-Down Lists in Google Sheets
Create dependent dropdown Google Sheets lists using INDIRECT and named ranges. Change one dropdown a...
Date Functions in Google Sheets: Complete Guide
Learn how to use date functions in Google Sheets to calculate age, tenure, deadlines, and business days. Examples with TODAY, DATEDIF, EDATE...
Date Functions in Google Sheets: Complete Guide
DATEDIF in Google Sheets: Calculate Days Between Dates
Learn how to use DATEDIF in Google Sheets to calculate days between dates, age from birthdate, and t...
TODAY and NOW Functions in Google Sheets
Learn how to use the TODAY function in Google Sheets to calculate age, tenure, and days until a dead...
Google Sheets IF Function: Complete Guide
Learn how to use the IF function in Google Sheets with step-by-step examples. Covers syntax, nested IF, IF with AND/OR, common errors, and b...
Google Sheets IF Function: Complete Guide
COUNTIF and COUNTIFS in Google Sheets
Learn how to use COUNTIF and COUNTIFS in Google Sheets to count cells by condition. Covers compariso...
IF with AND and OR in Google Sheets
Learn how to use IF with AND and OR in Google Sheets to test multiple conditions. Step-by-step examp...
IFS Function in Google Sheets (With Examples)
Learn how to use the IFS function in Google Sheets to evaluate multiple conditions without nesting. ...
Nested IF in Google Sheets (with Examples)
Learn how to write nested IF statements in Google Sheets. Covers multi-tier classification, letter g...
SUMIF and SUMIFS in Google Sheets
Learn how to use SUMIF and SUMIFS in Google Sheets to add values based on one or multiple conditions...
IMPORTRANGE in Google Sheets: Complete Guide
Learn how to use IMPORTRANGE in Google Sheets to pull data from other spreadsheets. Covers syntax, access permissions, errors, and combining...
IMPORTRANGE in Google Sheets: Complete Guide
Fix IMPORTRANGE Access Permission in Google Sheets
Fix the IMPORTRANGE access permission error in Google Sheets. Learn how to grant, manage, and troubl...
VLOOKUP with IMPORTRANGE in Google Sheets
Combine VLOOKUP with IMPORTRANGE to look up values from another Google Sheets spreadsheet. Step-by-s...
INDEX MATCH in Google Sheets: Complete Guide
Learn how to use INDEX MATCH in Google Sheets to look up values in any direction. Covers syntax, left lookups, multiple criteria, and common...
INDEX MATCH in Google Sheets: Complete Guide
INDEX MATCH for Beginners in Google Sheets
Learn INDEX MATCH in Google Sheets with this beginner tutorial. Step-by-step guide covering MATCH po...
INDEX MATCH vs VLOOKUP in Google Sheets
Compare INDEX MATCH and VLOOKUP in Google Sheets. See when each lookup formula works best with side-...
Google Sheets QUERY Function: Complete Guide
Learn how to use the QUERY function in Google Sheets to filter, sort, and summarize data. Step-by-step examples with SELECT, WHERE, and GROU...
Google Sheets QUERY Function: Complete Guide
QUERY GROUP BY in Google Sheets (Summarize Data)
Learn how to use QUERY GROUP BY in Google Sheets to summarize data with SUM, COUNT, AVG, MIN, and MA...
QUERY SELECT in Google Sheets: Choose Columns
Learn how to use QUERY SELECT in Google Sheets to pick specific columns, reorder them, and use aggre...
QUERY WHERE Clause in Google Sheets
Learn how to use the QUERY WHERE clause in Google Sheets to filter rows by text, numbers, dates, and...
Text Functions in Google Sheets: Complete Guide
Learn how to use text functions in Google Sheets to clean, combine, and extract data. Covers TRIM, PROPER, SPLIT, SUBSTITUTE, and more with ...
Text Functions in Google Sheets: Complete Guide
CONCATENATE & TEXTJOIN in Google Sheets
Learn how to combine text from multiple cells in Google Sheets using CONCATENATE, the ampersand oper...
SPLIT Function in Google Sheets (With Examples)
Learn how to use the SPLIT function in Google Sheets to separate text into columns by any delimiter....
VLOOKUP in Google Sheets: Complete Guide
Learn how to use VLOOKUP in Google Sheets with step-by-step examples. Master syntax, fix common errors, and explore alternatives.
VLOOKUP in Google Sheets: Complete Guide
Fix VLOOKUP Errors in Google Sheets
Fix VLOOKUP errors in Google Sheets including #N/A, #REF!, #VALUE!, and wrong results. Find the caus...
VLOOKUP for Beginners in Google Sheets
Learn VLOOKUP in Google Sheets from scratch with this step-by-step beginner tutorial. Covers syntax,...
VLOOKUP from Another Sheet in Google Sheets
Pull data from another sheet or tab using VLOOKUP in Google Sheets. Step-by-step guide covering shee...
VLOOKUP Multiple Criteria in Google Sheets
Learn how to use VLOOKUP with multiple criteria in Google Sheets. Two proven methods with step-by-st...
Standalone Guides
In-depth guides on topics that stand on their own.
FILTER Function in Google Sheets: Complete Guide
Learn how to use the FILTER function in Google Sheets to extract rows matching conditions. Covers multiple criteria, AND...
Pivot Tables in Google Sheets: Beginner's Guide
Learn how to create a pivot table in Google Sheets. Summarize data by category with SUM, COUNT, and AVERAGE. Step-by-ste...
XLOOKUP in Google Sheets: Complete Guide
Learn how to use XLOOKUP in Google Sheets with step-by-step examples. Covers syntax, reverse lookups, wildcards, approxi...
Looking for a specific formula?
Browse the Function Reference