How to Design an interactive slides - Dynamic Filtering Slides via VBA?

Designing great slides is an essential skill when you would like to give an important presentation to your target audience. To achieve it, you need to summarize your content into concise sentences or even only a couple of key points. You need to organize the sequence and the rhythm of content to guide your audiences understand your points quickly without misunderstandings. You also need to do some research on the coloring, the font type and size to make sure people can read it through comfortably. Sometimes you might need to provide some dynamic features to have your presentation more interactive, easy-to-read, and dashboard-like.

You will think of Power BI, Tableau or other interactive visualization tools when it comes to business intelligence dashboards. However, you might not go these routes because

1. You don’t have any licenses for these softwares.
2. You would not like to switch between these softwares and PPT slides back and forth.
3. The data you have is not structured so it is hard to populate it into these softwares.

We are going to introduce an approach to help you design interactive slides in MS PowerPoints via VBA. In this session, we will mainly focus on designing a dynamic filtering slide to present a price range chart by Laptop brands and by GPUs.