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.
Once you have the design of your template finalized in your spreadsheet, it's time to save the spreadsheet as a template. To do that, click File, and choose Save as Template. Now you can specify a different folder or create a new folder to save your template in but accepting the default location, which is My Templates, will mean our new template is going to be visible in the My Templates pane of the Template Chooser. Now we can change the name up top. Let's change it to simply Running Club.
We don't need the word Template at the end. Now when we click the Save button, the spreadsheet is saved as a template in the My Templates folders. Let's try this out. Click File, and choose New from Template Chooser. Notice the new category called My Templates. When we select it we see the Running Club template we just created. With it selected, click Choose to create a brand new spreadsheet based on the template. Notice the name up top is Untitled until we save it.
Now to delete a Custom Template, you will need to navigate to the folder in which you save the template, using Finder. Let's switch over to Finder, you will notice the path, from your own user folder under Library > Application Support > iWork > Numbers > Templates, under My Templates, is where you will find the template you created. You can then select it and drag it to the Trash or right-click and choose Move to Trash from there. So designing a template with preformatted styles, tables, charts and other objects can save users the time and effort that would otherwise be required to create a spreadsheet from scratch.
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.