Apple iWork 08 Tutorials
Create Dynamic Spreadsheets / Edit a Formula
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 / Edit a Formula)
Now, let's continue our work with functions here just a little bit and we saw earlier in the previous module how to create functions and formulas very easily just with some drag and drops. Now, I've started to flush this out in a little more detail here and let's add some other numbers and I've got a quarterly totals column here, so let's just try to add up some of our quarterly totals here. Well, I also have the option of starting a formula with the equal sign and now I get something that looks like this and I can just start typing either, I have actually a couple of options here. I can use a hard number like 500 and then arguments like plus, minus, divided, multiply and so on. So 500 plus, that's one of the options I have. I can also just click on one of the cells. So 500 plus January iWork '08 and I can continue to build this formula. Plus March Outlook 2007 and again, I can subtract if I want to. Minus another hard value, 500 and now when I'm done building the formula, I can either press enter or this little checkbox right here is the accept formula changes, this is cancel formula changes. So I'll accept them of course and let's see. How's the math working out? Five hundred plus or minus. These cancel each other out so 100, 200 is 300. Exactly. So it's pretty easy to build formulas and this also lets me change these items here so if this becomes 150, then of course the item is going to change here within the formula itself and the result of that formula is going to change. Now, other options you have, you could select the cell, look at the contents of the cell, which is, contents of this cell are based on a formula. I could just type in some of my functions like sum is a function and then as long as I understand the language of how to build it, I'd be in good shape. So sum of open paren and then I can drag and select a range, so B3 to D3 and then close paren and enter and now I've got a quarterly total for the iWork '08 tutorial views. Ok? So lots of ways to do this. You can also add other things to it. So some of B3 to D3 plus maybe 300, something like that and you should get to a value of 950, of course. So that's how you use the formula editor and of course the formula editor is going to let you have a little more specific control about what gets selected and what gets part of the end equation there. What you also have available when you're dealing with a formula or a function is the, also the ability to drag a function or a formula really across the entire table. So for example, this one down here we built. We just drag and dropped the sum formula. We selected this range here and I'm starting to edit this here, which I don't want to do so I'm going to press escape. But we just selected this range, we drag and we dropped the sum value or the sum function into that cell. I can select this and then with the auto-fill handle I can drag this all the way across the table and it will do the same thing for each column. So watch what happens here if I take this. The auto-fill handle is just a lone, black cross like this. No arrow next to it and then drag, drag and that's the auto-fill. So that fills, if you look at the individual cell, this is the sum of C3 to C5. What about one that I've built from scratch like this? Will that work as well? Let's try it out. Absolutely it will. So we still have here sum of B5 through D5 plus 300 becomes a great way to use that auto-fill and the auto-fill handle.
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
