Perezonomics
  • Home
  • Tesla
  • About Me

The iPad Pro, 3D Touch, and Microsoft Excel

3/26/2016

 
Picture
​Apple has come a long way in making the iPad a much more palatable device to get real work done. Most companies live and die by using Microsoft Excel and the new 13” iPad Pro has enough screen real estate to finally make spreadsheets doable. For the iPad to ever be taken seriously by the enterprise market, it had to grow in size. That’s not to say that it will definitely be an enterprise success, but at least Apple has given it a fighting chance. Phase I is complete.
​But there is an equally large piece still needed to make spreadsheets on a tablet more comfortable. I’m not talking about the frivolous stuff that most Mac users opine for. I’m talking about a suitable replacement for the right-click menu in Microsoft Office. Unlike a file system or multiple window support, the right-click menu is used by the majority of people who use laptops to get work done, not just a tiny minority with esoteric jobs. Phase II of the iPad’s assault on enterprise has not started yet.
 
When I first envisioned using an iPad to do my work, I figured that Apple would have to add either Mouse or Touchpad support to iOS. Coming from Windows PCs where everything originated from the right-click menu, using spreadsheets on a tablet seemed cumbersome. To get around the lack of a right-click, pop-up menu in iOS, Excel uses a variety of work-a-rounds that needed multiple touches. Selecting ranges, writing Formulas, and formatting text all take a lot longer to do on a tablet than they do on a laptop.
 
I made the assumption that Apple would need to do the unthinkable--allow mouse support in iOS to make spreadsheets just as efficient on tablets.  But I was like a medieval knight who is unable to imagine that what he really needs is aerial drone surveillance to spy on the enemy. I can’t request what I can’t imagine.
 
The whole concept of 3D Touch took me totally by surprise. I couldn’t have fathomed that Apple would create a whole new dimension of interacting with your information. Who needs a separate device tethered by a wire when you can simply use the screen itself as one giant right-click button? Brilliant. Apple doesn’t really get enough credit for thinking outside the box on this one.
 
The Samsung fans love to say that it looks like Samsung copies Apple because the whole market was headed in that direction anyway. But I have a feeling that if Apple hadn’t done 3D Touch on a smartphone that no one in the industry would have done anything like it for ten years. Samsung was too busy fighting the spec war even if they were killing their SoC performance by adding more pixels to their resolution. They were also working on gimmicks like curved sides, the smartphone equivalent of adding 22” spinner rims on your car. Visually interesting but of little practical value. 
​If, or I should say when, Apple adds 3D Touch to the iPad, this ushers in the exciting possibility of Microsoft incorporating Peek and Pop into Microsoft Office.  You could press on your selected cell with your index finger to “peek” at your right-click menu. Then you could select your menu choice by pressing harder to “pop”. This would make working on a tablet just as efficient as using a Mouse, arguably even more efficient. No longer would you have to tap multiple touch targets in different parts of the screen.
 
But the introduction of Peek and Pop into Excel goes beyond just matching simple speed. For a younger generation of office workers who may be exposed to a 3D-Touch-enabled Microsoft Office before they ever use the laptop version, this could become the preferred method. You could make the case that this direct touch interface is actually more intuitive and superior to the mouse point and click.
 
For 45-year-old office veterans like me with twenty plus years of experience with a mouse, this would be heresy. I remember back in the mid-90’s when the industry standard Lotus 123 was being upended by Microsoft’s Excel. I heard about a large study that tried to quantitatively answer the question of which spreadsheet program was better. They pulled a large group of both Excel and Lotus 123 users and had each group switch and use the other program. The results? The study found that whatever program you cut your teeth on, you viewed that program as superior after having used both programs. My point is that once you get used to a certain way, your history colors your assessments of new options.
 
But guys like me will be gone in twenty years. 

Past Posts
----------------------
​Why a larger iPad is long overdue - Jan 2015

Comments are closed.

    Robert Perez

    Manufacturing and distribution analysis since 1993.

    Picture
    E-Mail Me

    RSS Feed

    Perezonomics is available in Apple News

    Archives

    October 2024
    September 2024
    May 2024
    April 2024
    March 2024
    February 2024
    January 2024
    December 2023
    November 2023
    October 2023
    September 2023
    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014

Web Hosting by iPage