Core Training for Microsoft Excel 2002

Working with Other Microsoft Office Programs

Including an Office Document in an Excel Worksheet

1 To insert an Office document into an Excel worksheet, click the Insert menu, then click Object.
2 In the Object dialog box, click the Create from File tab.
3 To browse to an object to insert, on the Create from File tab, click Browse.
4 In the Browse dialog box, double-click the Garden Company folder, and then double-click YearEndSummary to select it.
5 To create a link to the external file so that changes in the source file will be reflected in your Excel workbook, in the Object dialog box, click the Link to file check box to select it, then click OK.
6 To open the presentation in a PowerPoint window, click the Edit menu, point to Presentation Object, then click Edit.
7 To modify the text content on this slide, click to the left of the text Year 2002 Summary so that the text box is activated, then type Calendar, and press the SPACEBAR.
8 To save your changes to the PowerPoint presentation, on the Standard toolbar, click the Save button.
9 To view the modified linked file in the Excel worksheet, click the red Close button in the upper-right corner of the PowerPoint window.
10 To view the presentation in Slide Show mode, double-click anywhere inside the embedded slide object on the worksheet.

Storing an Excel Workbook as Part of Another Office Document

1 To embed an Excel worksheet into a PowerPoint presentation, on the Standard toolbar in PowerPoint, click the Open button.
2 In the Open dialog box, double-click the YearEndSummary file to open it in PowerPoint.
3 To select a blank slide in which to embed a worksheet, click on slide 4 in the Slide pane, which is on the left side of the PowerPoint window.
4 To insert the Excel worksheet as an object, click the Insert menu, then click Object.
5 To insert an object from a file, click the Create from file option button to select it, and then click the Browse button that appears.
6 To select the Excel file to embed, in the Browse dialog box, double-click the Garden Company sub-folder, and then double-click ProductSales.
7 To embed the file, click OK.
8 To edit the worksheet from within PowerPoint, click the Edit menu, point to Worksheet Object, and then click Edit.
9 To view cells D15 through H15, first click twice on the Right scroll arrow of the horizontal scroll bar, and then click the Down scroll arrow of the vertical scroll bar (eight times), at the right edge of the PowerPoint window, till the 15th row is clearly visible.
10 To select cells D15 through H15, click cell D15, press and hold down the SHIFT key, click cell H15, and release the SHIFT key.
11 To remove the bold formatting from the selected cells, on the Formatting toolbar, click the Bold button.
12 To deactivate the included workbook and save your changes, click above the image in the presentation.

Create a Hyperlink

1 To create a hyperlink in a worksheet, first click twice on the Down arrow of the vertical scroll bar, and then click cell C17 to select it.
2 To insert a hyperlink in cell C17, click the Insert menu, and click Hyperlink.
3 To create a hyperlink to an existing file, click ProductList, so that ProductList appears in the Text to display and the Address boxes.
4 To change the hyperlink text that displays in the worksheet, position the mouse pointer over the first letter P in the Text to display text box so that the mouse pointer arrow points towards the right, and click to select the text.
5 Type Product List, then click OK.
6 To view the hyperlinked ProductList workbook, click the hyperlink Product List in cell C17.
7 To close ProductList and return to ProductSales, click the Close Window button (with the black X) at the top right corner of the workbook window.
8 To insert another hyperlink in this worksheet, click the Up scroll arrow, click cell I2 to select it, then click the Insert menu, and click Hyperlink.
9 To create a link to another worksheet within the workbook, in the Link to section of the Insert Hyperlink dialog box, click Place in This Document.
10 To link to the January worksheet, in the Or select a place in this document box, click January.
11 To change the hyperlink text that displays in the worksheet, position the mouse pointer over the first letter J in the Text to display text box so that the mouse pointer arrow points towards the right, and click to select the text.
12 Type January details, then click OK.
13 To view the January worksheet, click the hyperlink January details in cell I2.

Pasting a Chart into Another Document

1 To begin pasting a chart into a PowerPoint presentation, click in the blank chart area to the left of the Sales by Category chart title to select the chart, then click the Edit menu, and click Copy.
2 To open the target PowerPoint presentation Year End Summary, click the Start button in the lower-left corner of the Windows taskbar, click My Documents, double-click the Garden Company folder, and then double-click YearEndSummary.
3 To select slide 5 of the PowerPoint presentation, click on slide 5 in the Slide pane on the left side of the PowerPoint window.
4 To paste the Excel chart into slide 5, click the Edit menu, and click Paste.
5 To change the pasted object to a picture of the chart rather than the entire Excel workbook, click the Paste Options button at the lower right corner of the pasted chart.
6 Click Picture of Chart (smaller file size) to select it.