Free Download · Excel Practice File 2
One hundred shop sales, four stores, and one owner who wants to know how the business is going. Turn a long list into an answer.
Excel workbook (.xlsx) · 60–90 minutes · 51 numbered steps · Answers included
Eleven Skills You'll Practise
New to Excel? Start with Where Does My Money Go? first. That file teaches you the basics — typing a formula, filling it down, and building a chart — in about half an hour. This one picks up exactly where it leaves off. If you can already total a column, you are ready for this.
Three tabs, the same as the first file. 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.
Fifty-one numbered steps grouped into eleven short tasks. Each one names the exact cell and the exact thing to type.
One hundred transactions across four stores, January to July 2026. 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 =H8*I8 to multiply the price by the quantity — then fill it down 100 rows with one double-click.
The tax rate lives in its own cell, so the formula points at it rather than hiding a number inside itself. Set it to 10% for Australian GST, 15% for New Zealand, 20% for UK VAT — or 0 if there's no sales tax where you are. Every figure in the file updates on its own.
Type =SUMIF($C$8:$C$107,A124,$M$8:$M$107). In plain English: look down the Store column, and wherever it matches, add up the sale. Those dollar signs are the part everyone gets stuck on, and the file explains exactly why they're there.
Type =SUMIFS(...) to find footwear sales at one particular store. This is where a spreadsheet starts doing something a calculator cannot.
Use VLOOKUP, then do the same job again with INDEX and MATCH — and see why people at work tend to prefer the second one.
A PivotTable does in thirty seconds what your formulas did in twenty minutes. You learn both on purpose: the formulas are what teach you what the PivotTable is actually doing.
The last task asks you to write three or four sentences about what you found. Anyone can total a column. Being able to say what the numbers mean is the skill that gets noticed at work.
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 Does My Money Go? Learn formulas and charts by building a real monthly budget.
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 business, tax or financial advice and does not take into account your individual circumstances, goals or needs. The shop, the staff and every figure in the workbook are invented for teaching purposes and do not represent a real business. The tax rate is set to Australian GST (10%) by default and can be changed in the workbook; the treatment shown is a simplified teaching example — for your own business, please speak to a registered tax agent or the equivalent in your country. For personal and educational use only — not for resale or redistribution.
Steady hands,
Mandeep