Excel 2007/2010: Creating Charts [How To]

Posted by Thomas On January - 20 - 2012

One of the improvements in Excel 2007 is the rebuilt Chart Tool.  “It used to be so easy” to create charts in Excel, just highlight an area of cells and click Create Chart, and voilá. Well it still is – it only looks a bit different.  In this mini-tutorial I’m using an example from work, tho the names, and numbers have been altered.

The Mission

At work we have tightened security on mobile Exchange Synchronization. A security policy has been set which requires that we ask each of the 2.500 users to read the new guidelines. Failure to accept the new policy guidelines will result in the user loosing access to the server. To be able to monitor the progress of this work (making sure we know that every user has read and accepted) I was asked to create a chart to graphically display the weekly progress,  number of emails sent, number of accepts etc.  The challenge is that we only record names, and dates for each occurrence (notice sent, reply received, account open or closed).

Read the rest of this entry »

Excel 2010: Sparklines

Posted by Thomas On October - 25 - 2011

Excel 2010, did not come with too may new features. It’s hard to come up with  ideas on how to improve something that is already a great product, I’m sure. But there was one new thing I’ve found quite useful: Sparklines.

Sparklines – What’s that ?

Read the rest of this entry »

Every time you create a new workbook in Excel, you get a document containing three blank sheets. Do you ever use more than one ? Or, do you always use more than three ? In this Quick-Tip I’ll show you how to set Excel to create new workbooks containing the number of sheets you require, whether it’s one or ten.

Here’s How

Read the rest of this entry »