Apple iWork 08 Tutorials
Create Dynamic Spreadsheets / Use Cell Controls
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 / Use Cell Controls)
In this module, we will look at cell controls and this is a very interesting way to work with a spreadsheet or a table and you've already seen this in action. If I switch back to my Hawaii itinerary that we saved earlier on, you'll notice that if I click on my reservation sheetÉ I'm sorry. If you click on the packing list sheet, you'll see a lot of these little checkboxes here which I can select. Now, you can add those to your own spreadsheets as well and I'll show you how to do that right now. So we have this table, tutorial views and let's say we just want to goal met and we change it. Instead of quarterly total, goal met. So maybe that's next to the quarterly total. Who knows? So now in these cells, I'll just select the range of cells and I'll use the inspector, and again the cell inspector, to change the cell format to a checkbox and now it just becomes a matter of whether they're checked or unchecked by default and now we can just look at the, maybe the totals again and then yes, the goal is met, no, the goal hasn't been met and so on. So that's one way to use these cell controls that I mentioned. Another way is maybe you have another range of cells and you want to define for people, or maybe for yourself, with a little more precision what kinds of numbers they can add. So the cell format, rather than number, is a step and so now the minimum might be 50 or 10, the maximum, let's just say is going to be 110 and the increment is going to be 10 as well. So just take some big, round numbers here and we'll go ahead and close this. Now what you should see is the ability, and notice that it truncated those. Those are no longer 150 anymore. They've been truncated to 110 and now, rather than entering in data specifically, if I try to enter in 85, it's going to take me back to 110. Again, 85, and I'll even delete what's there before and again, it'll just round that up. So these steppers let me increment, decrement and maybe that's what the choice I want, which makes the numbers easier to work with. So those are the controls that you can use. You can use these kind of controls, these kind of controls and again, they're called controls because it controls what kind of information can be added to a cell. Open this back up again, the inspector and just take a quick peek at some of the other ones. The slider, again, if you wanted to slide your entry and again, notice that the increment is going by tens, so let's get this out of the way a little bit. So you could use a slider to enter your data in as well. Or you can use a pop-up menu and maybe one is the first one, but this is going to be the choice of ten. Your second one, we'll give it a double click, 20 and then if we go beyond 20, let's go to 50. So again, let's close this and see what kind of results we now have. So now when I select this cell, get the drop-down pop-up menu and I can choose from 10, 20 or 50. Now, could I have added other responses to that as well? Of course I could. Do they have to be numbers? No, they do not have to be numbers. I can just type in whatever I want. So if I want to use this a kind of a survey type of a mechanism, I can enter in questions that could be answered and again, because of that automatic formatting, so when we see these things converge a little bit because of the automatic formatting that's applied to text, it slides that information off to the left rather than to the right. Those are your controls. Very handy and very powerful way to work with your tables. And ultimately, serves the goal of building dynamic spreadsheets.
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
