Your Cart
Loading

Monthly KPI Report in Excel — Workbook & Practice File

On Sale
$2.39
$2.39
Added to cart

Monthly KPI Report — Excel Practice Workbook

Build a practical monthly business performance report using real Excel formulas and structured sales data.

This is the exact Excel workbook used in the Mr.Excellerator YouTube tutorial, Create a Monthly KPI Report in Excel.

Instead of building the example from scratch, you get a ready-to-use workbook with 120 realistic sales transactions, working calculations, monthly reporting formulas, and a connected KPI dashboard.

What's Included

  • Sales Data: 120 realistic sample transactions with dates, regions, products, prices, costs, and payment statuses.
  • Monthly KPI Report: Revenue, Costs, Gross Profit, Gross Margin, Paid Orders, and Units Sold.
  • Regional Performance: Monthly revenue and revenue share across four regions.
  • KPI Dashboard: A connected management summary displaying the selected month's results.
  • Practice Exercises: Guided tasks to help you understand and reuse the reporting model.

What You'll Learn

  • Calculate monthly KPIs using SUMIFS and COUNTIFS.
  • Work with Excel Tables and structured references.
  • Calculate profit and gross margin.
  • Compare performance across regions.
  • Check reporting accuracy using reconciliation formulas.
  • Update the reporting period without rebuilding the report.

Built for Reuse

The source data uses an expandable Excel Table, allowing new transactions to be included in the reporting calculations without manually editing fixed-range formulas.

The workbook is suitable for following the tutorial, experimenting with sample data, and adapting the reporting logic to your own transactions.

Compatibility: Excel 2016, 2019, 2021, and Microsoft 365.

File format: XLSX. No VBA macros required.

Note: Gross profit represents revenue minus direct transaction costs. It does not include overhead, taxes, or other operating expenses.

Get the exact workbook, follow the tutorial, and start building more reliable monthly reports.

You will get a XLSX (19KB) file