fx Dashboards

Interactivity

60 मिनट4 पाठ12 प्रश्न

पाठ

1. Slicers + timelines with multiple pivots15 min 2. Form controls: dropdown, spin button, checkbox, option buttons15 min 3. Driving charts with FILTER + dynamic arrays15 min 4. Camera tool and linked pictures15 min

अभ्यास फ़ाइल

⬇ डाउनलोड करें dashboards-practice.zip

Dashboards practice bundle

Download dashboards-practice.zip and extract it before opening the workbooks.

dashboard-starter.xlsx: dashboard canvas and a CALC sheet with financial-year and region selectors. Import the CSVs into your own RAW sheets, create named tables, and build the calculations and charts during the lessons.
dashboard-reference.xlsx: checked summary tables for all three projects. These are static answer tables; build your own PivotTables, formulas, charts and filter connections.
sales/: 50,000 orders covering FY2024-25 and FY2025-26, plus 48 region/month targets for FY2025-26 only.
finance/: monthly actual/budget P&L, line classifications and annual balance-sheet inputs.
marketing/: monthly channel metrics, separate campaign totals and cohort retention rates.
solutions-en.md and solutions-hi.md: worked guidance for all 22 lessons.
answer-key.json and audit_dashboards.py: numerical references and an optional Python 3 audit using only the standard library.

Money is in rupees; divide by 100,000 to display lakh. FY runs April–March. Import ISO dates as dates, identifiers as text and monetary fields as numbers. The modern formula lessons use Microsoft 365 functions.

Show unavailable targets as blank for FY2024-25. Label all-region sales heatmaps separately from region-filtered panels. Finance cash movements and balance-sheet ratios are annual; keep these separate from monthly P&L filters. Marketing cohorts have no Channel field and campaigns have no Month field, so label their independent scope. Treat all data as synthetic practice material.

मॉड्यूल प्रश्नोत्तरी (12)

1. Where should the pivots live?

On a hidden PVT sheet, not on DASH

2. How do you make several pivots connectable to one slicer?

Same source/cache — copy the first pivot

3. How can one slicer filter sales and targets pivots?

Both in the Data Model with a shared dimension table

4. What does a combo box write in its linked cell?

The position number of the selected item

5. How does a checkbox hide a series?

IF(checkbox, value, NA()) — NA isn't plotted

6. What keeps option buttons in separate groups?

A Group Box around each set

7. How does SUMIFS handle an "All" selection?

Use "*" as the criterion

8. How does a chart use a spilled range?

Through a defined name referring to the spill

9. What makes the Top-N chart change size?

TAKE with the spin-button cell as N

10. Where is the Camera tool?

Add it to the Quick Access Toolbar from All Commands

11. How do you make a linked picture switch views?

Point it to a name using CHOOSE/INDEX with a control cell

12. Where should you format — the picture or the source range?

The source range