Killer Excel Dashboard Reports

for Microsoft Excel 2007 & 2010

This isn't Excel - it's magic! 

Do your reports take a lot of work for you to update each period? And a lot of work for your readers to understand? Your Excel reports don't have to be that way. Not only can you create reports that are easy to update, you can make them much easier to read.

Excel dashboard reports act like the dashboard of your car – they present business information in a way that's easy to read and easy to understand. If you want to know how to create Excel reports like these - or if you want standard reports that are easier to create, easier to update, and easier to read - then this is going to be one of the most valuable workshops you've attended.

With the help of just a few simple techniques, Excel offers significant power to generate high-quality, low-maintenance management reports, including dashboards. For example, it is possible to report sales, cash flow, headcounts, competitor performance, customer survey results and economic data…all in the same report.

What's more, this approach serves as a business early warning system, enabling management to take action at an early stage. In addition, because we can change our Excel reports quickly, we can respond quickly to managers' changing information needs.

The Excel Window Components 

Advanced Chart Creation

• Inserting a Chart
• The Chart Formula
• Changing the Chart Type
• Adding and Removing Data
• Changing Chart Options
• Changing the Chart Location
• Copy a Chart
• Add a Secondary Axis
• Accommodating extreme values
• Chart alignment

• Reformat the Chart
• Changing Colours
• Axis Formatting
• Manage Chart Labels

Dashboard Reports

• Creating the Dashboard
• Keyboard shortcuts

Supporting Skills for Dashboard Creation

• Absolute References
• Working with Ranges
• The MAX and MIN Functions
• The NA Function
• The IF Function
• The ISERROR Function
• The OFFSET Function
• The CHOOSE Function
• Importing Information
• Linking Programs

• Add the Camera Tool to a Toolbar
• Use the Camera Tool
• Manipulate the Camera Object
• Assign a Range to the Camera Object
• Display a Dynamic List in a Camera Object

Who should attend?

• Marketing Managers
• Sales Managers
• Financial Managers
• Chief Information Officers
• Business Analysts
• Personal Assistants
• Anyone who wants to produce more impressive and useful Excel charts

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.