Join Richard Harrington for an in-depth discussion in this video Creating formulas, part of iWork: Workflows and New Features.
…If you don't get what you need from smart…cells, you can also create your own custom formulas.…Let me show you how to add a…formula, as well as access some additional advanced functionality.…Creating formulas is similar to previous versions of Numbers.…For example, lets add an extra cell here, I could…do this by dragging down to increase the number of rows.…Or in this case, I've added some footer cells.…Under Table, I could simply increase that number or…use the shortcut of Option + down-arrow to add.…
Alright, let's go ahead and adjust this here back to 3.…And…what I want to do is average out the rates.…So, I'll click equals and as I start to…type, you'll note that it begins to suggest things.…So, it automatically, intelligently selected average, giving…me the choice between these two options.…And I want the average option.…And now it prompts me to build. So it needs a value.…Well I'm going to click on these Rates here to…select a range. So now it's going to give me the average…rate of what these people build per hour. I'll click Apply and…
This course was created and produced by Rich Harrington. We're honored to host this content in our library.
- Installing iWork
- Setting up iCloud
- Sharing via AirDrop
- Printing with AirPrint
- Enhancing objects and text with styles
- Adding animation to presentations and spreadsheets
- Working with coaching tips
Skill Level Appropriate for all
Keynote: Delivering Presentationswith Richard Harrington1h 35m Intermediate
Mac OS X Mavericks Essential Trainingwith Nick Brazzi7h 59m Appropriate for all
iOS 7: iPhone and iPad Essential Trainingwith Garrick Chow8h 21m Appropriate for all
1. Installing the Software
2. A New Way of Collaboration
3. Essential New Features in Pages
4. Essential New Features in Keynote
5. Essential New Features in Numbers
- 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.