All Tutorials

A free Google Sheets budget template with 30 categories, 12 months in one file, rollover, annual bills, and a dashboard for any month. No email needed.

A free Google Sheets expense tracker: log each purchase in one row and see spending by category, this month vs last month, budget left, and year to date.

A free Google Sheets habit tracker: tick a checkbox each day and it counts days done, progress toward your goal, and your current and best streak.

A free Google Sheets college application tracker: deadlines with days left, status for every school, fees, essays and recommendations, plus a summary.

A free Google Sheets assignment tracker: every class and due date in one list, days left, overdue work in red, status, priority and your average grade.

A free Google Sheets job application tracker: every application with status, days since you applied, next step and date, plus your interview rate.

A free Google Sheets pay stub template: hours and overtime, gross pay, tax and other deductions, net pay, and year-to-date totals that calculate themselves.

A free Google Sheets student data tracker: scores for 40 students and 8 assessments, automatic percent and letter grade, missing work, and class averages.

A free Google Sheets weekly schedule: pick any date and the week lays out Monday to Sunday, with time slots you set, today highlighted, and a priorities list.

Google Sheets has dark mode in the Android and iPhone apps, but no setting on the web. Here's how to turn it on in the app and your options on a computer.

Hide and unhide rows or columns in Google Sheets with a right-click or a shortcut, group rows you can collapse, and find hidden rows. Includes Ctrl+Alt+9.

Multiply in Google Sheets with * or PRODUCT and divide with / or DIVIDE. Multiply a column by a number, fix #DIV/0!, and get a quotient and remainder.

Calculate percentages in Google Sheets: percent of a total, percent change, add or subtract a percent, and format results. Plus PERCENTIF and TO_PERCENT.

Sort or alphabetize data in Google Sheets without scrambling rows: sort a range A to Z, sort by date, sort by multiple columns, and keep the header in place.

Subtract in Google Sheets with a minus sign formula like =B2-C2 or the MINUS function. Subtract columns, dates, percentages and whole ranges, with fixes for errors.

Make a table in Google Sheets in one step with Format > Convert to table (Ctrl+Alt+T), or build a simple formatted table by hand with borders and colors.

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

Use XLOOKUP horizontally in Google Sheets: search across a row and return from another row. Everything HLOOKUP does, without the row index number.

Handle missing lookups in Google Sheets with XLOOKUP's missing_value argument. Return text, zero, or a blank instead of #N/A, without wrapping in IFERROR.

Master XLOOKUP match_mode in Google Sheets: exact match, next smaller, next larger, and wildcards. Includes tier lookups and why sorting is not required.

XLOOKUP vs INDEX MATCH in Google Sheets: syntax, flexibility, compatibility, and speed. When the modern function wins and when the classic pattern holds up.

XLOOKUP vs VLOOKUP in Google Sheets, compared feature by feature. See what XLOOKUP fixes, how to convert old formulas, and when VLOOKUP is still fine.

Return several columns from one XLOOKUP in Google Sheets. How spilling works, fixing the #REF! blocked-spill error, and multi-column lookup patterns.

Use XLOOKUP search_mode in Google Sheets to search bottom-to-top for the latest entry, or switch on binary search for speed on large sorted ranges.

Look up with two or more conditions using XLOOKUP in Google Sheets. The ARRAYFORMULA wrapper Excel guides leave out, plus the concatenation alternative.

Fix every XLOOKUP error in Google Sheets: #N/A not found, #N/A from mismatched ranges, #REF! blocked spills, and #VALUE! from missing ARRAYFORMULA.

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 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 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 VLOOKUP with wildcards in Google Sheets for partial text matching. Use asterisk and question mark wildcards with real examples.

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

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.

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.

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

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 use the SPLIT function in Google Sheets to separate text into columns by any delimiter. Covers commas, spaces, custom delimiters, and edge cases.

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.

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 XLOOKUP in Google Sheets with step-by-step examples. Covers syntax, reverse lookups, wildcards, approximate match, and VLOOKUP comparison.

Learn how to use the FILTER function in Google Sheets to extract rows matching conditions. Covers multiple criteria, AND/OR logic, and real examples.

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

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

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 LABEL in Google Sheets to rename column headers in your output. Syntax, step-by-step examples, and common mistakes.

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.

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 use custom number formats in Google Sheets for currency, percentages, dates, and more. Covers format codes, conditional formatting, and examples.

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

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

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.

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.

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

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

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.

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

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 use custom formula data validation in Google Sheets. Restrict cell input with any formula that returns TRUE or FALSE. Step-by-step examples.

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 restrict date entry in Google Sheets with data validation. Prevent past dates, set date ranges, and use custom formulas for date rules.

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 Paste Special in Google Sheets to paste values only, formatting, transpose, and more. Covers shortcuts, menu options, and common use cases.

Count non-empty cells in Google Sheets with COUNTA, count numbers with COUNT, and blanks with COUNTBLANK. Plus the empty-string trap COUNTA falls into.

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.

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

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

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

Sum a column in Google Sheets with =SUM(B2:B20), total a column that keeps growing, see a quick sum without a formula, and fix totals that come out wrong.

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 add alternating colors in Google Sheets for easier reading. Covers built-in zebra stripes, custom colors, and conditional formatting methods.

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.