A hands-on primer
A spreadsheet is just a grid you can do math inside. This page is a real, working one — read a few ideas, then change the numbers below and watch them recalculate.
This one is live — click a cell
The screen is a grid of cells. Columns run across the top with letters, rows run down the side with numbers. Where a column and a row cross, that cell takes its name from both: column B, row 3, is cell B3.
That name is called a cell reference, and it is the single most important idea in a spreadsheet. Instead of retyping a number, you point at where it lives. Change the number once, and everything pointing at it updates.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Qty | Price |
| 2 | Pens | 3 | 1.50 |
| 3 | Paper | 5 | 4.00 |
The highlighted cell above is C2 — column C, row 2. When someone says "put the total in C2," this is the square they mean.
Two small tools sit above the grid. The Name Box (top-left) always shows which cell you have selected. The formula bar next to it shows what you actually typed — useful, because a cell can display an answer while secretly holding a formula. You saw both in the workbook above.
Click a cell, type, and press Enter. That is the whole act of entering data. Excel then quietly decides what kind of thing you typed, and it tells you which by how it lines the value up.
Numbers snap to the right edge of the cell. Text stays on the left. Dates count as numbers, so they go right too. This is your first debugging trick: if a number you expected to add is sitting on the left, Excel is treating it as text, and math won't work on it.
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| 2 | North | 1,200 |
| 3 | South | 980 |
The words hug the left, the amounts hug the right. You didn't set that — the alignment is Excel telling you it understood each entry correctly.
To fix a value, click the cell and type again to overwrite it, or press F2 (or double-click) to edit what's already there. Press Delete to clear a cell out.
Type an equals sign, and Excel switches from "storing what you typed" to "working something out." That one character is the doorway to everything a spreadsheet can do.
After the = you can do plain arithmetic with + - * (times) and / (divide). The real power comes from using cell references instead of raw numbers:
| A | B | |
|---|---|---|
| 1 | Hours | 8 |
| 2 | Rate | 25 |
| 3 | Pay | =B1*B2 → 200 |
Because =B1*B2 keeps working. Change the hours in B1 to 40 and the pay updates on its own. You wrote the relationship, not the answer — that's the whole trick, and it's why people trust spreadsheets with real work.
Go back up to the live grid and try it: click an empty cell, type =B2+B3, and press Enter. Then change one of those numbers and watch your cell follow along.
A function is a shortcut for a common calculation. You give it a range — a block of cells written as B2:B5, meaning "B2 through B5" — and it does the rest. These five cover an enormous amount of everyday work:
The Total row in the workbook at the top already runs =SUM(B2:B5). Click that cell to see the formula in the bar, then change any amount above it — the total keeps up. Swap the word SUM for AVERAGE or MAX and watch it change what it reports.
Select a cell and you'll see a small square at its bottom-right corner — the fill handle. Drag it, and Excel repeats or continues the pattern down the column. This is how a formula written for one row gets applied to a hundred.
The clever part is that references shift as they travel. If C2 holds =A2*B2 and you drag it down, C3 becomes =A3*B3 on its own. It stays pointed at "the row I'm on," which is almost always what you want.
| A | B | C | |
|---|---|---|---|
| 1 | Qty | Price | Total |
| 2 | 3 | 1.50 | =A2*B2 |
| 3 | 5 | 4.00 | =A3*B3 |
| 4 | 2 | 9.00 | =A4*B4 |
AutoFill knows sequences too. Type Jan and drag, and it continues Feb, Mar, Apr. Type 1 and 2 in two cells, select both, drag, and it counts on: 3, 4, 5.
Formatting decides how a value is displayed without changing the value underneath. The number stays exact; you just choose how to show it. The controls live on the Home tab of the ribbon along the top.
The ones you'll reach for constantly: currency and percent to label numbers, bold and fill color to make headers stand out, and borders to separate a totals row. A cell showing $1,200.00 still holds plain 1200 underneath — every formula keeps working on the real number.
Rounding is display-only. A cell showing 3 might really hold 2.6. If a column of tidy-looking numbers doesn't add up the way you expect, hidden decimals are usually why.
You never need these, but they turn slow clicking into fast work. Learn two or three at a time.
You now have the whole foundation: cells and references, entering data, the = that starts a formula, five functions, AutoFill, and formatting. Everything more advanced — charts, sorting, IF, lookups, pivot tables — is built on exactly these pieces. Open a blank sheet and rebuild the budget from the top of this page without looking. That's the fastest way to make it stick.