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:
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.
SlideFab 2 v1.3 is a bugfix update addressing a recent issue with the license server authentication:
This SlideFab 2 video shows how to create Category Trees automatically. A Category Tree is a structured visualization of corporate spend. It serves for quickly showing where most money goes in terms of categories, sub categories, suppliers and countries.
SlideFab 2 v1.2 is a minor update introducing a few new features, improvements and bugfixes.
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.
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.