Introduction

OfficeReports is an add-in for Microsoft Office®, which turns Microsoft Office into a complete data analysis and reporting suite for survey data. The add-in contains 2 products:

OfficeReports Analytics enables you to add and analyze data and create tables, charts and complete reports in Excel.

OfficeReports Automation includes OfficeReports Analytics and will besides all Analytics functionality also enable you populate infographics in PowerPoint (tables, charts, shapes, images, text sections, etc.) based on the results in Excel workbooks. All your work is reusable, making OfficeReports Automation a perfect tool for mass-generation of reports and for reporting tracking surveys.

 

This is what the OfficeReports ribbon tab in Excel looks like:

 

What makes OfficeReports different from other crosstab- and reporting tools?

1. OfficeReports is an integrated part of Microsoft Excel and PowerPoint

This gives access to ALL the functionality of Microsoft Office as an integrated part of the reporting. No other tool can give you this advantage. You can e.g. use it to add conditional formatting to your tables (heatmaps) in Excel or to add animations to your PowerPoint report. The animations will still work after updating the report with new data.

2. Analytics & Reporting Mode

There is a difference between doing data analysis and doing data reporting. To make the reporting more easy, we have introduced a 'Reporting Layout' type for tables and you have to choose if you want to work in Analytics or in Reporting mode. Read more here.

3. Fast Creation Tables

By defining 'table default settings' for variables it is possible to create e.g. a sorted table with a Z-Test comparing all columns to the first column without having to make any setting, saving lot's of time. Using 'Add Many Tables' lots of tables can be created at once.

4. The Filtering System

Using OfficeReports it is possible to define multiple filters on different levels: the report level, the category level (table column) and the table level . Besides settings these filters, they can be ignored as well on the other levels. This way we can add benchmarks to tables and can make tables ready for mass-generation of reports. Read more here.

5. Report Builder

Thanks to the Filtering System and the Reporting Table Layout we have been able to create a Report Builder, which can both create new slides or populate existing slides. This is done by generating the needed tables in Excel and automatically link them to the tables and charts in PowerPoint. The result is an automated report template, ready to be updated with new data. Read more here.

6. Support for Tracking Survey reporting

Populating tables, charts and shapes in PowerPoint with ranges from our tables in Excel is a powerful way to create reporting templates. When we have created the automated report template, we can update the reports with data from the next wave in minutes. Read more here.

7. Repetitive Reports

When we have created the automated report template, we can mass-generate reports using a different filter for each report. Read more here to generate the workbooks we need, and here to see how to mass-generated presentations from these workbooks.

 

Our support is FREE!

Our support is free, so don't hesitate to contact us in case you have any questions! Just send an email to helpdesk (at) officereports (dot) com or fill out this form.

 

Happy reporting!

The OfficeReports Team, 2020