By Ellen Finkelstein
Insert a live spreadsheet into PowerPoint
You can insert a live Excel spreadsheet onto a slide so that you can use Excel while in Slide Show view.
There are other ways to get Excel data onto a slide, so why would you want an active Excel spreadsheet? Let’s say that you’re presenting some results of your financial analysis and your boss asks, “How did you get those results? Show me the spreadsheet.” You could switch to Excel, but it might be more slick to have it available in your PowerPoint presentation.
Slick? What does that mean? It just means that the process is less disruptive and more continuous, so it looks more professional. Try out this unusual technique and see if you like it.
Here are the steps:
1. Choose Insert (tab)> Object> From File. In the Insert Object dialog box, choose the Create from File option.
2. Click Browse, navigate to the Excel file, and double-click it. Click OK. You now see the spreadsheet on your slide. You may see all of it or part of it, but when you show it in Slide Show view, you’ll be able to pan and zoom to display what you want.
This excerpt is shared with permission from ellenfinkelstein.com.