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.
Another type of content that can be added to a template is a placeholder. We're still working with our Running Club Template file, and you'll notice here in our in our Member List sheet, we have a table called Members which has a Photo column. Now each of the cells in this table is a placeholder. So we might want to adjust the table size to accommodate photos in this last column. We'll select the table, with the handles appearing now, let's go to the bottom right hand corner handle. We'll drag it across and down to increase row height to allow us to insert a good size photo.
Now I can deselect the table. But what if we wanted people to be able to add their own photo to the first sheet. Let's switch over to the Running Club Record sheet, and let's say we want people to be able to add an image from their own Running Club up here in the top right corner of the sheet. Well we can add a placeholder here. To do that we insert a photo and turn it into a placeholder. So let's click Insert, select Choose, where we have one called Runner it's a JPEG in the Exercise Files. Now when we click Insert it gets added to the center of our sheet.
But we can resize this. Let's size it down a little bit. Let's drag it up to the top right corner, not overlapping our graph too much. We don't want to hide any of the data. Now let's format this a little bit as well. We use the Format bar to add a nice picture frame. The first button currently displaying None allows us to choose a nice border around the outside. Let's choose that second picture frame and let's rotate this a bit. We'll need our Metrics Inspector for that. Click the Inspector button and sure our Metrics selected. And we'll use our Rotate handle down below to rotate this about 6 point, let's go to about 6.8 degrees. And we'll close up the Metrics Inspector and there is our image.
Now we want people to be able to add their own images here. So let's turn it into a placeholder, with it still selected, click Format and move down to Advanced and Define as Media Placeholder. When we select this, it now becomes a Media Placeholder, let's deselect by clicking the canvas and just hover over the image with your mouse. You will see a message appear. 'This image is a placeholder drag a new media file here to replace it.' Perfect. All we need to do now is save our changes. Command+S on the keyboard will update our spreadsheet.
Now anyone using this template is going to be able to drag their own photo to this spot on our first sheet, and it will be formatted just as we specified.
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.