Principles of Executive Dashboard Design

Developing executive dashboards require the use of the more advanced features that excel provides such as VBA and pivottables. They are different from traditional excel reports. Excel is a cost effective solution in the development of executive and operational dashboards.

executive dashboard reporting based on the key principles should bridge that gap between systems and the information needs of management. More importantly, good dashboard design and data modelling should help information workers and analysts to spend less time with manual excel tasks and more time analysing information.

Keep it simple and to a single page

Don't clutter your executive dashboards with unnecessary visual elements and data. If it looks too busy, then the excel dashboard will fail to communicate the data effectively. We are trying to communicate a message about the data. Don't include every bit of data in a dashboard. The information should show progress towards key objectives and priorities. The other point here is that if something is out with your line of sight, then it can't be viewed quickly or possibly missed altogether. When you print your dashboard, it should also fit to a single page.

Simple to understand

Also, excel dashboards should signal when more action is required through the use of visual attributes. When developing an executive dashboard, it is advisable to start with a mock-up of the performance information that is required and work backwards to the point where data is gathered. An executive dashboard should help to visually identify trends and patterns quickly without confusion. In other words, if it doesn't communicate any information about the data then don't display it. Examples of this could be logos, pictures and 3D charts.

Use visual attributes

Bright colours such as red will attract more attention than subtle colours, so keep bold colours to a minimum and only use them to highlight or as an alert. Some people are colour blind, which is another reason for using subtle colours. Use natural white space between components. Everything that is not communicating a message such as chart lines or grid line should be toned down or removed completely if appropriate. Keep black for data that needs to be more prominent. There are many other visual attributes, other than colour. For example, using a different SHAPE and size can make data stand out. So can the use of added marks such as * @ % or other symbols. [Enclosure] can also be useful for "drawing" attention.

 I Want To Start Mastering Microsoft Excel!

MICROSOFT EXCEL VIDEO TUTORIALS made easy today, find valuable SHORTCUTS To using carefully designed VIDEO TUTORIAL TODAY!.

How You Could Simplify a 5-Hour Task   To Become a 5-Second Task! (Data Sorting, Data Analysis And Chart Plotting)  And you can use it again and again by just clicking on one button.

Are you really serious about Mastering Microsoft Excel, achieving excellent speed and result and perform like nobody could ever achieve before in your work!

If you are, you can make that an instant reality right now. Grab a copy of Excel Expert User at the great bargain now, while you still can!

VBA for Excel (Macros) VBA is the programming language used within Excel to develop macros

Let me offer you my 30 years of experience in accounting and finance and my expertise in Excel certified by Microsoft to help you use all of this data and transform it into sound business decisions.

"Tired of Boring Online Courses?"   Then Stop Attending Them And Switch To The Fast Lane Now!

You can learn the basics of Excel in less than an hour.

Some people make a table on Excel and then and up doing the math with a calculator since they don't know which of the the buttons are used to automatically deal with the numbers for them. You probably didn't even know how flexible the copying and pasting is on Excel.

This needs to end right now . You're wasting too much time using trivial techniques when you could just as easily use the automated techniques and work on things much faster.

It's called Easy Excel Basics because everything can be learned in under 1 hour! Think of all the things you can do with the time that you have left.