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

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.

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

All new and totally free SlideFab 2 lite edition coming with v1.4 update

SlideFab 2 v 1.4 is an edition update which introduces an all new and totally free SlideFab 2 lite version. The idea of this lite version is to democratize Excel to Powerpoint automation: Power to the User! It offers all features of the full SlideFab 2 versions flex and saver. The lite version can be used to automate two shapes per slide, which will cover essential tasks, e.g. setting slide headline and some content automatically. This content can be a chart, an image, a table or even something else. With this lite version dozens, hundreds or even thousands of slides can be fabricated automatically.

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

Featured Video Play Icon

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.

Continue reading