Learn Excel EasyDaily One Lesson

Start Here

New to Excel? Read the lessons below in order — each one is short, has a real example, and builds on the one before. Or jump to the topic you need.

Want them delivered? Subscribe — Daily One Lesson

All lessons 14

Data Cleaning 1

  1. Remove Duplicates in Excel: 3 clicks, no formula

Fixes & Errors 1

  1. Excel Formula Not Calculating? 5 causes and fixes

Formatting 2

  1. Merge Cells in Excel: the right way (and the trap)
  2. Conditional Formatting in Excel: colour cells automatically

Formulas & Functions 7

  1. SUM in Excel: add up a column in 5 seconds
  2. XLOOKUP in Excel: the lookup formula that just works
  3. INDEX MATCH in Excel: the lookup that works in any version
  4. VLOOKUP in Excel: explained with one example
  5. Excel SUM Formula: every way to add numbers
  6. XLOOKUP vs VLOOKUP: which one should you use?
  7. CONCATENATE in Excel: join text from two cells

Macros & VBA 1

  1. How to Enable Macros in Excel (and when you should not)

Shortcuts 1

  1. Excel Keyboard Shortcuts: the 25 worth learning

Sorting, Filtering & Lists 1

  1. Excel Drop Down List: make one in 30 seconds