If you’re not a heavy spreadsheet user, and you’re perfectly happy using Office 2008 on your Mac, then you might view $100 per year as outrageously expensive. That $100 is a lot of money-or it’s not a lot of money, depending on your needs and perspective. For that, you get 20GB of OneDrive cloud storage, and the ability to use all of Office on up to five computers (OS X or Windows) and five tablets. While the app itself is free to use (as a spreadsheet viewer), to actually edit workbooks, you need an Office 365 subscription, which will set you back $100 per year. The elephant, of course, is the Office 365 subscription model that Microsoft applied to Excel for iPad. The lack of support for other cloud services is troubling, but not crippling-Excel, for instance, shows as a supported app in the Open In menu in Dropbox. A nicely-laid-out file organizer lets you browse files on both the iPad and on OneDrive, although there’s no file preview functionality-if you want to know what’s in a certain file, you’ll have to open it.Įxcel doesn’t support Google Drive or Dropbox, which isn’t surprising-you won’t find support for OneDrive (or Dropbox) in Google Sheets or Numbers. (You can also disable auto-save in the same menu you use to duplicate workbooks.)įiles can be saved to the iPad (and transferred in/out via iTunes’ Apps section), or saved to your OneDrive cloud disk. (Have a second iPad? It’d come in handy right about now.)īy default, Excel for iPad constantly saves your work-so if you’re working on a mission-critical workbook, you’ll want to duplicate it first, just in case you do something bad. Usually, this isn’t a problem, but it can get annoying if you’re working on related workbooks and need to pop back and forth a lot. If you have two worksheets you want to work on, and they’re in different workbooks, you’ll have to close one to work on the other. One last limitation is that Excel for iPad can only be used on one workbook at a time. Finally, references in formulas to cells on external worksheets won’t update. You can see existing sparklines (a full graph in one cell, basically), but you cannot create new ones. Existing array formulas work, but you can’t enter or create new ones. (You may be able to open a spreadsheet in Numbers and print it that way, too.) This may or may not be a big issue, depending on your workflow.Īs noted earlier, you can’t create comments you also can’t name cells or ranges (but you can work with existing names), nor create conditional formatting rules. Inability to print-if you want to print your worksheets, you’ll need to find a Windows or OS X computer to do so. ![]() There are some features missing from Excel for iPad. I was impressed with the responsiveness of the app, even when working on somewhat larger worksheets-scrolling was smooth, and I didn’t notice any slowdowns or other issues. Some are limited, of course-there aren’t nearly as many cell border styles-but there’s enough here to meet the needs of even heavy-duty spreadsheet users. ![]() The built-in help is actually helpful, and includes things such as this guide to Excel’s gestures.įrom functions to fonts to cell borders to merging cells to table styling to hiding and shuffling worksheets in a workbook, Excel for iPad has most of the features of the desktop version. The help system is relatively complete, including a comparison table that shows what you can do in each version of Excel (iOS, OS X, Windows), along with a touch guide that explains how to interact with your data. However, the image browser is restricted to photos stored on the iOS device you can’t access any media files on your OneDrive, for example. ![]() You can also choose from a large assortment of shapes, add text boxes, and even insert images. Most of the chart types have also migrated, and creating a chart is as easy as selecting the data to chart, tapping the Insert ribbon, choosing a chart type, and then tap-dragging out a region for the chart. ![]() There are over 400 formulas present-if that’s not all of the formulas from the desktop version, it’s the vast majority of them. Microsoft did an incredible job at getting a lot of Excel’s power into the iPad version of the app.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |