Apple iWork 08 Tutorials
Create Dynamic Spreadsheets / Add a new Table
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 new Table)
And welcome to chapter six in our look at iWork 2008. This chapter goes back once again to Numbers and continues our discussion from the introductory chapter, which was chapter three. So like the other ones in Pages and Keynote, this chapter is all about creating dynamic spreadsheets and we will start with a look at just adding simply a sheet. We've taken one of the templates that is available from the template chooser and we will add a sheet and then to that sheet we will start to deal with really the core element of a spreadsheet, which is a table. The table is where you will add data and then you will crunch the numbers and that's again particularly what we use spreadsheets for. So in this example here, I've added a couple of sheets previously and deleted them and now I've got a sheet five here. If I give it a double click, I can start to rename that sheet, so I'll call this VTC 1 as the sheet and its got one table that is a component of that sheet. Now, I can start from scratch. Of course, I don't have to here, but I can add a table if I want to by clicking on this tables button and adding a basic or a table with headers or a table that already starts to try to arrive at sums, sums checklist and so on. So you have some kind of template tables that you can already deal with and of course, with a table selected, if I don't like it I can always just click and select it and hit the delete button on the keyboard and now I've got just a plain sheet without anything in it. So again, tables, basic and now I've got a basic table that looks like that. And really the difference is that I have column headers and in a headers table I have column and row headers as well. Now, with each of these tables, again, I can give it a selection by clicking on the upper left-hand corner. With the cell active, I see the coordinates, I see the columns and the rows and I can make the selection of the entire table by clicking on this upper left-hand corner. So there and delete and we just deal with one table at a time to make a cell active. I can also add rows and columns if I want to by moving my mouse pointer over to the first section of the placeholder or the coordinate for that row. So this is row four and I get this little drop-down menu. So I can add a row below, above or delete the row. So let me add a row below and now I've got another row added to my spreadsheet. Same thing with the columns here. If I hover my mouse up to the first part of the column heading or the column coordinate and get a little drop-down menu and I can add a column before or a column after and start to expand the table. Now, that's different of course then resizing the table which, again, involves a selection of the table and then clicking and dragging on the table handles. So that's a way to get started and this has the ledger style. If I want to make it a gray fill or a gray with gray headers, of course I have those styles that are available to me right way, but of course, later on in this tutorial we'll deal with how to define styles of your own.
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
