Formulas & Functions
VLOOKUP in Excel: explained with one example
VLOOKUP in Excel: the four parts of the formula, one example, and the two mistakes that cause #N/A.
Learn Excel the easy way.
Short, plain-English tutorials on formulas, shortcuts, charts and everyday Excel tasks. No jargon. One idea per post.
Start here Get Daily One LessonLatest tutorials
Macros & VBA
How to Enable Macros in Excel (and when you should not)
How to enable macros in Excel for one file or for good, why the yellow bar appears, and how to unblock a downloaded file.
Formulas & Functions
INDEX MATCH in Excel: the lookup that works in any version
INDEX MATCH in Excel, explained in two small steps. Looks left, never breaks when columns move, works in every Excel version.
Formulas & Functions
XLOOKUP in Excel: the lookup formula that just works
XLOOKUP in Excel explained with one example: find a value in a list and return what sits next to it, with no column counting.
Data Cleaning
Remove Duplicates in Excel: 3 clicks, no formula
Remove duplicates in Excel with the built-in button in three clicks, and see the two ways it goes wrong.
Formulas & Functions
SUM in Excel: add up a column in 5 seconds
Add up a column of numbers with =SUM(range), or let Excel write it for you with Alt+=. Plus the fix when SUM shows 0.
Showing 289–294 of 294 tutorials · Page 33 of 33
