Professional Excel Sales Dashboard — Formulas, Charts and Automated Reports. A complete, ready-to-use sales dashboard workbook for a small shop: 7 sheets, 120 sample orders (January–December 2026), and everything calculated with live formulas — no hard-coded totals.

What's inside:

• Dashboard: 8 live KPIs (revenue $14,314, units 807, profit $5,725.60, 40% margin, average order $119.28) plus 3 charts (revenue by category, monthly revenue trend, top 5 products).
• Sales Data: a real Excel Table with 120 sample orders; category, price and cost are pulled automatically from the Products catalog with VLOOKUP, and amounts and profit are formula-driven.
• Category Summary: SUMIFS totals per category with a pie chart and data bars.
• Monthly Report: monthly revenue, orders and profit by COUNTIFS/SUMIFS, a trend line chart, and automated insights (best month, best quarter, strongest growth, average monthly revenue).
• Product Performance: a live SUMIFS ranking of all 15 products by revenue.

A Start Here sheet explains every sheet in plain language. All figures in the sample rows are clearly labeled SAMPLE data — replace them with your own sales and every KPI, chart and report updates automatically. Works in Excel and LibreOffice; all totals verified.