Featured Video Play Icon

Output File Decomposition Example

This video is based on the "Hello World" example and goes one step further. This example is about output file decomposition. While the original example created 1 presentation containing 6 output slides (1 slide per loop), this video shows one output file can be created per loop (so 6 files with 1 slide each). When using output file decomposition, other features such as adding segments or sorting slides locally (per loop run) can be applied as well.

 

Continue reading

Featured Video Play Icon

Hello World Example

This brief video shows how to create a Hello World project with SlideFab 2. It will be explained how an Excel workbook can be set up and linked with Powerpoint such that multiple slides with different "Hello World" titles are created through SlideFab automatically.  

Continue reading

SlideFab v1.10 released

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

SlideFab v1.10 is a minor update bringing a couple of bugfixes and improvements. Most notably, SlideFab is now capable of making slides and whole presentations from a worksheet directly without opening the SlideFab window. Therefor a named range "SlideFab_X" needs to be created for a given Excel cell where X is the number of the Xth embedded setting. Now, when double-clicking this cell, SlideFab will run according to embedded setting number X. On top of this a few bugs were fixed and some aspects were improved. This makes an upgrade to  SlideFab v1.10 highly recommendable.

The following lists give an overview of the novelties and bugfixes since version 1.9.

What's new in SlideFab 1.10

Features:
- Making slides directly from a worksheet via double click a cell with a named range such as "SlideFab_X" where X is a number of an embedded setting

Bugfixes:
- Removed a false error message when auto-fitting text to shape seemed not to work after shape was deleted due to condition
- Fixed a bug where conditional formats in a table were not updated properly
- Handled an issue when embedded savings were stored in the workbook but could not get read anymore
- Resolved a problem when exporting to Powerpoint chart did not work when it was linked to Excel. Now there is a warning instead
- Tweaked the positioning of the worksheet view when clicking into a range selector textbox (e.g. for shape source range). Now the chosen range is centered instead of being focused in the upper left area of the visible range
- Improved slide and shape renaming with a new message within the SlideFab Powerpoint add-in

SlideFab v1.9

IMAGinE Innovation: Here comes SlideFab v1.9

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

This latest release of SlideFab v1.9 comes with a couple of novelties, for example two great new export modes:

  1. SlideFab has now the function to open up image files (e.g. jpg, png) from the hard drive and put these images into Powerpoint slides. As filenames can be computed or looked up from lists with formulas (e.g. VLookup or Index/Match), this new feature opens up a world of new possibilities. For example, when embedding company logos into the presentation it is not necessary to add these images to the Powerpoint file itself.
  2. Another novelty is SlideFab's feature to support charts which are designed within Powerpoint. This is a tremendous addition to copying charts from Excel over to Powerpoint or to updating think-cell charts. The way it works is very simple: Design any chart within Powerpoint and then define where the data in Excel will come from. (Please note: this import mode will be only be visible when using charts in a Powerpoint template file. Otherwise this mode will not be shown within the export mode dropdown in the slide editor)

On top of these new features SlideFab got a massive speedup improvement which will pay off for larger presentations with hundreds of slides.

SlideFab v1.9 also supports the format painter for indirect shapes and images from files. For example, when a drop shadow (or border, reflection, etc.) is set in the template for a shape which will become a picture when running the slide fabrication, this drop shadow will appear in the output file as well.

 

The following lists give an overview of the novelties and bugfixes since version 1.8.

 

What's new in SlideFab 1.9

Feature:

  • New export mode: SlideFab can now read image files and put those into Powerpoint shapes
  • New export mode: SlideFab supports Powerpoint charts and updates data tables from ranges in Excel

Under the hood improvements:

  • Splitting and caching to speed-up the fabrication of larger Powerpoint presentations with > 200 slides
  • Disabling and restoring autosave in Powerpoint to improve speed-up
  • Improved positioning precision for shapes when imported from a Powerpoint template presentation
  • Minor bug fixes
SlideFab category tree example image for the blog post

Wolf in sheep’s clothing? How to tame the beast and create great category trees in Powerpoint automatically using SlideFab

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

Category trees are a little bit like wolfs in sheeps' clothings: They look pretty, sometime cute. But if you try to create great category trees, they will eat up all your time. So, what is a category tree: It is visualization of numerical data which is categorized in multiple ways. The category tree gives an overview of the most important sub categories first. Then it shows how these sub categories break down. For example, it can be used to show supplier spend data on spend category and sub category level as well as the top suppliers and countries per subcategory. Gathering all these numbers and compiling these Powerpoint slides is a huge copy/paste effort. You can imagine: Chances are high that something will go wrong. And if the underlying data changes, then it basically means starting from scratch. 

Fortunately, category trees can be created with SlideFab as well. As soon as Excel model and Powerpoint presentation are set up, the slides can be created within no time. So whenever data changes it will be a piece of cake to recreate the category trees. This means faster results with less time invested and also no manual copy/paste errors made. This short video shows in less than three minutes how this looks like and how it can be done.

If you want to try it yourself, go grab the SlideFab trial version and download the category tree example from the downloads page. It is even possible to plug in your own data, just make sure to refresh the pivot tables after pasting your data.

A longer tutorial explaining this example follows soon, it will go through the model and template and explain the underlying logic. If there are questions in the meantime, feel free to reach out.

Creating 100 Fact-Based Supplier Negotiation Decks with custom storylines in 15 minutes

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

This tutorial video gives an overview of the SlideFab capabilities when it comes to automatically creating whole presentations and not just mere slides. The example is based upon the idea that for annual negotiations with the suppliers there should be a custom-tailored fact-based presentation for every supplier in order to prepare and support the negotiations, ultimately leading to better results (e.g. savings). Therefore a storyline is created which leads through the historic performance and culminates in a claim for the upcoming year. The video explains how custom formula-based slide titles and content can be created to really have a personalized look and feel beyond just showing charts and tables. As a result, based on 7 templates slides, 650 slides  for 100 suppliers will be created (50 slides are not created for sake of story consistency using the slide condition feature.  Basically it is about just not showing some suppliers how good they actually are 😉 ).

Of course, this idea of custom-tailored presentations can be applied in other domains as well, e.g. when conducting surveys and using SlideFab to create feedback presentations for all participants or when running a decentralized project where individual work plans and instructions need to be compiled in larger numbers or on a regular basis through SlideFab.

Please note: The video was created with SlideFab 1.7 which at this time was still known as SlydMkr. For the new features since then please refer to The most powerful Powerpoint automation tool got even stronger: SlydMkr / SlideFab v 1.8 released.

SlideFab FBN example video tutorial poster

Creating supplier spend tables in Powerpoint automatically using SlideFab

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

The new SlideFab v1.8 introduced the Slide Loops feature which brought great flexibility and power. In this video a very simple example will be shown on how this function works. Spend data from a list of companies in Excel shall be copied over to Powerpoint in such a way that there is one slide per supplier. One slide - and if this is not enough? Indeed, in such cases SlideFab will take care and create as many slides a required in order to have everything covered.