Create a Pivot Table in Excel 2007

August 17, 2008 by Administrator · Leave a Comment 

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

Send post as PDF to PDF Creator | PDF Converter | PDF Software | Create PDF

Using Excel to Manage Simple Databases

August 17, 2008 by Administrator · Leave a Comment 

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

Send post as PDF to PDF Creator | PDF Converter | PDF Software | Create PDF

Bar Chart using REPT function

August 4, 2008 by Administrator · Leave a Comment 

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 PDF Creator | PDF Converter | PDF Software | Create PDF

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

August 2, 2008 by Administrator · Leave a Comment 

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 PDF Creator | PDF Converter | PDF Software | Create PDF