Entering and editing data in Excel - Dashboard Guide

Dashboard Mode - Entering and editing data

Goal

Understand how to enter and edit data in Excel to keep your spreadsheet accurate and up to date.

Sample Data

Item	Quantity	Price per Unit	Total Price
Apples	10	0.50	=B2*C2
Bananas	5	0.30	=B3*C3
Oranges	8	0.60	=B4*C4
Grapes	12	0.40	=B5*C5
Peaches	7	0.55	=B6*C6

Dashboard Components

• Data Entry Table: The table where you enter and edit item names, quantities, and prices.
• Total Price Column: Uses formula =B2*C2 in row 2 and copied down to calculate total price per item.
• Total Sales KPI: Shows total sales amount with formula =SUM(D2:D6).

Dashboard Layout

+---------------------------+
|      Data Entry Table     |
|  (Items, Quantity, Price) |
|                           |
|  +---------------------+  |
|  | Total Price Column   |  |
|  +---------------------+  |
|                           |
|  Total Sales: $X.XX       |
+---------------------------+

Interactivity

When you change any quantity or price in the table, the Total Price column updates automatically. The Total Sales KPI also updates to show the new total. This keeps your data and summary always current.

Self Check

Try changing the quantity of Bananas from 5 to 10. Which components update?

• The Total Price for Bananas updates to 10 * 0.30 = 3.00.
• The Total Sales KPI updates to reflect the new total sum.

Key Result

A simple dashboard showing how to enter and edit data with automatic total calculations.