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 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 →
How to stop storing Excel workbooks in xlsb format
Many organizations resort to storing data in xlsb binary format for their workbooks, primarily because they find themselves grappling with files that are simply too large and fragile. While it may …
Continue Reading about How to stop storing Excel workbooks in xlsb format →