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 Freeze Rows and Columns in Google Sheets (and Excel)
Keep your header row or first column visible while you scroll. How to freeze and unfreeze rows and columns in Google Sheets, with the Excel equivalent.
Google SheetsHow to Highlight Duplicates in Google Sheets
Use conditional formatting with a custom formula to highlight duplicate values, entire duplicate rows, or only the second and later copies in Google Sheets.
Google SheetsHow to Remove Duplicates in Google Sheets (3 Easy Ways)
Remove duplicate rows in Google Sheets with the built-in cleanup tool, the UNIQUE function, or a COUNTIF helper column. Step-by-step with examples.
Google SheetsHow to Use VLOOKUP in Google Sheets (With Examples)
Learn VLOOKUP in Google Sheets: the syntax, a worked example, exact vs approximate match, and how to fix #N/A and #REF! errors.
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.