EXCEL · DIGITAL WORKBOOK

Cash Collection Dashboard

Track invoice amounts, received payments and due dates. Use SUMIF to total balances by paid and unpaid status.

Who it’s for

Beginners building practical excel skills.

What you’ll practise

• Use SUMIF to total balances by paid and unpaid status
• Verify that outstanding equals billed minus received

What you get

A worked example, guided exercise, independent practice and a review checklist. Delivered as a text file.