Spreadsheet answers, step by step
Clear, step-by-step tutorials for Google Sheets and Excel. No fluff: every guide shows exactly where to click and which formula to type.
Google Sheets
All Google Sheets tutorials →How to Use AVERAGE in Google Sheets (and AVERAGEIF)
Find the average in Google Sheets with AVERAGE, ignore blanks and text, average only cells that meet a condition with AVERAGEIF, and handle the #DIV/0! error.
Google SheetsHow to Change Text to Uppercase or Lowercase in Google Sheets
Change case in Google Sheets with UPPER, LOWER and PROPER. Capitalize names, fix ALL CAPS imports, and replace the original text with the cleaned version.
Google SheetsHow to Make a Chart in Google Sheets
Create a chart in Google Sheets in a few clicks, pick the right chart type, edit titles and colors in the chart editor, and move or delete the chart.
Google SheetsHow to Add Checkboxes in Google Sheets (and Count Them)
Insert checkboxes in Google Sheets, count ticked boxes with COUNTIF, cross out completed tasks automatically, and remove checkboxes.
Google SheetsHow to Color Cells Based on Value in Google Sheets
Automatically color cells in Google Sheets with conditional formatting: single color rules, color scales (heatmaps), coloring a whole row, and a custom formula.
Google SheetsHow to Combine Text from Cells in Google Sheets (CONCATENATE and TEXTJOIN)
Join text from several cells in Google Sheets with the & operator, CONCATENATE and TEXTJOIN. Add spaces and separators, and skip empty cells.
How to Create a Drop-Down List in Excel
Create a drop-down list in Excel with Data Validation: from typed items, from a cell range, from another sheet, and a list that updates automatically.
ExcelHow to Use XLOOKUP in Excel: A Beginner's Guide
XLOOKUP explained with simple examples: syntax, left lookups, custom 'not found' messages, returning several columns, and how it compares to VLOOKUP.