Sales dashboard

A real dashboard in 2 tabs: the sales data and a dashboard with KPIs, revenue by month, region and salesperson, a color-coded ranking and three charts.

Area: Sales. Level: Advanced.

Functions used: MONTH, SUM, COUNTA, SUMIF, COUNTIF, INDEX, MATCH, MAX.

• Next project: Management income statement
• All projects
• Lessons