Teaching analytics with modern 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 →
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 →
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 →
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? →
Data modeling, contrary to be nearing obsolescence, remains crucial for data analysts aiming to enhance their reporting speed and deepen their insights into business operations. Bernard Obeng …
CALCULATE() function in Excel Power PivotExcel users have access to a wealth of powerful functions through Power Pivot and DAX, but one function stands out as particularly crucial: CALCULATE(). This function holds the key to dynamically …
Continue Reading about How to use the CALCULATE() function in Excel Power Pivot →