26/10/2026
Comment “Guide” and I’ll send you the exact steps and the prompt.
Build a live dashboard in Microsoft Copilot from any Excel file saved in SharePoint, and turn it into an agent you can run again and again. No Power BI, no rebuilding the same report every month.
Save your file to SharePoint, create a new agent in Copilot, and describe what you want in plain language. The agent builds the dashboard for you, and when the file updates, one command refreshes it with the latest numbers.
You can also chat with your data directly or turn the dashboard into a presentation for your boss. It works for expense trackers, sales reports, MIS files and any data your team updates regularly.
