Build a Simple Sales Dashboard

Combine KPIs and a chart into a one-glance dashboard.

You will learn to

• Build KPI formulas
• Find the best month with INDEX/MATCH
• Add a chart

How it works

A small dashboard combines a few key numbers (KPIs) with a chart. Calculate total revenue with SUM, average order value with SUM(revenue)/SUM(orders), and find the best month with INDEX and MATCH on MAX.