Apple iWork 08 Tutorials
Create Dynamic Spreadsheets / Add a Function
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Apple iWork 08 / Create Dynamic Spreadsheets / Add a Function)
Numbers also lets you perform much more complex calculations on the data that is in a particular table by using the function browser. So if you have a cell here that you want to populate with a function, you do so by clicking on the function button up here and rather than the simple ones like sum and average and minimum and maximum, we use the more functions to open up the insert function or the function browser and now you have a big laundry list of possible categories including the all category that give you just hundreds upon hundreds of functions that you could add to a cell. And notice that as I even start this, it's beginning to populate that cell with the equals. In other words, the formula editor is already up and ready for us. So it'll just depend, and there's far too many for you or me or anyone else to try and memorize because you use these on an as-needed basis. But let's just say for example your numeric, you can have the ceiling functions, floor functions, this is also where we can choose a sum function if we want to. So why would we need to using the browser? Round up, round down, first specify number of places. So all of these things can be used to start to manipulate the data in more sophisticated ways. So that equals odd number. Now, if I enter something in that it's impossible to do the calculation on, I get a little button that looks like this. This is the little warning, warning triangle and if I give it a click, I'll see number is an invalid reference. So what I need to do here is instead of have number, which was a placeholder value, if I type in something like four here in the number and press return, then the function of rounding this up to the next highest odd number will be five. If I choose instead of odd and I choose a cell value like this, I can press enter and again, 451 is the next thing that is rounded up to using this formula called odd. So that's how you use the function editor or the function browser. It can also be launched right from here as well, with that little button. But either way, you're going to get the same thing and again, perform much more sophisticated calculations. If you can use the formulas that we've already configured here, we understand a little bit how to edit those formulas, then you'll be off to the races really when it comes to using more complex functions because really, it's just a matter of specifying a function to use because sum performs many calculations. Sometimes odd can perform many calculations but like some of these other ones, like date and time, financials, standard deviations and so on and so on, turning metric, these all are explained to you and, again, who would ever bother to memorize them all normally? No one would. But this calculates the co-sine of an angle, express and radiance. Great. Let's insert that into my table as well. Once you get the basics of it though, it's just a matter of selecting the proper cells and then letting the function perform the actual calculations.
Tutorial Information
| Course: | Apple iWork 08 |
| Author: | Brian Culp |
| SKU: | 33851 |
| ISBN: | 1-934743-50-X |
| Release Date: | 2008-02-07 |
| Duration: | 6.5 hrs / 105 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
