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…]
A large part of the work you do in Excel is editing the cell contents in worksheets. To save time editing, learn the following Excel shortcuts, including the key combinations and their functions: [more…]
Excel 2007 alone is a powerful tool for data analysis and number-crunching. But when you add VBA programming to your Excel workbooks and spreadsheets, your opportunities for transforming simple data into [more…]