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.
If you have a spreadsheet created using another application such as Microsoft Excel or Apple Works 6 for example, you can open those files directly from within Numbers '09. Let's explore opening other formats by clicking the File menu and then select Open. We will browse to the 02_02 folder of the Exercise Files where we find two different formats; one is an Excel file, the other a text file using Comma Separated Values. That's the CSV extension. We can also bring in tab-delimited files and .OFX files if we need to.
Let's start with our Microsoft Excel file. Click once to select it, then click Open, and the file will be opened in Numbers '09. Conversions do take place and you may see Document Warnings. Here we see one Import Warning, Frozen panes or split windows are not supported, so they were removed once this document was imported into Numbers '09. We can clear those messages before closing the Document Warnings window. Another option is to drag files directly into an existing spreadsheet. First, let's move to the left hand side and click Realtor Comparison. Here we see a blank table. Now we'll access our Exercise Files directly from Finder, and let's drag the CSV file into the sheet.
Now we can drag it directly into the sheet to create a new table or drag it into an existing table. With the top left corner cell selected, let's release to import that data into the existing table. Now we can close the Exercise Files folder to return to our spreadsheet. So importing other formats is very simple here in Numbers '09. If you have existing files in other formats, open them directly in Numbers '09 to work with them here.
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.