Configuring Tombstones for your organization

Modified on Sun, 15 Nov at 10:13 AM

Power-user Tombstones let your users browse your organization's references (also called credentials or tombstones) in the PowerPoint Library, filter them by date, industry or language, and insert them in one click, already in your corporate format. An admin sets them up once from an Excel database and a PowerPoint template, then publishes them from the admin portal.

In short

  • For users: find the most relevant references with filters and insert them formatted, in one click
  • For admins: an Excel database + a PowerPoint template + a folder of logos, published from the admin portal
  • Filters: defined by suffixes in the Excel column headers, such as [Slider] or [Combobox]
  • Not only references: works with any structured data, such as a collection of CVs

How Tombstones work in Power-user: an Excel database and a PowerPoint template give filtered references inserted in one click

How Tombstones work in Power-user: an Excel database and a PowerPoint template give filtered references inserted in one click

How Tombstones work

  1. An Excel database lists all the references of your organization, one row per reference.
  2. A PowerPoint template defines the format in which they are inserted.
  3. When a user browses Tombstones in the Library, Power-user takes the data from the Excel database, fills the PowerPoint template and inserts it in the presentation.

Filtering Tombstones in the Library of PowerPoint to find the most relevant references

Filtering Tombstones in the Library of PowerPoint to find the most relevant references

Tombstones inserted in one click in the corporate format of the organization

Tombstones inserted in one click in the corporate format of the organization

Tip: not only for references. Tombstones work with any structured dataset, for example a collection of CVs or any data you often add to your presentations.

Step 1: create the Excel database

  1. Download the sample Excel database.
  2. In the Tombstones sheet, add or rename columns: one column per field, such as date, client name, industry, country, language or project manager.
  3. Fill in your references, one row per tombstone.
  4. Keep the data in an Excel Table named Tombstones, in a sheet also named Tombstones, then save the file.

Customizing the Tombstones Excel database

Customizing the Tombstones Excel database

To name the Table: select the range, click Insert > Table, then type Tombstones in the Table Name field of the Table Design tab.

For logos: put all the logos in one folder and enter the file name with its extension in the Excel column, for example Client1.png.

Step 2: customize the PowerPoint template

  1. Download the sample Tombstones template.
  2. Add a shape for each Excel column to display. These shapes are placeholders for the data: format them as you like (colors, alignment…).
  3. In the Selection Pane, rename each shape with the header of its column, without the suffix. For example, name Year the shape filled by the Year [Slider] column. For logos, use the name of the column that contains the picture file name.
  4. Group all the shapes and name the group Tombstones, then save the file.

Customizing the Tombstones PowerPoint template

Customizing the Tombstones PowerPoint template

  • Decorative shapes not linked to data can stay in the group, without renaming.
  • Several tombstones per slide: duplicate the group and position each copy.
  • Several layouts: use one slide per layout; users choose the one they want.

Step 3: set up the filters

Add a suffix to a column header in the Excel database to turn it into a filter in PowerPoint:

SuffixFilter displayedBest for
[Slider]A slider to select a range of valuesNumbers, such as years or amounts
[Combobox]A drop-down list with one choiceLanguage or client name
[Multiselect]Checkboxes to keep several choicesFor example projects in France or Germany. A row can have several values in the same cell, separated by //.
[Sort]No filter, but the column is added to the sort optionsAny field users may want to sort by

Columns used as filters are automatically available in the sort options too.

Filters available to browse Tombstones in PowerPoint, defined by the Excel column suffixes

Filters available to browse Tombstones in PowerPoint, defined by the Excel column suffixes

Step 4: test and publish

Publish for testing

  1. In a new folder of your file-sharing solution (shared drive or network), save the PowerPoint template, the Excel database and a compressed folder of all the pictures (logos, flags…), as .zip, .bzip, .7zip, .rar, .lzip, .tar or .tar.gz.
  2. Log in to the admin portal. In the Users menu, add yourself to the Test team.
  3. In the Library menu, find the two Tombstones items, one for Test and one by default. If they are missing, click New to create them.
  4. Open the Test item, enter the direct links to the PowerPoint file, the Excel file and the compressed pictures folder (see Getting the direct link to a file or folder), and click Save.
  5. Restart PowerPoint and open Tombstones in the Library. Check that everything works; if not, fix the files and publish a new version of the Test item.

Tombstones items in the Library menu of the Power-user admin portal

Tombstones items in the Library menu of the Power-user admin portal

Entering the paths of the Tombstones files in the admin portal

Entering the paths of the Tombstones files in the admin portal

Error messages shown when testing Tombstones in PowerPoint

Error messages shown when testing Tombstones in PowerPoint

Publish for all users

When the tests are conclusive, open the Tombstones default item of the Library menu, paste the paths of the Excel file, the PowerPoint file and the compressed folder, and save. Every user sees the Tombstones after restarting PowerPoint.

Why use Tombstones

Companies in consulting, finance or marketing services use tombstones in their proposals to show that they have delivered similar projects. Without a tool, this wastes a lot of time:

Without Power-userWith Power-user Tombstones
Users search for references in old presentations.All references are in the Library of PowerPoint.
They use the references they find, not the most relevant ones.Filters by date, industry or language surface the right ones.
They spend time formatting each reference.References are inserted in your corporate format in one click.
They translate references, sometimes back and forth.Your database can hold the versions you need, for example a language column.
Need help to set up your Tombstones? Contact us at support@powerusersoftware.com. To see everything you can customize, read Customizing Power-user for your organization.

Frequently asked questions about Tombstones

What are tombstones in a PowerPoint proposal?

Tombstones, also called credentials or references, are short summaries of past projects or deals that companies add to their proposals to show their experience. Power-user Tombstones let users insert them from a database, already formatted.

How do I create a database of references for PowerPoint?

With Power-user, list your references in an Excel Table named Tombstones, one row per reference and one column per field, then link it to a PowerPoint template from the Power-user admin portal.

How do users find the right tombstone?

In the Power-user Library in PowerPoint, users filter the tombstones by the fields you define, such as year, industry, country or language, and sort them.

How do I add client logos to tombstones?

Put all the logos in one folder, enter each file name with its extension in an Excel column, and name the matching PowerPoint shape after that column. Publish the logos as a compressed folder with the other files.

Can Tombstones be used for CVs?

Yes. Power-user Tombstones work with any structured dataset, such as a collection of CVs or other data often used in presentations.

How do I test Tombstones before publishing them to everyone?

In the Power-user admin portal, add yourself to the Test team and publish the files in the Test Tombstones item. When everything works, publish them in the Tombstones default item.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article