Office 2010: a deeper dive

By | April 29, 2010, 4:00am PDT

Summary: I’ve spent the last six months immersed in Office 2010, using all the core programs day in and day out, digging in to see what’s new, what works, and what’s still annoying after all these years. In this post, I’ll give you a wide-ranging overview of what’s in Office 2010, so you can decide whether it matters to you.

In every sense of the word, Microsoft Office is huge. Hundreds of millions of people use at least one of the programs in the Office family every day—in enterprises, small and medium-size businesses, homes, and schools. When Microsoft released Office 2010 to manufacturing on April 15, it kicked off an upgrade cycle that will last for several years.

I’ve got a unique perspective on Office. I’ve written at least one book about every version of Office since 1994 (that’s eight releases and 10 books in 16 years, for those who are keeping score). I’ve also written countless magazine articles and blog posts, all of them based on extensive, hands-on experience with the individual Office products. This time around is no exception. I’ve spent the last six months immersed in Office 2010, using all the core programs day in and day out, digging in to see what’s new, what works, and what’s still annoying after all these years. In this post (first of a series), my goal is to give you a wide-ranging overview of what’s in Office 2010, so you can decide whether it matters to you.

Judging by the Talkback comments I’ve seen in various posts here and in quick-and-dirty reviews elsewhere, I know there’s a lot of misconception about what’s in Office 2010. I’ve read a few comments that dismissed the changes in this edition as superficial eye candy, hardly worth the upgrade. And I understand how easy it would be to come to that conclusion if you simply poke at Word and Outlook for a couple hours (or even a couple days), and then fire up the other Office apps for a quick lap around the track. With that sort of superficial look, it’s easy to pass judgment on Office as too big, too complicated, too expensive, too old. (Amusingly, most reviewers I’ve read find some pet feature that doesn’t work exactly as they would have designed it and then harp on that for the bulk of the review. It’s as predictable as the sunrise.)

Honestly, I wish Office 2010 was a minor upgrade. If it were, I would have been done with this book about six weeks ago and I’d be sitting on a tropical beach sipping mai tais right now. But the reality is different: Office 2010 is a surprisingly deep, thoughtfully designed, well-engineered collection of software programs. The more I dig, the more I like the small but useful touches that the Office design team has wrought. That’s not just my opinion, either. I’ve heard variations on that sentiment from dozens of correspondents, including a few who are Office skeptics.

It is true that the core programs in Office—Word, Excel, Outlook, and PowerPoint—are mature, as befits their age. There are only a handful of truly new features to be found, which I point out in the balance of this post. Much of the work in Office 2010 is cleanup and polishing, smoothing over rough edges, making common features work the same across apps, improving performance. In some striking ways, Office 2010 is to its predecessor as Windows 7 is to Windows Vista. And that’s not a bad thing.

Microsoft has made a substantial investment in online features for this edition. With Office Web Apps, it’s delivered a version 1.0 release of Word, Excel, PowerPoint, and OneNote, with a common feature set that works on Windows Live SkyDrive for consumers (or will, in a few months when the retail version is released) and as part of SharePoint servers in big corporations. It’s not a competitor to Google Docs—and it might never be, because Microsoft is still in the business of selling shrink-wrapped software. But Office Web Apps offer a decent feature set and fairly significant promise. I’ll look at those web-based pieces in a follow-up post. Today I’m focusing exclusively on the desktop version of Office.

If you were hoping to see a simpler lineup of Office editions in 2010 than in its predecessors, I have only a little good news. The lineup is more logical and consistent, but the number of available combinations is still confusing, and the licensing story has, sadly, become more complex than ever. If you have questions about the details of what’s in each edition, what they’ll cost, and when they’ll be available for sale, see the last page in this package, Prices, packaging, dates, and other details.

As part of my research for this post, I fired up copies of Office 2003 and Office 2007 in virtual machines and used them alongside the new edition for a few days. If you’ve already deployed Office 2007, at least some of these features will be old news. But for anyone who has stuck with Office 2003 for all these years and still uses it heavily, the cumulative changes are overwhelmingly positive, and it’s hard to imagine an objective reason for not upgrading.

Here’s what I cover in this post:

Page 2: The Ribbon, finished Every program now has been ribbonized, including Outlook, OneNote, and Publisher. But that’s not the only interesting UI change.

Page 3: What’s new in Word, Excel, and Outlook? These are the programs everyone uses, in the office and at home. Are there any new killer features?

Page 4: Prices, packaging, dates, and other details You’ve got questions, I’ve got the answers you’re looking for.

Next: The Ribbon gets some much-needed polish –>

Topics

Ed Bott is an award-winning technology writer with more than two decades' experience writing for mainstream media outlets and online publications.

Disclosure

Ed Bott

Ed Bott is a freelance technical journalist and book author. All work that Ed does is on a contractual basis.

Since 1994, Ed has written more than 25 books about Microsoft Windows and Office. Along with various co-authors, Ed is completely responsible for the content of the books he writes. As a key part of his contractual relationship with publishers, he gives them permission to print and distribute the content he writes and to pay him a royalty based on the actual sales of those books. Ed's books are currently distributed by Que Publishing (a division of Pearson Education) and by Microsoft Press.

On occasion, Ed accepts consulting assignments. In recent years, he has worked as an expert witness in cases where his experience and knowledge of Microsoft and Microsoft Windows have been useful. In each such case, his compensation is on an hourly basis, and he is hired as a witness, not an advocate.

Ed does not own stock or have any other financial interest in Microsoft or any other software company. He owns 500 shares of stock in EMC Corporation, which was purchased before the company's acquisition of VMWare. In addition, he owns 350 shares of stock in Intel Corporation, purchased more than two years ago. All stocks are held in retirement accounts for long-term growth.

Ed does not accept gifts from companies he covers. All hardware products he writes about are purchased with his own funds or are review units covered under formal loan agreements and are returned after the review is complete.

Biography

Ed Bott

Ed Bott is an award-winning technology writer with more than two decades' experience writing for mainstream media outlets and online publications. He's served as editor of the U.S. edition of PC Computing and managing editor of PC World; both publications had monthly paid circulation in excess of 1 million during his tenure. He is the author of more than 25 books on Microsoft Windows and Office, including the recently released Windows 7 Inside Out.

Talkback Most Recent of 332 Talkback(s)

  • Great read Ed
    I've been using the beta on various platforms and have been thoroughly impressed. I'm excited to pick up the final bits this summer.
    ZDNet Gravatar
    Cylon Centurion
    29th Apr 2010
  • Interesting read, but ...
    I'd love to see more (please, grin).

    In my opinion upgrading from 2007 to 2010 is iffy.

    For large businesses that will make use of the collaboration enhancements it is probably worthwhile.

    For SMB and Home users, probably not worth the money to upgrade from 2007.

    For students, absolutely yes. The price is right, might as well take advantage of it.

    For any long time "power user", probably still not worth upgrading from 2003.
    ZDNet Gravatar
    Ron_007
    29th Apr 2010
  • forums
    @Ron_007 Some people cannot look past the GUI. While I haven't had the chance to dive into Office 2010 deep yet I do see some of the good things from 2007 but Microsoft made it perform be tter and did enhance some of the usability features.
    ZDNet Gravatar
    alasiri1
    11th Mar
  • RE: Office 2010: a deeper dive
    @NStalnecker I used office 2010 for quite awhile, but had to go back to 2007 due to too many crashes, and issues with multiple monitors.

    Honestly, sure I love trendlines on pivotcharts, but by far most of current office users won't notice any difference. Just more buttons they'll never click.
    ZDNet Gravatar
    c_hamoen@...
    8th Jun 2010
  • RE: Office 2010: a deeper dive
    Haha, thanks! happy Replica Breguet Watches
    ZDNet Gravatar
    beijing2008
    14th Sep
  • ZDNet Gravatar
    xiaodou
    26th Sep
  • RE: Office 2010: a deeper dive
    cheap replica watches
    ZDNet Gravatar
    xiaodou
    26th Sep
  • RE: Office 2010: a deeper dive
    An interesting insight into the new suite: I've been
    using the Beta mainly for the past six or so months and
    have found it a joy to use. Noted that you didn't touch
    much on Publisher and OneNote: more's the pity as the
    ribbon in these makes them feel almost brand new again
    and I find them a joy to use.
    ZDNet Gravatar
    douglasac10
    29th Apr 2010
  • ZDNet Blogger

    I'll have a lot to say about OneNote
    That's in the next part.
    ZDNet Gravatar
    Ed Bott
    29th Apr 2010
  • The new school...
    OneNote is absolutely flippin' BRILLIANT.
    ZDNet Gravatar
    jessiethe3rd
    29th Apr 2010
  • RE: Office 2010:orjin krem
    @Ed Bott An interesting insight into the new suite: I've been
    using pembe maske energy balance revivaly maske the Beta mainly for the past six or so months and
    have found it a joy to use. Noted that you didn't touch
    much on Publisher and OneNote: more's the pity as the
    ribbon in these makes them feel almost brand new again
    and I find them a joy to use.
    ZDNet Gravatar
    ekoaldiva
    20th Jun
  • RE: Office 2010: a deeper dive
    @douglasac10 I used office 2010 for quite awhile, but had to go back to 2007 due to too many crashes, and issues with multiple monitors.
    orjin krem tutune son nanomatik
    Honestly, sure I love trendlines on pivotcharts, but by far most of current office users won't notice any difference. Just more buttons they'll never click.
    ZDNet Gravatar
    gaberdiye03
    20th Jun
  • RE: Office 2010: a deeper dive
    @douglasac10 Very articulate and overall wonderful! yapboz oyunlari
    ZDNet Gravatar
    AlexSerdar
    3rd Jul
  • RE: Office 2010: a deeper dive
    @douglasac10

    Where does Idaho rank? We have been living in Montana for the past 5 years and I am not supri sexy shop to find it #3 on the "worst" list. Considering a sexshopmove to Idaho to escapthe high cost of living a low income in MT. There may not be a sales tax here but they get you if you own property!
    ZDNet Gravatar
    filhomarques
    15th Jul
  • Ed, anything on low integrity mode/sandboxing?
    I heard rumors that Office 2010 would execute certain of
    the applications in low integrity mode like IE and
    Chrome?

    Can you confirm that?
    ZDNet Gravatar
    honeymonster
    29th Apr 2010

Talkback - Tell Us What You Think

Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

The best of ZDNet, delivered

ZDNet Newsletters

Get the best of ZDNet delivered straight to your inbox

Facebook Activity

White Papers, Webcasts, & Resources