In this video, staff author Jess Stratton shows users how to navigate around the Excel for iPad interface, including a tour of the ribbon tabs.
[Instructor] On my iPad I'll tap to get into the Excel app. In the new screen on the left I'll tap blank workbook. Now that we have a spreadsheet open let's go through the navigation starting at the top left. The arrow with the circle around it will immediately return you back to that main screen where you can view your account, open a recent spreadsheet, or create a new one. The paper icon will give you properties about your actual file, such as the size, the name, you can export it, send a copy to somebody else, and print it.
The left and right curved arrows are undo and redo to undo the last action you did in your spreadsheet. In the top center is the familiar ribbon interface just like we saw with Word in the previous chapter. The home tab is your most commonly used elements that you'll use in Excel, such as font properties, cell boarders and color, data formatting, inserting cells and so on. The insert tab is where you'll go to insert things like tables, charts, pictures, shapes, and text boxes.
The draw tab is where you can tap to use your finger to insert annotations directly into your spreadsheet. The formulas tab is where you'll go when you want to start changing and working with your data that's more than just plain text. We'll go over those a little bit later in the chapter. The data tab allows you to filter and sort the data in your columns. The review tab allows you to view and add comments for other people to check you work and go over your spreadsheet. The view tab changes the way Excel looks just like it did in Word.
You can toggle on and off the formula bar, the tabs, the grid lines. You can even freeze panes if you want a header row to remain visible when scrolling through lots of rows of data. All the way to the right is a magnifying glass icon. This will allow you to search within your document. The person icon is how you'll share your file with others. Directly below that is the formula and text bar. This is where you'll type the data to go into a cell once you tap on a particular cell you want.
The keyboard will come up right when you tap that. You can make it go away by either tapping the keyboard icon on the bottom right hand side or the X all the way to the right. You can also double tap into any cell to bring up the keyboard. Once the keyboard is up you can tap the right hand side to toggle between an alpha keyboard, like we have now, or tapping the one, two, three icon, which will bring up a formula, symbol, and number pad. Finally at the very bottom left is where you can see individual sheets in your workbook.
You can tap the plus sign to add a new sheet, but we'll be going over that in detail at the end of the chapter.
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Installing Office on an iOS device
- Exploring the interface
- Creating and editing documents, spreadsheets, and presentations
- Sharing files on the go
- Finding and replacing text in Word
- Inserting pictures and charts in Excel
- Presenting slides with PowerPoint and your iOS device
- Accessing email and calendars in Outlook
- Collaborating with others