Excel Dashboards and Reports For Dummies Extras

Sorted by:  

Creating Waffle Charts in Excel with Conditional Formatting

A waffle chart is an interesting visualization that helps display progress toward goals. This kind of chart is a relatively effective option when you want to add an interesting visualization to your Excel [more…]

Adding Extra Layers of Analysis to Your Excel Charts

It's not uncommon to be asked to add additional analysis to your visualization that typically isn't plotted on an Excel chart. For example, this chart shows sales for each quarter, but your client may [more…]

The Art of Dynamic Labeling in Excel

Dynamic labels in Excel are labels that change according to the data you're viewing. With dynamic labeling, you can interactively change the labeling of data, consolidate many pieces of information into [more…]

10 Excel Chart Types and When to Use Them

Building a chart in Excel in and of itself is not a terribly difficult thing to do. The hard part is getting your mind around which types of chart to use in which situation. Excel has 11 major chart types [more…]

Excel Dashboards & Reports For Dummies Cheat Sheet

Companies and organizations are always interested in business intelligence — raw data that can be turned into actionable knowledge. This need for business intelligence manifests itself in many forms. Dashboards [more…]

Dynamic Annotations Using Custom Number Formatting in Excel

Excel’s number formatting syntax consists of different individual number formats separated by semicolons. By default, the syntax to the left of the first semicolon is applied to positive numbers, the syntax [more…]

Managing Excel Workbooks in OneDrive

OneDrive provides an ideal web-based platform to store and share your Excel dashboards and reports. As you publish multiple Excel workbooks to OneDrive, you may find the need to do things such as delete [more…]

10 Ideas for Enhancing Dashboards with Excel Shapes

Most users think of Excel shapes as mildly useful objects that can be added to a worksheet only if you need to show a square, some arrows, a circle, and so on. But if you use your imagination, you can [more…]

Sample Files for Excel Dashboards & Reports For Dummies, 3rd Edition

Click here to download the sample files for Excel Dashboards & Reports For Dummies,3rd Edition. These files contain all the sample files from the book. Use them to work through the book’s examples. [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com