Whole new data interface
Excel 2007 presents a whole new interface which differs from almost all of its predecessors. The new interface, Microsoft calls it the results oriented interface, places the most used commands first and functions as a one click tool bar. No need to navigate through the menu. Just do everything within a click. The new interface also provides you more space on the desktop than its previous version and a better tool bar customization
Increased data storage
Excel 2007 now has 1,048,576 rows and 16,384 columns which makes up to 17,179,869,184 cells. You read it right. Excel has 17 billion+ cells which is 1024 more than its previous version. Sure a big leap in data storage, hope your computer memory permits it.
Excel 2007 now has a unique way to quickly format your data. The introduction of themes and styles would help you a long way to provide high printer friendly documents. You can now apply 64000 unique styles to cells and you have 16 million colors. So just apply the format you like. Now no two spreadsheets would look alike.
Easy file conversion
Perhaps, one of the biggest advancements in this version is the ability to convert your Excel file into a whole lot of formats. You can now have your file in XML, PDF, XPS formats. So no matter the platform, your Excel file would be viewed in any computer
Reduced file size
Excel now supports multi threading. Thus the Operating System can run several Excel processes at on time. Plus the new Excel algorithm keeps your file extremely small (you can test it out with your previous versions). You could also freely convert your files between any Excel version. What's more you can now have unlimited number of worksheets (though theoretically it is limited by memory)
New look 3D charts and smart art
Another big advancement is the new look 3D charts and graphs. Just turn your Excel into virtual dashboard with colorful and powerful graphs. The smart art service also looks quite good. Select your favorite shape in a single click rather than moving through menus. You can also use data bars and icon sets to further enhance your workbook. Now you can turn your workbook into a presentation
Improved sort and filtering
Excel now provides improved sort and filtering service. The auto filter option now provides for quick filtering of text, numbers and dates. The sort function has now unlimited keys. So you can sort your data through any number of rows and columns