Blog

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.

UPDATE: There was a bug in the Excel model which led to incorrectly drawn charts. Thanks to Thomas Seitz from http://www.tsm-marktforschung.de/ for pointing this out. The example files was updated, cf. below.

Read More »Likert Charts mass creation in Powerpoint using Excel and SlideFab 2
SlideFab 2 v1.5 release hero image

Mass Producing Excel Charts to Powerpoint gets easier with all new SlideFab 2 v1.5

SlideFab 2 v1.5 comes with the great new feature to automate Excel-to-Powerpoint linked charts. This is a great addition to the existing SlideFab 2 features which can copy charts from Excel to Powerpoint as image and to update the data in Powerpoint charts. Of course, this feature is also supported in the all free SlideFab 2 LITE edition.

MINOR UPDATE 10th January, 2019: A new installer was made available as the old SSL certificate had expired.

Read More »Mass Producing Excel Charts to Powerpoint gets easier with all new SlideFab 2 v1.5

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:

Imagine a classical way to make an Excel file hard to understand: Adding numerous references across worksheets to single cells. This happens quite often. Even to adapt Excel users: For example, they separate calculation sheets from a parameter sheet. Conceptually, this is a good idea, but things can get messy.

Read More »How Excel Tables exceed Named Ranges when writing legible formulas

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.

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

Table spreading across slides

This video is based on a scenario where a table with 1,000 rows in an Excel table shall be brought to Powerpoint. As 1,000 rows are way too much for a single slide, the table shall be spread across multiple slides. Let’s call this Table Spreading. In this video the Slide Loop feature will be used to create 125 slides, where each one holds a Powerpoint table with 8 rows plus header.

Read More »Table spreading across slides
Screenshot of the Loop Condition example video showing the created slides

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. 

Read More »Loop Condition Example
A screenshot from the SlideFab 2 "Hello World" example video

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.

Read More »Hello World Example
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.

Read More »Power to the User. All new SlideFab 2 Released