Microsoft Office 12, so far

This one‘s good. Despite its humongous size [618MB] it’s an interview with Julie Larson-Green at Microsoft, who’s the boss of the MS Office User Experience. She explains how come Microsoft is leaving the old menu-system in Office, so check out some pictures of it already.

Larson-Green explains how much Microsoft have monitored the way users (who’ve been enlisted by MS) work with MS Office, which shortcuts they use to get things done, and – maybe the most important part – what they don’t use, so that can get shaved off the big picture. Mind you, the video is about the user experience, and not as much about the new, tweaked or deleted features, but I will run through most of the new features and user interface-related bits that hit me during Larson-Green’s presentation of this pre-release-version of Office 12. When you’ve checked pictures, or the video above, you notice that when you click a certain menu, the content of that menu doesn’t pull down like it does in the current versions of Office, but the ribbon (which is what MS has code-named it) which is situated just below the menus, displays only the relevant functions for you. So, if you click the Insert-menu, the ribbon displays, for instance, the options “IGX Graphic”, “Chart”, “Hyperlink” and a variety of symbols, and these are all categorised. For instance, when clicking the Insert-menu, you find a part of the ribbon marked “Links”. In this part, you find “Bookmark”, “Hyperlink” and “Cross-reference”.

Microsoft are re-thinking the user experience in a big way, and they’re not offering a way to a “classic mode”, meaning that you will not be able to switch to a previous way that Office used to look, i.e. with the menus pulling down, et.c. I’ve got a wager on this with a journalist from Computer Sweden. He says they’ll incorporate a “classic mode”, and I say not. He’s already a loser (for implying he had very new pictures of Office 12 when they were a week old – which is like, duh, aeons of billions of years in the computer world – and for writing very muddled stuff on how the ribbon actually works).

From what I’ve seen of said video, I think people are going to like Office 12 once they get past the initial shock. If you think Microsoft are destroying Office with the ribbon-experience, remember what Blixa Bargeld from Einstà¼rzende Neubauten has said: destruction is not negative – one has to destroy in order to build. That’s reassuring, correct?

I like the concept of what Larson-Green refers to (in the video) as “the floaty”. Imagine you’re in Word, you select text and up pops a mini-menu. It’s not like a regular floating toolbar that we see in the current production versions of Word, that you can close, this one’s quite different. First, it notices what you’re doing; OK, you’re selecting text, so the floaty pops up displaying only buttons that are relevant when you’ve selected text. Now, the more you move your mouse-pointer away from the floaty, it becomes less visible. If you move the pointer enough away from the floaty, it goes away and doesn’t reappear when you let the pointer hover over the text. That’s cool and very useful. Observe that the floaty doesn’t replace the right-click; when you do, you are presented with all options that are valid in said document; this is not context-dependent, which the floaty most definitely is. The larger the monitor, the more efficient the floaty proves to be. It’s shown appx. 34 minutes into the video.

I worked as Support Specialist in MS Office at Ericsson and Compaq for nearly two years before I moved on. After that, I’ve been the MS Office-support specialist in every place I’ve worked, and am now educating people in how to use Excel. So, I can say I represent two parties: the techy nerds who desire new programs and the functions in them to the max (to a certain extent though, nerds usually try every function in a program once, to then leave it at that, which kind of sums up the essence of the nerd), and the everyday user who actually uses said programs and functions, and only those required in daily work. Hence, here are a few things in said video that I’ve seen, and that I like.

Imagine this: you’re in Word, you’ve got a page of text in front of you, and you want to change the font in the entire document. No big deal – if you know what your document will look like after you’ve changed it. In Office 12, you mark everything in the document, click the Write-menu and click the arrow that displays your fonts, you just have to mouse-over the different fonts and the font you mouse-over is previewed in your actual document text. That’s good. Wow, I feel like the boss in “Office Space“, expressing joy at a new Word-command, but there you go – it’s the nerd in me, but also the user, think about it: this behaviour means you and others will click less and hence spend less time on a Word-document.

In Word, you’re now given the option to include a cover page, by Insert: Cover page. For me, not interesting. I don’t see Swedes using it, either. Maybe sales-people. Anyway, if one is able to create a template cover page, it might be useful! Headers and footers are also available in a few themes.

Insert: Table. This is very interesting, because you drag how many rows and columns you want your table to look like, and Word previews it for you. Nice one, I’ve missed that like crazy. There are also Table Templates included, which is a sort of Autoformat (which is a term from Office 2003 and previous versions) of a new table you insert. Now, if you opt to insert a table, the ribbon changes to display table options only. Now you’re seeing the vision. Imagine what happened otherwise: you’d get a table toolbar popping up in the work-area of the document, irritating you. Well, irritating a lot of people, so MS has shaved that off with using the ribbon instead. You’re also endowed with “Table QuickFormats”, enabling you to quickly format your tables by picking a template from a gallery.

PowerPoint includes new, very interesting ways to convert text into graphics. What the video displays as “IGX Graphics”, is the MS code-name for a new diagram-tool. If you, in PowerPoint, type a few lines (that turn out “bulleted”), mark that text and click the arrow next to the IGX Graphics-icon, you are presented with a gallery of graphics. You really should see the video to catch the full glimpse of this, but let’s just say it’s a lot easier to create a flow-chart this way than using the old one. After you’ve converted your text to an IGX graphic, you can give it a special style, e.g. you can give buttons a beveled look, add more 3D-looks, shadows, et.c. Again, the previews are very much alive, which is something I’ve pined for, especially using Office 97.

Themes! This is interesting, and I think this will hit through all the Office-applications. Not to be confused with Templates – I assume! Again, this is a little preview of the first test-build of Office 12, which means Microsoft may change the names of all of this stuff, although I imagine they won’t, most of the time. Anyway, themes. Say you’re in PowerPoint, and you create a new presentation. That presentation is now endowed with a theme, which you can switch. A theme means that this presentation is now equipped with a pre-selected number of colours, QuickFormats, galleries, shadows, et.c. It means a theme’s there to keep a document consistent throughout its days. Techy aspect to this: as I’m a technician, I often face people who’re experiencing corrupt Word-documents. Yeah, Word. Sometimes Excel, but nowhere near as often as Word, and the other applications produce less corrupt files – but this may be because I’ve worked in organisations where MS Word is, without a doubt, the most used Office application. Anyway, the errors: you may have come across them yourself, and they’re more common in Office 97 than in the later editions, although they do turn up there as well. I’m sort of wondering…how corrupt Word 12-documents can get, if they inherit themes, galleries, and as developers are now given the chance to actively change the content of Office; developers are going to be able to create content in Office, e.g. galleries, QuickFormats and other deep content that allows developer tools to become “first-class citizens”, as Larson-Green calls them. I wonder if this, in the end, means that introducing the new Office API’s to developers will force the customers to really enforce quality control on the suppliers. Imagine a poorly written gallery that can propagate corruption to every Word-document you open/create and save, even though you don’t use it? Hell city, kitty. But these are just my worst-case-scenario thoughts.

Office 12 will be much more useful to people with hearing and seeing disabilities. For example, for the first time you’re able to type text and let it turn into graphics. Just imagine what this allows 3rd party-developers to do for people with accessibility issues. Sweet!

Back to PowerPoint, though. Animations! Of course, these are previewable as well. Mouse-over on an animation (selected through the Animation-menu) and you’ll see the preview on your presentation, live, without entering Slideshow Mode. The same thing with Themes. This is all enabled through the new graphics engine, which is something that actually strikes through in Windows Vista, the coming operating system from MS; I’ve heard rumours that some functions in Office 12 will not work unless you’re running your Office 12 on Windows Vista, and I think that’s probably true. By the way, if you want to see how Windows Vista looks, check out this page where you can grab an interview with the lead program manager of Aero (which is the name for the new look in Windows Vista) who besides showing the new interface says that fresh research shows that the regular Windows-user has four (4) windows (i.e. applications, shells, Windows Explorer-windows, et.c.) open as a max. Anyway, check that film out if that rings your bell. Also, check this page where you’ll find a film that shows Windows Vista from a user-and-developer-perspective. Very good one! For you Office-freaks, a very interesting bit in Windows Vista is the search functions: you can opt to search for Office-files created by a specific author; believe it or not, Windows Vista gives you a drop-down menu where you can pick an author – and this data is picked from the properties of the Office-files! The nerd in me is now very happy. And this is why people should always care about the meta-data in Office. Open a document previously saved, click the File-menu and pick Properties. That’s what Windows Vista – and a buck-load of applications and systems – will pick the info from.

Excel! The first little thing to note is at the end of the tabs. In the video the interviewer says “What’s the new tab?”. Well, if you click it, it creates a new tab. Time-saving. The second thing that hit me, in the video – but it might be the first thing that hits me whenever I get the first beta-version of Office 12 and try this out myself – is that one can click the top part of the spread-sheet that reads “Click to add header”. In older versions of Excel, you have to click through File: Page Setup: Header/Footer. That’s a pretty different path to take than in Word, where you venture through View: Header and Footer. Another good thing in Excel is the zoom-bar, which is a little lever placed in the bottom right corner of Excel; pull the lever and you’re presented with a layout view of the pages, like a cross between Page Break Preview in Excel, with Print Layout View in Word. This zoom-feature is also available in Word and PowerPoint. Great!

Insert: PivotTable. Now, in ye older Office than version 12, PivotTables are accessible through Data: PivotTable and PivotChart Report. I think the new name with the little icon will actually get more people using it, because today, merely a few percent of all Excel-users even know what a PivotTable does. For more info on that, check this link.

The great thing about Excel in Office 12 is how functions are accessible. Now, you click the Formulas-menu, and you get a number of book-icons in the ribbon. These represent different categories of formulas, and if you click one, a pull-down menu appears and displays the available formulas. Mouse-over one of them, and their functionality is displayed in tool-tips. Easy! It’s better-looking than in older versions of Excel, and Larson-Green states the tool-tips will hold enough info for the user to not want to press F1 to enter Help-mode and get more info on the function in question.

You can high-light cells based on requirements, e.g. select a bunch of cells that contain values and click Highlight; now click “Top 10%” and the cells containing the top 10% are high-lighted. Now you’re presented with a little windows where you can change the 10% to whatever number you like. Using conditional formatting you can even easily let Excel divide the selected cells into three different number ranges and colour-mark the cells accordingly. Evidently, the Office User Experience-team have been studying users. Another proof of this: usually, the top row in a spread-sheet displays the headers. If you navigate in a big-enough Excel-sheet you want the headers to stay with you as you scroll, and you use the Window: Freeze Panes-function. Now, Excel automatically senses that you’re using headers, that you’re scrolling downwards enough that the headers should be lost, but here’s the money-shot: without using any former Freeze Panes-function, Excel renames the column-names (i.e. A, B, C, D, et.c.) to the header-names. Whassup!

Styling charts is much more simple and intuitive thanks to the ribbon. You can pick where the legend, titles and your chart goes from a gallery, if you’d like, or you can pick the layout of the individual parts that make a chart, e.g. the legend, how it should be displayed, how the chart itself should display visually, e.g. with drop-shadows, bevelled, et.c.

So hey, where’s my copy of Office 12? :-)


Translate to:

11 Responses to “Microsoft Office 12, so far”

  1. *K* Says:

    I read about 12 words of what you wrote. We finally got new Macs and software at work, so we’re only what 3 generations behind the latest now??? Wooooo!!!!!!!

  2. Niklas’ blog » Blog Archive » Urgent MS-patch + Office 12 again Says:

    [...] Paul Thurrott has just written a piece on Office 12, check it out here. Personally, I think the hype about the Office 12 ribbon will die quite soon after Office 12 is released, when people realise two things: 1) it’s not worth anybody’s time to be scared of because 2) you’ll realise it will save you lots of time. And there’s a lot under the hood of Office 12, check my old, lengthy post about Office 12 about more on this, plus another one on the new file formats and XML stuff, and there’s even more from this search for it. [...]

  3. Niklas’ blog » Blog Archive » Tech: extensions, PS3, Linux and MS Office 2007 Says:

    [...] This is a very interesting page where you can let the top MS Office-honchos show you the great news of MS Office 2007, which of course is the coming version of Office 2007. I’ve written about many of these features before, in the days when Office 2007 was still known as Office 12, all corners were sharp and the graphics-engine wasn’t maxed out the way it is now, and now – things are looking good, and it’s obvious that Microsoft has been studying MS Office-users with great care, to know what to enhance in MS Office. [...]

  4. Roger Says:

    Yes it’s good – but you don’t seem to be able to create IGX graphics which build!!! a serious omission (or maybe that’s just the Beta…)

  5. Niklas Says:

    I am able to create IGX graphics, using Office 2007 TR1. What are your problems, specifically?

  6. Niklas’ blog » Blog Archive » Windows Vista Beta 2, MS Office 2007 beta 2 Says:

    [...] On MS Office 2007, it seems that themes, i.e. colour-schemes, are working, which they did not in beta 1. Not forgetting that you can now blog from Word, save files as PDF and a great number of other things that I have covered before. [...]

  7. Niklas’ blog » Blog Archive » Computer World reviews MS Office 2007 Says:

    [...] Office 2007 has been built through a process where Microsoft have, for the very first time, really watched how users work when using ye olde Office-suite: which menus and buttons don’t they use? How can we decrease the number of clicks needed for users to perform tasks? Should we concentrate on user productivity? New functionality? Why do users have to wade through loads of menus to find what they need? Those questions really, really needed answers, not only to make people buy the next version of MS Office (and to accept the fact that it will require more of the computer, e.g. processing-power and hard-disk space) but to break the Microsoft development curse: they haven’t delivered a new product in a very long time, and by that, I mean it’s been ten years since the Exchange, Office, VB, server-platforms and so forth jumped out of the bag, so there’s no real ring to it, right? No, shiny new versions don’t count, and neither is stealing everything new from OSX to Windows Vista. But this is shiny new in a nice way, so let’s see what’s up and has happened since my review a year ago. [...]

  8. What is Open Office? Says:

    After some initial testing, we found that _everyone_ at our office hated MS Office 2007. We’ve all switched to Open Office. Not only is it easier to use, but it cost us nothing to setup and install. The $12400 that was saved went right into our pockets: every employee got an Open Office bonus of $250 in their paycheck last August, with an additional $1650 used to refurnish the office kitchen.

  9. Niklas Says:

    True, a lot of people have major problems with MS Office 2007; I use both OpenOffice and MS Office 2007, and both suites have things that the other lacks. While I’m happy with both of them for different reasons, I must say I like the idea with the MS Office 2007 ribbon. In terms of productivity, I’d say it enhances work, especially in combination with quick finger-action as far as keyboard shortcuts are concerned in MS Office 2007.

    A lot of our users at work love the online functionalities that MS Office 2007 brings, such as automatic searches for new templates, clip-art and dictionary searches.

    On the other hand, one does not pay for OpenOffice. Therein lies the catch. Personally, I think Microsoft has to come up with a lot more nifty features/offers in order to get the big customers to bite. On the other hand, a lot of professional systems integrate with MS Office, which gives them the upper hand in the bitter end – today. As systems become more and more standardised and open, however…we’ll just have to see what happens as a lot of Office-suites are online, e.g. Google Docs, and MS Office.

    P.s. I like the beta of Virtual UbiquityAdobe Buzzword, which is an online word-processor.

  10. What is Open Office? Says:

    We’ve looked briefly at online docs (Google, specifically) but we’d prefer to keep an documents in-house. I’m surprised that you feel that MS Office enhances work. I personally find that it gets in the way of my work, with the interface and file format switching every two or three years.

    Recently we’ve been floating the idea of moving all workstations to Ubuntu, but we’re stuck with Solidworks (CAD software) that won’t run in Linux.

  11. Niklas Says:

    I’ll be the Devil’s Advocate this time around: speaking of MS Office, the interface hasn’t changed this much for 18 years; there haven’t been anything like The Ribbon and the Floaty in previous versions of MS Word before, and do note that this way of working even differs from other applications by Microsoft. Seeing that they’re doing their best to integrate all of their applications into each-other, it will be very interesting to see whether more applications by Microsoft will adhere to the new way MS Office looks and works, or if they will choose to go different ways on that one.

    On the other hand, I must say I still am not fully at home with the new way MS Office looks and works, and I’ve worked as an MS Office support specialist full-time at Ericsson/Compaq for 1½ years, and am still educating people in MS Excel – plus, I’ve now been using MS Office 2007 for appx. two years, since the alpha-phase.

    The learning-curve hits a steeper hill when faced with another reality: I think quite few people who are using MS Office are using the very latest version. This causes all kinds of problems, from compatibility issues to some having to work in different ways, depending on which version of Office they’re using at the moment. At work, we’ve almost completely migrated from v97 (which is unsupported by Microsoft since a few years back) to v2007, but there are still a lot of third-party kinks to work through.

    The new, XML-based file formats have come with MS Office 2007. Even though they’re causing a bit of compatibility problems with older versions of MS Office, there are free add-ins available for Office 2000/XP/2003 right here.

    As far as SolidWorks seems concerned, it seems useless under Wine, even though I wonder how it would work on Ubuntu, under VMWare. That would, however, require a license for running Windows, which spoils the entire idea, I guess.

Leave a Reply