Join David Rivers for an in-depth discussion in this video Using functions, part of Numbers 3 Essential Training.
- View Offline
- Exercise Files
Here in Numbers, we can add all the formulas…we want by building them…as we did in the previous movie.…But on occasion, those formulas…could get very complicated or long.…For example if we wanted to total up…several rows in a column by adding the plus sign…in the cells, it could take awhile.…Well the good news is there are a number of…built-in functions here in Numbers…to make life a lot easier for you.…They're really concentrated formulas…piled into a single function that we can select,…and then apply the data that we want.…
I'll show you what I mean as we continue working…with our KinetEco budget file here,…we're in the profit loss summary sheet…looking at our annual budget overview table.…If you skip to this movie, you can open up…K Eco Budget 05-02.…Let's start in the estimated column here…next to total income.…That's cell B3.…This is actually going to come from another sheet.…It's going to come from our income details sheet,…and the estimated column you can see…is column D here,…and all we want to do is add up all of these figures.…
- Creating and laying out spreadsheets
- Importing data
- Working with tables
- Adding images to cells
- Performing calculations with formulas and functions
- Creating charts
- Formatting text and numbers
- Including audio, video, and shapes
- Designing templates
- Printing and sharing spreadsheets
Skill Level Beginner
Mac OS X Mavericks Essential Trainingwith Nick Brazzi7h 59m Appropriate for all
1. Getting Started with Numbers
2. Working with Spreadsheets
3. Working with Tables
4. Working with Table Styles
5. Using Formulas and Functions
6. Working with Charts
7. Working with Text and Numbers
8. Working with Objects
9. Creating Your Own Templates
10. Sharing Your Spreadsheets
- 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.