Teaching analytics with modern Excel
In a previous post, we explored the GROUPBY() function as a formula-driven alternative to PivotTables in Excel: Although the GROUPBY() function is useful, it lacks a key feature: the ability to …
Continue Reading about How to understand the PIVOTBY() function in Excel →
As analysts, the ability to summarize and aggregate data on the fly is an essential skill. Traditionally, PivotTables have been a popular method for this purpose. However, a new, function-driven …
Continue Reading about How to understand the GROUPBY() function in Excel →
Copilot for Excel is now live, bringing a suite of AI-powered features directly into your Excel experience. It's time to embrace the future of data analysis and ensure you're fully prepared to utilize …
Excel's PivotTable has always been a powerful tool for data analysis, but with the introduction of the Recommended PivotTable feature, it has become even more accessible and intuitive to unearth …
Continue Reading about AI-Powered Excel: Insert a PivotTable with Recommended PivotTable →
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 →
Excel PivotTables are great for summarizing a variety of columns of a dataset in a variety of ways. But there's one particular use case where the classic PivotTable falls short. Let's take a look at …
Continue Reading about How to get the count of distinct items using Excel PivotTables →
