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?
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?
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?