Featured Video Play Icon

Loop Condition Example

This video is based on the "Hello World" example and and incorporates a loop condition. The loop condition can be used to not create slides, if it does not evaluate to true. In this example the loop condition is used, to leave out every second slide. So instead of all 6 slides of the "Hello World" example only slides 1,3 and 5 (candidate values "A", "C" and "E") will be created. 

Continue reading

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

SlideFab 2. Power to the User Blog Post Image

Power to the User. All new SlideFab 2 Released

I am very proud to announce the all new SlideFab 2. Simply the most powerful Powerpoint automation tool ever built.

Based on the experience from SlideFab 1 the new version was redesigned and rebuilt from scratch. SlideFab 2 brings the user experience to a completely new level. Not only does SlideFab 2 come with a new interface, it also introduces a unique and much simpler user process to automatically create Powerpoint presentations based on Excel workbooks.

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.