INDEX and MATCH in Excel: the flexible alternative to VLOOKUP
Learn how to combine INDEX and MATCH to look up data in Excel in any direction, without the limits of VLOOKUP, with step-by-step examples.
SUMIFS and COUNTIFS: how to sum and count with multiple conditions
Learn how to sum and count data that meets several conditions at once in Excel, with text, number, date and wildcard criteria plus a summary table.
IF, AND and OR in Excel: how to make decisions with formulas
Learn how to use IF, AND and OR in Excel with practical examples: single conditions, multiple conditions, nested IFs, IFS and comparing columns.
How to Audit Price List Changes with Excel
A practical method to review supplier price lists, spot hidden increases, removed products and errors before you update your catalog.
Inventory Reconciliation with Excel: A Step-by-Step Guide
How to match your physical inventory with your system stock using Excel: prepare the data, compare quantities, find discrepancies and fix them.
8 Common Mistakes When Comparing Excel Files and How to Avoid Them
The most frequent pitfalls when comparing spreadsheets, from swapping the file order to invisible spaces, and how to avoid each one.
How to Convert Excel to CSV Without Losing Data
Everything you need to convert Excel to CSV properly: delimiters, UTF-8 encoding, dates, decimals and workbooks with several sheets.
How to Convert CSV to Excel Without Losing Leading Zeros or Dates
Opening a CSV with a double click can damage your data. Learn how to convert CSV to Excel while keeping leading zeros, dates, accents and long numbers.
XLS vs XLSX: Differences and When to Convert Your Files
What is the difference between XLS and XLSX, which one is smaller, which one is safer and when you should convert from one format to the other.
How to Convert PDF to Excel and Extract Tables Correctly
A practical guide to moving tables from a PDF into Excel: types of PDF, choosing the right tool, checking the result and cleaning the extracted data.