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 …
Power Automate for Excel: How to work with adaptive cards for Teams
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 →
How to connect your Excel workbook to the Dataverse via Dataflows
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 →
How to create a real estate dashboard in Power BI, Part 2: Building the dashboard
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 …
Python in Excel: How to do hierarchical clustering with Copilot
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 →
Python in Excel: How to generate descriptive statistics
Many data professionals overlook descriptive statistics, thinking their datasets aren't suited to it or that it doesn't add significant value. But descriptive statistics are foundational: they allow …
Continue Reading about Python in Excel: How to generate descriptive statistics →