Link

  • 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

  • 'Sticky' colors

  • Update all links in the presentation

  • Update all links on a slide

Import

Import
    • Import Excel data
    • Import SPSS data
    • Import TripleS data
    • Connect to SurveyMonkey Survey
    • Import multiple datasets
    • Merge datasets

Variables

Variables
    • Category variables
    • Numeric variables
    • Date variables
    • Text variables
    • coming soon: Time variables
    • Derived Variables: Create intervals, combine categories using and/or/not etc.
    • Advanced Formula Editor

Data View

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

Tables
    • Observations, Percent or both
    • Grid tables with observations, percent or mean
    • Base, Total, Mean and Std. deviation
    • Benchmarking
    • Filtering
    • Significance tests
    • Ignore report filter
    • Weighting
    • Top/Bottom Box (NET)
    • Top/Bottom N reporting
    • Customized table layout (see Layout)
    • Edit defined table

Charts

Charts
    • Observations, Percent
    • Base, Total, Mean and Std. deviation
    • Gridcharts with observations, percent or mean
    • Benchmarking
    • Filtering
    • Significance tests
    • Ignore report filter
    • Weighting
    • Top/Bottom N reporting
    • Customized chart layout (see Layout)
    • Edit defined chart

Layout

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

Collaborate
  • Just email the files to colleagues. It will work.

Reuse the report definition

Reuse the report definition
    • Define a report filter
    • Generate many reports using different filters
    • Save report as a template

Advanced Statistics

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

  • Z-Test (Column Proportions)

  • T-Test (Column Means)

  • Correlation

Productivity

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)