Create pivot tables/charts

You can use PIVOTTABLE function in Excel to create frequency or contingency tables. Select Data –> Pivot table and Pivot chart report… and follow the prompts.

This procedure is demonstrated in this video on how to Create Pivot tables (wmv) (16.8MB; 1.06min)

Further information about creating pivot tables/charts

Information about creating pivot tables/charts can be obtained from the following tutorials available on the Microsoft website: