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 →
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 →
Here are some memorable quotes from <i>Modern Data Analytics in Excel</i>
Modern Data Analytics in Excel is a technical book primarily focused on delivering dense technical information, which may not be everyone's cup of tea. However, if you delve into a lot of technical …
Continue Reading about Here are some memorable quotes from <i>Modern Data Analytics in Excel</i> →