Alexander Michael. Excel Dashboards and Reports for Dummies

Alexander Michael. Excel Dashboards and Reports for Dummies, 3rd Edition. — For Dummies, 2016. - 384p.
ISBN10: 1119076765 ISBN13: 978-1119076766
Файл PDF в архиве ZIP.Part I Getting Started with Excel Dashboards & Reports
Getting In the Dashboard State of Mind
Building a Super Model
Part II Building Basic Dashboard Components
Dressing Up Your Data Tables
Sparking Inspiration with Sparklines
Formatting Your Way to Visualizations
The Pivotal Pivot Table
Part III Building Advanced Dashboard Components
Charts That Show Trending
Grouping and Bucketing Data
Displaying Performance against a Target
Part IV Advanced Reporting Techniques
Macro-Charged Dashboarding
Giving Users an Interactive Interface
Adding Interactivity with Pivot Slicers
Part V Working with the Outside World
Using External Data for Your Dashboards and Reports
Sharing Your Workbook with the Outside World
Part VI The Part of Tens
Ten Chart Design Principles
Ten Excel Chart Types and When to Use Them