Entering and editing data in Google Sheets - Dashboard Guide

Dashboard Mode - Entering and editing data

Goal

Track weekly sales data for a small store by entering and updating sales numbers easily.

Sample Data

Week	Product	Sales
1	Apples	50
1	Bananas	30
2	Apples	60
2	Bananas	40
3	Apples	55
3	Bananas	35

Dashboard Components

• Sales Data Table: Editable table where you enter and update sales numbers for each product by week.
• Total Sales per Product: Shows total sales for each product using formula =SUMIF(B2:B7, "Apples", C2:C7) for Apples and =SUMIF(B2:B7, "Bananas", C2:C7) for Bananas.
• Average Sales per Week: Calculates average sales per week using formula =AVERAGE(C2:C7).

Dashboard Layout

+----------------------+-----------------------+
| Sales Data Table     | Total Sales per Product|
| (Editable)           | Apples: [formula]      |
|                      | Bananas: [formula]     |
+----------------------+-----------------------+
| Average Sales per Week (formula)               |
+------------------------------------------------+

Interactivity

When you edit sales numbers in the Sales Data Table, the Total Sales per Product and Average Sales per Week update automatically to show the new totals and averages.

Self Check

If you change the sales for Bananas in Week 2 from 40 to 50, which components update and what happens?

• Sales Data Table: Shows the new value 50.
• Total Sales per Product: Bananas total increases by 10.
• Average Sales per Week: The average sales number increases accordingly.

Key Result

A simple dashboard to enter weekly sales data and see total and average sales update automatically.