Creating customized story flows in PowerPoint slide and presentation mass production

Using customization to individualize mass-produced PowerPoint slides

The art of creating PowerPoint presentations is topic of a whole industry: Templates, tutorials, manuals, best practices, etc. are offered to enable users to sculpture one perfect presentation. However, so much effort for one presentation does not scale well, e.g. when each country, business unit, team leader, etc needs a dedicated presentation. In such cases mass creating slides and presentations can help: Same structure but different data. In most cases the outcome is not very emotional or thrilling as titles or annotations do not reflect the message conveyed through the data. The slides tell no story. In fact, one might argue that a phonebook is more exciting. Unfortunately, the situation is as follows: One gets either customization or economies of scale.

Matrix customization vs economies of scale

However, this article is about approaches to bring more customization to mass-produced slides. Even though these tipps are meant for SlideFab 2, some will find them helpful for manual automation coding with VBA or Excel modeling in general.  So, here are some ideas which explain how to get more customization when mass producing PowerPoint slides or presentation based on Excel.

Continue reading

SlideFab 2 dashboard competition title image

Human-vs-Machine: How SlideFab 2 performs against human brute force

How much time does SlideFab 2 really save? In order to find that out there will be a competition between Alice and Bob. On the one hand, Alice uses SlideFab 2. On the other hand, Bob uses his own hands with high-performance copy and paste and leverages a small VBA snippet as turbo. The task will be to create dashboard slides in PowerPoint which are filled through an Excel-based calculation.

SlideFab 2 Human vs Machine Challenge Just after starting

Continue reading

SlideFab 2 Likert Chart Example Title page

Likert Charts mass creation in Powerpoint using Excel and SlideFab 2

There are plenty of ways to visualize results from surveys and benchmarks. A classical one is a line plot of the Likert scale (i.e. Likert chart / plot). While it is a great chart type, it is a pity that Excel does not offer it out of the box.

There are manuals on the internet available on how to build a Likert chart with Excel. However, this post explains how to mass create multiple slides with Likert Charts with SlideFab 2 for free. This can be useful in benchmarking surveys for example, where each participant shall receive a personalized result presentation.

Continue reading

How Excel Tables exceed Named Ranges when writing legible formulas

Creating legible Excel formulas is something which is very handy, typically. No matter whether another person or oneself needs to adopt and understand an Excel file. It can be difficult to find into the logic of an old or alien Excel file: Then even plain calculations can be hard to grasp. But there are also cases where complex workbooks are easy to understand. It depends, as always:

Continue reading

Featured Video Play Icon

How to easily automate creating slides with a Powerpoint chart from Excel

UPDATE: Check out an even simpler and faster way to automate this example using linked charts based on the new SlideFab 2 v1.5. Never the less, the approach below is still valid.


 

This video is based on a scenario where lots of data in Excel is used to create numerous slides with each having a Powerpoint chart. SlideFab will create the slides and update the data ranges for the charts automatically.

Continue reading