Free Shipping Anywhere in the World

Shop over 1 Million Toys in our Huge New Range

Excel Dashboards and Reports for Dummies, 3rd Edition


Product Description
Product Details

Table of Contents

Introduction 1 Part I: Getting Started with Excel Dashboards & Reports 7 Chapter 1: Getting In the Dashboard State of Mind 9 Chapter 2: Building a Super Model 25 Part II: Building Basic Dashboard Components 51 Chapter 3: Dressing Up Your Data Tables 53 Chapter 4: Sparking Inspiration with Sparklines 69 Chapter 5: Formatting Your Way to Visualizations 83 Chapter 6: The Pivotal Pivot Table 115 Part III: Building Advanced Dashboard Components 151 Chapter 7: Charts That Show Trending 153 Chapter 8: Grouping and Bucketing Data 179 Chapter 9: Displaying Performance against a Target 201 Part IV: Advanced Reporting Techniques 217 Chapter 10: Macro-Charged Dashboarding 219 Chapter 11: Giving Users an Interactive Interface 233 Chapter 12: Adding Interactivity with Pivot Slicers 255 Part V: Working with the Outside @World 273 Chapter 13: Using External Data for Your Dashboards and Reports 275 Chapter 14: Sharing Your Workbook with the Outside World 301 Part VI: The Part of Tens 323 Chapter 15: Ten Chart Design Principles 325 Chapter 16: Ten Excel Chart Types and @When to Use Them 339 Index 345

About the Author

Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
Item ships from and is sold by Fishpond World Ltd.
Back to top