Due to maintenance activities at the server facility, there might be a potential downtime for the website and the licensing system of SlideFab between Nov… Read More »Server maintenance in progress between Nov 28, 2022 22:00 and Nov 29, 2022 06:00 CEST
Version 7.0 available. New feature: Filtering pivot tables automatically with the Master Cell value.
SlideFab 2 version 7.0 adds a small new feature which is a great leap forward for building simple Excel models: A new feature to filter pivot tables. With this it is possible to avoid VBA coding to change the pivot filter, like it was used in this old blog post for creating category trees. And this new feature also removes the need to write aggregating formulas for all those, who did not use the VBA snippet in the first place.
This means that it is much simpler to mass produce PowerPoint slides based with Excel charts, when these charts are Excel pivot table charts, which automatically change when the filtering is changed.Read More »Version 7.0 available. New feature: Filtering pivot tables automatically with the Master Cell value.
SlideFab 2 version 6.0 adds a small new feature to Excel/PowerPoint waterfall charts and also brings a few bug fixes.
The waterfall “focus changes” feature when using the PowerPoint Chart Export Mode helps to make smaller changes more visible without having to adapt the y-axis manually. It makes sense when the totals are so huge in comparison to the changes that the changes will be merely visible as flat lines only. This feature determines the maximum and minimum values of the waterfall and then adapts starting and end point of the y-axis. It works like like zooming in on the changes.Read More »Version 6.0 available. New “focus changes” feature for waterfall charts. Some bug fixes
Case Study: Maintenance-free Excel workbook for simplifying the slide creation process using Dynamic Array Formulas
Client: Consulting boutique for work and organizational psychology
Type of engagement: Commissioned work
Objective: Redesigning and rebuilding a slow and cumbersome legacy Excel model for automatic zero maintenance slide creation with SlideFabRead More »Case Study: Maintenance-free Excel workbook for simplifying the slide creation process using Dynamic Array Formulas
SlideFab 2 version 5.0 adds a new scaling feature to shrink or stretch shapes based on factors calculated in Excel. This is really helpful to gain even more control over mass-produced slides and presentation.
Up to this point SlideFab was mainly focused on exporting content from Excel to PowerPoint. Let it be texts, charts, images or something else. Some dynamics were available with the Shape Condition feature, which allows to remove shapes based on an Excel formula outcome.
With this new version SlideFab has entered the world of manipulating PowerPoint shapes through scaling. Now, it is possible to provide separate scaling factors for horizontal and vertical dimensions. By setting the anchoring point both horizontally (left vs right vs neither) and horizontally (top vs bottom vs neither) the user gets control on how the scaling will be applied.Read More »Version 5.0 available. New scaling feature. Some bug fixes
SlideFab 2 version 4.0 brings support of Dynamic Array Formulas when referencing the Excel worksheet. Referencing to ranges (with # at the end) using these… Read More »Version 4.0 available. Dynamic Array Formula support and bug fixes
Client industry: Consulting / utilities
Type of engagement: Provision of SlideFab, technical support
Objective: The automatic creation of tailor-made benchmarking evaluations for the participating companies of the Digital@EVU initiativeRead More »Case Study: Benchmarking reports for the participating companies of the initiative Digital@EVU
Case Study: Country / function specific reports based on an employee survey for a global luxury food manufacturer
Client industry: Luxury food products
Type of engagement: Joint effort with the client to build Excel workbook, PowerPoint template and SlideFab setup
Objective: Automatically creating individualised surveying resultsRead More »Case Study: Country / function specific reports based on an employee survey for a global luxury food manufacturer
Due to routing changes at the server facility, there might be a potential downtime for the website and the licensing system of SlideFab between May… Read More »Server maintenance in progress between May 4, 2021 22:00 and May 5, 2021 08:00 CEST
There are plenty of reasons to connect Excel with PowerPoint. Often this is about keeping numbers or charts up-to-date. In other cases it is about creating data-driven slides automatically. For both cases there are various add-ins available. The following list contains a selection of tools for exporting or connecting from Excel to PowerPoint.Read More »Tools for exporting or connecting from Excel to PowerPoint
The internet is full of articles, blog entries and recommendations dealing on how to create PowerPoint slides from Excel using VBA. As Excel and PowerPoint seem to be quite as old as the internet itself, the amount of information is enormous.
Additionally, there is a huge group of people asking for help in forums like reddit or stackoverflow. Quite often they show pieces of VBA code found somewhere on the internet. And then, of course, they struggle to adapt the code to their own problem.
How can it be that the offer of help is so huge but the need for individual support is even greater? Is it really so easy to create PowerPoint slides from Excel using VBA? The following list gives an overview of what is available on the internet regarding this topic. But, of course, there is much more available through web search.Read More »8 Articles about creating PowerPoint slides from Excel using VBA
This update to version 3.0 brings various new features to SlideFab:
- A new logic audit feature which lets SlideFab search for inconsistencies in the automation setup. This helps to detect issues before running the Slide Making process.
- The newly introduced Excel Charts Export Mode from version 2.0 got an upgrade. It is about series sorting and elimination of empty entries.
- A more sophisticated error checking during Slide Making gives feedback if something went wrong.
And last but not least, this new version incorporates a couple of bug fixes.
This new version is available at the download page. Already installed SlideFab updates automatically.Read More »Version 3.0 available. Logical Audit, simplifying chart features and more
This update to version 2.0 brings various new features to SlideFab:
- A new chart export modes for allowing more flexibility in the output presentation
- A helpful feature to edit the path to multiple linked charts at once
- A killer button to end all Excel processes
and a few things more.
Apart from these novelties the versioning was improved to distinguish the kind of update: For feature updates like this one, the major number left of the dot increases. For smaller updates and bugfixes the minor number counts. Accordingly, this version is not 1.12 but 2.0.
This new version is available at the download page. Already installed SlideFab updates automatically.Read More »SlideFab 2 version 2.0 available. New features, higher robustness.
So far, it was required to use the Make Slides window within SlideFab 2 to automatically create the PowerPoint slides based on Excel. This works fine. But for a deeper integration of SlideFab 2 into your own applications some API functionality was missing… until now. The slide mass creation can be invoked through the SlideFab 2 API using a few lines of code. It is pretty simple to use and offers a whole new world of opportunities for all those who enjoy coding VBA.
This new version is available at the download page or updated automatically from your existing SlideFab 2 installationRead More »Invoking slide automation through the all new SlideFab 2 API. Here comes SlideFab 2 v1.10
UPDATE: Please also have a look at the blog post explaining how to build a resilient Excel model using Dynamic Array Formulas and spilling ranges.… Read More »What is important when creating Excel models (not only for SlideFab)?
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.Read More »Power to the User. All new SlideFab 2 Released