
Lookups in four slides
Find a value in a table without scrolling for it.
One idea per slide, every Tuesday.

Find a value in a table without scrolling for it.

The three most common range mistakes and how to spot them.

Build a decision in a cell, one condition at a time.

Turn text into real dates and count the days between them.

Summarise a long list by group in five clicks.

Keep the formulas safe when someone else fills in the sheet.

Free, for your email
My free one-page sheet of the twelve formulas I use every week, sent when you sign up. Print it and keep it beside the keyboard.
Sums and counts
Lookups
If and logic
Dates and text