Creating Tables

Select a empty cell in the workbook and click ‘Table -> Create Table’ or right-click the mouse in an empty cell click 'Create Table'. Before we start creating tables, there is a few things you should know about OfficeReports:

Table Layout

Important: Depending on the output you need, OfficeReports creates tables in either 'Reporting' or 'Analytics' layout. In case your final delivery is a PowerPoint presentation, make sure you use 'Reporting' layout.

You can change the 'Reporting Mode' (Analytics or Reporting) in 'General Settings -> Table Settings'. Read more about the Reporting Mode. Other table settings are defined in 'Layout -> General Layout Definitions'. Read more about Table Layout Settings.

Default Settings

Important: Save time creating tables by setting the correct default settings, so OfficeReports automatically uses the correct settings for the tables you create.

In the OfficeReports ribbon tab, click 'General Settings' and define e.g. a default Weight-variable and default statistics for ordinal variables. Read more about General Settings.

Some tables settings are used again and again when specific variables are used in the table banner. You can define default settings for these variables in the Data Editor by selecting the variable and clicking the 'Table Default Settings' button and specify settings like sorting and significance test.

Table Types

Using OfficeReports, you can create the following types of tables:

  • Frequency tables and Cross tables (crosstabs) - used for reporting a variable, maybe split by banner variable(s)
  • Grid tables - used for reporting many variables in the same table, maybe split by a banner variable
  • Aggregate tables - used for reporting questions asked multiple times (e.g. for different brands - first mentioned, second mentioned etc.)
  • Performance tables - used to report worst and best performance


After creating the table, OfficeReports will show the ‘Table Pane’ in Excel, where you now can adjust all settings for the table. Read more about the Table Pane.