Oak Products Project - Page 2   

  Forward  Back (Intro)   Excel Review Home

 

Step I: Obtain the Raw Data

The Word97 file named Oak Products Data.doc holds:

    1. Resource requirements for each chair type (for each chair, a column shows how many dowels, rungs, rails, etc. are required).
    2. Current chair profit levels (in a row with the label "Unit Profit").
    3. The parts inventory expected to be on hand for August (in a column with the label "On Hand").

The contents of the Word file appears below. Notice that in Word this data is arranged in tabular format.

Return to Top

Step II: Analyze the Data

You build a spreadsheet model in Excel to help you determine August's most profitable product mix. Although you could start your worksheet from scratch, you can save data entry time by importing into Excel some of the data from the Word document.

A. Import Word Data Into Excel

Setup

Open both Excel and Word as full-screen sessions. (You can shift between them by holding down the ALT key and pressing the Tab key.)

Select the Data to Copy

  • In Word, open the document that holds the tabular data.
  • Position the insertion point in the table of data.
  • Click the Table command in Word's menu.
  • Choose Select Table. Word highlights the entire table (but not the separate document header).

Copy the Data to the Windows Clipboard

From the menus choose Edit and then Copy. (Alternatively, click the Copy button on Word's Standard Toolbar or hit CTRL+C.)

Copy the Data to Excel

  • Switch to Excel by hitting CTRL+TAB until your Excel session is active.
  • Click cell A3 to make it the current cell.
  • Select Edit, Paste Special from the menus.
  • In the Paste Special dialog box, select Paste and As Text and click OK.

   

Each cell in the Word table becomes a cell in the Excel worksheet. Now you're ready to build the model around this core set of data.

 

Return to Top   Next Page