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.
Saving your work is important and Numbers '09 provides several different methods for doing so. Let's explore some of the Save options here in Numbers '09, using our Running Club Data spreadsheet. We will begin by discussing how to update changes you make to the content. Let's move down into the table anywhere, click to select one of the numbers and type in a different number. When we press Return, the change is accepted into the spreadsheet. Now to update our work, we can click File and choose Save, or from the keyboard if you prefer, use Command+S. This will update the changes we have made keeping the same name, the same format, and location for this spreadsheet. But if you need to change the name, perhaps the location, or even the format to share with others who don't use Numbers, you will want to use to Save As.
In this case, click File and choose Save As. This displays the Save As window. From here, we can change the name, we can change the location, and down below, we can even change the format. For example, if we want to save a copy as an Excel document, click the checkbox next to Save Copy As and from the button, ensure Excel Document is selected. Now when we click Save, we'll be saving to the same location but using a different format.
When exporting to other formats such as Microsoft Excel, you may see Document Warnings. In this case, our Numbers spreadsheet does have header and footer cells that were exported as body cells that looked the same in Microsoft Excel, but this warning just informs us of the change. When you are done reading any warnings, you can click the Clear All button and close the Document Warnings window. You still have a copy of your original spreadsheet in the Numbers format but you just saved a copy of it to Microsoft Excel. This is just one way to export to other formats. Another option is to click File and choose Export. From here, you will see two other options: PDF, Portable Document Format, and CSV, which stands for Comma Separated Values.
In this case, you make your selection, choose some of the options such as Image Quality and Layout for PDF. Click the Next button. We'll get to choose a name and location. If the default name and location are fine, click the Export button to complete the process. So, it's good to know you have several options when saving your work in Numbers '09.
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.