Features
Explore all the features
InfoGraphics

- Link an Excel range to a native PowerPoint Table, Chart or Shape
- Links the content of the range
- Optionally, link the font and/or the background color
- Automatically use logos instead of texts
- Use icons instead of background colors
- Use significance characters from a cell
- 'Sticky' colors
- Spread over multiple slides
- Link a variable number of rows/columns
- Update all links in the presentation
- Update all links on a slide
Import

- Import Excel data
- Import SPSS data
- Import TripleS data
- Connect to SurveyMonkey Survey
- Connect to SurveyGizmo Survey
- Import multiple datasets
- Merge datasets
Variables
- Category variables
- Numeric variables
- Date variables
- Text variables
- Aggregate Variables
- Assign a Value to categories (for mean calculation etc.)
- Group Variables
- Derived Variables: Create intervals, combine categories using and/or/not etc.
- Advanced Formula Editor
Data View
- View data in a grid (like Excel)
- Edit data
- Filter data for better overview
- Sort data for better overview
- Export raw data to Excel
- Export raw data to SPSS
Tables
- Observations, Percent or both
- Grid tables with observations, percent and mean
- Base, Total, Mean and Std. deviation
- Std. Error, Median, Minimum and Maximum
- Filtering
- Weighting
- Pearson Correlation
- T-Test (Student or Welch)
- Z-test
- Significance tests using unweighted base or effective base
- Benchmarking
- Ignore report filter
- NPS
- NET categories
- Top/Bottom N reporting
- Customizable layout (see Layout)
- Tables are interactive!
Charts

- Observations, Percent
- Base, Total, Mean and Std. deviation
- Gridcharts with observations, percent or mean
- Benchmarking
- Filtering
- Same statistics as Tables
- Ignore report filter
- Weighting
- Top/Bottom N reporting
- Chart are interactive!
Layout
- Define your own table and chart types
- For tables: define lines, colors and fonts
- For charts: use Excel chart templates
- Use Macros (can also change content of table/chart!)
Collaborate

- Just email the files to colleagues. It will work.
Reuse the report definition

- Define a report filter
- Generate many reports using different filters
- Save report as a template
Advanced Statistics

- Define benchmark variables
- Calculate respondent weights. OfficeReports uses RIM weighting, and can weight over many dimensions
- Weight tables/charts using weights calculated by OfficeReports or a numeric variable
- Create frequency tables with confidence interval
- Chi Square
- Student's Z-Test (Column Proportions)
- Welch's Z-Test (Column Proportions)
- T-Test (Column Means)
- Test using effective base or unweighted base
- Correlation
Productivity

- Insert many tables and charts in one step
- Create new table/chart using settings from the last defined one
- Just Copy and Paste a table/chart and edit it.
- Reuse the report (See above)