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...
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-...
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...
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...
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...
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 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 ...
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...
Looking for a specific formula?
Browse the Function Reference