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.
The easiest way to change the appearance of a table is to apply a table style to it. Numbers provides a number of built-in table styles to help you ensure that tables are consistently formatted. We'll begin by examining the table styles used in the two tables here in our Running Club Data spreadsheet. The easiest way to do that is to select the table first. Let's click Distance Run in the Sheets pane. Notice down below in the Styles pane, Ledger is highlighted. This is the table style already applied to this table.
When we select the other table, Table 2, we notice the basic style has been applied to this table. Now to apply a different style, we simply click the Style in the Styles pane. You may want to adjust this pane to view all of the styles available. Let's select the same style used in our Distance Run table. That one is called Ledger. Click Ledger and that style is applied to Table 2. Deselect the table by clicking on the canvas to see the end result better.
Now a table style predefines the following attributes: the table background and its opacity, which we can see in some of the cells here in the table. Also the stroke, color and opacity of the outside border of body cells and the outside borders of the header row, header column, and footer rows, if your table has them. And the background and the text attributes of table cells are also adjusted including header and footer cells. Now let's say we want to apply a different style altogether to both of these tables at the same time. The easiest way to do this is to drag the desired style to the sheets name in the Sheets pane.
So, for example, if we wanted to try the one called Teams, we simply click-and-drag it to the name of the sheet Running Club Record and release. Notice the style is applied to both of these tables. So thanks to the predefined table styles in Numbers, you can quickly enhance the appearance of tables with a click of the mouse button.
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.