Every Excel Error Explained: #VALUE!, #REF!, #DIV/0! and More
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.
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.
Create drop-down lists in Excel with data validation: from typed items, from a range, from a table that grows automatically, plus dependent lists, error messages and common fixes.
Build a simple, clean sales dashboard in Excel step by step: prepare the data, create pivot tables, add KPI tiles, charts and slicers, and refresh it with one click.
Four easy ways to find and remove duplicates in Excel: the Remove Duplicates button, highlighting first, the UNIQUE function and Power Query, plus how to avoid deleting the wrong rows.
Google Sheets vs Excel compared: price, collaboration, size limits, formulas, Power Query, automation, AI and offline use, plus which one to choose for your work.