If you’re like most businesspeople, you probably use Excel to crunch numbers and organize data. But did you know that you can embed an Excel worksheet into PowerPoint or Word 2007? This is a great way to share your data with colleagues or clients, and it’s also a great way to teach them how to use Excel. To embed an Excel worksheet into PowerPoint or Word 2007, follow these steps:

  1. Open the document that you want to embed the Excel worksheet in.
  2. Click the Insert tab on the Ribbon and then click the Worksheet button.
  3. In the resulting dialog box, select the workbook that contains your Excel spreadsheet and then click OK.
  4. In PowerPoint or Word 2007, open the presentation that you want to include the embedded spreadsheet in.
  5. Click in a location inside of your presentation where you want to place the embedded spreadsheet (you can also drag and drop it there). ..

First let’s take a look at easily embedding a new blank Excel document.  Open up the PowerPoint presentation (or Word document) to add the Excel worksheet, then Insert Object.

In the Insert Object dialog box select Microsoft Office Excel Worksheet and click on OK.

Now you can start entering data into the new Excel worksheet.  You will notice that all of the Excel controls will now be shown in the Ribbon.  This can come in very handy when you need to create a new worksheet within presentation quickly.

The other option we can use is to embed an existing worksheet.  For this we just need to go to Insert Object again and this time click Create from file and then browse to the worksheet to include.

After embedding the file you can work to adjust the slide for the presentation and also continue to work on the Excel sheet.

You can use the same controls on the Ribbon to embed a worksheet in Word as well, here is an example.