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.
In Numbers '09, you can use the Mac OS X Characters window to insert special characters that don't typically appear on your keyboard such as mathematical symbols, letters with accent marks and arrows and more. Let's use our Milea Listing and Prospect spreadsheet to add a symbol after the word Milea in the title over our mailing list. First, we'll click once to select the text box. Then click again inside the text box after the A in Milea. Here's where we need to add a symbol. So to access the Special Characters window, we can do that from the Edit menu, and choose Special Characters. You can also access it from the International Flag that may appear at the very top on the menu bar. But once we've got the Characters window open, we now have a number of categories to sift through where we can find our special symbols.
Here, under Symbols for example if we scroll down and select Letter Like Symbols or find the one we're looking for which is the Registered Symbol. Once selected, you can see character information down below, and even font variations. So if you want to choose a specific font that matches your font that's in the title in this case, you can scroll through the different fonts, and select one that looks good. Let's choose Bookman Old Style. Now with it selected, we see a preview. All we have to do is click the Insert with Font button to insert it into our text. Now of course this doesn't look good the way it is. We'll probably want to select it and make it superscript.
So drag over the symbol itself and next, we'll go up to Format, down to Font, and over and down to baseline. Here, we can choose Superscript, which will change its size and move it up a little bit higher where it belongs, and we're done with the Characters window. Let me click the Close button. Now we can also use the Keyboard Viewer to add accent marks to characters. But first it needs to be enabled from our System Preferences. So let's click the Canvas to deselect anything. We'll click the Apple symbol, move down to System Preferences and click to open up our System Preferences window.
Next, we'll select International. Then the Input Menu button to make sure our Keyboard Viewer is enabled. If it's not checked off, go ahead and click the check box to enable it. Now we can close our System Preferences window. As we look through the table here, we see a name where we could use some special accents. The last name Cote here is spelled without those accents. So let's click between the O and the T, and we'll take out the O with our Backspace key and now we'll access our Keyboard Viewer. Let's access it from the International Flag. We'll click Show Keyboard Viewer, which opens it up.
We can move this around. Watch what happens when you hold down the Option key on your keyboard. The actual accents appear in orange. So for example if we want to select the accent that belongs over the O, we can click it right in the Keyboard Viewer and inside our cell now, you can see the symbol and it's shaded in yellow waiting for us to type in a character. We want the letter O. So we type the O and it appears with the accent over it. Let's repeat that for the E. We'll take it out, hold down our Option key, and you'll notice the accent we're looking for appears in the top-left corner.
When you release the Option key, you'll notice that it's the Tilde on your keyboard. So you don't have to use the Keyboard Viewer, hold down Option, press the Tilde key on your keyboard to get the accent, and now we can type in the E to finish it off. When you're done with the Keyboard Viewer, click the Close button in the top-left corner. So thanks to the Character Palette and the Keyboard Viewer, we can insert a wide range of special characters and accents, not typically available from the keyboard.
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.