How to compare two columns in Excel and find matches and differences
Formulas and conditional formatting to see which values match between two columns, which are missing from one of them and how to extract them into a separate list.
Comma or semicolon: the CSV separator and regional settings explained
Why Excel sometimes saves CSV files with semicolons, why everything can end up in a single column, and how to control the separator and decimals.
How to export data from your bank, ERP or online store to Excel and get it ready to use
Export transactions, orders or invoices from any system and turn them into a clean Excel table: amounts, dates, text and duplicates sorted out.
Excel and Google Sheets: how to move files between them without losing formatting
What is kept and what is lost when you move a spreadsheet from Excel to Google Sheets and back, and how to do it step by step without breaking formulas or formatting.
How to open a CSV file in Excel correctly: delimiter, encoding and import
If your CSV opens in a single column, with broken accented characters or missing leading zeros, here is how to import it properly and fix it if you already opened it.
How to detect outliers and data entry errors in a spreadsheet
One extra zero or a misplaced decimal can skew an entire report. Learn to find outliers and data entry errors with formulas, conditional formatting and data validation.
Remove spaces and invisible characters in Excel: TRIM, CLEAN and the non-breaking space
A trailing space or a hidden character is enough to make VLOOKUP fail or let duplicates slip through. Learn how to find and remove them, with and without formulas.
Numbers stored as text in Excel: how to spot and fix them
If SUM returns 0 or VLOOKUP can’t find a code you can see on screen, you probably have numbers stored as text. Here’s how to spot and convert them.
Power Query for beginners: clean and combine data without formulas
Learn how to use Power Query in Excel to clean tables, merge files and refresh reports with one click, without writing formulas.
How to Compare Two Excel Files and Find Every Difference
Learn how to compare two Excel files step by step, which kinds of differences to look for, and how to get a clear report of the changes without checking cell by cell.