Microsoft Excel 2010 helps you analyze, manage and share information in more ways than ever before, helping you make better, smarter decisions. New data analysis and visualization tools help you track and highlight important data trends. Whether you’re producing financial reports or managing personal expenses, Excel 2010 gives you more efficiency and flexibility to accomplish your goals.
Macro recording support for chart elements.
In earlier versions of Microsoft Office Excel, a macro recording could not generate any macro code while formatting a chart or any related object. With Microsoft Office 2010, all operations that are performed on a chart can be recorded. Now, you could start to standardize your charts across your organization by distributing those macros.
With the advent of Sparklines you can take business decisions based on data contained in a single cell. Sparklines condense data from various sources into a single cell and is instrumental in demonstrating trends using line, column or win/loss charts.
Excel 2010 64-bit advantages.
If you get to work on really large worksheets, your best bet is the 64 bit version of Excel 2010. The size of worksheet is limited only by the available physical memory. Memory consumption is optimized the the 64 bit architecture to keep cell table operation as fast as possible. You can also create bigger workbooks using 64-bit Excel that can be too big for 32-bit Excel to open.
File loading performance.
Excel 2010 has put parallel processing and multi-core functionality to its best use, you’ll notice this if you deal with files containing several large worksheets. The performance gains are noticeable depending on the content and structure of the workbook. That is, if you have one large worksheet and few smaller sheets, you wouldn’t notice much difference, but if you have two large worksheets, Excel 2010 can fetch the second sheet off the disk while the first one is being loaded to memory.
Your PivotTables will load faster with the new Excel 2010 architecture. Data retrieval, sorting and filtering in PivotTables is enhanced with multithreading.
OLAP Write-back support.
With Excel 2010, OLAP PivotTable values can be changed and written back to the Analysis Services cube on the OLAP server. You need to have CubeCellvalue add-in installed for Excel 2010 to be able to use Online Analytical Processing. Excel 2010 is capable of storing workbook data directly to an OLAP cube, and it can be written back to a worksheet as required and you can get the OLAP server to perform calculations and summarize the data in PivotTable report that shows up in your Excel worksheet.
New Charting Limits.
In Excel 2010, your data points in a data series in limited only by the available memory. In Excel 2007 you could have 32,000 data points in a data series for 2-D charts. This adds the capability of being able to visualize and analyze larges sets of data in Excel 2010.
Extensibility solutions in Excel 2010 uses MSXML 6 or you could use managed code that uses .NET Framework. Users will receive a runtime error if attempted to run a solution that was created using MSXML5
New version of Solver.
Excel 2010 is shipped with a new version of Solver add-in. Optimal solutions in what-if analysis, an improved interface, a new Evolutionary Solver, based on genetic algorithms, that handles models with any Excel functions, new global optimization options, better linear programming and non-linear optimization methods, and new linearity and feasibility reports are few features that the new Solver bring along and it is available in 64 bit too.
They improve PivotTables and CUBE functions in a workbook, Slicers make filtering and interpretation of data easier. Slices filtered data interactively. You can hook them to PivotTables, Pivot Charts, or CUBE functions to create interactive reports or dashboards, they float above the grid and behave like report filters