Free Download ยท Excel Practice File
Learn Excel formulas and charts by building one month of a real household budget โ at your own pace, with every step explained.
Excel workbook (.xlsx) ยท 30โ40 minutes ยท No experience needed ยท Answers included
Seven Skills You'll Practise
Three tabs. One tells you what to do, one is the work, and one shows you the answers โ so you can check yourself without needing to ask anyone.
Thirty-three numbered steps in plain language. Each one names the exact cell and the exact thing to type.
The workbook itself โ seven spending categories over one month. Only the yellow cells need you.
Every formula finished and both charts already built, so you can compare your work line by line.
A quick look at the kind of thing you'll be doing. Every step in the file is written out like this.
Type =B9*C9 to multiply the cost of something by how many times it was paid this month.
Type =E9-D9 to subtract the spending from the budget. A number in brackets means you overspent.
Type =D9/E9, then click the % button. Anything above 100% is a category worth a second look.
One click on the ฮฃ button totals a whole column. This is the single most useful thing Excel does.
From the same numbers. Seeing where the money went is very different from reading a list of it.
Replace the sample figures with your own real spending. Every formula recalculates on its own โ which is the whole point of learning this.
Opens in Microsoft Excel, Google Sheets, LibreOffice Calc or Apple Numbers.
๐ Got stuck, or want to go further with Excel?
Your first discovery call is always free โ no pressure, no commitment.
Book Your Free Discovery CallAll free, all beginner-friendly, all yours to keep.
Where Did the Sales Go? 100 shop sales, SUMIF, VLOOKUP and PivotTables.
Get it โA free 2-minute quiz based on Her Money, Her Future.
Start the quiz โBeginner, Intermediate or Advanced. Test your money knowledge.
Start the quiz โ15 questions on digital tools, online safety, cloud & AI.
Start the quiz โPlease note. This file is general educational content about using spreadsheets. It is not personal financial advice and does not take into account your individual circumstances, goals or needs. All figures in the workbook are illustrative only. Before making financial decisions, please consult a licensed financial adviser. For personal and educational use only โ not for resale or redistribution.
Steady hands,
Mandeep