How to Build Your First Monthly Budget
The most common first real use for these skills — a budget built from your own numbers, in the tool you just learned.
Read the guide →
Most people learn Excel by copying whatever someone showed them once, which is why so many spreadsheets contain typed-in totals that quietly go wrong. This guide teaches the small core that everything else is built on: how Excel decides what your data is, why formulas reference cells instead of numbers, what the dollar sign actually does, and the two features — lookups and pivot tables — that turn a list into an answer. Ten sessions of 25 to 40 minutes, each ending with a checklist and exercises on your own file.
What you'll be able to do: In ten days, go from a blank spreadsheet to building a working, formula-driven sheet you actually trust.
Outcome: "I can navigate a sheet, select ranges, and enter data so Excel reads it the way I mean it."
Open a blank workbook, click cell A1, type your name and press Tab; type today's date and press Enter. Watch where the cursor lands each time — Tab moves right, Enter drops to the next row and returns to the column you started in. That one behaviour removes most of the mouse work beginners do.
A sheet is a grid addressed by column letter and row number — A1, B7, C12 — and a range is two corners joined by a colon, like A1:C10. The thing beginners get wrong is data types: Excel silently decides whether what you typed is a number, a date or text. Numbers and dates align right by default; text aligns left. So if a number sits on the left of its cell, Excel thinks it's text, and every formula using it will fail or return zero. That alignment is a free diagnostic — use it.
In A1 type Month and in B1 Sales. Fill A2:A4 with January, February, March and B2:B4 with 1250, 1400, 1100. The B values sit right-aligned, so they're real numbers. Now type 1,250 EUR into B5: it lands left-aligned, because the letters made it text — and a total over B2:B5 will ignore it completely, without warning you. Delete it, type 1250, and press Ctrl+1 to format the cell as currency instead. The rule this teaches is the one that prevents most broken sheets: store the number, apply the units as formatting, and never type units into a cell you intend to calculate with.
Outcome: "I can write formulas that reference cells instead of typed-in numbers."
In any empty cell type =2+2 and press Enter. That's a formula — everything in Excel that calculates begins with the equals sign, and nothing that calculates works without it.
The golden rule of spreadsheets: never type a number into a formula when that number already lives in a cell. =1250+1400 is correct exactly once and silently wrong from the next edit onwards; =B2+B3 keeps itself right. Three functions carry most early work: SUM(range) adds, AVERAGE(range) means, and COUNT(range) counts numeric entries. Select any range and Excel already shows sum, average and count in the status bar — useful for checking a formula's answer against something you didn't write.
With months in A2:A5 and sales in B2:B5, put =SUM(B2:B5) in B6 and =AVERAGE(B2:B5) in B7. Change January from 1250 to 1500: both update the instant you press Enter. Now, in B8, write the same total the wrong way: =1250+1400+1100+1300. Today it shows the correct figure. Tomorrow someone corrects February in B3, B6 updates and B8 doesn't — and because both cells still show a plausible number, nothing looks broken. That gap between the two is the entire argument for cell references, and it's why hand-typed numbers inside formulas are the most common cause of wrong spreadsheets in real offices.
Outcome: "I can drag a formula down a column and know in advance which references will move."
Put =B2*2 in C2, then drag the small square at the cell's bottom-right corner down to C5. Click each copied cell and read the formula: B3*2, B4*2, B5*2. Excel rewrote the reference for you — that's what 'relative' means.
A plain reference like B2 is relative: copy the formula anywhere and it shifts by the same offset. A dollar sign freezes part of it. $B$2 never moves; B$2 keeps the row fixed while the column travels; $B2 does the opposite. You need this the moment one fixed value — a VAT rate, an exchange rate, a commission percentage — feeds a whole column of formulas. While editing a reference, press F4 to cycle through the four forms instead of typing dollar signs.
Prices sit in B2:B10 and the VAT rate, 21%, is typed once into E1. In C2 write =B2*$E$1 and drag down to C10: every row multiplies its own price by the single rate in E1, because the dollars stopped E1 from travelling. Write it without dollars as =B2*E1 and drag, and row 3 looks for E2, row 4 for E3 — all empty — so the column fills with zeros that look like a data problem rather than a formula problem. The real payoff comes next: change E1 to 6% and all ten rows recalculate at once. One rate, one place, one edit.
Outcome: "I can turn a raw block of data into a sheet someone else can read without asking me questions."
Click any cell inside your data and press Ctrl+T, then confirm that your block has a header row. Banded shading and filter arrows appear in one step — you've just made an Excel Table.
Three features do most of the readability work. Freeze panes (View → Freeze Panes → Freeze Top Row) keeps headers visible as you scroll. Number formatting (Ctrl+1) makes figures legible — currency, thousands separators, dates — without altering the stored value. And Tables (Ctrl+T) give you ranges that grow by themselves: a formula written against a Table column stays correct when rows are added, which a plain range does not.
Raw, it's a wall of digits. Freeze the top row so the headers stay put while you scroll to row 250. Select the amount column and press Ctrl+1 → Currency with two decimals, so 1250 reads as €1,250.00 while still calculating as 1250. Then press Ctrl+T to turn the block into a Table and rename it Expenses in the Table Design tab. Now =SUM(Expenses[Amount]) totals the column by name and keeps working when tomorrow's row 301 arrives — whereas =SUM(D2:D301), written today, will quietly stop including everything added after it.
Outcome: "I can write a formula that makes a decision, and one that fetches a value from another table."
In an empty cell write =IF(5>3,"yes","no") and read it aloud as a sentence: if this test is true, give me this, otherwise give me that. The syntax is the sentence.
IF(test, value_if_true, value_if_false) handles decisions. XLOOKUP(what_to_find, where_to_look, what_to_return) fetches a matching value from another table — it replaced VLOOKUP, and unlike VLOOKUP it doesn't care which column comes first and doesn't break when someone inserts a column. On older versions without XLOOKUP, VLOOKUP(value, table, column_number, FALSE) does the same job, and that final FALSE is non-negotiable: it forces an exact match instead of an approximate one.
A second sheet named Budgets holds category names in column A and budget figures in column B. On your main sheet, C2 holds a category and D2 the actual amount spent. To pull in the budget: =XLOOKUP(C2, Budgets!A:A, Budgets!B:B) in E2. To judge it: =IF(D2>E2,"OVER","ok") in F2. Or combine them into one cell: =IF(D2>XLOOKUP(C2,Budgets!A:A,Budgets!B:B),"OVER","ok"). Drag down, and every row now says in one word whether it broke its budget — a question that previously needed a person comparing two sheets by eye.
Outcome: "I can build a pivot table that answers a question about my data without writing a single formula."
Click any cell inside your data, then Insert → PivotTable → OK. An empty pivot appears beside a field list. Configure nothing yet — just read the four drop zones: Rows, Columns, Values and Filters.
A pivot table answers questions shaped like total X by Y. What you want broken down goes into Rows; what you want measured goes into Values; a second breakdown goes into Columns. The single most common reason a pivot refuses to behave is the source data: pivots need one clean header row and one record per row — no merged cells, no blank header, and no subtotal rows already sitting inside the data.
First question: what did we spend per category, per quarter? Drag Category into Rows, Amount into Values (it defaults to Sum), and Date into Columns — then right-click any date in the pivot and choose Group → Quarters, and Excel collapses 365 dates into four columns. Two minutes, no formulas, and you have a quarterly cross-tab. Second question: who did we spend it with? Drag Category out of Rows and Supplier in — same data, different answer, no rebuilding. Then right-click any figure → Show Values As → % of Column Total, and the euros become percentages. The skill being learned here isn't the clicking; it's asking the question in the 'total X by Y' shape before you touch anything.
The complete guide — all 6 chapters, every checklist and exercise — as a clean, printable PDF. No email required.
Every guide on this site is produced with the Self-Directed Learning Framework: instead of an article that explains a topic at you, the framework turns it into a structure you work through — each chapter with one outcome, a starting action under twelve minutes, the minimum you actually need to know, a worked example, a checklist, and exercises. It starts from three questions:
Topic: Learning the basics of Excel well enough to build a reliable sheet.
Outcome wanted: Build a working spreadsheet with formulas, lookups and a pivot table, and understand why each part behaves the way it does — within about ten days.
Starting point: Practical but shaky — can open a spreadsheet and type in it, but avoids formulas and doesn't trust the results.
The prompt framework behind it is public: see the C.R.A.F.T. prompt framework, including the exact prompt that generated this library.
The most common first real use for these skills — a budget built from your own numbers, in the tool you just learned.
Read the guide →Free, self-paced guides across everyday, professional and academic topics.
See all guides