Join Jess Stratton for an in-depth discussion in this video Working with formulas, part of Office for iPad and iPhone Essential Training.
…Formulas and functions are at the heart of what makes Excel so powerful.…Formulas and functions allow you to transform data and perform complex…calculations on that data, whether it's an operation on text or a number or a date.…To enter a formula from scratch, tap into the cell and…start with the equal sign, just like you do in the desktop version of Excel.…All the functions will turn up.…You can either scroll and get an alphabetical list of everything,…or you can tap on the Formulas ribbon tab.…
This is going to give you a categorized view,…of all the functions that you can choose from.…Tapping the i sign with the circle on it, will give you information and…tell you how to use that function.…It tells you how it works and you'll see how to type the function, and…how to enter any cell or data parameters that it might need.…If you know the specific function that you want, like I said earlier,…you could either start typing, or you could simply tap the effects button.…This is going to bring up that same list.…
- Installing Office for iPad
- Exploring the interface
- Creating new documents, spreadsheets, and presentations
- Changing the page layout in Word
- Inserting pictures and charts in Excel
- Adding slide transitions in PowerPoint
- Collaborating in Office for iPad and iPhone
Skill Level Beginner
Q: This course was updated on 11/07/2014. What changed?
A: We added new movies and updated existing ones to include the new Word, Excel, and PowerPoint apps for iPhone as well as discuss Dropbox integration. While most of the course was filmed on an iPad, the apps work very similarly on both the iPad and iPhone. Also check out the <a href="http://www.lynda.com/Office-tutorials/Office-iPhone-First-Look/361524-2.html"><em>Office for iPhone First Look</em></a><em></em> course to explore which editing features are available to all users and which require an Office 365 subscription.
1. Word for iPad
2. Excel for iPad
3. PowerPoint for iPad
4. Outlook for iPad
4. Collaborating with Office for iPad
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.