Learn excel
Short lessons written around the screening tests employers use. Read one, then take the test.
Relative and absolute referencesWhy a formula breaks when you copy it, and how the dollar sign fixes it.Lesson 1
Lookups, SUMIF and COUNTIFThe three functions that turn a list into answers, with the mistakes that make them return errors.Lesson 2
Cleaning data and building a first pivot tableRemove duplicates, fix text numbers, then summarise thousands of rows in a minute.Lesson 3
IF, AND, OR and nested conditionsHow to write a formula that makes a decision, combine several tests, and avoid the nesting mistakes that return wrong answers.Lesson 4
Advertisement