Excel formulas for beginners: the 12 you need first
The Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example to practise.
Find your way around a spreadsheet and name any cell.
Every cell has a name: its column letter, then its row number, like B3.
Look at cell A4. Type what it says into cell E2, then press Enter.
Typing formulas is easiest on a computer with a keyboard.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Item | Qty | Price | Your answer | ||
| 2 | Monitor Stand | 2 | 40.49 | |||
| 3 | Headset | 4 | 120.99 | |||
| 4 | Office Chair | 2 | 95.5 | |||
| 5 | Bookshelf | 6 | 155.99 | |||
| 6 | USB-C Hub | 2 | 42.5 | |||
| 7 | ||||||
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| 11 | ||||||
| 12 |
A spreadsheet is a grid of boxes called cells.
By its column letter, then its row number. The cell in column B, row 3 is B3. The name of the selected cell is shown in the box at the top left of the grid.
The Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example to practise.
Know someone fighting with a spreadsheet? Send them this page.