Charts in Excel: how to choose the right chart for your data
Column, line, pie, scatter or combo: learn how to choose the Excel chart that best tells the story of your data and avoid the…
7 min read
Blog
Guides, tips and tricks to work better with Excel, CSV and spreadsheets.
-
-
Text functions in Excel: LEFT, RIGHT, MID, TEXTBEFORE and TEXTJOIN
Extract prefixes, names, domains or parts of a code and join text with separators using Excel's text functions, with practical examples.
6 min read -
Dates in Excel: how to calculate days, months, ages and working days
Learn how to subtract dates, calculate months and ages with DATEDIF, add deadlines and count working days in Excel, with examples you can copy.
7 min read -
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.
6 min read -
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…
6 min read -
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.
7 min read -
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.
5 min read -
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.
5 min read -
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.
5 min read
