For decades, Excel training meant formulas, charts, and PivotTables. Now, learners open Excel and see a Copilot icon in the ribbon, a Python cell, or an automated workflow running in the background. …
How to teach Power BI to Excel users quickly
If you’re responsible for leading Power BI adoption and training at your organization, you know the challenge: users deeply comfortable with Excel may resist adopting new tools, feeling overwhelmed by …
Continue Reading about How to teach Power BI to Excel users quickly →
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 →
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 →
What are the seven wonders of Modern Excel?
I asked ChatGPT: if the 7 wonders of the modern world were modern Excel features, which would they be and why? Here's what I got back: 1. Great Wall of China - Power Query The Great Wall is …
Continue Reading about What are the seven wonders of Modern Excel? →