Excel Guides

Learn how to use FILTER, SORT and UNIQUE to extract, sort and clean up data with a single formula that updates itself.

AutoFilter, multi-level sorting, Advanced Filter and the FILTER and SORT functions: when to use each one, with examples and mistakes to avoid.

What each Excel error means, why it appears and how to fix it with formula examples, without hiding everything behind IFERROR.

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 get the most out of it.

Column, line, pie, scatter or combo: learn how to choose the Excel chart that best tells the story of your data and avoid the most common mistakes.

Extract prefixes, names, domains or parts of a code and join text with separators using Excel’s text functions, with practical examples.

Learn how to subtract dates, calculate months and ages with DATEDIF, add deadlines and count working days in Excel, with examples you can copy.

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.

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.

Learn how to use IF, AND and OR in Excel with practical examples: single conditions, multiple conditions, nested IFs, IFS and comparing columns.