How Do I Quickly Re-filter and Export Camera Tool Views to PowerPoint Slides?

What the heck is Excel Camera Tool? Excel's camera tool is a pretty handy button that allows you to make interactive pictures of your data! It comes especially handy when you need to copy Excel data that falls in non-adjacent ranges (since the camera tool generates an interactive picture, outline grouping can be used to … Continue reading How Do I Quickly Re-filter and Export Camera Tool Views to PowerPoint Slides?

How Do I Quickly Export My Charts to PowerPoint Slides?

Your articles on exporting Excel pivot tables to PowerPoint have come super handy but now I need to copy a bunch of charts... How do I tackle this? Before you continue, you'll need to keep a very important difference in mind - namely the one that VBA makes between chart sheets and chart objects • … Continue reading How Do I Quickly Export My Charts to PowerPoint Slides?

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?