Excel formulas for beginners: the 12 you need first
The basic Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example and free practice.
A spreadsheet is a grid of boxes. Each box is called a cell.
keyboard 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 basic Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example and free practice.
Know someone fighting with a spreadsheet? Send them this page.