I have Excel 97, 2000, 2002, 2003, 2007, 2010 (Windows) and 2004, 2008 and 2011 (Macintosh) installed on my laptop. Excel 2003 had been my favorite, but now Excel 2010 is the one I always use--unless answering a forum question that demands one of the other versions. Reasons include:
***Usable on-line help for VBA (though still not as good as Excel 2003 with its examples and related search terms). Microsoft appears to have gone through the help text in 2010 and improved it in many cases.
***Statistically sound stat functions (Microsoft hired an outside firm to fix the problems that gave their stat functions a bad reputation)
***More powerful Solver
***Sharp corners beginning to wear off on the ribbon
***Faster calculation engine
***You can record chart macros (unlike Excel 2007)
***Useful new functions (IFERROR, SUMIFS, COUNTIFS) in 2007 and later
***Analysis ToolPak functions are always available (i.e. no longer optional)
The only specification limits you are still run into are the length of a cell formula added by VBA (255 characters) and height of a row (409.5 points), both of which are unchanged. All the old limits that people used to kvetch about are far increased (number of rows and columns, number of parameters in a function, amount of text displayed in a cell, number of conditional formats, level of nesting in a formula, inability to use entire columns in an array formula, number of unique styles/formats in a workbook)
I have also found Outlook 2010 to be more reliable than Outlook 2007 (which often drove me crazy while I waited for it to let me open the next email or start typing).
Brad
