Daily tips for using Microsoft Excel.

Sunday, February 25, 2007

Pivot Tables in Excel 2007

Pivot tables are better in Excel 2007. There is a new interface where you drag and drop fields in new drop zones instead of on the report. This should eliminate many of the common errors that people make when trying to build a pivot table. Episode 487 of Call for Help, airing February 27, 2007 shows off many of the new pivot table features.

Friday, February 23, 2007

Tables in Excel 2007

One of the cool new features in Excel 2007 is the Table functionality. About 90% of the spreadsheets you create have headings followed by rows of data, right? Well, use the Table tools to add intelligence to those spreadsheets. Episode 485 of Call for Help shows you how.

Thursday, February 15, 2007

Five Things to Know When Upgrading to Excel 2007

Excel 2007 debuted on January 30, 2007. If you are lucky enough to be upgrading, you are in for fantastic new features. I am sure you will hear about those great new features from the Microsoft marketing machine. Today's episode of Call for Help will highlight the five gotcha's; things you need to know before you upgrade.