Excel 2007 key new stuff:
§ Better decision making using Key Performance Indicators (KPIs). Extended conditional formatting which includes (new!) data bars, icon sets, and heat maps for better analysis of your corporate data.
§ Intellisense for Excel formulas. Reduce typing errors and improve productivity through (new!) Intellisense for Excel formulas.
§ Get control of your spreadsheets. Comply with regulatory demands and manage proliferating spreadsheet data via (new!) server-side publishing, calculation, and rendering with Excel Services and Excel Web Access.
§ Support for large workbooks. Excel is up to the job of supporting the most demanding tasks by supporting 1,000,000 rows by 16,000 columns – that’s over a billion cells per worksheet and 4.3 trillion cells per Excel file!
§ XML-based file formats. Work directly with underlying Excel data using the (new!) XML-based file formats. Since the format is open and XML-based, it has never been easier to extract or insert data, or to reformat your sheets using styles!
§ Rich Server-based solutions. Excel Services adds (new!) server-based APIs for building rich, server-based solutions on top of Excel and SharePoint.