Automatic updating of excel tables in powerpoint slides

Posted by / 22-Apr-2020 21:54

Automatic updating of excel tables in powerpoint slides

I have the monthly sales turnover for these districts.

In need to update them monthly from an Excel sheet.

Meaningful facts and data are the basis of any successful presentation.

It can, however, easily occur that old figures have snuck into your presentation.

In this article, my aim is two-fold: ) isn’t just in the realm of tracking studies. You can essentially write a report from a mid-field data export, and then automatically update your report with the final data.

So there is the possibility to link the diagrams with Excel and thus make work easier.

Under File / Information / Edit Links to Files (PPT 2016) you can also set an automatic update of the diagrams in Power Point.

Here we look at the three elements of Power Point that allow automatic updating.

When you click on a chart within Power Point, you have the option to Edit Data.

automatic updating of excel tables in powerpoint slides-87automatic updating of excel tables in powerpoint slides-48automatic updating of excel tables in powerpoint slides-58

Learn how to always keep your charts up to date while simultaneously saving time!