Excel 2007 Enhancements

MS Excel 2007 has in one way been revolutionizing the desktop analytical computing will work in future .

Here is list of extra-ordinary enhancements in Excel 2007 which makes it must-have and must-use for any executive.

Feature	Excel 2003	Excel 2007	Remark
The total number of available columns in Excel	255	16384	64 times
The total number of available rows in Excel	65536	1048576	16 times
Number of unique colors allowed a single workbook	56 indexed	4.3 Billion	Very colorful intuitive analysis
Number of conditional format conditions on a cell	3	Unlimited	Very colorful intuitive analysis
Number of levels of sorting on a range or table	3	64	Helping good analyses
ber of items shown in the Auto-Filter dropdown	1000	10000	Auto-filter more scaleable
The total number of unique cell styles in a workbook (combinations of all cell formatting)	4000	64000	Very good for analyses.
The number of levels of nesting that Excel allows in formulas	7	64	More complex situation can be handled easily
Number of Cell sets in Pivot table	8,160,000	17,179,869,184 Limited only by memory	2100 Times. Analytical capability increased manifold.
The number of fields (as seen in the field list) that a single PivotTable can have	255	16384	64 times

The list of above enhancements have been compiled from information available at

ERPJEWELS.COM