Advanced Analysis with Python in Copilot for Excel can help with many data analysis tasks that would typically be challenging to execute in Excel. From building predictive models using techniques like …
How to refresh all Excel workbook connections with Office Scripts and Power Automate
In a previous post we explored the relationship between Power Automate and Power Query, explaining that Power Automate and Power Query serve different purposes in workflow automation and data …
How to create interactive visualizations in Excel using dynamic arrays
Among all of the amazing enhancements in Excel, one that really resonates with the core of Excel is dynamic arrays. Spreadsheets became popular primarily because of their tactile ability to visually …
Continue Reading about How to create interactive visualizations in Excel using dynamic arrays →
Useful links for getting started with Python in Excel
Python integration with Excel has arrived! While I enjoy guiding newcomers, diving into the documentation can often provide the most comprehensive understanding. Below, I've compiled a list of key …
Continue Reading about Useful links for getting started with Python in Excel →
How to load multiple tables to the Data Model at once in Excel
In my training sessions, I often have learners practice loading multiple datasets into Power Query and the Data Model, one file at a time. A common question arises: how can we load several datasets …
Continue Reading about How to load multiple tables to the Data Model at once in Excel →
Power Automate for Excel: How to understand conditional flows
One of the most essential tools for making computers work for you is conditional logic—"if this, then that" logic. It's simple yet incredibly powerful, and much of how computers function today relies …
Continue Reading about Power Automate for Excel: How to understand conditional flows →