Why automation saves hours in Excel - Dashboard Impact

Dashboard Mode - Why automation saves hours

Goal

Understand how automating repetitive tasks in Excel saves time by comparing manual and automated work hours.

Sample Data

Task	Manual Time (minutes)	Automated Time (minutes)	Times Per Week
Data Entry	30	5	5
Report Generation	45	10	3
Data Cleaning	20	4	4
Email Sending	15	3	7
File Organization	25	6	2

Dashboard Components

• Total Manual Time per Week (minutes): =SUMPRODUCT(B2:B6,D2:D6)
  Calculates total time spent manually on tasks each week.
• Total Automated Time per Week (minutes): =SUMPRODUCT(C2:C6,D2:D6)
  Calculates total time spent with automation each week.
• Time Saved per Week (minutes): =SUMPRODUCT(B2:B6,D2:D6)-SUMPRODUCT(C2:C6,D2:D6)
  Shows how many minutes are saved weekly by automation.
• Time Saved per Week (hours): = (SUMPRODUCT(B2:B6,D2:D6)-SUMPRODUCT(C2:C6,D2:D6))/60
  Converts saved minutes into hours for easier understanding.
• Summary Table: Shows each task with manual time, automated time, times per week, and time saved per week = (B2 - C2)*D2 copied down.

Dashboard Layout

+-----------------------------+-----------------------------+
| Total Manual Time (minutes)  | Total Automated Time (minutes)|
|           [KPI]              |             [KPI]             |
+-----------------------------+-----------------------------+
| Time Saved per Week (minutes) | Time Saved per Week (hours) |
|            [KPI]             |             [KPI]             |
+-------------------------------------------------------+
|                    Summary Table                        |
|  Task | Manual | Automated | Times/Week | Time Saved   |
+-------------------------------------------------------+

Interactivity

Add a filter to select specific tasks. When a task is selected, all KPIs and the summary table update to show data only for that task. This helps focus on time savings for chosen tasks.

Self Check

If you filter to show only "Report Generation", which components update?

• All KPIs recalculate totals and savings only for "Report Generation".
• The summary table shows only the row for "Report Generation".

Key Result

Dashboard shows weekly time spent manually vs automated on tasks and total time saved by automation.