Track and highlight important trends with new data analysis and visualization features in Excel 2010. The new Sparklines feature delivers a clear and compact visual representation of your data through small charts within worksheet cells. Slicers let you filter and segment your PivotTable data in multiple layers so you can spend more time analyzing and less time formatting
Experience Dynamic Searching Using VLOOKUP, MATCH and INDEX
Work with massive amounts of data in Office Excel 2007, which supports spreadsheets that can be up to 1 million rows by 16,000 columns. In addition to the bigger grid, Office Excel 2007 supports multicore processor platforms for faster calculation of formula-intense spreadsheets.
Use Office Excel 2007 and Excel Services to help share spreadsheets more securely with others
Excel Services, a feature of Microsoft Office SharePoint Server 2007, dynamically renders a spreadsheet as HTML so others can access the information using a Web browser. Because of the high degree of fidelity with the Office Excel 2007 client, Excel Services users can navigate, sort, filter, input parameters, and interact with the information, all within their Web browser.
PivotTable views enable you to quickly reorient your data to help you answer multiple questions. Find the answers you need faster and create and use PivotTable views more easily by dragging fields where you want them to be displayed.
Enjoy improved and powerful support for working with tables
Create, format, expand, filter, and refer to tables within formulas because Office Excel 2007 has greatly improved support for tables. When you’re viewing data contained in a large table, Office Excel 2007 keeps table headings in view while you scroll.
Take advantage of the flexibility and the new cube functions in Office Excel 2007 to build a custom report from an OLAP database. You can also connect to external sources of data more easily using the Data Connection Library.