Make DYNAMIC SENTENCES that change based on Excel data

Video is intentionally silent

↓ Back to Table of Contents

The ability to write dynamic sentences is one of the most powerful document automation features on the planet. Did you know that many sports articles in newspapers are written using dynamic sentences? Automation software can easily write articles describing how the Patriots beat the Stealers by a score of 23-20.

Automated Insights and Narrative Science are two companies that help newsrooms do this. But you don't need a huge budget to take advantage of automated content. You too can harness the same techniques to create content that updates intelligently using nothing but Microsoft Word and Microsoft Excel.

One of the easiest ways to create dynamic written content is to use Epsillion's Variables feature. Simply write your sentence as normal, then insert a Variable in place of a particular word. That variable might resolve to one of two outcomes -- for example, "increase" or "decrease". Depending on whether the latest number in your Excel spreadsheet is increasing or decreasing, your sentence can indicate the correct direction.

The second way to create dynamic written content is to use Epsillion's Conditional Paragraphs. This is a powerful technique that makes virtually any combination of words, charts, tables, and images possible depending on the value of an Excel cell. So, for example, you could have a dropdown menu in Excel that lets you choose between "retail", "industrial" or "residential". If you choose "retail" the conditional paragraph inserts several pages related to your retail topic; if you choose "industrial", your document features paragraphs, charts, and tables related to industrial analysis.

To learn more, contact us today or read a few articles in our document automation blog. Don't wait. Your competitors aren't!

Documentation Automation Software Training and Tutorials

These videos will help you get started with—and master—Epsillion.

Have a request for a video? Email us at to let us know!

Videos

Get started

1. What is Epsillion?
2. Three reasons to use Epsillion
3. Open the Epsillion desktop application (Dec 2023)
4. Sign in / login to Epsillion (Dec 2023)
5. Start a NEW AUTOMATED DOCUMENT from your LIBRARY (Dec 2023)
6. Start a NEW AUTOMATED DOCUMENT from scratch (Dec 2023)

Boost speed

7. Lightning Mode for up to 10X processing speed (Dec 2023)

Add content

8. Add words to your automated report (Dec 2023)
9. Add an IMAGE to your automated document (Dec 2023)
10. Add a CHART to your automated document (Dec 2023)
11. Add a TABLE to your automated document (Dec 2023)

Add references

12. Add REFERENCES to your images, charts, and tables (Dec 2023)
13. Add a FOOTNOTE to your automated document (Dec 2023)

Use variables

14. Add a SINGLE CELL VARIABLE in Excel (Dec 2023)
15. Add COLUMN VARIABLES in Excel (Dec 2023)

Dynamic content based on variables

16. Make DYNAMIC SECTION / PARAGRAPH that changes based on Excel data (Dec 2023)
17. Make DYNAMIC SENTENCES that change based on Excel data (Dec 2023)

Sign PDF

18. Sign your PDF using your signature

Trouble shoot

19. Fix the (rare) problem of your addin disappearing from the Excel or Word ribbon
20. Add the Developer tab in the Excel ribbon, so you can run VBA code
21. Unhide, count, and delete unneeded named ranges

Have a request for a video? Email us at to let us know!