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 II
Building Basic Dashboard Components
Discover how to add dynamic annotations to your charts at www.dummies.com/extras/exceldashboardsreports.
In this part …
Uncover the best practices for designing effective data tables.
See how you can leverage the Sparkline functionality found in Excel.
Look at the various techniques you can use to visualize data without the use of charts or graphs.
Explore how pivot tables can enhance your analytical and reporting capabilities as well as your dashboards.