Book description
Make the most of your data using the power of ExcelWhen you think of data, do you think of endless rows and columns in spreadsheets? Excel Dashboards and Reports For Dummies, 3rd Edition shows you how to make the most of your data—and puts an end to mind-numbing spreadsheets by exploring new ways to conceptualize and present key information. There's often a gap between handling data and synthesizing it into meaningful reports, and this approachable text bridges this gap with quick and accessible information that answers key questions, like how to meaningfully capture data trends, how to show relationships in data, and when it's better to show variances than actual data values.
As a leading spreadsheet application, Microsoft Excel is the go-to data software. This tool allows you to use dashboard reports that leverage gauges, maps, charts, sliders, and other visual elements to present complex data in a manner that's easy to understand. Using Excel dashboards effectively can improve your professional capabilities by leaps and bounds.
- Analyze and report on large amounts of data in a meaningful way
- Look at data from different perspectives, and better visualize the information you're presenting by quickly slicing data on the fly
- Automate redundant reporting and analysis functions, making your data analysis and reporting routine more efficient
- Create visualizations, dashboards, and what-if analyses that are as visually appealing as they are substantial
Excel Dashboards and Reports For Dummies, 3rd Edition is a fantastic resource if you're looking to spice up your reporting!
Table of contents
-
- Cover
- Introduction
- Part I: Getting Started with Excel Dashboards & Reports
- Part II: Building Basic Dashboard Components
- Part III: Building Advanced Dashboard Components
-
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
- Toggling a Chart Series On and Off
- Using the Option Button Control
- Showing Many Views through One Chart
- Using the Combo Box Control
- Changing Chart Data with a Drop-Down Selector
- Using the List Box Control
- Controlling Multiple Charts with One Selector
- Chapter 12: Adding Interactivity with Pivot Slicers
- Part V: Working 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 Excel Chart Types and When to Use Them
-
Chapter 15: Ten Chart Design Principles
- About the Author
- Cheat Sheet
- Advertisement Page
- Connect with Dummies
- End User License Agreement
Product information
- Title: Excel Dashboards and Reports for Dummies, 3rd Edition
- Author(s):
- Release date: January 2016
- Publisher(s): For Dummies
- ISBN: 9781119076766
You might also like
book
Excel Dashboards and Reports For Dummies, 2nd Edition
Create dynamic dashboards and put your data on display with For Dummies No matter what business …
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 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 Formulas & Functions For Dummies, 5th Edition
Put the power of Excel functions to work in your formulas There are more than 400 …