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.
Tables are made up of rows and columns. As you continue to work with your tables the need to adjust those rows and columns may arise. Let's use our Energy Saving Plan spreadsheet here to explore adding and removing rows and columns, resizing them, even rearranging them. We will begin by adding a new row to the bottom of our table named Utility Costs by Type. To make it look more like the table above, we need an additional row to display our % Increase. There are a number of different ways to insert rows and columns. Let's click anywhere in the bottom row. We already know we can use handles that appear in the bottom left-hand corner or bottom right-hand corner, to increase or decrease the size of our table by adding and removing columns and rows.
Let's go to the bottom right corner. As we drag out and down we see additional rows and columns. Let's just move down enough to add a new row for a total of four rows and five columns. Notice that the formula from cell E3 is copied down to the new cell E4. We'll leave that there for now. Now let's add some data. We'll move to cell A4 click there and type in % Increase. Now we need our formula in cell B4. Formulas start with an equal sign.
We'll type the equal sign and now we want to take the values of (B3-B2)/B2. We can type all of that in, or we can select the cells. Let's start with an opening round bracket and click B3. It's inserted for us. Now the minus sign on the keyboard and click B2. Now we can close that up with the closing bracket and the division symbol is the slash on the keyboard, and now we can just simply type in B2 as opposed to selecting it. Press Return or click the Check mark to lock that in. Notice the formatting is the same as the other data in this table, a Currency Format.
It really should appear as a percent. So we'll go to the percent button on the Format bar, and click to change the format. Now it's a simple matter of copying this formula across to the other cells, we'll move to the bottom right corner of the cell containing our formula. When the plus sign appears, drag across all the way to column E and release. Our table is starting to look more like the table above. It looks like this table up here also uses a blank row and a blank column as a spacer. Let's explore another way to add a row. We'll click anywhere in the new bottom row, and now this time we'll use the Table menu. Click Table and you will notice at the very top we can add a row either Above or Below our selected cell.
In this case, we want it Above. So click Add Row Above and a new row appears. We also want a new column to the left of column because. So we'll click anywhere in column B, click Table and choose Add Column Before. Again, a formula is copied automatically with Numbers '09, and a warning sign appears because there are no values to be calculated. So we'll click in that cell anywhere around the warning symbol and press Delete on the keyboard because we really don't want the formula there at all.
Now we need to resize our columns, and there is a number of different ways to do that. Let's start with going between the B and the C header that appears at the top of the columns, when you see the double arrow, click-and-drag to the left as far as you can go. We can do the same with the row headers on the left. We'll go in between 4 and 5, when the double arrow appears, drag upwards to create that spacer. That looks much better. We can also create automatic widths and heights for our rows and columns.
For example, if we move between columns E and F, and double-click, automatically column E is readjusted to the widest value in this particular column. But it really doesn't look good. So let's click Edit and choose Undo Resize Columns to Fit. Another thing you can do with your rows and columns is rearrange them. For example, if we want Water to appear between Gas and Electric, we can click the header at the top, click E to select the entire column, and now click again and drag to the left. When the blue bar appears between C and D release, and you've reordered your columns.
The same can be done with rows. Let's change row 3, click the 3 and drag it upwards. When the bar appears between 1 and 2, we release and we've reordered our rows. This doesn't affect the formulas being used, and the end-result. To see the end-result let's click anywhere outside our table on the canvas to deselect it. So remember when creating and working with table set, if your columns and rows and not exactly right from the beginning, Numbers '09 lets you adjust them in many ways after the fact.
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.