TABLE OF CONTENTS
- Introduction to the Tombstones feature
- Creating the Excel database of tombstones
- Customizing the PowerPoint template
- Customizing the filters available to users in PowerPoint
- Publishing the Tombstones
Introduction to the Tombstones feature
Why are Tombstones useful?
Tombstones are one of the most powerful features available in Power-user for PowerPoint.
Applying custom filters will provide users with the most relevant credentials to win a proposal
Tombstones can be inserted in 1 click and will immediately take the corporate format defined by your organization
Tombstones work with any structured dataset. This means that this feature can also be used to configure a collection of CVs, or any other structured data that might be used frequently in your presentations.
How Tombstones work in Power-user
The Tombstones work the following way:
- An Excel database compiles all the references of your organization
- A PowerPoint template defines the format in which the Tombstones should be inserted
- When a user browse Tombstones within the Library, Power-user will fetch the data from the Excel database, fill the PowerPoint template with that data and insert it in the presentation
Creating the Excel database of tombstones
- Download our sample Excel database of tombstones from this link.
- In the "Tombstones" sheet, customize the sample database to your need by adding or renaming columns. Each columns represents a distinct field (e.g. date, client name, industry, country, language, project manager, etc.)
- Fill the database with the data of your organization's references. Use 1 row for each tombstone.
- Make sure the Tombstones remain part of an Excel Table named "Tombstones" (as in the sample), in a sheet also named "Tombstones", so that Power-user will know where to find the data to use.
- When the database is ready, save the file
Customizing the PowerPoint template
- Download this sample Tombstones template.
- Open the file, and add a shape for each column of your Excel database that you would like to display on the Tombstones. These shapes will act as placeholders for the data from Excel. Customize their format, colors, text alignment etc. as you see fit.
- From the Selection Pane, rename each shape with the header name of the matching column (without the suffix). For instance, rename "Year" the PowerPoint shape that should be filled with the data from the "Year [Slider]" column of the Excel database.
- For shapes that will contain pictures (e.g. logos), use the name of the column that contains the path to the picture.
- You can include decorative shapes (not linked to data from the Excel database), no need to rename them.
- When all the shapes have been properly named, group them and rename the group "Tombstones".
- To display multiple Tombstones on a slide, just duplicate that group and position each tombstones on the slide.
- To provide users with multiple choices of layouts, just use a distinct slide for each layout.
- When your template is ready, save the file.
Customizing the filters available to users in PowerPoint
You can customize the filters that are available to users in PowerPoint. Each filter can be defined by adding the appropriate suffix to the header of the column in your Excel database:
- [Slider]: Use this suffix to display a slider Filter, allowing to select values within a range. This is appropriate for numbers (e.g. years, amounts...).
- [Combobox]: Use this suffix to display a combobox Filter. This is appropriate for a one-choice selection (e.g. language or client name).
- [Multi selection]: Use this suffix to display a checkbox Filter, which is appropriate for allowing users to keep several choices in their filter (e.g. filtering tombstones from project either in France or Germany).
- [Multiselect]: this is the same as the [Multi selection], but should be used for fields that have multiple items in the same cell (with a "//" separator). This will be appropriate if each project can can have multiple tags.
When you configure fields to be available as Filters, they will also automatically be available in the Sort options. But you can also add extra fields in the Sort options by adding a [Sort] suffix to a column.
Publishing the Tombstones
Once both your PowerPoint template and Excel database are ready, you can publish the Tombstones so that they will become available to users in your organization.
To publish the Tombstones:
- Add a new folder to your file-sharing solution (e.g. shared drive or network)
- In that folder, save the relevant files:
- The PowerPoint template
- The Excel database
- A folder containing all the pictures that will be used by the Tombstones (e.g. logos, flags etc.). Make sure that the path to that folder is correctly reflected in the Excel database.
- Connect to your admin portal, using your organization's credentials