Pivot tables

We just got a Mac after many years of PC and one of the first things I checked was the capability of numbers. No pivot tables or macros. These are two of the most powerful things I use in Excel. I see it is really lacking database functionality as well. So I'm thinking I'm stuck w/ Excel. However, I go to check out Office 2008 and I find that VB is not supported so macros are gone from Excel in 2008. Now what do I do? I assume MS is probably going to kill VB for PCs as well. So do I buy Office 2007? Is it good? My IMac came preloaded w/ a trial version of Office 2004 which scares me into thinking maybe 2007 has issues.

Anyway, this is an old thread but I'm a newbie so any suggestions/opinions are highly welcome.

Use Excel (or Office) version 2003 for the PC. This is the best option right now. While M$ has offered many new features in 2007, the interface change is a killer for productivity. Version 2008 for the Mac is not ready for prime time.

Regards,