Most Recent

MS Excel

Adding Symbol Fonts to Your Excel Dashboards and Reports

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

MS Excel

Great Online Resources for Excel Dashboards and Reports

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

MS Excel

Some Excel Worksheet Functions

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

MS Excel

Excel Array Functions

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

MS Excel

Excel Data Analysis Tools

Excel's Analysis ToolPak gives you a whole range of new statistical analysis tools. These are the tools in Excel's Analysis ToolPak. You load them as add-ins. [more…]

Learning anything is easy with For Dummies eLearning!