Presento
Feature Overview

OfficeReports Presento automates PowerPoint reporting for market researchers who work with crosstabs in Excel.Below you’ll find a complete overview of all Presento features — from linking Excel tables and charts to PowerPoint, to updating hundreds of slides automatically in just one click.

Free Support

Online Help, Videos
Free Support via chat, support meetings and support requests

Reorganizing Data in Excel

Linked Range - Links directly to the needed data
Lookup Range - Text search to find a range
Lookup Table - Extracts the needed data from standard crosstabs

PowerPoint Shapes

Link fill and font colors from the Excel range (use Excel's Conditional Formatting)
Text-to-Image
Link background colors from the range

General

Slide Library
Automatically create and attach a worksheet for every utilized slide

PowerPoint Tables

Automatic adjustment of number of rows and columns based on selected Excel range
Link fill and font colors from the Excel range (use Excel's Conditional Formatting)
Color-Driven Icons based on Excel fill or font color
Text-to-Image
Switch row/column
Hide 'Zero Values' in tables and charts
Link background colors from the range
Efficiently display long lists across multiple slides
Automatically remove 'zero' rows and/or columns

Report Automation

Utilize 'dynamic' links: automatically adjust the linked number of rows and columns from Excel area
Automatically 'refresh' the entire presentation with data from another workbook
MS Office VBA-Macro Integration

PowerPoint Charts

Chart Types: Rotated Line, Quadrant, XY, Diverging Bar
Automated labeling for XY-charts, inside the chart or adjacent table
Color-Driven Icons based on Excel fill or font color
Text-to-Image
Switch row/column
Hide Zero Values
'Sticky' colors: Maintain consistent e.g. brand colors, even after sorting
Table-based Axis Text Display with text formatting and alignment
Automatically remove 'zero' rows and/or columns

Customizable Infographics

Sliders
Filled Shapes
Conditional Shapes (e.g. Smiley)