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.
In Numbers '09 you can copy a chart and paste into a Keynote presentation or a Pages document. Let's work with our 3- dimensional pie chart that appears in our Energy Saving Plan spreadsheet. Click once to select it and copy it. Once you have copied the chart, you can move to the Keynote presentation or the Pages document to paste it. Let's switch over to Pages and use the file called EnergyTracker. We will move down to Page 2 and click below the title anywhere. Here is where we want to paste our chart. To do that, we can click the Edit menu or use the keyboard shortcut Command+V, choose Paste and you will notice the chart looks exactly as it did in our Numbers spreadsheet.
This creates a link to the Numbers version, meaning if the Numbers table data depicted in that chart changes, we can refresh it here in Pages. Let's switch over to Numbers and make a change to the table itself. We will click in cell B2, which is under the Gas label next to 2007. Currently the value is 796.75, but we'll change that to 1200. When we press Return, we see the total change in the table and it also changes in our chart. Now before we can update our Pages document, we need to save our spreadsheet.
So let's click File and choose Save to do that. Command+S is the keyboard shortcut and now we'll switch over to our Pages document. Currently, we don't see the change updated in this chart. What we need to do first is click once to select the chart, here you will see the Source, which is our Energy Saving Plan spreadsheet and just left of the name is a Refresh button. Click this button to update the chart where we'll see the new total and the slice of pie is adjusted for us.
Notice also if you no longer wish to link this chart to the Numbers data, you can click Unlink. Let's click the Unlink button, which closes up our Link option and our chart is no longer linked to the Numbers data. So if we updated our table again, we would not be able to update the changes here, in this chart. Click once anywhere on the page outside the chart to deselect it, to see the end result better. So thanks to the ability to link charts, you will never have to duplicate efforts when you want to use a Numbers chart in a Pages document or a Keynote presentation.
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.