iPad Excel Data Analysis Function

Question

Level 1

8 points

iPad Excel Data Analysis Function

Hello there,

I am stuck with a question no one seems able to answer- I've tried all three of our local Apple stores and they haven't been able to tell me. I also don't know any iPad users that have been able to give me an answer either.

I have been using a 5S and am very familiar with the functionality of Numbers and Pages. However, I'm a finance student and the fact of the matter is that I have to have access to Excel. I've invested YEARS and thousands of dollars into the iOS ecosystem and I'm very torn over what to do next. I'm hoping to migrate permanently from a laptop to a tablet for my productivity, which involves extremely heavy duty (5+ hours daily) word processing and spreadsheet creation. Pages handles the job just fine, but Numbers isn't really cutting it; Excel is simply the de facto standard in my line of work. I was pleased as punch when Microsoft finally launched Office for iOS. If the simple functions were all I needed, my choice would be open and shut. However, it's not. I must have access to the Solver and Data Analysis toolpaks. This is where it gets tricky. I have been told by Mac users running Excel that data analysis is not natively supported as it is on a Windows machine. Fine. However, no one I know is using full Office through iOS and no one at the Apple Store has been able to answer me definitively on this, either. Does anyone out there know first hand if the Data Analysis and Solver toolpaks are available on iOS version of Office? I would like to avoid fussing around with another tablet (quality, etc) and the fact that iOS is the only mobile operating suite where I can seemlessly blend Google, Apple and Microsoft, I am really, really, really hesitant to leave it. I am not willing to shell out the money for Office on iOS and run it on my phone (though I love that idea) just to find that it won't do data analysis (I'm all for experiments but that's a bit pricey for a student). Thanx for your time.

TL:DR, does the new Microsoft Office for iOS provide Solver and Data Analysis toolpaks in Excel?

iPhone 5s, iOS 7.0.3

Posted on Jun 4, 2014 2:15 PM

Reply

Answer 1

varjak paw

Level 10

170,200 points

Jun 4, 2014 3:16 PM in response to eridax700

I know what the toolpaks are (in the Mac version of Excel they're referred to as "add ins"), and again, I can find no evidence that Microsoft supports toolpaks/add-ins in Excel for iPad.

If you wish to confirm this with other users, I'd suggest you ask in the Excel for iPad forum:

http://answers.microsoft.com/en-us/office/forum/office_mobile-excel-os_device_ip ad?auth=1

Regards.

Reply

Answer 2

varjak paw

Level 10

170,200 points

Jun 4, 2014 2:19 PM in response to eridax700

That would be a question best asked of Microsoft, but no, it does not appear that any toolpaks are supported. A truncated comparison can be found here:

http://office.microsoft.com/en-us/excel-help/compare-excel-for-ipad-with-excel-f or-mac-and-excel-for-windows-HA103458713.aspx

Regards.

Reply

Answer 3

eridax700 Author

Level 1

8 points

Jun 4, 2014 3:03 PM in response to varjak paw

This sort of helps, but the toolpaks are very, very specific things, which is why I'm hoping for someone that has actually used Office for iOS and knows what the toolpaks are.

Reply

Answer 4

Nov 22, 2015 7:30 AM in response to eridax700

The short answer is no. I teach business analytics and operations management at a school that has embraced the iPad whole hog. We have not found the data analysis toolpak nor have we found a reliable work around.

All of the apps out there lack the functionality.

For this reason, we still rely on laptops and computers for the labs.

Reply

Answer 5

rccharles

Level 6

12,957 points

Nov 22, 2015 12:12 PM in response to eridax700

Without a mouse this could be a pain.

Hazeware

Run Windows 7 and Microsoft Office off of a cloud computer.

https://hazeware.com/

Reply

Answer 6

Sep 22, 2016 11:33 AM in response to eridax700

My finance professor wanted us to bring in Excel...and wanted us to download the Data Analysis Toolpak. I opted to use Numbers instead on my iPad...and it turns out that it has everything. I'm a proficient user of Excel, but I'm an Apple guy...and found that Numbers can do it all...you just have to know how.

Reply