Find and replace in Excel - Dashboard Guide

Dashboard Mode - Find and replace

Goal

Quickly update multiple cells by finding specific text and replacing it with new text in a sales report.

Sample Data

Order ID	Product	Region	Sales
1001	Apple	North	150
1002	Banana	South	200
1003	Apple	East	180
1004	Orange	West	220
1005	Banana	North	170
1006	Apple	South	160
1007	Orange	East	210

Dashboard Components

• Original Data Table: Shows the sales data with product names before replacement.
• Find and Replace Action: Use Excel's Find and Replace feature to change all occurrences of "Apple" to "Green Apple" in the Product column.
• Updated Data Table: After replacement, the Product column updates to show "Green Apple" instead of "Apple".
• Total Sales by Product: A summary table using =SUMIF(B2:B8,"Green Apple",D2:D8) to sum sales for "Green Apple" and similarly for other products.

Dashboard Layout

+----------------------+-----------------------+
| Original Data Table   | Updated Data Table    |
| (Rows 2-8)           | (After Replace)       |
+----------------------+-----------------------+
| Total Sales by Product Summary Table           |
+-----------------------------------------------+

Interactivity

When you perform Find and Replace on the Product column, the Updated Data Table changes immediately. The Total Sales by Product summary updates automatically because it uses formulas referencing the updated Product names.

Self Check

Try replacing "Banana" with "Yellow Banana" using Find and Replace. Which components update? The Updated Data Table and the Total Sales by Product summary will reflect the new product name and sales totals.

Key Result

Dashboard shows how Find and Replace updates product names and sales summaries in a sales report.