All Tutorials

Compare Google Sheets courses: free options from Google, Coursera and LearnFree, paid ones from Udemy and Ben Collins, plus a free 9-part syllabus.

How to use TEXTJOIN in Google Sheets. Delimiter first, TRUE to skip blanks, then the pieces. Join a whole column into one cell and avoid double delimiters.

Learn how to format charts in Google Sheets. Covers titles, colors, legends, gridlines, data labels, and fonts to make your charts clear and professional.

Learn how to use EDATE and EOMONTH in Google Sheets to add months to a date, find end-of-month dates, and build billing and review schedules.

Learn how to use NETWORKDAYS in Google Sheets to count business days between dates. Covers holidays, custom weekends with NETWORKDAYS.INTL, and SLA tracking.

Learn how to use the WEEKDAY function in Google Sheets to get the day of the week as a number. Convert to day names, detect weekends, and build schedules.

Learn how to use VLOOKUP with wildcards in Google Sheets for partial text matching. Use asterisk and question mark wildcards with real examples.

Learn how to make a scatter plot in Google Sheets step by step. Covers data setup, trendlines, formatting, and when scatter charts work best.

Learn how to make a Gantt chart in Google Sheets using a stacked bar chart. Covers data setup, helper formulas, formatting, and project timeline tips.

Learn how to make a combo chart in Google Sheets step by step. Combine columns and lines in one chart to compare category breakdowns with overall trends.

Learn how to make Google Sheets charts update automatically when you add data. Covers named ranges, whole-column references, and OFFSET formulas.

Learn how to wrap text in Google Sheets so long text displays inside cells. Covers wrap, overflow, clip options, shortcuts, and auto-resize tips.

Learn how to VLOOKUP dates in Google Sheets. Fix date format mismatches, use DATEVALUE for text dates, and look up date ranges with step-by-step examples.

Learn how to combine VLOOKUP with IF in Google Sheets. Handle errors, add conditions to lookups, and switch ranges dynamically with examples.

Learn how to return multiple values with VLOOKUP in Google Sheets. Three methods: FILTER function, INDEX MATCH array, and helper column approach.

Learn how to make a pie chart in Google Sheets step by step. Covers basic pies, donut charts, percentage labels, exploded slices, and when to avoid pie charts.

Learn how to make a line chart in Google Sheets step by step. Covers single and multiple series, trendlines, dual axes, and formatting for clear trends.

Learn how to make a bar chart in Google Sheets step by step. Covers grouped bars, stacked bars, horizontal layout, customization, and formatting tips.

Learn how to add days to a date in Google Sheets and subtract days, months, or years. Includes EDATE for months, DATE for years, and deadline patterns.

Learn to format dates in Google Sheets with the Format menu, custom number formats, and the TEXT function. Includes all format codes and common fixes.

Learn how to extract text with LEFT, RIGHT, and MID in Google Sheets. Pull characters from the start, end, or middle of any cell with step-by-step examples.

Learn how to remove extra spaces and non-printable characters in Google Sheets with TRIM and CLEAN. Fix imported data, broken lookups, and whitespace issues.

Learn the difference between absolute and relative cell references in Google Sheets. Covers the $ sign, mixed references, the F4 shortcut, and when to use each type.

Learn how to reference cells and ranges from another sheet tab in Google Sheets. Covers the exclamation point syntax, spaces in sheet names, and formulas.

Learn how to use ARRAYFORMULA in Google Sheets to apply a formula to an entire column from one cell. Step-by-step examples with IF, VLOOKUP, and more.

A quick-reference list of 100+ Google Sheets formulas organized by category. Includes syntax, one-line descriptions, and links to step-by-step tutorials.

A quick-reference list of 50+ Google Sheets keyboard shortcuts for Windows, Mac, and Chromebook. Navigate, edit, format, and build formulas faster.

An honest comparison of Google Sheets and Excel covering pricing, collaboration, formulas, performance, and offline use. Pick the right tool.

Learn 5 ways to remove duplicates in Google Sheets. Covers the built-in tool, UNIQUE function, COUNTIF helper column, and more with step-by-step examples.

Learn the difference between VLOOKUP approximate match (TRUE) and exact match (FALSE) in Google Sheets. When to use each with step-by-step examples.

Learn how to use VLOOKUP with ARRAYFORMULA in Google Sheets to fill an entire column with one formula. Step-by-step examples and error handling.

Learn how to do a case-sensitive VLOOKUP in Google Sheets using INDEX, MATCH, and EXACT. Step-by-step formula examples, common errors, and best practices.

Use INDEX MATCH with multiple criteria in Google Sheets to look up values based on two or more conditions. Array formula examples with step-by-step setup.

Compare INDEX MATCH and VLOOKUP in Google Sheets. See when each lookup formula works best with side-by-side examples, performance notes, and migration tips.

Learn how to use the TRANSPOSE function in Google Sheets to flip rows into columns and columns into rows. Covers the formula, paste special, and tips.

Learn how to use the UNIQUE function in Google Sheets to extract distinct values from a column or range. Covers syntax, examples, and combining with SORT.

Learn INDEX MATCH in Google Sheets with this beginner tutorial. Step-by-step guide covering MATCH positions, INDEX returns, and combining both functions.

Learn how to use SPARKLINE in Google Sheets to create mini line, bar, column, and winloss charts inside cells. Syntax, options, and examples.

Learn how to use DATEDIF in Google Sheets to calculate days between dates, age from birthdate, and tenure. Covers all six units with step-by-step examples.

Learn how to use the TODAY function in Google Sheets to calculate age, tenure, and days until a deadline. Covers NOW for timestamps and time tracking.

Split text to columns in Google Sheets using the Data menu or the SPLIT function. Step-by-step guide covering delimiters, formulas, and practical examples.

Use the SUBSTITUTE function in Google Sheets to find and replace text inside formulas. Covers syntax, nested replacements, the instance argument, and real examples.

Learn how to combine text from multiple cells in Google Sheets using CONCATENATE, the ampersand operator, and TEXTJOIN with delimiters and ranges.

Change text case in Google Sheets with UPPER, LOWER, and PROPER. Convert to uppercase, lowercase, or title case with step-by-step examples and formulas.

Learn how to use the SPLIT function in Google Sheets to separate text into columns by any delimiter. Covers commas, spaces, custom delimiters, and edge cases.

Learn how to create a pivot table in Google Sheets. Summarize data by category with SUM, COUNT, and AVERAGE. Step-by-step tutorial with examples.

Combine VLOOKUP with IMPORTRANGE to look up values from another Google Sheets spreadsheet. Step-by-step formula guide with examples and performance tips.

Use REGEXMATCH, REGEXEXTRACT, and REGEXREPLACE in Google Sheets for pattern-based text matching, extraction, and replacement with regular expressions.

Use FIND and SEARCH in Google Sheets to locate text inside a cell. Learn the syntax, differences, wildcard support, and how to combine them with other functions.

Learn how to use the SORT function in Google Sheets to sort data by one or multiple columns. Covers syntax, examples, and combining SORT with FILTER.

Learn how to use QUERY PIVOT in Google Sheets to create cross-tabulated reports. Syntax, step-by-step examples, and tips for pivot-style summaries.

Fix the IMPORTRANGE access permission error in Google Sheets. Learn how to grant, manage, and troubleshoot the Allow access prompt between spreadsheets.

Learn how to share Google Sheets with specific people, shareable links, and embed options. Covers permission levels, access controls, and sharing best practices.

Learn how to use ROUND, ROUNDUP, ROUNDDOWN, and MROUND in Google Sheets. Covers syntax, rounding examples, and when to use each function.

Learn how to use QUERY across multiple ranges and sheets in Google Sheets. Combine data with curly braces, IMPORTRANGE, and vertical stacking.

Learn how to use QUERY ORDER BY in Google Sheets to sort results by one or multiple columns, ascending or descending. Step-by-step examples.

Learn how to insert a checkbox in Google Sheets and use it in formulas. Count, filter, and format rows based on checkbox values. Step-by-step guide.

Learn how to use QUERY with dates in Google Sheets. Filter by date ranges, compare dates, format output, and avoid common date errors. Examples included.

Learn how to combine QUERY with IMPORTRANGE in Google Sheets to filter, sort, and summarize data from another spreadsheet. Step-by-step examples.

Learn how to use QUERY LABEL in Google Sheets to rename column headers in your output. Syntax, step-by-step examples, and common mistakes.

Create dependent dropdown Google Sheets lists using INDIRECT and named ranges. Change one dropdown and the next updates automatically. Step-by-step.

Learn how to print Google Sheets with gridlines, headers, and fit-to-page scaling. Covers print area, page breaks, orientation, and margins.

Learn how to use custom number formats in Google Sheets for currency, percentages, dates, and more. Covers format codes, conditional formatting, and examples.

Learn how to protect sheets and lock specific cell ranges in Google Sheets. Control who can edit what with permissions, warnings, and exceptions.

Learn how to create a dropdown list in Google Sheets with data validation. Restrict input, reduce errors, and keep your data clean. Step-by-step guide.

Learn how to use MAX, MIN, LARGE, and SMALL functions in Google Sheets. Find the highest, lowest, and nth-ranked values in any range.

Learn how to merge cells in Google Sheets with Merge all, Merge horizontally, and Merge vertically. Includes unmerge steps, formula tips, and common pitfalls.

Learn how to create and use named ranges in Google Sheets. Replace cell references with readable names in formulas. Covers creation, editing, and best practices.

Learn to highlight duplicate values in Google Sheets with conditional formatting and COUNTIF. Find duplicates, flag second occurrences, and color rows.

Learn how to use the LET and LAMBDA functions in Google Sheets. Simplify complex formulas with named variables and create reusable custom functions.

Learn how to do a mail merge with Google Sheets and Gmail. Send personalized emails to a contact list using Apps Script with step-by-step examples.

Learn how to write custom formula rules for conditional formatting in Google Sheets. Covers relative references, AVERAGE, LARGE, COUNTIF, and date patterns.

Use INDEX MATCH MATCH for two-way lookups in Google Sheets. Find values at the intersection of a row and column with step-by-step examples.

Use INDEX MATCH to return multiple matching results in Google Sheets. Array formulas and FILTER alternatives for returning all rows that match a condition.

Learn how to use the INDIRECT function in Google Sheets to create dynamic cell references. Covers syntax, examples with data validation, and common errors.

Learn how to highlight an entire row with conditional formatting in Google Sheets. Custom formula examples for row-based formatting by cell value.

Find the closest value in Google Sheets using INDEX MATCH. Covers nearest match with MIN ABS, next lower, next higher, and closest date formulas with examples.

Fix #N/A, #NUM!, #REF!, #VALUE!, and wrong results from INDEX MATCH in Google Sheets. Step-by-step troubleshooting for every common error with examples.

Use INDEX MATCH for left lookups in Google Sheets. Return values from columns to the left of your search column, something VLOOKUP cannot do.

Learn how to use conditional formatting based on another cell in Google Sheets. Step-by-step custom formula examples with cell references and dynamic thresholds.

Learn why IMPORTRANGE is slow in Google Sheets and how to speed it up. Practical fixes for loading delays, laggy recalculations, and oversized imports.

Import data from multiple tabs using IMPORTRANGE in Google Sheets. Stack ranges, combine tabs, and use QUERY to filter across sheets in one formula.

ARRAYFORMULA doesn't spill INDEX MATCH down a column, INDEX only returns the first match. Here's why, and the MAP + LAMBDA formula that returns a result for every row from one cell.

Learn how to use QUERY GROUP BY in Google Sheets to summarize data with SUM, COUNT, AVG, MIN, and MAX. Step-by-step examples and common mistakes.

Learn how IMPORTRANGE auto-update works in Google Sheets, how to force a refresh, and what to do when imported data stops syncing between spreadsheets.

Use IMPORTRANGE with FILTER in Google Sheets to pull only the rows you need from another spreadsheet. Step-by-step guide with real examples.

Learn how to use the SWITCH function in Google Sheets to replace messy nested IFs. Includes full syntax breakdown, step-by-step examples, and error fixes.

Learn how to use QUERY SELECT in Google Sheets to pick specific columns, reorder them, and use aggregate functions. Step-by-step examples and syntax.

Learn how to insert an image inside a cell in Google Sheets using the IMAGE function and the Insert menu. Covers sizing modes, URLs, and troubleshooting.

Learn how to import CSV and Excel files into Google Sheets. Covers File menu upload, IMPORTDATA for URLs, and fixing delimiter and encoding issues.

Learn how to use an IF statement with a checkbox in Google Sheets. Returns custom text based on checked or unchecked status with step-by-step examples.

Learn how to use IFERROR in Google Sheets to replace formula errors with custom messages or blanks. Step-by-step examples with VLOOKUP and INDEX MATCH.

Learn how to use the QUERY WHERE clause in Google Sheets to filter rows by text, numbers, dates, and multiple conditions. Examples and common mistakes.

Learn how to use the HYPERLINK function in Google Sheets to create clickable links in cells. Covers URLs, emails, other sheets, and dynamic links.

Learn how to use SUMIF and SUMIFS in Google Sheets to add values based on one or multiple conditions. Step-by-step examples, syntax, and common mistakes.

Learn how to use the Google Sheets API to read and write spreadsheet data. Step-by-step setup with Python and JavaScript code examples.

Learn how to use Google Sheets offline without internet. Covers setup in Chrome, editing offline, syncing changes, and troubleshooting common issues.

Discover the best Google Sheets templates for budgets, project tracking, invoices, and more. Learn how to find, use, and customize built-in and community templates.

Learn how to use COUNTIF and COUNTIFS in Google Sheets to count cells by condition. Covers comparison operators, wildcards, and multiple criteria examples.

Learn how to use the GOOGLEFINANCE function in Google Sheets to get live stock prices, historical data, and currency exchange rates with real-time formulas.

The best Google Sheets add-ons for productivity, data cleaning, reporting, and automation. Covers how to install, manage, and remove add-ons.

Learn how to use IF with AND and OR in Google Sheets to test multiple conditions. Step-by-step examples for combining logical functions in one formula.

Learn how to use Find and Replace in Google Sheets. Covers basic search, match case, search by regex, replace across sheets, and formula-based alternatives.

Learn how to use FLATTEN in Google Sheets to combine multiple columns or ranges into a single column. Includes examples with UNIQUE, SORT, and FILTER.

Learn how to freeze rows and columns in Google Sheets to keep headers visible while scrolling. Covers freeze options, shortcuts, and common issues.

Learn how to use the IFS function in Google Sheets to evaluate multiple conditions without nesting. Includes real examples, IFS vs nested IF, and tips.

Learn how to use the DATEVALUE function in Google Sheets to convert text to a date. Fix text dates from imports, CSVs, and pasted data with examples.

Learn three ways to auto timestamp when a cell changes in Google Sheets: IF+NOW formula, keyboard shortcut, and Apps Script for automatic date entry.

Learn how to use YEAR, MONTH, and DAY in Google Sheets to extract date parts. Group data by year, filter by month, and rebuild dates with examples.

Learn how to write nested IF statements in Google Sheets. Covers multi-tier classification, letter grades, tiered commission, and when to switch to IFS.

Learn how to restrict date entry in Google Sheets with data validation. Prevent past dates, set date ranges, and use custom formulas for date rules.

Learn how to set up custom error messages and input messages for data validation in Google Sheets. Reject input or show warnings with clear help text.

Learn how to use custom formula data validation in Google Sheets. Restrict cell input with any formula that returns TRUE or FALSE. Step-by-step examples.

Pull data from another sheet or tab using VLOOKUP in Google Sheets. Step-by-step guide covering sheet reference syntax, naming rules, and real examples.

Learn how to use COUNT, COUNTA, and COUNTBLANK in Google Sheets. Covers counting numbers, non-empty cells, blanks, and when to use each function.

Learn how to use Paste Special in Google Sheets to paste values only, formatting, transpose, and more. Covers shortcuts, menu options, and common use cases.

Learn how to use VLOOKUP with multiple criteria in Google Sheets. Two proven methods with step-by-step examples: helper column and ARRAYFORMULA approach.

Learn how to use conditional formatting with dates in Google Sheets. Highlight overdue dates, upcoming deadlines, and past dates with custom formula rules.

Learn how to add icons and emojis to Google Sheets using conditional formatting and formulas. Step-by-step guide with IF, CHAR, and emoji examples.

Learn when to use conditional formatting vs data validation in Google Sheets. Covers what each does, key differences, and when to combine them.

Fix VLOOKUP errors in Google Sheets including #N/A, #REF!, #VALUE!, and wrong results. Find the cause of each error and resolve it with formula examples.

Learn how to apply color scale conditional formatting in Google Sheets. Create heat maps and gradient formats to spot high and low values at a glance.

Learn how to make a histogram in Google Sheets to visualize frequency distributions. Step-by-step guide covering bin sizes, customization, and formatting.

Learn how to add a trendline in Google Sheets charts. Choose linear, exponential, or polynomial types, display the equation, and show the R-squared value.

Learn VLOOKUP in Google Sheets from scratch with this step-by-step beginner tutorial. Covers syntax, real examples, common mistakes, and practical tips.

COUNTIF counts the number of cells in a range that match a condition. Learn the syntax, see examples with wildcards, and fix errors.

Learn how to use the IFERROR function in Google Sheets to catch errors and return a fallback value instead of displaying error messages.

DATEDIF calculates the difference between two dates in years, months, or days. Learn the syntax, unit codes, examples, and common errors.

Learn how to use the IFS function in Google Sheets to evaluate multiple conditions and return the value for the first one that is TRUE.

INDEX returns the value of a cell in a range based on the row and column numbers you specify. Syntax, examples, and common errors.

MATCH returns the relative position of a value within a one-dimensional range. Syntax, examples, and common errors explained.

IMPORTRANGE imports a range of cells from one Google Sheets spreadsheet into another. Syntax, examples, and access permission errors.

CONCATENATE joins two or more text strings into one. Learn the syntax, see examples for names and addresses, and when to use alternatives.

Learn how to use the QUERY function in Google Sheets to filter, sort, and summarize data using a SQL-like query language.

Learn how to use the IF function in Google Sheets to return different values based on whether a condition is true or false.

SUMIF adds values in a range that meet a condition you specify. Learn the syntax, see practical examples, and fix common errors.

SUM adds numbers together from individual values, cell references, or entire ranges. Learn the syntax, examples, and common pitfalls.

TODAY returns the current date and updates automatically on each recalculation. Learn the syntax, see examples, and understand its behavior.

VLOOKUP searches down the first column of a range and returns a value from any column in the same row. Syntax, examples, and errors.

XLOOKUP searches a range for a key and returns a value from a result range. A more flexible replacement for VLOOKUP with built-in error handling.

Learn how to add alternating colors in Google Sheets for easier reading. Covers built-in zebra stripes, custom colors, and conditional formatting methods.

Learn how to use Google Apps Script with Google Sheets. Write custom functions, automate tasks, and build menus with step-by-step examples.

Learn how to use AVERAGE, AVERAGEIF, and AVERAGEIFS in Google Sheets. Covers syntax, conditional averages, multiple criteria, and common errors.

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 best practices.

Learn how to use the QUERY function in Google Sheets to filter, sort, and summarize data. Step-by-step examples with SELECT, WHERE, and GROUP BY.

Learn how to use conditional formatting in Google Sheets to highlight cells by value, color-code data, and create custom formula rules. Step-by-step examples.

Learn how to use data validation in Google Sheets to create dropdown lists, restrict input, add checkboxes, and write custom rules. Step-by-step guide.

Learn how to use IMPORTRANGE in Google Sheets to pull data from other spreadsheets. Covers syntax, access permissions, errors, and combining with QUERY.

Learn how to use INDEX MATCH in Google Sheets to look up values in any direction. Covers syntax, left lookups, multiple criteria, and common error fixes.

Learn how to create charts in Google Sheets with bar, line, pie, and combo chart examples. Covers chart types, SPARKLINE formulas, and customization tips.

Learn how to use date functions in Google Sheets to calculate age, tenure, deadlines, and business days. Examples with TODAY, DATEDIF, EDATE, and more.

Learn how to use text functions in Google Sheets to clean, combine, and extract data. Covers TRIM, PROPER, SPLIT, SUBSTITUTE, and more with examples.

Learn how to use VLOOKUP in Google Sheets with step-by-step examples. Master syntax, fix common errors, and explore alternatives.

Learn the fundamentals of Google Sheets including creating spreadsheets, entering data, formatting cells, and using basic formulas.