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...
Google Sheets Charts: The Complete Guide
Dynamic Chart Range in Google Sheets
Learn how to make Google Sheets charts update automatically when you add data. Covers named ranges, ...
Format and Customize Charts in Google Sheets
Learn how to format charts in Google Sheets. Covers titles, colors, legends, gridlines, data labels,...
How to Add a Trendline in Google Sheets
Learn how to add a trendline in Google Sheets charts. Choose linear, exponential, or polynomial type...
How to Make a Bar Chart in Google Sheets
Learn how to make a bar chart in Google Sheets step by step. Covers grouped bars, stacked bars, hori...
How to Make a Combo Chart in Google Sheets
Learn how to make a combo chart in Google Sheets step by step. Combine columns and lines in one char...
How to Make a Gantt Chart in Google Sheets
Learn how to make a Gantt chart in Google Sheets using a stacked bar chart. Covers data setup, helpe...
How to Make a Histogram in Google Sheets
Learn how to make a histogram in Google Sheets to visualize frequency distributions. Step-by-step gu...
How to Make a Line Chart in Google Sheets
Learn how to make a line chart in Google Sheets step by step. Covers single and multiple series, tre...
How to Make a Pie Chart in Google Sheets
Learn how to make a pie chart in Google Sheets step by step. Covers basic pies, donut charts, percen...
How to Make a Scatter Plot in Google Sheets
Learn how to make a scatter plot in Google Sheets step by step. Covers data setup, trendlines, forma...
SPARKLINE in Google Sheets: Mini Charts in Cells
Learn how to use SPARKLINE in Google Sheets to create mini line, bar, column, and winloss charts ins...
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
Color Scale Conditional Formatting in Google Sheets
Learn how to apply color scale conditional formatting in Google Sheets. Create heat maps and gradien...
Conditional Formatting Entire Row in Google Sheets
Learn how to highlight an entire row with conditional formatting in Google Sheets. Custom formula ex...
Conditional Formatting Icons in Google Sheets
Learn how to add icons and emojis to Google Sheets using conditional formatting and formulas. Step-b...
Conditional Formatting with Dates in Google Sheets
Learn how to use conditional formatting with dates in Google Sheets. Highlight overdue dates, upcomi...
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...
Data Validation Error Messages in Google Sheets
Learn how to set up custom error messages and input messages for data validation in Google Sheets. R...
Data Validation with Custom Formula in Google Sheets
Learn how to use custom formula data validation in Google Sheets. Restrict cell input with any formu...
Date Validation in Google Sheets (Restrict Date Entry)
Learn how to restrict date entry in Google Sheets with data validation. Prevent past dates, set date...
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
Add or Subtract Days, Months, Years in Google Sheets
Learn how to add days to a date in Google Sheets and subtract days, months, or years. Includes EDATE...
Auto Timestamp When Cell Changes in Google Sheets
Learn three ways to auto timestamp when a cell changes in Google Sheets: IF+NOW formula, keyboard sh...
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...
DATEVALUE Function in Google Sheets
Learn how to use the DATEVALUE function in Google Sheets to convert text to a date. Fix text dates f...
EDATE and EOMONTH Functions in Google Sheets
Learn how to use EDATE and EOMONTH in Google Sheets to add months to a date, find end-of-month dates...
How to Format Dates in Google Sheets
Learn to format dates in Google Sheets with the Format menu, custom number formats, and the TEXT fun...
NETWORKDAYS Function in Google Sheets
Learn how to use NETWORKDAYS in Google Sheets to count business days between dates. Covers holidays,...
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...
WEEKDAY Function in Google Sheets
Learn how to use the WEEKDAY function in Google Sheets to get the day of the week as a number. Conve...
YEAR, MONTH, and DAY Functions in Google Sheets
Learn how to use YEAR, MONTH, and DAY in Google Sheets to extract date parts. Group data by year, fi...
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 Statement with Checkbox in Google Sheets
Learn how to use an IF statement with a checkbox in Google Sheets. Returns custom text based on chec...
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...
IFERROR in Google Sheets: Hide Errors Gracefully
Learn how to use IFERROR in Google Sheets to replace formula errors with custom messages or blanks. ...
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...
SWITCH Function in Google Sheets (With Examples)
Learn how to use the SWITCH function in Google Sheets to replace messy nested IFs. Includes full syn...
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
Does IMPORTRANGE Auto-Update? Sync Explained
Learn how IMPORTRANGE auto-update works in Google Sheets, how to force a refresh, and what to do whe...
Fix IMPORTRANGE Access Permission in Google Sheets
Fix the IMPORTRANGE access permission error in Google Sheets. Learn how to grant, manage, and troubl...
Fix Slow IMPORTRANGE in Google Sheets
Learn why IMPORTRANGE is slow in Google Sheets and how to speed it up. Practical fixes for loading d...
IMPORTRANGE from Multiple Tabs in Google Sheets
Import data from multiple tabs using IMPORTRANGE in Google Sheets. Stack ranges, combine tabs, and u...
IMPORTRANGE with FILTER in Google Sheets
Use IMPORTRANGE with FILTER in Google Sheets to pull only the rows you need from another spreadsheet...
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
Fix INDEX MATCH Errors in Google Sheets
Fix #N/A, #REF!, #VALUE!, and wrong results from INDEX MATCH in Google Sheets. Step-by-step troubles...
INDEX MATCH Closest Value in Google Sheets
Find the closest value in Google Sheets using INDEX MATCH. Covers nearest match with MIN ABS, next l...
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 Multiple Criteria in Google Sheets
Use INDEX MATCH with multiple criteria in Google Sheets to look up values based on two or more condi...
INDEX MATCH Return Multiple Results in Google Sheets
Use INDEX MATCH to return multiple matching results in Google Sheets. Array formulas and FILTER alte...
INDEX MATCH vs VLOOKUP in Google Sheets
Compare INDEX MATCH and VLOOKUP in Google Sheets. See when each lookup formula works best with side-...
INDEX MATCH with ARRAYFORMULA in Google Sheets
Use INDEX MATCH with ARRAYFORMULA in Google Sheets to apply a lookup formula to an entire column at ...
Left Lookup with INDEX MATCH in Google Sheets
Use INDEX MATCH for left lookups in Google Sheets. Return values from columns to the left of your se...
Two-Way Lookup with INDEX MATCH in Google Sheets
Use INDEX MATCH MATCH for two-way lookups in Google Sheets. Find values at the intersection of a row...
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 LABEL in Google Sheets: Rename Headers
Learn how to use QUERY LABEL in Google Sheets to rename column headers in your output. Syntax, step-...
QUERY Multiple Ranges in Google Sheets
Learn how to use QUERY across multiple ranges and sheets in Google Sheets. Combine data with curly b...
QUERY ORDER BY in Google Sheets (Sort Results)
Learn how to use QUERY ORDER BY in Google Sheets to sort results by one or multiple columns, ascendi...
QUERY PIVOT in Google Sheets (Pivot-Style Reports)
Learn how to use QUERY PIVOT in Google Sheets to create cross-tabulated reports. Syntax, step-by-ste...
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...
QUERY with Dates in Google Sheets (Filter, Format)
Learn how to use QUERY with dates in Google Sheets. Filter by date ranges, compare dates, format out...
QUERY with IMPORTRANGE in Google Sheets
Learn how to combine QUERY with IMPORTRANGE in Google Sheets to filter, sort, and summarize data fro...
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...
FIND and SEARCH Functions in Google Sheets
Use FIND and SEARCH in Google Sheets to locate text inside a cell. Learn the syntax, differences, wi...
LEFT, RIGHT, MID Functions in Google Sheets
Learn how to extract text with LEFT, RIGHT, and MID in Google Sheets. Pull characters from the start...
REGEXMATCH, REGEXEXTRACT, REGEXREPLACE
Use REGEXMATCH, REGEXEXTRACT, and REGEXREPLACE in Google Sheets for pattern-based text matching, ext...
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....
Split Text to Columns in Google Sheets
Split text to columns in Google Sheets using the Data menu or the SPLIT function. Step-by-step guide...
SUBSTITUTE Function in Google Sheets
Use the SUBSTITUTE function in Google Sheets to find and replace text inside formulas. Covers syntax...
TRIM & CLEAN Functions in Google Sheets
Learn how to remove extra spaces and non-printable characters in Google Sheets with TRIM and CLEAN. ...
UPPER, LOWER, PROPER Functions in Google Sheets
Change text case in Google Sheets with UPPER, LOWER, and PROPER. Convert to uppercase, lowercase, or...
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
Case-Sensitive VLOOKUP in Google Sheets
Learn how to do a case-sensitive VLOOKUP in Google Sheets using INDEX, MATCH, and EXACT. Step-by-ste...
Fix VLOOKUP Errors in Google Sheets
Fix VLOOKUP errors in Google Sheets including #N/A, #REF!, #VALUE!, and wrong results. Find the caus...
How to Combine VLOOKUP with IF in Google Sheets
Learn how to combine VLOOKUP with IF in Google Sheets. Handle errors, add conditions to lookups, and...
How to VLOOKUP Dates in Google Sheets
Learn how to VLOOKUP dates in Google Sheets. Fix date format mismatches, use DATEVALUE for text date...
VLOOKUP Approximate vs Exact Match in Google Sheets
Learn the difference between VLOOKUP approximate match (TRUE) and exact match (FALSE) in Google Shee...
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...
VLOOKUP Return Multiple Values in Google Sheets
Learn how to return multiple values with VLOOKUP in Google Sheets. Three methods: FILTER function, I...
VLOOKUP with ARRAYFORMULA in Google Sheets
Learn how to use VLOOKUP with ARRAYFORMULA in Google Sheets to fill an entire column with one formul...
VLOOKUP with Wildcards in Google Sheets
Learn how to use VLOOKUP with wildcards in Google Sheets for partial text matching. Use asterisk and...
Standalone Guides
In-depth guides on topics that stand on their own.
Absolute vs Relative References in Google Sheets
Learn the difference between absolute and relative cell references in Google Sheets. Covers the $ sign, mixed references...
Alternating Colors in Google Sheets (Zebra Stripes)
Learn how to add alternating colors in Google Sheets for easier reading. Covers built-in zebra stripes, custom colors, a...
Google Apps Script for Sheets: Beginner's Guide
Learn how to use Google Apps Script with Google Sheets. Write custom functions, automate tasks, and build menus with ste...
ARRAYFORMULA in Google Sheets: Complete Guide
Learn how to use ARRAYFORMULA in Google Sheets to apply a formula to an entire column from one cell. Step-by-step exampl...
AVERAGE, AVERAGEIF, AVERAGEIFS in Google Sheets
Learn how to use AVERAGE, AVERAGEIF, and AVERAGEIFS in Google Sheets. Covers syntax, conditional averages, multiple crit...
How to Reference Another Sheet in Google Sheets
Learn how to reference cells and ranges from another sheet tab in Google Sheets. Covers the exclamation point syntax, sp...
Conditional Formatting vs Data Validation in Google Sheets
Learn when to use conditional formatting vs data validation in Google Sheets. Covers what each does, key differences, an...
Paste Special in Google Sheets (Values, Format)
Learn how to use Paste Special in Google Sheets to paste values only, formatting, transpose, and more. Covers shortcuts,...
COUNT, COUNTA, COUNTBLANK in Google Sheets
Learn how to use COUNT, COUNTA, and COUNTBLANK in Google Sheets. Covers counting numbers, non-empty cells, blanks, and w...
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...
Find and Replace in Google Sheets (With Regex)
Learn how to use Find and Replace in Google Sheets. Covers basic search, match case, search by regex, replace across she...
FLATTEN Function in Google Sheets
Learn how to use FLATTEN in Google Sheets to combine multiple columns or ranges into a single column. Includes examples ...
Google Sheets Formulas Cheat Sheet (100+)
A quick-reference list of 100+ Google Sheets formulas organized by category. Includes syntax, one-line descriptions, and...
How to Freeze Rows and Columns in Google Sheets
Learn how to freeze rows and columns in Google Sheets to keep headers visible while scrolling. Covers freeze options, sh...
GOOGLEFINANCE Function in Google Sheets (Stock Data)
Learn how to use the GOOGLEFINANCE function in Google Sheets to get live stock prices, historical data, and currency exc...
Best Google Sheets Add-Ons
The best Google Sheets add-ons for productivity, data cleaning, reporting, and automation. Covers how to install, manage...
Google Sheets API: Read and Write Data Programmatically
Learn how to use the Google Sheets API to read and write spreadsheet data. Step-by-step setup with Python and JavaScript...
How to Use Google Sheets Offline
Learn how to use Google Sheets offline without internet. Covers setup in Chrome, editing offline, syncing changes, and t...
Google Sheets Keyboard Shortcuts Cheat Sheet
A quick-reference list of 50+ Google Sheets keyboard shortcuts for Windows, Mac, and Chromebook. Navigate, edit, format,...
Best Google Sheets Templates (Budget, Project, More)
Discover the best Google Sheets templates for budgets, project tracking, invoices, and more. Learn how to find, use, and...
Google Sheets vs Excel: Which Should You Use?
An honest comparison of Google Sheets and Excel covering pricing, collaboration, formulas, performance, and offline use....
HYPERLINK Function in Google Sheets
Learn how to use the HYPERLINK function in Google Sheets to create clickable links in cells. Covers URLs, emails, other ...
How to Insert an Image in a Cell in Google Sheets
Learn how to insert an image inside a cell in Google Sheets using the IMAGE function and the Insert menu. Covers sizing ...
How to Import CSV and Excel Files into Google Sheets
Learn how to import CSV and Excel files into Google Sheets. Covers File menu upload, IMPORTDATA for URLs, and fixing del...
INDIRECT Function in Google Sheets (Dynamic References)
Learn how to use the INDIRECT function in Google Sheets to create dynamic cell references. Covers syntax, examples with ...
LET and LAMBDA Functions in Google Sheets
Learn how to use the LET and LAMBDA functions in Google Sheets. Simplify complex formulas with named variables and creat...
Mail Merge with Google Sheets and Gmail
Learn how to do a mail merge with Google Sheets and Gmail. Send personalized emails to a contact list using Apps Script ...
MAX, MIN, LARGE, SMALL in Google Sheets
Learn how to use MAX, MIN, LARGE, and SMALL functions in Google Sheets. Find the highest, lowest, and nth-ranked values ...
How to Merge Cells in Google Sheets
Learn how to merge cells in Google Sheets with Merge all, Merge horizontally, and Merge vertically. Includes unmerge ste...
Named Ranges in Google Sheets: Create and Use Them
Learn how to create and use named ranges in Google Sheets. Replace cell references with readable names in formulas. Cove...
Custom Number Formats in Google Sheets (Guide)
Learn how to use custom number formats in Google Sheets for currency, percentages, dates, and more. Covers format codes,...
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...
How to Print Google Sheets (Fit to Page)
Learn how to print Google Sheets with gridlines, headers, and fit-to-page scaling. Covers print area, page breaks, orien...
How to Protect Sheets and Ranges in Google Sheets
Learn how to protect sheets and lock specific cell ranges in Google Sheets. Control who can edit what with permissions, ...
Remove Duplicates in Google Sheets (5 Methods)
Learn 5 ways to remove duplicates in Google Sheets. Covers the built-in tool, UNIQUE function, COUNTIF helper column, an...
ROUND, ROUNDUP, ROUNDDOWN, MROUND in Google Sheets
Learn how to use ROUND, ROUNDUP, ROUNDDOWN, and MROUND in Google Sheets. Covers syntax, rounding examples, and when to u...
How to Share Google Sheets (Permissions & Links)
Learn how to share Google Sheets with specific people, shareable links, and embed options. Covers permission levels, acc...
SORT Function in Google Sheets (Formula Guide)
Learn how to use the SORT function in Google Sheets to sort data by one or multiple columns. Covers syntax, examples, an...
TRANSPOSE in Google Sheets: Flip Rows and Columns
Learn how to use the TRANSPOSE function in Google Sheets to flip rows into columns and columns into rows. Covers the for...
UNIQUE Function in Google Sheets (Formula Guide)
Learn how to use the UNIQUE function in Google Sheets to extract distinct values from a column or range. Covers syntax, ...
How to Wrap Text in Google Sheets
Learn how to wrap text in Google Sheets so long text displays inside cells. Covers wrap, overflow, clip options, shortcu...
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