Excel Practice Workbooks

Download function practice workbooks and editable sales, collection, receivables and budget MIS templates.

Practice in your own Excel installation

Download the function workbook from its lesson or choose a project workbook. Each V22 function workbook contains a preserved sandbox, typed Inputs, ten distinct Practice tasks and an executable Answer key. Check the version guidance and recalculate in Excel with Ctrl+Alt+F9 before reviewing calculated results.

MIS reporting templates

Sales performance MIS

Compare team sales with targets for a selected month. See achievement, shortfall and the teams that need attention.

Each row represents a sales allocation with its own target. Do not repeat a monthly team target on every transaction.

Preview Sales performance MIS · Download Sales performance MIS

Branch collection MIS

Track branch collections against allocated targets. Review achievement and the remaining amount to collect.

Collections are cash received, not sales. Allocate each target once to avoid double counting.

Preview Branch collection MIS · Download Branch collection MIS

Receivables aging

Group unpaid invoices into current, 1–30, 31–60, 61–90 and 90+ day buckets using a fixed report date.

This is an invoice snapshot, not a payment ledger. Historical reports require the payment total as of that date. Credit notes and multiple currencies need separate treatment.

Preview Receivables aging · Download Receivables aging

Budget versus actual

Compare monthly department expenses with the budget. Positive variance means overspend; zero budgets remain explicit.

Each budget allocation is entered once. Compare expenses on the same accounting basis; this is not a cash-flow forecast.

Preview Budget versus actual · Download Budget versus actual

Interactive practice runs in your browser.