Free Download · Word and Excel Practice Project
You're the new admin assistant. Work out the month's sales in Excel, tidy the report in Word, then bring the two together into one professional document.
Zip file · Learner guide (.docx) + Excel starter (.xlsx) + Word draft (.docx) · 3–4 hours · Basic to intermediate
Skills You'll Practise in Both Programs
Who is this for? Anyone who can already open a file, type and save, and wants to build real office skills. Every task is marked ★ Foundation, ★★ Building or ★★★ Stretch, so you can stop at your level and come back later. Brand new to Excel? Try Where Does My Money Go? first.
Three files. One tells you what to do, and the other two are the work. Download them all in the zip, or one at a time below.
27 short tasks in three parts, with every click written out. Print it or keep it open beside your work.
Forty October orders for a small office supplies business, a product price list and an empty Summary sheet.
A rough first draft of the monthly sales report. Every line looks the same, and the numbers are missing.
Three parts. Do them in one long sitting or across three shorter ones.
Calculate subtotals, GST and totals for every order. Type =K2*Summary!$B$3 to find the GST, and learn why those dollar signs matter. Then look up product names with VLOOKUP, flag bulk orders with IF, and build a summary with SUMIF and COUNTIF.
Fix the spelling, swap the business name everywhere with Find and Replace, apply heading styles, add lists, a header and footer, page numbers, a cover page and an automatic table of contents.
Fill in the report with your Excel figures, paste in your summary table and chart, add a caption, and save the finished report as a PDF. This is the part most courses skip, and the part you'll use most at work.
Works best in Microsoft Word and Excel (2016 or later, or Microsoft 365).
Finished Part 1? If your Summary sheet shows these four numbers, your formulas are on track.
40
Number of orders
294
Total items sold
$1,016.60
Total GST
$11,182.60
Total sales inc GST
Different number? Check that your GST formula uses $B$3, and that your ranges stop at row 41.
The answer key has every formula filled in, the finished chart, the answer to every question and a marking checklist for the Word report. It's free. Just tell us who you are and we'll email it to you.
Teaching a class, running a neighbourhood house program or training staff? Let us know. We're happy to talk about running this project as a workshop.
Thank you! Your request has been sent.
We'll email the answer key to you within two business days. Keep going in the meantime. You're doing well.
💛 Got stuck, or want to go further with Word and 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 →Where Did the Sales Go? 100 shop sales, SUMIF, VLOOKUP and PivotTables.
Get it →15 questions on digital tools, online safety, cloud & AI.
Start the quiz →Please note. These files are general educational content about using Microsoft Word and Excel. They are not business, tax or financial advice and do not take into account your individual circumstances, goals or needs. Bayside Office Supplies, its customers, staff and every figure in the files are invented for teaching purposes and do not represent a real business. The GST treatment shown is a simplified teaching example — for your own business, please speak to a registered tax agent. For personal and educational use only — not for resale or redistribution.
Steady hands,
Mandeep