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...

We're all about QuickBooks this morning. First, read this late-breaking news from John Stokdyk, editor of AccountingWEB (U.K.), who is attending the QuickBooks Connect conference in San Jose, California. Then, for more...
Technology—specifically internet technology—has a record of disrupting tried-and-true methods of operation in ways that we often don't foresee. Look no further than the recent HBO announcement that they *gasp...
If you're thinking that bitcoin and digital currency generally are merely some one-off flash in the pan, the new Digital Currency Council would argue otherwise. The council launched in September and already had 400...

Already a member? log in here.

Upcoming CPE Webinars

Oct 23Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.
Oct 30Many Excel users have a love-hate relationship with workbook links.
Nov 5Join CPA thought leader and peer reviewer Rob Cameron and learn ways to improve the outcome of your peer reviews while maximizing the value of your engagement workflow.
Nov 12This webcast presents basic principles of revenue recognition, including new ASU 2014-09 for the contract method. Also, CPAs in industries who want a refresher on revenue accounting standards will benefit.