Blog

Tools for exporting or connecting from Excel to PowerPoint

There are plenty of reasons to connect Excel with PowerPoint. Often this is about keeping numbers or charts up-to-date. In other cases it is about creating data-driven slides automatically. For both cases there are various add-ins available. The following list contains a selection of tools for exporting or connecting from Excel to PowerPoint.

Read More »Tools for exporting or connecting from Excel to PowerPoint

8 Articles about creating PowerPoint slides from Excel using VBA

The internet is full of articles, blog entries and recommendations dealing on how to create PowerPoint slides from Excel using VBA. As Excel and PowerPoint seem to be quite as old as the internet itself, the amount of information is enormous.

Additionally, there is a huge group of people asking for help in forums like reddit or stackoverflow. Quite often they show pieces of VBA code found somewhere on the internet. And then, of course, they struggle to adapt the code to their own problem.

How can it be that the offer of help is so huge but the need for individual support is even greater? Is it really so easy to create PowerPoint slides from Excel using VBA? The following list gives an overview of what is available on the internet regarding this topic. But, of course, there is much more available through web search.

Read More »8 Articles about creating PowerPoint slides from Excel using VBA

Version 3.0 available. Logical Audit, simplifying chart features and more

This update to version 3.0 brings various new features to SlideFab:

  1. A new logic audit feature which lets SlideFab search for inconsistencies in the automation setup. This helps to detect issues before running the Slide Making process.
  2. The newly introduced Excel Charts Export Mode from version 2.0 got an upgrade. It is about series sorting and elimination of empty entries.
  3. A more sophisticated error checking during Slide Making gives feedback if something went wrong.

And last but not least, this new version incorporates a couple of bug fixes.

This new version is available at the download page. Already installed SlideFab updates automatically.

Read More »Version 3.0 available. Logical Audit, simplifying chart features and more
This is still picture from the video explaining the five different chart relevant Export Modes

Linking / exporting charts from Excel to PowerPoint using 5 different Export Modes of SlideFab

When creating recurring PowerPoint slides based on Excel workbooks, there are 5 different SlideFab Export Modes to choose from. This video elaborates on how to choose and employ the right Export Mode. The video shows how to set up the Excel model and the PowerPoint slide template for the use of SlideFab.

Read More »Linking / exporting charts from Excel to PowerPoint using 5 different Export Modes of SlideFab
Mood image highlighting new version 2.0 of SlideFab 2

SlideFab 2 version 2.0 available. New features, higher robustness.

This update to version 2.0 brings various new features to SlideFab:

  1. A new chart export modes for allowing more flexibility in the output presentation
  2. A helpful feature to edit the path to multiple linked charts at once
  3. A killer button to end all Excel processes

and a few things more.

Apart from these novelties the versioning was improved to distinguish the kind of update: For feature updates like this one, the major number left of the dot increases. For smaller updates and bugfixes the minor number counts. Accordingly, this version is not 1.12 but 2.0.

This new version is available at the download page. Already installed SlideFab updates automatically.

Read More »SlideFab 2 version 2.0 available. New features, higher robustness.

Invoking slide automation through the all new SlideFab 2 API. Here comes SlideFab 2 v1.10

So far, it was required to use the Make Slides window within SlideFab 2 to automatically create the PowerPoint slides based on Excel. This works fine. But for a deeper integration of SlideFab 2 into your own applications some API functionality was missing… until now. The slide mass creation can be invoked through the SlideFab 2 API using a few lines of code. It is pretty simple to use and offers a whole new world of opportunities for all those who enjoy coding VBA.

This new version is available at the download page or updated automatically from your existing SlideFab 2 installation

Read More »Invoking slide automation through the all new SlideFab 2 API. Here comes SlideFab 2 v1.10
SlideFab 2 v1.7 release image

think-cell chart mass production with all new SlideFab 2 v1.7

think-cell create Excel link

SlideFab 2 v1.7 brings not many updates but for fans of think-cell a significant one: When a PowerPoint template slide contains one or more Excel-linked think-cell charts, SlideFab will allow the chart update and break the Excel links for the output slides. In this way the output slides will contain real think-cell charts (not just mere screenshots or so) which can be fine-tuned or altered when required. Further information about how this works can be found in the documentation.

Read More »think-cell chart mass production with all new SlideFab 2 v1.7
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.

Read More »Using customization to individualize mass-produced PowerPoint slides
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.

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