Excel
-
1
The interface and building a sound table
Most Excel problems are not in the functions but in a table that was built wrong from the start. This lesson sets the foundation before we write a single formula.
9 min read -
2
Formulas and references
The = sign turns a cell from a sheet of paper into a calculator. And the difference between B2 and $B$2 is the difference between a file that works and one that collapses the moment you fill it down.
10 min read -
3
The core functions
Excel has more than five hundred functions, but ten of them cover ninety per cent of your work. These are the ten.
10 min read -
4
Lookup functions and linking tables
You have a statement, a customer table and a price list on separate sheets. These functions are the bridge that pulls them into a single report.
10 min read -
5
Pivot tables and reports
Ten thousand rows of journal entries, and one question from the manager: "how much did we spend per cost centre?" The answer is three clicks away — if your data is clean.
11 min read