Embed Excel Spreadsheet in PowerPoint 2010

Sometimes we need to add formulas and functions to elaborate the complex logics while giving a presentation. However, you can easily insert table and fill out data but showing rationale through functions and formulas would still be missing. PowerPoint 2010 does luckily provide an option to let user insert and embed Excel spreadsheet directly, thus one does not need to open Excel separately.

Insert Excel Spreadsheet

Navigate to Insert tab and from Table options, click Excel Spreadsheet.

excel spreadsheet

It will show you an Excel spreadsheet in current presentation slide. Now to expand it’s view, click outside of spreadsheet and resize & place it anywhere in presentation slide.

excel datasheet

Double-click inside the spreadsheet to create it with all the features, functionality, tools included in Excel 2010. You will see all Excel window tabs and Quick Access toolbar links.

excel sheet

Start filling out spreadsheet right away. Once done, click outside of it’s window to view a generic table in presentation slide. Now carry on with your presentation.

excel spreadsheet filled

If at any point of time you need to add, modify and formulate the table, just double-click into table to view it as Excel spreadsheet.


again

Embed Excel Spreadsheet

Embedding a pre-made excel spreadsheet has some benefits, such as, ability to link (sync) with the original spreadsheet. For embedding an existing Excel spreadsheet in PowerPoint slide, navigate to Insert tab and click Object.

object

It will bring-up Insert Object dialog, now enable Create from file option and click Browse to select the Excel spreadsheet. Click OK to continue.

insert object dialog

You will see the first worksheet of inserted Excel workbook in presentation slide.

excel sheet

For modifying and showing different worksheet in PowerPoint slide, double-click the inserted worksheet to open Excel workbook. Now navigate through different sheets to view them in PowerPoint presentation slide. On modifying dataset in Excel spreadsheet, changes will be reflected in PowerPoint table as they both are linked (synced) together. Once done, Excel window can be closed.

excel spreadsheet

You can also check out previously reviewed guides on  How to Compress Videos in PowerPoint 2010 & Link PowerPoint with OneNote 2010.

Advertisement