Guides, tips and tricks to work better with Excel, CSV and spreadsheets.
9 articles Clear filters
Calculate the variance in amount and percentage, summarize expenses by line item and highlight anything beyond your threshold, with ready-to-copy formulas.
A step-by-step method to compare two versions of a customer or subscriber list in Excel and find out who is new, who has left…
Formulas and conditional formatting to see which values match between two columns, which are missing from one of them and how to extract them…
Learn how to compare two Excel files step by step, which kinds of differences to look for, and how to get a clear report…
We look at the advantages and limits of comparing spreadsheets by hand, with formulas, with built-in Excel features and with free online tools.
Best practices for naming, storing and comparing versions of your Excel workbooks so you always know who changed what and when.
A practical method to review supplier price lists, spot hidden increases, removed products and errors before you update your catalog.
How to match your physical inventory with your system stock using Excel: prepare the data, compare quantities, find discrepancies and fix them.
The most frequent pitfalls when comparing spreadsheets, from swapping the file order to invisible spaces, and how to avoid each one.
