Spreadsheet guides
Practical, step-by-step answers to the spreadsheet problems people search for most. Each guide shows the manual method in Excel and Google Sheets, and the fast way with MindySheets.
How to remove duplicates in Excel (5 ways, including near-duplicates)
Five ways to remove duplicates in Excel — Remove Duplicates, conditional formatting, COUNTIFS, UNIQUE and Power Query — plus how to catch near-duplicates.
How to clean data in Excel: a 12-step checklist
A 12-step checklist for cleaning messy data in Excel: spaces, capitals, spellings, text numbers, dates, duplicates, blanks and validation, with the exact formulas.
Excel formula errors explained: #REF!, #N/A, #DIV/0! and how to fix them
What every Excel error means and how to fix it: #DIV/0!, #N/A, #REF!, #VALUE!, #NAME?, #NUM!, #NULL!, #SPILL! and #CALC!, plus finding every error at once.
XLOOKUP vs VLOOKUP vs INDEX MATCH: which should you use?
XLOOKUP, VLOOKUP and INDEX/MATCH compared: syntax, defaults, version support, left lookups and multiple criteria, with copy-ready formulas for each.
How to make a monthly sales report in Excel (step by step)
Build a monthly sales report in Excel from raw orders: clean the data, summarise with SUMIFS and PivotTables, compare months, chart the trend and write the commentary.
How to convert text to numbers (and fix text dates) in Excel
Six ways to turn numbers stored as text into real numbers in Excel — Convert to Number, Text to Columns, VALUE, NUMBERVALUE and more — plus fixing text dates.
Rather skip the steps?
Upload the spreadsheet and Mindy will find the problems, fix what you approve and explain the results.