Stationery shop sales report
Turn weekly transaction data into a useful sales summary.
Skills: Formulas · SUM · MAX
Practical Excel projects
Turn separate skills into useful spreadsheet work.
Small-business budget review
Summarise monthly costs and identify the largest spending areas.
Skills: SUM · AVERAGE · MIN/MAX
Sales target decision tool
Apply performance rules and flag teams that need attention.
Skills: IF · AND/OR · Percentages
Regional sales summary
Answer management questions across regions, products, and months.
Skills: SUMIFS · COUNTIF · Criteria
Customer records cleanup
Repair inconsistent customer records and prepare them for import.
Skills: TRIM · UPPER · LEN
Inventory and reorder report
Match stock records to prices and identify items to reorder.
Skills: XLOOKUP · IFERROR · COUNTIF
Supplier pricing model
Connect supplier, quantity, and region tables to select the right price.
Skills: SUMIFS · Multi-criteria · MIN/MAX
Live operations tracker
Build an operations view that updates as new records are added.
Skills: COUNTIF · SUMIFS · Live summaries
Executive KPI dashboard
Turn detailed business data into a concise management dashboard.
Skills: SUM · AVERAGE · Dashboard controls
Cash-flow investment model
Forecast cash flow and assess whether a fictional expansion is viable.
Skills: Cash flows · AVERAGE · IF
Reusable monthly report
Refactor a repetitive monthly report into a clear, reusable template.
Skills: ROUND · SUM · IFERROR
Workbook audit and handover
Find formula risks, repair issues, and prepare a model for handover.
Skills: Control totals · COUNTIF · IF