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.
With Numbers '09, you can publish a spreadsheet to iWork.com and invite people to view, even comment on the spreadsheet. All they need is a Mac or a PC with a modern web browser. Let's publish our Milea Listings and Prospects spreadsheet to iWork.com. To publish anything at all to iWork.com, you have to have an Apple ID and a mail account and of course, you have to be connected to the Internet. We can access iWork.com from the Share menu or directly from the Toolbar, click the iWork.com button. Now to form the pop-up menu, we can start adding information such as the email addresses of those we want to invite to view this document.
Let's add at least one email address. The subjects written for you indicating people would be invited to view your spreadsheet on iWork.com. You can also add some additional text in the Message field. For example, Please add comments. If you do ask people to add their comments, you will want to make sure that the checkbox next to Leave comments is checked off to enable this feature. You may also want to allow people to download copies of the document, in our case, is spreadsheet. If so, they will be able to choose from one or more different formats depending on what you check off in that Download Options section. Notice there are Numbers formats as well as PDF and Excel formats available. If we only want people to download our spreadsheet in a Numbers '09 format, we can deselect the other checkboxes.
By default, the name of this file will be the same as it is now, so you can leave that or change the name if you so wish; when you are ready though, click the Share button to copy it to iWork.com. What it's going to do is generate a copy, create the email that's going to be sent out and send it out to people with a link directly to the actual spreadsheet and it's going to upload the spreadsheet to iWork.com. Then people will be able to have access to it, they may be prompted to log in with their Apple ID and Password and we have enabled comment, so we'll see what that's like momentarily.
When the document is copied to iWork. com, you will see this message. Clicking OK will take you back to Numbers '09 or you can go directly to iWork.com and view that document now by clicking the View Document Now button. Also, in the email message you will see a link taking you directly to the document. Let's click View Document Now to go to iWork.com and view our Milea Listings and Prospects spreadsheet here. Notice the different sheets on the left- hand side in the Navigator. We can walk through the various sheets in our spreadsheet by clicking the appropriate sheet.
On the right-hand side you will also see some important information such as the Document Publisher, you will see the Download button where we can download a copy in the specified format, in this case, Numbers '09. You will also see some other important information down below where you can add notes for example. Here we see the original note, which is Please add your comments. The Comment button appears at the very top. Click the Add Comment button to add a comment. You will see your own name appear and let's add a comment like, Is this the best format for the pie chart? When you click the Post button, the comment is posted. It's now added to the spreadsheet, it can be moved around. A Reply can be made and we can click the Delete button to delete this group of comments at any time.
When you are done with iWork.com, simply close up the window and when you are ready, continue on with the other documents in iWork.com. So with an iWork.com account, sharing your spreadsheets with others just became simpler. You no longer need to have multiple copies sent out via email; simply have everyone access a single copy at iWork.com.
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.