Interactive cross-tabs

OfficeReports Analytics adds a complete cross-tab tool in Excel. It can import data from i.a. Excel and SPSS or it can connect to your SurveyMonkey and SurveyGizmo surveys. Analytics let's you create interactive banner tables (cross-tabs). Advanced Statistics like T-Test, Z-test and Pearson correlation are available. The 'Analytics Pane' becomes visible as soon as you add a table, or when you click in a cell of an existing table. In the pane, all the features are available so you can change the table any time you want. Click on the picture on the right to see a screenshot showing the same table in 2 different layouts.

Chart with base and significance info
Chart with base and significance info


See how OfficeReports can increase your productivity:

  • OfficeReports Analytics let's you create a single table at the time, or generate many tables at once.
  • All tables are interactive and can be changed and updated at any time.
  • You can copy a sheet and define a new filter for all tables on the copied sheet
  • You can start creating the tables even before all data is collected. Just import the missing data later, click the Refresh button and the whole report is updated with the new data.

Pivot Table/Chart

The ordinary Excel PivotTable is lacking a lot of statistical functionality in those cases where we are dealing with samples. OfficeReports Analytics adds not only significance tests, but for example also weighting and low base notation. Adding OfficeReports Analytics to the already extensive analytics capacities of Excel itself, makes Excel a very powerful cross-tab tool for Market Research.


Some of our happy customers