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.
After applying a table style to a table, you can change any of the formatting defined by the style. For example, if we wanted to change the header row in our Distance Run table. First, we would select those cells, all of the cells in the top row, and then let's start making some changes to the attributes of these cells. We'll start with the Fill. Click the Fill button on the Format Bar and let's choose Black. Next we'll make some changes to the border around the outside of the cells that are selected. First we'll go to the Format Bar and click the Borders button and choose Outside Edges. Now we can make changes such as the type of line, we'll choose Solid. We'll change it to a little bit thicker, try 3 points and we can change the color of our border as well, click the Color button and let's choose a nice light green.
To really see this changes, let's deselect our table by clicking the canvas anywhere. So the changes we just made are called Overrides. If we later assign a different style to this table, we can choose to keep or remove any of the overrides we created. For example, we'll select the table from the Sheets pane, Distance Run and apply the Beige style. When we click Beige in the Styles pane, look what happens. It's applied to all of the table except for the attributes we changed in this header row. This doesn't look very good. We might want to apply the style and clear any of the overrides simultaneously. In this case, we click the arrow to the right of the Beige style and choose Clear and Apply Style.
This applies the Beige style and clears any overrides we created earlier. So, although we can quickly change the appearance of table using styles, it's important to know we can also override the styles formatting and then choose to keep or clear those overrides when applying new styles.
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.