Microsoft Excel - Intermediate(With Labs and Exam)
You are the clerk at Lucky Wholesalers Ltd, a wholesale distributor in Lusaka. Every Friday you and the supervisor count the stock, and this week the till does not seem to balance. Your mission is to turn the raw stock-count data into a professional Sales sheet with formulas, currency formatting, a cash-up check, a chart, and a print-ready PDF. This intermediate Excel course covers structuring worksheets, formulas and functions, number formatting, the IF function, charts, and preparing output for print and PDF.
Explore this course
Preview the journey below — 6 hands-on labs. Enroll to unlock the labs, study notes, the practice quiz and the certification exam.
Study Notes
Hints
Lay Out the Sales Sheet
Stuck? Peek at a pointer, not the answer
Check and Organise the Data
Stuck? Peek at a pointer, not the answer
Build the Sales Formulas
Stuck? Peek at a pointer, not the answer
Format the Sales Report
Stuck? Peek at a pointer, not the answer
Complete the Cash-Up
Stuck? Peek at a pointer, not the answer
Chart the Sales and Prepare the Output
Stuck? Peek at a pointer, not the answer
Hands-On Labs
Lay Out the Sales Sheet
Open the raw stock data, save a working copy, and build the title, details block and header row that turn it into a Sales sheet.
45 min · Enrolled users only
Check and Organise the Data
Verify every product is present, tidy the category rows, practise inserting and deleting rows, and freeze the header so it stays visible.
40 min · Enrolled users only
Build the Sales Formulas
Write the sales formula, copy it down the column with the fill handle, and add the total with SUM.
45 min · Enrolled users only
Format the Sales Report
Apply currency formats, bold headings, borders and a title style so the report reads professionally and matches the target look.
50 min · Enrolled users only
Complete the Cash-Up
Build the reconciliation block, add the IF status formula, and read the result - the till is short by K788.
45 min · Enrolled users only
Chart the Sales and Prepare the Output
Create a column chart of sales by product, then set up the page, add a header and footer, check the print preview, and export the report as a PDF.
50 min · Enrolled users only