Excel lesson — interactive edition
Same lesson structure as today, but the practice sections are real spreadsheets. Type a formula, press Enter, see it evaluate against the actual cells.
Intro
VLOOKUP, but you actually try it
Reading about formulas only takes you so far. Below is a real spreadsheet — type the formula yourself, hit Enter, and watch it work.
Key concept
SUM adds a range of numbers
=SUM(A1:A3) adds the values in cells A1, A2, and A3.
You can pass any range. The colon means "everything between."
Example
=SUM(A1:A3) → 60
Try it
Add up January sales
Column A has three days of sales. In cell B1, write a formula that adds them all up.
| A | B | |
|---|---|---|
| 1 | 10 | |
| 2 | 20 | · |
| 3 | 30 | · |
Key concept
AVERAGE gives you the mean
=AVERAGE(range) returns the arithmetic mean.
Same shape as SUM — just a different function name.
Try it
What is the average?
Same numbers as before. In B1, write a formula that returns their average.
| A | B | |
|---|---|---|
| 1 | 10 | |
| 2 | 20 | · |
| 3 | 30 | · |
Pro tip
You can reference any cell
Formulas live anywhere. =A1+A2 works just as well as =SUM(A1:A2). Use ranges when you have more than a couple of cells.
Summary
What you just did
- Wrote your first SUM formula and saw it compute live
- Swapped SUM for AVERAGE in the same shape
- Built muscle memory the boring text version cannot give you