Download a free 2-page printable Excel formulas cheat sheet: 52 essential formulas with examples (SUMIFS, XLOOKUP, IF, TEXT, dates, FILTER), plus common errors and must-know tips.
Learn the IF function in Excel and how to combine it with AND and OR to test several conditions. Real examples for bonuses, pass/fail grades, overdue invoices and more.
Learn how INDEX and MATCH work together in Excel to look up values in any direction. Step-by-step examples, two-way lookups, and how it compares to VLOOKUP and XLOOKUP.
Numbers stored as text break SUM, VLOOKUP and sorting in Excel. Learn how to spot them and 6 quick ways to convert text to numbers, including Text to Columns and VALUE.
What do #VALUE!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM!, #SPILL! and ##### mean in Excel? A plain-English guide to every Excel error and how to fix each one.
XLOOKUP vs VLOOKUP compared side by side: syntax, looking left, exact match, inserting columns, errors and compatibility. Find out which lookup function you should use.
Learn how VLOOKUP works in Excel with simple, real examples: the four arguments, exact vs approximate match, common mistakes, and when to use XLOOKUP instead.
Getting #N/A from VLOOKUP or XLOOKUP? Learn the 6 common causes (extra spaces, text numbers, wrong match type, unlocked ranges) and how to fix each one step by step.
The Excel keyboard shortcuts office workers use most, grouped by task, with a free one-page printable PDF cheat sheet to keep on your desk.
Learn SUMIFS and COUNTIFS in Excel with real office examples: totals by region and month, date ranges, text wildcards, “not equal” conditions and the most common mistakes.