January 2016
Beginner to intermediate
384 pages
8h 46m
English
Content preview from Excel Dashboards and Reports for Dummies, 3rd Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Part IV
Advanced Reporting Techniques
Visit www.dummies.com/extras/exceldashboardsreports to take a peek at various techniques 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.