Create a Pivot Table in Excel 2007

An introduction video (youtube) description the use and creation of pivot tables in Excel 2007.

Send post as PDF to

Using Excel to Manage Simple Databases

Here is a video from freetutorials (youtube) on using Excel to manage simple databases.

Send post as PDF to

Bar Chart using REPT function

The REPT function repeats text a given number of times. For example, =REPT(”*”,10) repeats * 10 times in a cell.

You can use this function to create a simple bar for values in multiple cells.  Here is a short video on YouTube:

Send post as PDF to

How to configure Office 2007 to save files using the old Office 97-2003 format

Personally, I use Excel 2003 at work and Excel 2007 at home. I am constantly (as in 3 or 4 times a weeks) using Excel 2003 files in Excel 2007.

I found this tip at vista4beginners.com showing how to have Office 2007 automatically have files in the Office 2003 format: Configure Microsoft Office 2007 to save files using the old Office 97-2003 format

Send post as PDF to