Book description
Create dynamic dashboards and put your data on display with For Dummies
No matter what business you're in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards & Reports For Dummies is here to help you make meaning of all your data and turn it into clear and actionable visualizations. Fully updated for the latest business intelligence and spreadsheet tools in Excel 2013, this book shows you how to analyze large amounts of data, quickly slice data into various views on the fly, automate redundant reporting, create eye-catching visualizations, and more.
Helps you move beyond reporting data with simple tables, rows, and columns to designing high-impact reports, dashboards, and visuals
Walks you through a wide array of technical and analytical concepts to give you the background you need to select the right tool for interpreting and displaying data
Covers how to build a chart, work with pivot tables, group and bucket your data, represent trends, create What-If analyses, and increase the value of your reports
Excel Dashboards & Reports For Dummies, 2nd Edition is the business analysis tool you need to transform your raw data into a powerful and effective presentation that is accessible to everyone.
Table of contents
-
- Introduction
- Part I: Getting Started with Excel Dashboards and Reports
-
Part II: Building Basic Dashboard Components
- Chapter 3: Dressing Up Your Data Tables
- Chapter 4: Sparking Inspiration with Sparklines
- Chapter 5: Formatting Your Way to Visualizations
- Chapter 6: The Pivotal Pivot Table
-
Part III: Building Advanced Dashboard Components
- Chapter 7: Charts That Show Trending
- Chapter 8: Grouping and Bucketing Data
- Chapter 9: Displaying Performance against a Target
-
Part IV: Advanced Reporting Techniques
- Chapter 10: Macro-Charged Dashboarding
-
Chapter 11: Giving Users an Interactive Interface
- Getting Started with Form Controls
- Using the Button Control
- Using the Check Box Control
- Using the Option Button Control
- Option Button Example: Showing Many Views through One Chart
- Using the Combo Box Control
- Combo Box Example: Changing Chart Data with a Drop-Down Selector
- Using the List Box Control
- List Box Example: Controlling Multiple Charts with One Selector
- Chapter 12: Adding Interactivity with Pivot Slicers
-
Part V: Working with the Outside World
- Chapter 13: Using External Data for Your Dashboards and Reports
- Chapter 14: Sharing Your Workbook with the Outside World
-
Part VI: The Part of Tens
-
Chapter 15: Ten Chart Design Principles
- Avoid Fancy Formatting
- Skip the Unnecessary Chart Junk
- Format Large Numbers Where Possible
- Use Data Tables instead of Data Labels
- Make Effective Use of Chart Titles
- Sort Your Data before Charting
- Limit the Use of Pie Charts
- Don’t Be Afraid to Parse Data into Separate Charts
- Maintain Appropriate Aspect Ratios
- Don’t Be Afraid to Use Something Other Than a Chart
-
Chapter 16: Ten Questions to Ask Before Distributing Your Dashboard
- Does My Dashboard Present the Right Information?
- Does Everything on My Dashboard Have a Purpose?
- Does My Dashboard Prominently Display the Key Message?
- Can I Maintain This Dashboard?
- Does My Dashboard Clearly Display Its Scope and Shelf Life?
- Is My Dashboard Well Documented?
- Is My Dashboard Overwhelmed with Formatting and Graphics?
- Does My Dashboard Overuse Charts When Tables Will Do?
- Is My Dashboard User-Friendly?
- Is My Dashboard Accurate?
-
Chapter 15: Ten Chart Design Principles
- About the Author
- Cheat Sheet
- More Dummies Products
Product information
- Title: Excel Dashboards and Reports For Dummies, 2nd Edition
- Author(s):
- Release date: March 2014
- Publisher(s): For Dummies
- ISBN: 9781118842249
You might also like
book
Excel Dashboards and Reports for Dummies, 3rd Edition
Make the most of your data using the power of Excel When you think of data, …
book
Excel Dashboards & Reports For Dummies, 4th Edition
It’s time for some truly “Excel-lent” spreadsheet reporting Beneath the seemingly endless rows and columns of …
book
Excel Dashboards and Reports, 2nd Edition
Learn to use Excel dashboards and reports to better conceptualize data Updated for all the latest …
book
Excel Data Analysis For Dummies, 4th Edition
Take Excel to the next level Excel is the world’s leading spreadsheet application. It’s a key …