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.
You can create your own table styles by reformatting a table and saving the formatting as a table style. Let's use our Savings Calculator spreadsheet. On the second sheet titled Potential Savers, we have the table called Savers and when we click that table to select it, you'll notice it's using the Earthtone table style. Let's move to the first sheet in our spreadsheet called Total Savings Goal. Here we find another table, it's named Savings Calculator and when we select it, you'll notice it's based on the Blue Fill table style. But many modifications have already been made to the style of this table. Many overrides already exist. Let's add one more, let's click the cell containing our total and center it from the Format Bar, click the Center Alignment button. Now when we deselect the table by clicking the canvas, we can see the end result of our changes.
Now to create our own style from those changes, first we select the table. You can do that from the Sheets pane and with our table selected, click the arrow next to the table style name, Blue Fill and choose Create New Style. Now it's time to give our new style a name, let's called it Blues because it's made up of many different shades of blue, and click OK. Our new style now appears at the bottom of our Styles pane. We can also change the height of our Styles pane by clicking and dragging the separator.
Now we have the brand new style available to apply to existing tables or new tables that we create in our spreadsheet. Let's go back to that other sheet called Potential Savers. Click the Savers table and now we'll go down to the very bottom where we see Blues, click the arrow so we can clear any overrides, and apply the new style, click Clear and Apply Style. Notice the new style is apply to our table, and we are ready to continue filling it up with content. Let's deselect this table by clicking the canvas anywhere.
Now if you don't like the name you have chosen for a style, you can easily rename it. Maybe Blues isn't the best name for our brand new styles, since we already have one called, Blue, Blue Headers and so on. This might be one that we use for calculating figure. So let's move down to the very last style, the brand new one called Blues. We'll click the arrow and choose Rename Style. From here you'll notice Blues is selected. You can also double-click the name to select it. You are ready to type over. Let's type Calculator. When you press Return, you've renamed your new table style.
Now if you decide you don't need a table style, you can also delete it from the Styles pane, just keep in mind that any tables currently using that style will have to be replaced with another table style. So let's go back to our new style now called Calculator, click the arrow and choose Delete Style. Notice at the top we do have tables using this particular style. So we need to choose a replacement style. We'll click the button to see the existing styles to choose from. Let's choose Blue Fill.
Now we can click Replace, which does two things. It removes our new style and replaces the table style that was being used in those tables with the selected Blue Fill table style. When we move back to our first sheet, you'll notice that the Blue Fill style has also been applied to our Savings Calculator table. So even though Numbers provides you with a number of built-in table styles to choose from, you can also create your own to suit your needs.
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.