Excel Interactive Dashboard with Copilot

Key insights

• Piggy Bank Accountant posted a short about an interactive Excel dashboard with Copilot.
• The idea is to describe a report in natural language and let Copilot build it.
• The dashboard stays linked to the workbook, so source data changes can flow through.
• Microsoft is introducing the feature to Microsoft 365 Insiders.
• The video is a 56-second YouTube Short, so the detail level is limited.

Piggy Bank Accountant recently published a 56-second YouTube Short about an interactive Excel dashboard made with Copilot. The clip shows Microsoft’s idea of turning workbook data into an interactive report with less manual setup. The main takeaway is simple: instead of building every chart and filter by hand, you can describe what you want and let Copilot generate the first version.

The short is brief, so the publisher does not walk through a full demo. The research notes supplied with the page say the feature is currently being introduced to Microsoft 365 Insiders. That means readers should treat this as an early look rather than a finished, broadly available release.

What's new

The new element is an Interactive Canvas experience in Excel. According to the source notes, Copilot can take data already in a workbook and generate an interactive dashboard or report from a plain-language request. The examples in the notes include executive reviews, project status reports, financial performance dashboards, sales overviews, and budget or planning reports.

The generated result is not just a static image. It remains connected to the workbook, so changes in the underlying data can flow through to the report. That makes the output closer to a working Excel artifact than a one-off summary.

Why it matters

For Excel users who build reports regularly, this could reduce repetitive work. Instead of arranging charts, formulas, PivotTables, and filters from scratch, Copilot can handle the first pass. That is most relevant for analysts, business users, and makers who need quick reporting without spending time on layout and setup.

For admins and rollout watchers, the key detail is the Insider status. The material does not say when the feature will reach all tenants or whether it depends on specific plans beyond Microsoft 365 Insiders. For now, that limits how far you can plan around it.

If you follow Excel news, this is another sign that Microsoft is pushing Copilot deeper into everyday workbook work.

How it works

1. Open an Excel workbook that already contains structured data.
2. Open Copilot in Excel.
3. Describe the dashboard or report you want in natural language.
4. Let Copilot analyze the workbook and create the initial layout.
5. Ask Copilot to refine the design, metrics, visual emphasis, or presentation.
6. Review the result and apply the changes you want.

The notes also say Copilot can work with Excel features such as charts, PivotTables, shapes, formulas, and summaries. In practice, that means the dashboard can be edited after Copilot creates it, rather than being locked into a fixed output.

Limitations and open questions

The source material is thin and does not include a full product announcement, licensing details, or a complete feature list. It also does not confirm whether every Copilot-generated dashboard option is available in the short clip, only that the concept is shown and that Microsoft is introducing the feature to Insiders.

We could not verify tenant availability, platform differences, or whether any specific data preparation is required beyond having structured workbook data. The notes mention slicers, filters, and timeline controls as part of dashboard guidance, but the short itself does not show those steps in detail.

Sources

• Piggy Bank Accountant YouTube Short

Frequently asked questions

What did the short show?

It showed the idea of creating an interactive Excel dashboard with Copilot from data already in a workbook. The source material does not provide a full step-by-step demo.

Who can use it right now?

The notes say the feature is being introduced to Microsoft 365 Insiders. The material does not confirm broader availability.

Does the dashboard stay connected to the data?

Yes, the notes say the generated canvas remains linked to the workbook. That means changes in the source data can flow through to the report.