Core Training for Microsoft Office PowerPoint 2003

Working with Tables, Charts, and Diagrams

Inserting and Formatting a Table

1To insert a new slide to contain the table, click below the scroll box on the Slides tab scroll bar, click Slide 8, and then on the Formatting toolbar, click the New Slide button.
2To give the slide a title, click the Click to add title placeholder, and for the purposes of this exercise, press SPACEBAR to have the title typed for you.
3To select the layout, in the Slide Layout task pane, click three times below the scroll box on the scroll bar, and click the indicated Title and Table layout.
4To specify the table's structure, double-click the table placeholder, and in the Insert Table dialog box, click the Number of rows Up arrow until the setting is 4, and then click OK.
5To give yourself more space to work in, close the Slide Layout task pane, and double-click the title bar of the floating Tables and Borders toolbar to dock it at the bottom on the window.
6To type a heading into the table's first cell, press SPACEBAR to have the heading typed for you, and then press TAB to move to the next cell.
7To type another heading, press SPACEBAR and wait while text is typed for you, and then press TAB to move to the first cell of the next row.
8To type entries into the remaining cells, press SPACEBAR to have the text typed for you.
9To select both cells in the first row, drag from left to right through Class and Classroom.
10To make the text in both cells bold, on the Formatting toolbar, click the Bold button.
11To center the text in these cells, on the Formatting toolbar, click the Center button.
12To center the text vertically in these cells, on the Tables and Borders toolbar, click the Center Vertically button, as indicated.
13To color the selected cells, on the Tables and Borders toolbar, click the Fill Color arrow, and click the indicated color box.
14To split a cell horizontally, on the Tables and Borders toolbar, click the Draw Table button, as indicated, and draw a horizontal line from left to right between Trees and Shrubs and Lawn Care.
15To split a cell vertically, draw a vertical line from top to bottom in the middle of the cell that contains the text Room 1.
16To erase the line you just drew and merge the split cells, on the Tables and Borders toolbar, click the Eraser button, as indicated, and then click the vertical line that you just drew.
17To turn off the Eraser tool, on the Tables and Borders toolbar, click the Eraser button again.
18To insert a slide on which to display information from a Microsoft Excel worksheet, on the Slides tab, click Slide 6, and then on the Formatting toolbar, click the New Slide button.
19To give the slide a title, click the Click to add title placeholder, and press SPACEBAR to have the title typed for you.
20To start importing the worksheet, click the Click to add text placeholder, click the Insert menu, click Object, and in the Insert Object dialog box, click the Create from file option.
21To designate the worksheet file, click Browse, and in the Browse dialog box, double-click the Garden Company folder, double-click the Training Classes folder, and then double-click the Budget file.
22To embed the worksheet, in the Insert Object dialog box, click OK.
23To increase the size of the inserted worksheet, drag its upper-left corner handle up and to the left until the left border of the table approaches the left edge of the slide.
24To make a formatting change to the worksheet, double-click the worksheet object, click cell A1 (the upper-left cell), and on the Formatting toolbar, click the Bold button.
25To change a value in one of the cells, click cell B8, press SPACEBAR to have the value "50" typed for you, and then press ENTER to update the calculation in cell B9.
26To deselect the table, click the blank area to the right of the table.

Inserting and Formatting a Chart

1To insert a chart on a slide formatted with a chart placeholder, on the Slides tab, click twice below the scroll box on the scroll bar, click Slide 11, and then in the Slide pane, double-click the chart placeholder.
2To start importing chart data, click the blank datasheet cell above East, and to the left of 1st Qtr, as indicated, and on Graph's Standard toolbar, click the Import File button, as indicated.
3To specify the worksheet to import, double-click the Garden Company folder, double-click the Training Classes folder, and double-click the TGC Sales file.
4To complete the importing procedure, in the Import Data Options dialog box, verify that Sales and Entire sheet and Overwrite existing cells are selected, and then click OK.
5To change data in the datasheet, click the Down scroll arrow in the datasheet, click cell A4, and for the purposes of this exercise, press SPACEBAR to have the data typed for you, and then press TAB.
6Notice that the bar for Fall 2002 in the chart automatically updates with the new data. To change the data in cell B4, which is already selected, press SPACEBAR to have the data typed for you, and then press ENTER.
7To close the datasheet, click the Close button on the datasheet's title bar.
8To plot the data in a different type of chart, on the Standard toolbar, click the Chart Type arrow, as indicated, and then click the indicated Area Chart.
9To select a chart type that is not on the button's palette, click the Chart menu, click Chart Type, and then in the Chart Type dialog box, click the Custom Types tab.
10In the Chart type list, click Columns with Depth, and then click OK.
11To change the font size, on Graph's Formatting toolbar, click the Font Size arrow, and click 18.
12To add gridlines, click the Chart menu, click Chart Options, click the Gridlines tab, and in the Value (Z) axis area, select the Major gridlines check box, and click OK.
13To change the angle of the labels on the horizontal Category Axis, click on the axis to the left of the first bar in the graph (Winter 2002), and on the Formatting toolbar, click the Angle Counterclockwise button, as indicated.
14To select the chart's walls (the areas between the chart's gridlines) so that you can change their color, on Graph's Standard toolbar, click the Chart Objects arrow, as indicated, and then click Walls in the list.
15To change the wall color, click the Fill Color arrow, and click the indicated color in the palette.
16To deselect the chart object and close Graph, click in the blank area to the right of the chart.
17To make the chart smaller so that the text label at the bottom of the slide is visible, drag the lower-right handle up and to the left, and then click again in the blank area to the right of the chart.

Inserting and Formatting an Organization Chart

1To insert an organization chart, click twice below the scroll box on the scroll bar of the Slides tab, click Slide 12, and double-click the diagram placeholder.
2The Organization Chart diagram is already selected in the Diagram Gallery dialog box, so click OK.
3To type a name and title in the top box, click the box, and for the purposes of this exercise, press SPACEBAR to have the text typed for you.
4To type a name and title in the lower-left box, click the box, and press SPACEBAR to have the text typed for you.
5To make an entry in the lower-middle box, click the box, and press SPACEBAR to have the text typed for you.
6To finish typing names and titles, click the lower-right box, and press SPACEBAR to have the text typed for you.
7To deselect the organization chart boxes, click the blank area to the right of the chart box for Karen Berg.
8To add a box to the organization chart, click the Kim Akers box, and on the Organization Chart toolbar, click the Insert Shape arrow, and click Subordinate.
9To type text in the new box, click the subordinate box, and press SPACEBAR to have the text typed for you.
10To add another subordinate box, click the David Ortiz box, and on the Organization Chart toolbar, click the Insert Shape button.
11To type text in the new box, click the subordinate box, and press SPACEBAR to have the text typed for you.
12To add another subordinate box, click the Gardening Teachers box, and on the Organization Chart toolbar, click the Insert Shape button.
13To type text in the new box, click the subordinate box, and press SPACEBAR to have the text typed for you.
14To add an assistant box, click the Karen Berg box, and on the Organization Chart toolbar, click the Insert Shape arrow, and then click Assistant.
15To type text in the new box, click the assistant box, press SPACEBAR, wait until the text is typed for you, and then click the blank area to the left of the assistant box.
16To change the organization chart style, on the Organization Chart toolbar, click the indicated Autoformat button.
17To select a new style, in the Organization Chart Style Gallery dialog box, click Square Shadows, and click OK.
18To select all the boxes at the management level of the chart so you can adjust the formatting, click the Kim Akers box, and on the Organization Chart toolbar, click the Select arrow, and click Level.
19To add the Karen Berg box to the selection, hold down SHIFT, and click the Karen Berg chart box.
20To make the text in these chart boxes bold, on the Formatting toolbar, click the Bold button.
21To make the organization chart smaller so that it does not obscure the slide's logo, drag the lower-right handle up and to the left.
22To see the results of your work, click the blank area to the right of the diagram object.