10 differences between a PowerPivot Pivot Table and a Standard one

1) PowerPivot Pivot Tables allow you to mix and match data from different tables (provided relationships between them have been created in the data model) 2) Summary Functions: PowerPivot Pivot Tables lack the "Product" and "Count Numbers" summary functions that standard pivot tables offer. But they do have the handy "Distinct Count" 🙂 3) Subtotals: Switching … Continue reading 10 differences between a PowerPivot Pivot Table and a Standard one

How Do I Quickly Export Multiple PivotTables to PowerPoint Slides?

I've got to convert all those pivot tables into slides and it's taking ages! No worries! It's not all doom and gloom!  I did write about a similar technique recently. This one is a little bit trickier because you've got to deal with multiple pivot tables per workbook rather than just one based in a … Continue reading How Do I Quickly Export Multiple PivotTables to PowerPoint Slides?

How Do I Quickly Re-filter and Export My Pivot Table Views to PowerPoint Slides?

Can you also make PowerPoints of your analyses for us, so that we can directly use them for our meetings? As much as I like getting new responsibilities, it would be a stretch to say I was jumping with joy at the prospect of spending a good hour or two on the mind-numbing activity of … Continue reading How Do I Quickly Re-filter and Export My Pivot Table Views to PowerPoint Slides?