This section explains how Excel tables can be intelligently linked with PowerPoint®. With this function, changes made in Excel sheets will be automatically transferred to tables that have been integrated in PowerPoint® presentations. Worrying about the correctness of integrated tables will be a thing of the past.
Using the function “Excel Table”, you can intelligently integrate tables in PowerPoint® presentations.
To link a table, you will firstly need to insert a table from the corporate design templates onto a slide via the quick access pane.
Then click on “Excel Table” and then on “New”.
When you click on “Browse”, you will be able to select the required file on your computer.
After clicking “Open”, the selected Excel® file will open and you can mark the area you want inserted in your PowerPoint® presentation. Afterward, click on „Choose selected range“. If you now click „Yes“ at „Update data automatically on open“ the table on the slide will be automatically updated when the slide or the presentation in the library is opened. Now click „OK“.
If you activate Refresh data automatically on open with “Yes”, the table on the slide will automatically update once the slide or the presentation is downloaded from the empower library. Click on OK. You will receive a notification in which you will be asked if the first line is to be used as a header for the table. If you click on No the first line of your selection in the Excel® table will be regarded as the first value line.
empower will then insert the values of the selected area in the table template on the slide. This table in PowerPoint® is now linked with the Excel® file on your computer and is also conform to corporate design.
If you change values in the Excel® file, you can update the table in PowerPoint® by clicking “Refresh”.
empower will then check the original file and shows the values that have been altered. Via “Open linked Table”, you are also able to display the linked Excel® file in split screen next to your presentation to compare their content.
In “Edit”, you can alter the selected area of the Excel® file, and with “Remove” separate the link between the Excel® file and PowerPoint®. The table on the slide will not be deleted. In “Manage”, you get an overview of all tables linked to your presentation. Here you see the location the original file is saved in, and are able to open it with a click on the path. If you select multiple or all entries, you can update all tables at once, or separate the link. In addition, you can also set which tables are to be refreshed automatically when opened.
In the main library as well as the Quick Access Pane, you will find the corporate design template folders with text elements, diagrams, tables, and symbols. Here you will see the “Insert” button as well as the function “Apply format”. This enables the transfer of the formatting of elements that are conform to CD onto falsely or previously unformatted elements with a single click.
Should a table, for example, not conform to corporate design, you can simply select the appropriate template in the “Tables” folder by accessing it from the Quick Access Pane. Select the table on the slide, and click “Apply format”. empower will apply the format of the template onto the table within the presentation. Apart from the “Apply format” button you may also activate two further options by clicking on the cog symbol:
- If “Apply position” is activated, not only the format but also the position of the template will be applied to the selected table.
- “Apply size” will adapt the size of the table to that of the template
When working with diagrams you have, in addition to the functions “Apply position” and “Apply size” the option “Convert chart type”. This enables you to change the type of your diagram by selecting the appropriate template and clicking “Apply format”.
Using text elements, you may integrate any text in a text box into the respective text element of the template library. To do so select the desired template and click “Apply format”. Afterward you are able to change this element into any text element.