Formulas & Functions
Excel SUM Formula: every way to add numbers
The Excel SUM formula: add a range, add separate cells, add across sheets, and AutoSum with one shortcut.
Author: Srini Vanamala
Sorting, Filtering & Lists
Excel Drop Down List: make one in 30 seconds
Make an Excel drop down list with Data Validation in 30 seconds, from typed options or from a range, and edit it later.
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.
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
The fastest way to add a column of numbers is =SUM(range). The formula =SUM(B2:B20) Click the cell under your numbers, type the…
152 tutorials · Page 17 of 17
