Excel on the web - Dashboard Guide

Dashboard Mode - Excel on the web

Dashboard Goal

See how sales perform across regions and products using Excel on the web. Quickly find total sales, average sales, and top-selling products.

Sample Data

Region	Product	Sales
East	Apples	100
West	Apples	150
East	Oranges	200
West	Oranges	120
East	Bananas	90
West	Bananas	110

Dashboard Components

• Total Sales: =SUBTOTAL(9,C2:C7) Result: 770
• Average Sales per Entry: =SUBTOTAL(1,C2:C7) Result: 128.33
• Sales by Region (East): =SUMIF(A2:A7,"East",C2:C7) Result: 390
• Sales by Region (West): =SUMIF(A2:A7,"West",C2:C7) Result: 380
• Top Selling Product: =INDEX(B2:B7,MATCH(MAX(C2:C7),C2:C7,0)) Result: Oranges
• Sales Table: Displays all data rows for detailed view.

Dashboard Layout

+----------------------+-----------------------+
| Total Sales: 770     | Average Sales: 128.33 |
+----------------------+-----------------------+
| Sales East: 390      | Sales West: 380       |
+----------------------+-----------------------+
| Top Selling Product: Oranges                 |
+---------------------------------------------+
| Sales Table (Region, Product, Sales)        |
| East, Apples, 100                            |
| West, Apples, 150                            |
| East, Oranges, 200                           |
| West, Oranges, 120                           |
| East, Bananas, 90                            |
| West, Bananas, 110                           |
+---------------------------------------------+

Interactivity

Use Excel on the web filters to select a specific Region or Product. When you filter by Region, the Total Sales, Average Sales, Sales by Region, and Top Selling Product update automatically to show only filtered data. The Sales Table also updates to show only matching rows.

Self Check

If you add a filter for Region = "East", which components update?

• Total Sales changes to 390
• Average Sales changes to 130
• Sales by Region (East) shows 390
• Sales by Region (West) shows 0
• Top Selling Product updates to "Oranges" (highest in East)
• Sales Table shows only East region rows

Key Result

Excel on the web dashboard showing total and average sales, sales by region, top product, and detailed sales table with filtering.