Why formulas automate calculations in Excel - Dashboard Impact

Dashboard Mode - Why formulas automate calculations

Dashboard Goal

Understand how formulas in Excel automatically update calculations when data changes.

Sample Data

Item	Price	Quantity	Total
Apples	2	5	=B2*C2
Bananas	1.5	8	=B3*C3
Oranges	3	4	=B4*C4
Grapes	4	3	=B5*C5
Totals			=SUM(D2:D5)

Dashboard Components

• KPI Card: Total Sales showing =SUM(D2:D5) which sums all item totals.
• Data Table: Shows Price, Quantity, and Total columns. The Total column uses formula =B2*C2 for each row to calculate item sales.
• Explanation Box: Text explaining that when you change Price or Quantity, the Total and Total Sales update automatically because of formulas.

Dashboard Layout

+----------------------+--------------------+
|      Data Table      |   Explanation Box   |
|  (Items, Prices, Qty)|  (Why formulas auto |
|  and Totals column)  |   update results)   |
+----------------------+--------------------+
|                 Total Sales KPI Card          |
+----------------------------------------------+

Interactivity

When you change any number in the Price or Quantity columns, Excel recalculates the Total for that row automatically. Then, the Total Sales KPI card updates because it sums the updated totals. This shows how formulas automate calculations without manual effort.

Self Check

If you change the quantity of Bananas from 8 to 10, which components update?

• The Total for Bananas updates automatically.
• The Total Sales KPI card updates to reflect the new sum.
• The data table shows the new total for Bananas.

Key Result

Shows how Excel formulas automatically update totals and overall sales when data changes.