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…]

Managing Excel Workbooks in SkyDrive

SkyDrive provides an ideal web-based platform to store and share your Excel dashboards and reports. As you publish multiple Excel workbooks to SkyDrive, you may find the need to do things such as delete [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…]

Sign Up for RSS Feeds

Computers & Software
Enter now for your chance to score $500

Inside Dummies.com