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 have access to a variety of predrawn shapes that can be added to your spreadsheets. You can insert circles, rectangles, stars, speech bubbles, arrows and more. So let's add a shape to our Running Club Data spreadsheet here. Perhaps an arrow pointing upward, under our Monthly Goal table would look nice. First we'll go to the Shapes button, click once to view a number of different predrawn shapes to choose from including lines, even lines with arrowheads. Then we get into some filled shapes like rectangles with square corners or rounded corners, we have got the ellipse for creating circles, we have got triangles, we have got thick arrows. There is also speech bubbles down below.
Let's choose a nice thick arrow. A default arrow is placed on our spreadsheet. We can move that around by clicking-and- dragging from the center, we'll move it down to the bottom right corner of our sheet and now we can make a number of adjustments to make this shape standout. Let's start by changing the Fill and Line attributes. This can be done directly from the Format bar. First of all, you will see the Stroke is selected as a thin line, it's 1 point and the color is black. Well, let's turn the Stroke right off. We'll click the Stroke button and choose None. But we'll change the Fill by clicking the Fill button and let's choose a nice dark green. This will kind of match our spreadsheet.
We can adjust the Opacity of this as well to make it somewhat see-through. Let's choose 80%. If we wanted to, we could add a shadow at this point. Now we can also access a number of options from various Inspectors that are available to us through the Inspector button, we'll click that first and choose the Graphic Inspector. Here you can see the Color Fill that we've selected and the Color, no Stroke and the Shadow has been turned on. If we wanted to adjust the Angle, we could do that by using the rotation handle or type in an exact number of degrees to rotate. We can also adjust the Offset to bring it further off the page or closer to the page, let's bump it down to 10 points. We'll leave the Blur and Opacity as it is. We can also add a Reflection from here but let's just keep the shadow for now.
If we want to rotate this, so it's pointing up towards our table, we'll then use the Metric Inspector. With the Metrics Inspector selected, you will notice down below we have a rotate handle here as well and the current Angle is set to zero. Now we could try to rotate to exactly 90 degrees or if you prefer, go inside the field, click-and-drag whatever is there and type 90. When you press Return, it will be a perfect 90-degree angle. Let's close our Metrics Inspector now. And with our shape selected, we see a number of handles around the outside, a little blue handle on the inside for us to adjust the width and height of the actual stem of the arrow. So let's move there when we see the four-sided arrow, just make it little bit thicker and we'll increase the size or height of our arrow by dragging the handle at the bottom or the top.
We will move it into position, get it lined up nicely with our Monthly Goal table and the other neat thing is we can totally change the shape by making this shape editable. We can do that from the Format menu. Click Format, move down to Shape and choose Make Editable. Now you will see red handles around the outside that will allow us to totally change the shape of our arrow. Let's start at the bottom right corner. The bottom right corner has a red handle that we can drag out. Let's line it up almost with the handle that appears on the point of our arrow. We'll do the same on the left side to make it symmetrical and we'll deselect now by clicking the canvas to see the end result; that's kind of cool.
The other thing you can do with Shapes is add text to them. Just double-click a shape. It may turn on its side for you to type in your text. Let's type in, the word REACH! You will see the default font and font attributes but we can click-and-drag over that text and make some changes here as well. Let's change it to 24 points, let's change it to white as well. And now watch what happens when we click the canvas to deselect our arrow, it flips it back to the degrees of rotation we selected a moment ago and we have got our text inside.
So shapes can add visual interest to a spreadsheet and with Numbers '09, the shapes you can add or create are limitless.
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.