The essentials of creating and working with charts in Excel 2007 will show you everything you need to know to convert your numbers into charts that can help your audience understand the meaning behind the data and make that data stand out.
A creative alternative to using the icon sets offered with conditional formatting is to use the various symbol fonts that come with Office. The symbol fonts are Wingdings, Wingdings2, Wingdings3, and Webdings [more…]
You can learn a lot from the approaches other have taken to design their Excel dashboards and reporting mechanisms. Here is a list of sites (in no particular order) dedicated to business intelligence and [more…]
Excel can help you make all sorts of calculations. Here's a selection of Excel’s statistical worksheet functions. Each one returns a value into a selected cell. [more…]
An array formula works with a series of data values rather than a one. Here are Excel's statistical array functions. Each one returns an array of values into a selected array of cells. [more…]