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.
An image can add visual interest to a spreadsheet and help tell a story. With Numbers '09, you can insert all kinds of images including TIFFs, GIFs, and JPEGs. You can add PDF images, PSD files, EPS and PICT files. So let's insert an image of the house at 1871 Meadow View Drive. There are a number of different ways to retrieve an image. If the photo has been uploaded to iPhoto, you can access it through the Media Browser by going to your photos. But if you haven't done that, you can also retrieve it by dragging it from a Finder window or click the Insert menu and select Choose. This will allow you to navigate to the folder where your image resides.
In our case, in our Exercise Files folder. The file that we are going to bring in is a JPEG file called 1871 Meadow. So I'll select that and click Insert to insert it into your spreadsheet. Now of course, there is a number of things we can do with this image, such as resize it and move it into position. Notice the handles around the outside. Let's start by resizing from the top right corner. When you see that double arrow, you can click-and-drag to change both the height and the width of this image.
Now to move it into position, we click- and-drag from the center of the photo anywhere. We'll try to line it up best we can with the others. You may need to adjust the size a little bit further. Now once we have got it into position, there is more we can do. A really nice feature of the iWork '09 application including Numbers '09 is that we can adjust the quality of an image without leaving Numbers to use a photo editing application. With our image still selected, click View and choose Show Adjust Image.
This opens up the Adjust Image window where we can adjust things like Brightness and Contrast. If you find the image is a little bit dark, you might want to adjust the Brightness slider to the right, for example, to lighten it up. You can also increase or decrease the Contrast. Saturation, Temperature and Tint allow us to work with the color in our photo. We can adjust the Sharpness as well, the Exposure. If it seems to be little bit over- exposed, we can drag the slider to the left, for example, to bring that down a little bit. We have even got the Levels at our disposal. And if you simply want to enhance the image without worrying about all those sliders, click the Enhance button and it will automatically be enhanced and you will see the Levels adjust automatically. You can reset back to the original image at any time but when you are done, click the Close button.
Now we'll deselect the image by clicking the canvas anywhere. And as you can see, adding and enhancing images in Numbers '09 can really add interest and information to your spreadsheets.
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.