Building an Executive Dashboard in Excel 2007 with Conditional Formatting
Latest News in Excel Dashboards: New functionality for Excel based Enterprise Dashboards.
One of the truly exciting improvements in Excel 2007 for us avid enterprise dashboard project team members is the extent of the conditional formatting of the cells. Depending on logic related to the value of the contents of the cell, you can assign colors (think heat map visualizations) or icons (think red/green visual KPI indicators).
Here are a couple of excel 2007 demo videos that give a glimpse of the new features that you will definitely be using when building an executive dashboard.
This first video has no sound so think of it as an early silent movie about business intelligence visualization! Watch the cells as the person quickly drops down the conditional formatting options.
[googlevideo]-4115540572629796916[/googlevideo]
This next one does have sound. You may want to skip straight to the latter part on the formatting options.
[googlevideo]-1192618361577555007[/googlevideo]
And here is a quick tour of some new Excel 2007 features. This guy blows through 5 new features in 30 seconds!
[youtube]ubvI4KyZc1I[/youtube]
For reference, here is a link to some more info on Excel 2007.
Tags: Excel Dashboard, Excel Dashboards, Excel Dashboarding, Dashboards with Microsoft Excel
The Dashboard Spy Business Intelligence Dashboards Blog
Related Business Intelligence Dashboard Examples:
Enterprise dashboards are very effective for monitoring various computer security-related tasks. ...
Building a dashboard with Excel 2007? Don't forget to make use of the Excel 2007 ribbon. You can ...
Are less dashboards being built using Excel 2007 than I thought? The recent post about customizi ...
A very useful extension for Excel dashboards is MicroCharts. It provides cell-sized charts
* Line, column, pie and bar charts
* Sparklines with rich formatting
* Bullet graphs for dashboard gauges
You can download the MicroCharts Add-In here:
http://www.MicroCharts.net
The video links are broken.
Sorry about that Jon. They are back up now. The Dashboard Spy.