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

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

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