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 — a frequent need in PowerPoint reporting automation. 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 and MATCH will be used to look up the appropriate rows.
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 right away (pricing if you still need a license).
Table spreading across slides ExampleDownload
There are more explanatory “How to” articles on the Tutorial page