From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)

Create charts and tables in PowerPoint

From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)

Start my 1-month free trial

Create charts and tables in PowerPoint

“

- [Instructor] There is one more way to get Excel content into a PowerPoint presentation. We can create it here directly. I'm going to add a new slide. And if I wish to insert a table, if I click the table icon in this slide, then it simply asks me how I want to insert a table. But if I choose Insert and click the Table drop down, one of my choices is to insert an Excel spreadsheet. And I get the same type of Excel object as I do when I embed. And I get all of the toolbars that are available with Microsoft Excel. So for all intents and purposes, I'm in Excel. If I want to add information, I can. Let me show you another way that I can do this. Going to undo, and I'm going to choose to insert a chart. And when I do, I will actually get an Excel object. Here's my chart, here's my data. And I can modify this data in any way I wish. If I decided I didn't need Series 3, I can delete it. I can rename any of these items. Once again, I'm creating Excel content directly in Microsoft PowerPoint. This Excel chart doesn't live anywhere else. It only lives in this presentation. The table, if I had finished creating it, would live only in this presentation. And when I'm all done creating the table or creating the chart, I simply click Back in my background and I can close in the case of a chart, the Excel worksheet. If I need to add a chart to a presentation and it doesn't already exist, if I need to add a table to a presentation and it doesn't already exist, this is a really great way to do it because I don't have to worry about managing linked workbooks. I don't have to worry about embedding more than I had hoped to embed. Whatever I create here begins here and will live here in my PowerPoint presentation. We now have a number of techniques that we can use to take information from Excel into PowerPoint, or to create Excel in PowerPoint. Now we're going to focus on Excel. The quality of our data in Excel is going to directly affect the quality of what we can display in a presentation. If our data needs to be cleaned up, if our data needs to be made easier to understand, illustrated, turned into charts, summarized, all of those types of data transformation need to happen in Excel, not in PowerPoint. So that is where we go next, creating great data in Microsoft Excel.

Contents