Whats new in Microsoft Excel 2010
Excel 2007 effectively rewrote the rulebook on spreadsheet usability
. The introduction of the Ribbon changed forever the way we interacted with the application, and we've never looked back. There's understandably nothing so extraordinary this time around, but Excel 2010 still has a few tricks up its sleeve.
The global changes that permeate the rest of the suite are all present here. Backstage view works well, particularly the combined Print/ Print Preview function, while the redesigned, customisable Ribbon will be of use to those who regularly use Excel's more esoteric functions. But, for heavy users, the most important changes are under the hood. The most noticeable area is in the rendering of chants and in loading large workbooks with many sheets, where Excel can now take advantage of multi core processors to load the sheets in parallel. If you're running the 64-bit version of either Windows Vista or Windows 7, you also get the choice of installing the 64-bit version of Office 2010, the principal advantage of which is to let you work with Excel workbooks larger than 2GB.
64-bit Excel also works faster on large workbooks than the 32-bit version, provided you give it enough memory, but choose carefully before going down the 64-bit route as some third-party plugins may not work and your VBA macros may need recoding. Elsewhere, PivotTables and Pivot Charts run faster, thanks to multithreading.
Reporting from SQL Server Analysis Services has been expanded with support for Named and Dynamic sets, and calculations can be written back to the data cube to be summarised. If you need to analyse millions of rows, or data from multiple sources, you can use the new Power Pivot for Excel. This separate plug-in for Excel (see www.powerpivot.com) gives fast access to mountains of data, automatically analysing relationships between tables and presenting disparate data as a coherent whole.
Other than this, there's a host of small tweaks and improvements. The Solver plug-in has been re-coded with an improved user interface, and now includes evolutionary as well as linear and non-linear algorithms. And 33 functions, mainly to do with statistical analysis and finance, have been re-coded to remove bugs or to improve accuracy. Data analysis capabilities have been extended, most notably through the introduction of sparklines - little line or bar charts that sit in one cell and summarise a small range of data.
Compare a standard line chart to a collection of sparklines based on the same data and you'll quickly see how much clearer the latter can be. Other visual improvements abound. Conditional formatting boasts more styles, options and new icon sets. The Slicer controls let you place interactive filters on worksheets to control what data is shown.
Charts are easier to edit, and it's good to see all limits have been removed, giving virtually unlimited data points. VBA programmability has been boosted with the macro recorder able to deal with the formatting of chart elements, and the addition of the last few missing features that will allow all Excel macros to be recoded into VBA.You can also use Visual Studio to write asynchronous, user-defined functions for use in Excel, or functions that use a High Performance Computing cluster, both of which can dramatically increase the speed of calculation of complex workbooks.
Finally, corporate users will appreciate Excel 2010's improved collaboration tools. The Office Web Apps and Excel Services on SharePoint mean workbooks display in the browser as you see them in the desktop application, complete with working Slicers. However, working together isn't as good an experience as it could be: you're limited in what you can do and can't see what others are doing until their changes suddenly appear onscreen. Overall, though, Excel 2010 does enough to prove it's still the gold standard. Sparklines, Slicers and PowerPivot provide visual appeal, but it's the horde of small improvements, especially in speed and usability, that mark out this release as special.
Whats new in Microsoft Excel 2010
By: Steve Barker
Inexpensive New York Vacation Packages Perfect For Seniors And Travelers : Instruction About Booking Aarkstore Enterprise---energymixx Ag (em2) - Financial And Strategic Analysis Review Cheapest New York Vacation Packages Tailor Made For Elderly And Travel Enthusiasts : Info Relating T Using A Led Lights Bar Eliminates The Disadvantages Of Traditional Lighting Official Manchester United announce a new jersey Low Priced New York Vacation Packages Speacially Made Old Generation And Travel Oriented : A How-to Home Loans: To Substantiate Financial Possibilities On New york How to Get the Best Deal on a New Car Dell - New BIOS For NVIDIA Laptop GPU Problems Aarkstore Enterprise---sustainable Energy Technologies Ltd. (stg) - Financial And Strategic Analysis Budget New York Vacation Packages Tailor Made For Older People And Travel Enthusiasts : Instruction Sports Betting Secrets – 4 Must Know Soccer Betting Tips For A New Bettor Aarkstore Enterprise---hydrogen Corporation (hydg) - Financial And Strategic Analysis Review