When introducing newcomers to Python in Excel, I typically recommend that they have some basic Python knowledge beforehand. This helps reduce the mental effort required to grasp the Python in Excel …
The End of DAX and M? How AI and Python Are Transforming Excel
As we delve deeper into the age of artificial intelligence and AI-assisted programming, a question arises: Are the plethora of programming languages in Excel becoming obsolete? With the advent of AI, …
Continue Reading about The End of DAX and M? How AI and Python Are Transforming Excel →
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 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 in Excel: How to update a table when a new file is added to a folder
Whether you're managing invoices, project documents, or daily reports, creating a log of all file uploads in a folder can be a valuable tool for tracking workflows, configuring updates, and …
How to understand the VSTACK() and HSTACK() functions in Excel
Appending data sources is a common data cleaning task in Excel. And while Power Query offers robust methods for doing this, the immediacy and hands-on feel of Excel formulas can be unbeatable. The …
Continue Reading about How to understand the VSTACK() and HSTACK() functions in Excel →