Excel 2010. A quick look

Posted by on Tuesday, September 8, 2009 · Leave a Comment 


Excel 2010 is coming in a few months and I am really excited by the new features. I am waiting anxiously for it to be GA.

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 definately 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

  • Improvments 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.

Related posts:

  1. Excel 2010. A quick review Just like driving a new car, I will report the new facelifts Microsoft has done to this spreadsheet program! Zippy startup and the familar Ribbon...

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

android-10b-excel

Google officially announces 10 billion app downloads in Excel

Dec 08, 2011 | Discuss

As an Android fan, I am happy to learn that the Android Market has surpassed 10 billion downloads. I found this pretty looking 3D column chart. I have never been convinced that 3D charts are good enough for serious business use. But this chart made me think again. The exponential growth trend jumped at me. [...]

Continue Reading

3D Setting in Excel Charts

Do it in Excel: Ring charts are better Pie charts

Sep 11, 2011 | Discuss

Pie charts are a circular chart divided into sectors, illustrating proportion. I remembered learning them when I was in primary school. Apparently it was invented by this person called William Playfair in 1801. Pie charts are simple to understand but rather limited because: 1. Can only show a single data series. 2. Can only show [...]

Continue Reading