Viewers: in countries Watching now:
Numbers offers intuitive organization features, allowing users to focus more on analysis and presentation. In Numbers '09 Essential Training, David Rivers explores the important features of this spreadsheet application and introduces the new tools for formula development and charting. He walks through the new functionality of charts, tables, and templates, and shows how to make spreadsheets effective and eye-catching. Exercise files accompany the course.
With Numbers '09, you can add your own tables to the menu of predefined tables that appear when you click the Tables button on the Toolbar or click Table and choose Insert from the menu bar. You can select the table style and structure of your choice. It can even contain content such as header text, formulas and so on. So let's create a reusable table from the somewhat blank table appearing here in our Milea Sales Data spreadsheet. The first step is to make sure it's structured the way we want and you see we have already got the right number of rows and columns.
We have named this table Realtor Comparison. We have got header rows and columns, even footer rows across the bottom. Let's add any additional content we might want appearing in this table every time we use it. For example, we'll click in the very top row and add a title; let's type in Local Realtors. Any other data we want appearing in this table every time we use it so we don't have to type it in, it can be added. Let's go over to cell A3 and here is where the types of properties are going to appear, so let's add them now. So we don't have to later.
Type in Single Family for the first type. Click in the next cell, here is where we are going to add Condos. Two more, we'll type in Lots and Commercial for the last type. Now, you will also notice across the bottom here we have formulas in column B, but we don't have them showing up in the rest of the column, so we'll click in Cell B7, move down to the fill handle when we see the black plus sign. Click, then drag across to copy the formula or all the way across to column E.
We will do the same for the average. Right now, we see a warning symbol because averages can't be calculated using zeros. That's okay. Once we get real numbers in here, these formulas will work. So I'll click in cell B8, move down to the fill handle and copy this formula across as well. Let's deselect the table by clicking in the canvas to see the end result. Now this is the table that we want to be able to insert into multiple spreadsheets as opposed to recreating at each time. So all we need to do now is add it to our Tables menu.
To do that, we first need to select the table, you can click anywhere in the table or click the name of the table here in the Sheets pane and with the table selected, we'll go to the menu bar, click Format, move down to Advanced and capture this table and when you click Capture Table, a dialog appears; you will see the name of the table appearing here at the top. Now this might be too specific. If we just want to use this table for comparisons, we can change the name. You can type a new name or in this case, click just before the C in Comparison and take out the word the Realtor.
The next choice is do we always want this table to look the way it is right now or do we want it to change and use the default style from the spreadsheet that we are working in. Let's have it always Use the default style, so it looks like the other tables in the sheet. Click OK and you have now added it to your menu. Let's test this out. We'll click the Comparisons sheet, which does use a different style and now we'll click the Tables button on the Toolbar and you will notice a new one at the bottom called Comparison.
When we click Comparison, the table gets added and notice the formatting and style has changed to the default for this particular sheet. Now it's just a matter of adding in the numbers. When you are done, deselect by clicking the canvas. That's beautiful. So thanks to the ability to create a reusable table, we'll never have to create this type of table from scratch again.
There are currently no FAQs about Numbers '09 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.