Some of the exciting improvements in Excel 2010:
Better Excel Charts
- Sparklines, improved data bars, better chart UI, cross-sheet conditional formatting, improved PivotChart interactivity.
- What does it mean: I expect that you can present great looking charts in your business reports. I’ll definitely be presenting what new tricks you can do in dashboarding.
Faster & more responsive performance
- Excel 2010 will feature multi-threaded calculations.
- 64-bit version of Excel, which allows Excel to address more memory.
- What does it mean: Workbooks with complex formulas will update much faster. I even expect my macros to work faster since the calculation engine has been souped up to take advantage of multiple processors on my laptop.
More accurate functions
- Improvements to the accuracy of some math, financial, and statistical functions.
- New functions are added to Excel’s rich function library.
Improvements in programmability
- Improved macro recording support.
- Enabling new integration scenarios with High Performance Computing clusters.
- What does it mean: Overall, I think the new Excel 2010 will bring spreadsheet computing to the next level. I can only imagine the impact it will have on financial modelling with the improvements in programmability.
I’ll be taking the new Excel 2010 for a spin and will write a more detailed review over the weekend. Stay tuned.
Free Microsoft Office Online apps. All you need is a desktop browser. Click here>>.
About Aeternus Consulting
Related Link: Aeternus Consulting Excel Training Courses Singapore