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?
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?
Resetting the default settings for all my pivot tables takes forever! No worries! Here's a piece of VBA code that makes resetting these a breeze! Why should I bother adjusting, though? Whilst most of these settings are more of a "visual best practice", they can have an impact on how people perceive your analysis Unfamiliar … Continue reading How Do I Quickly Reset a Pivot Table Default Settings with VBA?