AVERAGE function in Excel - Dashboard Guide

Dashboard Mode - AVERAGE function

Goal

Find the average sales amount for a small store over a week to understand typical daily sales.

Sample Data

Day	Sales ($)
Monday	120
Tuesday	150
Wednesday	130
Thursday	170
Friday	160
Saturday	200
Sunday	180

Dashboard Components

• Average Sales Card: Shows the average daily sales.
  Formula: =AVERAGE(B2:B8)
  Result: 158.57
• Sales Data Table: Displays daily sales for reference.

Dashboard Layout

+----------------------+------------------+
| Average Sales Card    | Sales Data Table |
| (Shows average)      | (Daily sales)    |
+----------------------+------------------+

Interactivity

Currently, no filters or slicers are added. The average updates automatically if sales data changes.

Self Check

If you change the sales value for Wednesday to 190, what happens to the average sales?

Answer: The average sales will increase because the Wednesday sales value is higher.

Key Result

Dashboard shows average daily sales calculated using the AVERAGE function from weekly sales data.