Teaching analytics with modern 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 →
Although PivotTables in Power Pivot may appear similar to those in classic Excel, critical differences exist. Creating measures is one area where Power Pivot diverges from traditional Excel, as we …
Continue Reading about How to understand implicit versus explicit measures in Excel Power Pivot →
