Teaching analytics with modern Excel
Power Pivot's PivotTables offer unique features, but creating and utilizing them can be challenging for beginners. This post offers a brief overview: Inserting the …
Continue Reading about How to create a PivotTable from the Excel PowerPivot Data Model →
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 →
I must admit, my Excel use has declined significantly since returning to school full-time. But, I still find plenty of uses - and, because they are not my routine office tasks, sometimes they are more …
It has a purpose, but GetPivotData has confused and frustrated many Excel users. You want to write a formula using PivotTable cells and get a clunky, inflexible result. Here's how to stop …
