Buy Microsoft Excel 2010

Excel continues to improve with this release from Microsoft. If you are upgrading from Excel 2007, you will notice these improvements:
1) Pivot table improvements. Calculate % of Parent Item, Rank, and more. Create dashboards with visual filters called Slicers. Fill in the blank cells along the row area of a pivot table. Create Asymmetric Pivot Tables with Named Sets.
2) The free PowerPivot add-in works only with Excel 2010 and offers the ability to create pivot tables from data on different worksheets. You also can process more than a million rows of data.
3) Sparklines allow you to create hundreds of tiny, word-sized charts in a few clicks. While they aren't as robust as the Sparklines that Tufte wrote about, you can use some mid-level Excel formulas to add labels and shading to the sparklines.
4) New functions for scientists. Better stats functions. Equation Editor. The AGGREGATE function.
5) Publish your workbooks to the web using the SkyDrive. Interact with and/or edit the worksheet in the browser.
6) Improved Paste Options throughout Office 2010. See what the paste will look like before you do it.
7) Unlike Excel 2007, this version of Excel offers a File menu, which is vastly improved.
8) Unlike Excel 2007, you can easily customize the ribbon interface. Move icons around or build your own ribbon tab.
9) Various improvements throughout the product. Examples: Smarter Fill-Handle Double-Click to copy formulas to the bottom of the data set. Dramatically improved background removal tool for pictures. Filter dropdowns now offer text search. The ability to show negative data bars in the new Conditional Formatting options that were introduced in Excel 2007. More processes can take advantage of multi-core technology. Pattern fills return for charts.
10) Improved macro recorder support for chart creation.

If you are upgrading from Excel 2003 or earlier, you will enjoy the increased grid size (1 million rows x 16K columns), better data visualizations such as Data Bars, Icon Sets, SmartArt, and a new Charting Engine. Sort/Filter by color. Functions introduced in Excel 2007 include IFERROR, SUMIFS, COUNTIFS, and the Cube Functions.



Get more detail about Microsoft Excel 2010.