If you are working on any supporting data for a presentation built in Excel, there's a quick way to insert a table from Excel and have the option to automatically update the table when you make any changes to the spreadsheet in Excel.

To achieve this, follow these steps. 1) in Excel, open the saved workbook with the data you want to insert and link too. 2) Drag over the area of data you want to link to in PowerPoint and press control + C. 3) in PowerPoint, Click the slide where you want to paste the copied worksheet data 4) on the home tab.

Click the arrow below, paste and select Paste special in the paste special box, click paste link, and then under as select Microsoft Excel worksheet object. 5) If you make any changes to the Excel table, simply right click on the table and select update link and the values in your table in PowerPoint will update.

We're quickly going to cover how to insert table from Excel using Pay Special.

So first what we want to do is open up the exercise file: working with table.

So make sure you've downloaded that in case you'd like to follow along.

So let's open up that Excel file.

And what we're going to do first is copy this table.

So just drag over this section and then click control C.

There we go. Let's go back into PowerPoint, minimize this.

And then what we're going to do now is use the pay special function.

So we could go to home and click on this dropdown here.

Instead we're gonna push control Alt and V and that opens up the Pace special function.

Now what we're going to do is we're going to go Paste link.

We want to use Paste link instead of the general paste is because what Paste link does is it will allow you to create any updates in the Excel table and then carry them over into the PowerPoint version.

And then we're going to select Microsoft Excel worksheets.

So then click okay, and there you go.

Got our little table here.

That obviously has been carried over from Excel.

And so now if we go back into Excel, obviously you can see we've won 30.0 here for new customer prior month.

If we say change that to 80, we can see that the numbers down at the bottom here have updated.

Let's go back into PowerPoint and there you go.

As you can see, the numbers have also updated, so a really useful way just to carry over any updates to data that you're using in your presentations.

The major restriction of copying over a table from Excel to PowerPoint is the limitation in formatting.

If you want to do any changes to the type of font you're using or the colour of the text or make any changes to the text you're using in terms of the titles, that all needs to be done in Excel.

What you can do in PowerPoint is change the background colour if you want to, or the outline of the table, and that's about it.

The other thing I just want to quickly cover when you link a table into PowerPoint from Excel is that if you have the PowerPoint presentation closed whilst you're making updates to the Excel table, you can then update the link when you reopen that presentation.

Just so any updates to the spreadsheet Excel are then carried over into your PowerPoint presentation.