Excel 2007
 

Hi,
I've been using Excel for many years, my current version is from Office XP.
Is it worthwhile upgrading to 2007?
Is there any fundamental improvement like the introduction of Pivot Tables
years ago, or is it mainly cosmetic?
I know it has lots more columns and rows available but apart from the
nuisance of not being able to use 365 columns for every day of the year that
never really been a problem to me.
I'm told that there are formula options like COUNTIFS which will do what
SUMPRODUCT does looking for two values in two columns but I haven't seen
them, if they exist what is the point? I know how to do that already.
The reason I ask is that I've just bought a new PC with Vista, not from
choice, the old one gave up the ghost. Vista has its good points like the
search facility which I must admit is good.
There are however a lot of issues with it like incompatibility with long
standing software, constant hard drive activity from updates etc, the 'Run'
command is in a different place and the Control Panel is different for no
real reason as far as I can see. It looks pretty but I think MS have a habit
of fixing things that aren't broken.
Any advice appreciated,
Regards,
Alan.