Featured Video Play Icon

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

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.

The data used in this example originates from the World Bank: Proportion of seats held by women in national parliaments (%)  by year and country. This data should be representative for many other data sets: Categorized numerical time series data where for each category a chart is required.

In this example one slide will be created per country. Each slide will be about one country and contain a bar chart by year and a shape with the country name.


An image from the SlideFab 2 Powerpoint chart example video showing how SlideFab

 

 

 

 

 

Basically, the video contains three implicit chapters:

  1. How to create a Powerpoint slide featuring a Powerpoint chart. This is very basic as it only involves inserting a bar chart into an empty slide,
  2. How to write the formulas to have a dynamic data range in Excel for the chart. This step involves writing a formula with INDEX and MATCH as a lookup to obtain the numbers for a specific country.
  3. How to link the Excel workbook with the Powerpoint presentation with SlideFab for automatically creating the slides. Finally, this step is about setting up the iteration loop using the selected country cell and the country list as well as selecting the dynamic Excel data range for the chart on the template slide.

Here you will also find the Excel workbook and Powerpoint presentation file as download, which can be tried out with SlideFab 2 right away. These files are prepared already, containing formulas and settings as shown in the video.

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.



In this video it will be shown how to create a control table that can be used by SlideFab for automation purposes. Moreover, the process of how to create a table which can hold a subset of the original 1,000 rows will be explained. A combination of functions such as Index, Match to lookup the appropriate for example will be used.

This table spreading example is rather advanced, so having a second look at the Excel file and the formulas is recommended

Here you will also find the Excel workbook and Powerpoint presentation file as download, which can be tried out with SlideFab 2 right away.

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. 


Screenshot of the Loop Condition example video showing the created slidesTherefor the original example receives two new formulas: The first looks up the position of the Master Cell content using the Match function. The second formula checks whether the  position is odd using the modulo operator (the IsOdd function would work as well). After linking this cell to the condition field in SlideFab, the slide making creates every second slide only.

Here you will also find the Excel workbook and Powerpoint presentation file as download, which can be tried out with SlideFab 2 right away.

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.

 

Screenshot for the Hello World with Output Decomposition ExampleAgain, this example is kept very simple. Of course, when the presentation template contains more than 1 slide, then the decomposed files will have more than 1 slide, too.

Here you will also find the Excel workbook and Powerpoint presentation file as download, which can be tried out with SlideFab 2 right away.

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.  

The example in this video keeps things very simple as it writes formula-based texts from Excel to Powerpoint. However, SlideFab can do more than that. And in fact, bringing tables, charts or images from Excel to Powerpoint is very similar to what is shown in the video.

Here you will also find the Excel workbook and Powerpoint presentation file as download, which can be tried out with SlideFab 2 right away.

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.

Creating 100 Fact-Based Supplier Negotiation Decks with custom storylines in 15 minutes

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

This tutorial video gives an overview of the SlideFab capabilities when it comes to automatically creating whole presentations and not just mere slides. The example is based upon the idea that for annual negotiations with the suppliers there should be a custom-tailored fact-based presentation for every supplier in order to prepare and support the negotiations, ultimately leading to better results (e.g. savings). Therefore a storyline is created which leads through the historic performance and culminates in a claim for the upcoming year. The video explains how custom formula-based slide titles and content can be created to really have a personalized look and feel beyond just showing charts and tables. As a result, based on 7 templates slides, 650 slides  for 100 suppliers will be created (50 slides are not created for sake of story consistency using the slide condition feature.  Basically it is about just not showing some suppliers how good they actually are 😉 ).

Of course, this idea of custom-tailored presentations can be applied in other domains as well, e.g. when conducting surveys and using SlideFab to create feedback presentations for all participants or when running a decentralized project where individual work plans and instructions need to be compiled in larger numbers or on a regular basis through SlideFab.

Please note: The video was created with SlideFab 1.7 which at this time was still known as SlydMkr. For the new features since then please refer to The most powerful Powerpoint automation tool got even stronger: SlydMkr / SlideFab v 1.8 released.

SlideFab FBN example video tutorial poster

Creating supplier spend tables in Powerpoint automatically using SlideFab

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

The new SlideFab v1.8 introduced the Slide Loops feature which brought great flexibility and power. In this video a very simple example will be shown on how this function works. Spend data from a list of companies in Excel shall be copied over to Powerpoint in such a way that there is one slide per supplier. One slide - and if this is not enough? Indeed, in such cases SlideFab will take care and create as many slides a required in order to have everything covered.

Mass production of think-cell charts using SlydMkr for the Sales Chart Example

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

In 2017 the famous Powerpoint add-in think-cell will celebrate its 15th anniversary. Even though plenty of great visualization (and also data investigation) tools such as Tableau and Qlikview have emerged since then, it cannot be denied that think-cell is the gold standard when it comes to creating charts in Powerpoint presentations. think-cell is easy to use and creates pretty, polished charts.

However, when it comes to creating many think-cell charts, the task is not so easy. Using the data-link function to connect Powerpoint with Excel is helpful for sure, but it can become quite hard to maintain in complex situations when there are multiple presentation versions with multiple think-cell charts. Also implementing custom VBA code to create think-cell charts automatically can become quite challenging.

This is where SlydMkr will come into play: This tutorial is about think-cell chart mass production. It will be shown how SlydMkr can be used to create think-cell charts automatically. As this approach does not involve any coding, it is very easy to set up. The "trick" is that the think-cell charts are defined as usual in Powerpoint, while the data range will be defined in the Excel model. But instead of using the well-known data-link mentioned above, SlydMkr will take care of business: While creating the slides, the think-cell charts will be updated with right data automatically.

Creating 1000 Powerpoint slides in 10 minutes easily using SlydMkr Wizard for the Excel Name Card Example

UPDATE: SlideFab 2 is now available with groundbreaking changes. The text below is deprecated.

 

This tutorial will show how to use the SlydMkr Wizard in order to create Powerpoint slides for a simple Excel model using a Powerpoint template file.

This example is about a very common task: There is a table of items and for each row a separate slide shall be created. In this example the table contains participant information, e.g. name, age, company, etc.. The desired output is a name card for each person where this information is printed nicely. To make things a littler more entertaining there is also a person specific company logo which needs to be put on the name card. And on top of this, the example shows how a conditionally formatted cell can be used to have different name card background colors for people at different ages.