Part IV

Macro-Charging Reports and Emails

Visit www.dummies.com/extras/excelmacros to discover how to send Excel reporting data directly to PowerPoint by using VBA.

In this part …

• Gain an understanding of how macros can be leveraged to automate your reporting processes.
• Discover how to automate the more mundane aspects of building pivot tables.
• See how macros can help work with the charts in your reports and dashboards.
• Explore some of the techniques you can leverage to send emails from Excel.