Microsoft Office for iPad sets the gold standard for tablet productivity

Microsoft Office for iPad sets the gold standard for tablet productivity

Summary: It took four years, but Microsoft has finally released full-featured Office apps for the iPad. As expected, the new Word, Excel, and PowerPoint apps are free to install but require an Office 365 subscription to unlock the full set of features. Here's what you can expect.

SHARE:

Microsoft today released native iPad apps for its flagship Office programs—Word, Excel, and PowerPoint. The three new apps join the existing iOS apps from the Office family: OneNote, Lync, OneDrive, OneDrive for Business, and an OWA app for Exchange-based email.

00_Office_iPad_Opener_small

Gallery: A closer look at Microsoft Office for the iPad

After four years’ worth of speculation and anticipation, today’s releases are a welcome arrival for longtime Office users who’ve had to deal with incompatibilities and unsatisfying alternatives every time they picked up an iPad.

Make no mistake about it: These three apps are feature-rich, powerful tools for creating and editing Office documents. They look and act like their Office 2013 counterparts on Windows. And although these iPad apps obviously can’t replicate every feature of the full desktop programs, they deliver an impressive subset of those features. Anyone who was expecting Office Lite or a rehash of the underwhelming Office for iPhone will be pleasantly surprised.

Technically, there’s no such thing as Office for iPad. Each of the apps is a separate download from the App Store. They’re all designed for use on iPads running iOS 7 or later. (That restriction means owners of the original iPad are out of luck, because that device won’t run iOS 7.)

As I predicted a year ago, the apps themselves are free, but you’ll need an Office 365 subscription (Home, Personal, Small Business, or Enterprise) to unlock their full potential. Unless you activate the app by signing in with your Office 365 credentials, you’ll be limited to reading Word documents, working with Excel data, and presenting PowerPoint slide shows. Only Office 365 subscribers get to create new documents or use any of the rich editing tools.

office-iPad-activation-required

You can create and save files directly on an iPad, but these apps are expressly designed for cloud storage, using Microsoft’s OneDrive, OneDrive for Business, and SharePoint.

The apps themselves are fast and extremely responsive. They also walk the delicate tightrope between observing iPad interface conventions and building on the muscle memory of anyone who’s used the desktop apps included with an Office 365 subscription.

Tap the button in the upper left corner, for example, just as in Office 2013 apps, to display a File menu that lets you create a new document, reopen a recently used file, or browse through local and cloud storage to find a specific file. (Using the OneDrive for Business app, you can mark files or folders to be cached for offline use.)

Commands for each app are grouped on ribbons that are more compact than their desktop alternatives. (To save space, you can tap the commands on the ribbon to hide the options for that tab, then tap again to make them visible again.) The number of options available on each ribbon is, likewise, limited in comparison to the full desktop programs.

CNET Video: Microsoft Office for iPad in action

What’s most impressive about these apps is how faithfully they display Office documents. Virtually all of the Word documents, Excel workbooks, and PowerPoint presentations I opened displayed perfectly on the iPad’s screen. The only exceptions involved documents with fonts that weren’t available on the iPad and some features that aren’t supported in the iPad app, such as Excel PivotTables.

For Word documents, you can use the Home tab to assign styles, modify character formatting, adjust line spacing and indents, and apply bullets and numbers to lists. If you compare the iPad’s Home ribbon to its desktop counterpart, you can spot some significant differences. You can’t define custom bullets or numbering formats on a tablet, nor can you define styles. For that sort of work you need to go back to the desktop.

Likewise, Word’s Insert ribbon lets you add page breaks and section breaks, insert a table, add pictures and shapes and text boxes, and create or edit hyperlinks. You won’t be able to create a table of contents or index from iPad, but you can quickly insert a simple footnote. Here, too, the goal of the iPad app is to enable a broad, but not deep, set of reading and editing options.

The developers of Word for the iPad lavished special attention on features for reviewing and collaborating on documents, with full support for revision marks and comments, in a display that is identical to what you’ll see on the desktop.

Word_enable_markup_small

Excel for iPad offers similar fidelity with existing worksheets. One noteworthy innovation is a second custom keyboard that you can switch to in place of the standard iPad keyboard. Besides a numeric keypad, there’s also a full selection of operators and symbols that you can use to enter and edit formulas.

Excel_custom_number_keyboard_small

From the Home tab, you can adjust fonts and basic character formatting, change number formats, insert and delete cells and rows and columns, and sort and filter as needed.

As with the other two apps, the Insert tab includes a subset of options. Pictures are the weakest link, allowing access only to the iPad’s Photos folder. But the charting capabilities in Excel on the iPad are first-rate, including the ability to select some data and then tap Recommended to insert just the right chart from a list of options that show previews using the live data.

Entering formulas is another pleasant surprise. The Formulas ribbon includes an extensive selection of functions, arranged by category just as in the desktop app. Even obscure statistical and financial functions are available.

Unlike its Office-mates, PowerPoint for iPad is less about creation and editing (although those tools are there) and much more about delivering the actual presentation. You can choose a theme when creating a new slide deck, for example, but you can’t change that theme from the iPad app. You can, however, add transitions between slides and rearrange slides in a deck.

If you can send the iPad display to a large screen or a projector, then you can drive the entire show from the iPad. As with PowerPoint on Windows tablets, you have options to display a virtual laser pointer, pen, or highlighter. Those annotations aren’t persistent; they disappear when you end the slide show.

What’s fascinating about Office for the iPad is how it leapfrogs Microsoft’s Windows tablets. On Windows 8 and Windows RT devices, Office is still a desktop app with some grudging interface tweaks designed to ease the pain of using an app without a mouse. Anyone who owns a Surface RT is likely to look enviously at these iPad apps, which for now are the gold standard for Office on a modern tablet.

Topics: CXO, Apple, Storage, Operating Systems, Mobility, Microsoft, iPad, iOS, Enterprise Software, Data Centers, Windows

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

230 comments
Log in or register to join the discussion
  • Doing business work on 10' screen

    Shoot me, please.
    LBiege
    • Hmm....

      Yeah, a 10 foot screen might be a little too large, but no need to be shot over it.

      Now a 10" screen on an iPad, which this article is about might be a bit small, but again nothing worth getting shot over.
      cmwade1977
      • Larger

        Just put the iPad real close to your face and use your nose to tap the screen.
        Sean Foley
        • Experience?

          Just wondered how much time you've actually spent with these Apps on an iPad. Your opinion isn't really worth a lot unless you've actually seen it and tried it out. Is it?
          UGottaBKidding
          • My thoughts exactly

            Ed declared this to be the gold-standard before he could possibly have even tried it. Work of a zealot, not a journalist.
            SomewhatSceptical
          • Maybe if you actually read the article...

            Novel idea, I know. Ed must have at least "tried it."

            "Virtually all of the Word documents, Excel workbooks, and PowerPoint presentations I OPENED displayed perfectly on the iPad’s screen. The only exceptions involved documents with fonts that weren’t available on the iPad and some features that aren’t supported in the iPad app, such as Excel PivotTables."
            Draclvr
          • You didn't read

            the article did you?
            new gawker
          • I'm sure he got a pre-release version

            He's well-read in Microsoft circles. So he's probably top of the list of columnists who get pre-release versions.
            KPOM1
          • Exactly

            And considering how expensive Office on the iPad turns out to be. . . .

            And how little discussion there was of the areas where iWork on iPad is much more productive than MS Office, I suspect he has little or no experience of the alternative, and far more affordable, and much better integrated, packages.

            In which case the "setting the gold standard for tablet productivity" comment is presumably paid advertising.
            Henry 3 Dogg
        • Re: Larger

          For nearsighted people, close is good (no glasses needed.) For one-handed people, the virtual keyboard doesn't need the large arm movements required for typing on a standard keyboard. To make this work, one would need to use the iPad with a smart cover while lying prone. The utility of a tool depends how well it meshes with your own set of abilities.
          IanRoy
        • One can also

          Do the same thing on a Surface tablet.
          athynz
          • You mean the

            Few and the proud surface owners.
            Johnpford
          • Yes

            We are proud :)
            Rann Xeroxx
      • Productivity?

        How does one touch-type on a virtual keyboard? Really, it's just a hunt-and-peck interface.
        harry_dyke
        • Virtual keyboards

          have an interface problem if you want to touch type on your tablet. I personally prefer the native AOSP version of the Android keyboard on my phone and tablet for the few times I use them. The iPad and iPhone keyboards drive me bonkers, but are usable once you adapt to the differences in how they operate.

          I use voice input for nearly all typing on my tablets and phones, but that doesn't always format well. I carry a bluetooth keyboard and multi-touch trackpad with me pretty much everywhere so I'm covered pretty much no matter what I might need to use my devices for.
          l_creech
    • Have to go with that

      Office just does not work on a ten inch screen, that goes for any office suite. It's just sheer torture on the eyeballs.
      Alan Smithie
      • If you have a keyboard & mouse/touchpad, a 10" screen isn't bad.

        It is trying to use an on-screen keyboard that cripples personal productivity.
        M Wagner
        • Defeats the object

          That was invented many years ago and the called it a laptop and the 10inch form factor was called a netbook with the added bouns that netbooks were very cheap.
          Alan Smithie
          • Not really

            Netbooks did not do so well. Mostly because they were junk to be cheap. People now-a-days who want "light" either carry a light Air or Ultrabook (office solution already available) or an iPad (most other tablets not doing well). Now they have a way to touch up their Office work if they are carrying their iPad at the moment. Makes sense to me. As for the keyboard, I have an iPad with the Logitech ultra slim keyboard cover when I know I will be doing much typing with it. This should work great for what I need.
            NBrazil
          • Yes really

            When netbooks came out people were not going to pay a premium when they could just buy a more functional laptop, hence netbooks had to be cheaper.

            The iPad has now evolved past that dilemma through the use of the touch screen gimmick. They've provided netbook functionality at the price of a laptop and now that you've got your keyboard and Office, you can't pretend otherwise.
            Pastabake