Start learning with our library of video tutorials taught by experts. Get started
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.
Numbers '09 allows you to work with multiple sheets in one file. Sheets are excellent for dividing information into manageable groups. Let's use our Milea Sales Data spreadsheet to explore working with sheets in Numbers '09. The first thing you will notice in the Sheets pane is this file consists of a single sheet called Sales Data. With this sheet selected, we can view the contents here on the Sheet's canvas. As we scroll down, you will notice this sheet contains multiple charts and multiple tables as well.
Another way to display the contents on a sheet is to click the Disclosure triangle. Here you will see a list of all of the tables and charts on the sheet. Perhaps, we should move this table called Current Listings to its own sheet. To select a table, we can click it here in the Sheets pane and see that it's selected in the Sheets canvas. To add additional sheets, we have several options. One option is to click the Sheet button on the Toolbar. This adds a new sheet, automatically numbers it and adds it to the bottom of the list.
Another option is to right-click or Ctrl-click in the Sheets pane and choose New Sheet from the pop-up menu. One other option is to click Insert and choose Sheet from the top of this menu. When you have too many sheets and you want to delete one, right-click or Ctrl-click any of the sheets and select Delete Sheet. You will need to confirm this by clicking the Delete button. Now to rename sheets, we can simply double-click the default name. Let's double-click the new sheet we added with the numbered name already selected, we simply type in our new name.
Let's try Current Listings. When you press Return, the sheet is renamed. Notice that each new sheet has its own default table added automatically. Let's double-click the second new sheet and call it Prospect Mailing List. Now we can move contents from one sheet to another. Let's move our Current Listings table from our Sales Data sheet down to our new Current Listing sheet. To do that, click once to select the table, then click-and-drag it down to the Current Listing sheet.
When the space is provided, release to add it to the new sheet. And now up here, select it in the new sheet's canvas. Sheets can be reordered as well. For example, if the Current Listing sheet should be at the top, we can click-and- drag in the Sheets pane to move it to the top. We can also rearrange the data and elements in the sheet by dragging them as well. For example, if we want all of our tables together, we can click then drag to reorder our tables and our charts. This doesn't change their order on the canvas.
So remember to use Sheets when you need to separate data into manageable groups.
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.