Analytics & AI for Modern Excel
As Excel users, we spend a lot of time reporting on data across different teams, formats, and audiences. We’re expected not just to crunch numbers but to generate insights and communicate them …
Continue Reading about How to build AI-powered Excel reports with Power Automate →
Every time I run a Copilot for Excel workshop, there’s one question that always comes up: “How can I make Copilot remember my prompts so it can do my weekly reports automatically?” Short …
Many Excel users spend hours each week creating reports, exporting data, and sending the same updates around. It works, but it’s repetitive and time-consuming. A smarter option is to bring those …
Continue Reading about Power Automate for Excel: How to work with adaptive cards for Teams →
If you want to make your Excel data more useful across the Power Platform, connecting it to Dataflows within Power Apps is the right starting point. By moving data from your workbook into a Dataflow, …
Continue Reading about How to connect your Excel workbook to the Dataverse via Dataflows →
In a previous post, I showed how to take a tenancy schedule from a real estate brochure PDF and turn it into a Power BI dashboard. In the last post, we focused on retrieving and cleaning the …
Hierarchical clustering is a technique that groups similar data points into clusters based on their attributes, forming a hierarchy or tree-like structure. Imagine organizing customers based on their …
Continue Reading about Python in Excel: How to do hierarchical clustering with Copilot →
