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.
7 min read
Blog
Guides, tips and tricks to work better with Excel, CSV and spreadsheets.
-
-
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…
6 min read -
How to split text into columns in Excel: names, addresses and codes
Three ways to split names, addresses and codes into several columns: Text to Columns, Flash Fill and formulas such as TEXTBEFORE or TEXTSPLIT.
6 min read -
Comparing Spreadsheets: Manual Methods vs Online Tools
We look at the advantages and limits of comparing spreadsheets by hand, with formulas, with built-in Excel features and with free online tools.
5 min read -
Version Control in Excel: How to Know What Changed in Your Files
Best practices for naming, storing and comparing versions of your Excel workbooks so you always know who changed what and when.
5 min read -
Dynamic arrays in Excel: FILTER, SORT and UNIQUE explained
Learn how to use FILTER, SORT and UNIQUE to extract, sort and clean up data with a single formula that updates itself.
7 min read -
Advanced filtering and sorting in Excel: find what you need in seconds
AutoFilter, multi-level sorting, Advanced Filter and the FILTER and SORT functions: when to use each one, with examples and mistakes to avoid.
7 min read -
Excel formula errors (#N/A, #VALUE!, #REF!, #DIV/0!) and how to fix them
What each Excel error means, why it appears and how to fix it with formula examples, without hiding everything behind IFERROR.
7 min read -
Excel tables (Ctrl+T): why you should always use them
With Ctrl+T you turn a list into a table that grows by itself, copies formulas and totals only filtered rows. Here is how to…
7 min read
