How to remove duplicates in Excel, and why it leaves the worst ones behind
Remove Duplicates only deletes exact matches, so UK, United Kingdom and GB all survive it. How to run it safely, how to spot duplicates first, and what to use instead.
Excel
One country, eight spellings: how an Excel drop down list stops the mess
One country, eight spellings, one unusable column. How to build a drop down list in Excel, how to make one list depend on another, and when free text is the better answer.
Pivot tables in Excel: how to summarise thousands of rows in under a minute
Pivot tables have an unearned reputation for being difficult. Learn what the four field areas actually do, how to prepare your data properly, and how to summarise thousands of rows in seconds.
Power Query: how to stop rebuilding the same spreadsheet every month
Power Query: how to stop rebuilding the same spreadsheet every month Excel 21 August 2026 By Matt Weston Power Query
How to use XLOOKUP in Excel, and why it replaces VLOOKUP
How to use XLOOKUP in Excel, and why it replaces VLOOKUP Excel 10 August 2026 By Matt Weston XLOOKUP is