Tag Archives: From Excel to PowerPoint

CompTraX – A Microsoft Excel-based company profiling tool [5/5]

Hello friends,

This is the final post in the CompTraX series.

As discussed in my last post, this update focuses on exporting all the companies of interest from the Excel tool to the PowerPoint template in one go. The tool now also creates a table of content in the beginning of the presentation. You can download the final version of the tool here (.zip ; .xlsm)

The video below demonstrates the tool in action:

This update is mostly dependent on VBA. One of the important code snippets for this tool is the part that copies the charts and relevant text fields (company overview, news item and pipeline information) from Excel and exports them on the slide: Continue reading