Embedding Data from an Excel Spreadsheet in a Power Point Presentation

Embedding data from an Excel spreadsheet into a Power Point presentation is especially useful if the basic presentation is used repeatedly and frequently. When data is embedded in a presentation or document it allows the data in the presentation to be updated automatically when the data is updated in the source spreadsheet.

Presuming both the source spreadsheet and the destination presentation already exist and are open in separate windows, follow these steps to embed the data:

  1. Select the range of cells you want to copy in the Excel spreadsheet.
  2. Click Copy on the toolbar or from the drop down Edit menu.
  3. Click on the Power Point presentation window to make it active and select the slide or notes page where you want to insert the cells from the spreadsheet.
  4. Select Paste Special from the drop down Edit menu.
  5. The Paste Special window displays. Select the Paste Special option. Highlight Microsoft Office Excel Worksheet Object. Click OK.
  6. The Power Point presentation slide will display with the selected data in the selected location.

These instructions apply to Microsoft Office 2003, specifically Excel 2003 and Power Point 2003.

This process can be extremely convenient. It is not, however, without risk. One of the most common risks is forgetting where the data is coming from. To help prevent this, insert a comment, containing the name of the presentation and possibly the path to it, in the cell(s) used as the source of the data. The location and path to the source location should also be recorded in the notes section of the presentation.

Another common problem is that the data used is based on one or more calculations. The use of calculations in spreadsheets presents many opportunities for error and these errors can carry over to the presentation without careful monitoring. One method for combating this problem is to record both the formula utilized by the spreadsheet and a more general formula that doesn’t rely on cell locations or similar data, in the notes section of the presentation. This has the added advantage of putting the formula at the speakers fingertips should it be needed to answer questions. Further, if the data used to calculate the value of the formula is available elsewhere in the presentation, it can serve as a valuable test to help ensure accuracy.

You may like these other stories...

You probably don't want to think about how many times you access the File menu in Excel 2010 or 2013. Personally I think Excel 2010 has the best possible File menu arrangement, other than having Print Preview grafted...
Following other recent high-profile hacking events, investigators discovered yesterday that hackers broke into the draft work paper files of several famous CPA firms. Revealing images of the scantily clad documents have been...
For bitcoin users, the taxman cometh. And you best know how to calculate taxes owed on what the IRS calls convertible virtual currency.In March 2014, the IRS issued Notice 2014-21, which declares virtual currency will be...

Already a member? log in here.

Upcoming CPE Webinars

Sep 24
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Sep 30
This webcast will include discussions of important issues in SSARS No. 19 and the current status of proposed changes by the Accounting and Review Services Committee in these statements.
Oct 21
Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience's communication style.
Oct 23
Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.