The OfficeReports ribbon tab in Excel
The OfficeReports ribbon tab in Excel

The Data Editor

Just like in SPSS, our Data Editor consists of a Variable View and a Data View. However, our user interface is much more up-to-date and easy to navigate, containing smart functionality for fast recoding of the variables, without the need of syntax files. OfficeReports will merge and group of variables and categories, create periods from dates and intervals from numeric variables - automatically. You can create new variables manually as well and use our formula editor to create what you need.

By selecting just a few variables in the Variable View, the Data View will only show the selected variables. This is extremely helpful when you need to check to see if your re-codes are correct.

Creating Cross-Tabs

OfficeReports has a whole host of features to make fast table creation possible. By setting the right report setting and the right 'table default settings' for specific variables, you can enable OfficeReports to create the right tables immediately, without needing to change settings. Combined with functionality like 'Insert Many Tables' and 'Create Crosstab Report' you are able to create large reports in minutes.

Tables are created directly in Excel, and can be edited using our 'Table Pane', which contains all the properties of the table.

You can define your own layouts so tables look the way you want.