Excel Dashboards and Reports For Dummies, 2nd Edition

Part IV

Advanced Reporting Techniques

Visit www.dummies.com/extras/exceldashboardsandreports to get a peek at various techniques that you can use to create dynamic labels, allowing you to create a whole new layer of visualization.

In this part …

• Take an in-depth look at some of the key dashboarding concepts you can leverage to create cutting-edge presentations.
• Gain a clear understanding of how you can leverage macros to automate your reporting systems.
• Discover how interactive controls can provide your clients with simple interfaces, allowing them to easily navigate through and interact with your dashboard or report.
• Explore pivot slicers and see how to use them to add interactive filtering capabilities to your pivot reporting.