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?