Microsoft Excel 2007
Tips

Tip 1: Chart option in Excel 2007

Microsoft Office Excel 2007 has changed from the 2003 version.  I found, when I first began to use the new 2007 version, that many things were changed.  The Charts for example are no longer in a drop down menu.  If you want to format a bar graph or other type of chart you have to click on insert.  Under insert all of the chart options you can create are displayed.  You just select how you want it to look and then you will be back in the normal area for entering the data, as well as placing the chart on a different sheet if you wish.

Tip 2: Auto-completion

Whether you have used earlier versions of Microsoft Excel or you are using 2007 there are some pretty neat tricks you don’t always learn.  This tip came to me through work.  When you are creating a spread sheet with numerical or alphabetical titles, you don’t have to type each number or word in.  For example, say you need the 12 months of the year.  You can type in January and February, then by clicking on the February box in the lower right and holding you can drag the mouse down the columns.  It will automatically fill in the sequence for you.