Purposes and learning outcomes
- To know how to import SPSS data sets and outputs into MS Excel 2007
- To introduce data handling and data analysis using MS Excel 2007
- To explore some advanced features of data presentation in MS Excel 2007
- Microsoft Excel 2007: Basics
- Making Analyses and Presenting Outputs in MS Excel
- Tips and Exercises
Note:In this module, Microsoft Office Excel 2007 has been used as an example software to show how the presentation of outputs from SPSS can be improved.The two main reasons for using Microsoft Office Excel 2007 are:
- Excel is available in many education offices and many people are already familiar with its features and functions.
- Excel can handle data sets/databases in other formats, including SPSS data sets, which makes it a useful tool for formatting and presenting data from a variety of sources.
Similar results can be achieved by using other statistical analysis software and spreadsheet software. Please feel free to use whichever statistical analysis software and spreadsheet software you own and are familiar with.
Microsoft Excel 2010 was launched in June 2010. If you are using Excel 2010, some of the features and methods may be different to those presented here. Please consult your user manual for the most up-to-date instructions about how to achieve the desired results.