In addition to the dramatically different user interface and new file formats shared with other Microsoft Office 2007 programs, Microsoft Office Excel 2007 also adds a number of improvements and new features:

 

1. Excel 2007 now supports up to 1 million rows and 16 thousand columns per worksheet! Specifically, the Office Excel 2007 grid is 1,048,576 rows by 16,384 columns, which give you 1,500% more rows, and 6,300% more columns than Excel 2003 to manage massive amounts of data! (FYI-columns now end at XFD instead of IV). As if that is not impressive enough, each Excel 2007 workbook can contain up to 1024 worksheets, an increase from the previous limit of 255 worksheets. Bet you cannot wait until a project of this size lands on your desk!

    

    

2. Quickly format data with shared Themes and Styles. For instance, in just minutes, you can easily apply professional looking formats to worksheets complete with borders, color and font formats, and other slick enhancements.

    

    

3. Formula writing is much easier with a resizable formula bar, a range name manager, and other upgraded formula tools.

    

    

4. Improved sorting and filtering tools including the ability to sort data by color and by more than 3 (and up to 64) levels.

    

    

5. New shared charting engine. Add visual enhancements to your charts such as 3D, soft shadowing, and transparency. Create and interact with charts the same way, regardless of the application you are using, because now the new charting engine is consistent in both Word and PowerPoint 2007.

    

    

6. The significantly upgraded Page Layout View helps ensure what you see on the screen is what you will get in printed output. That means any headers and footers you add or edit are displayed in plain view and worksheet pages are even easier to see.

    

    

7. Significantly improved PivotTables with updated features to summarize, analyze, and format your PivotTable data.