Resources to help in using Excel for statistical work
Should Excel be used for statistical analysis?
Resources
Some of these materials were developed with the help of funding from sources that include the University of Reading Teaching and Learning Development Fund and DFID.
- The SSC's Excel Add-In for statistical work: Online Help | Tutorial (PDF) | Download SSC-Stat | Help File | Guides
- SSC Courses on Excel and Statistics
- Statistical seminars at the University of Reading
- Slides from seminar on 'Good Statistics with Excel' (PowerPoint)
- Guides:
- Using Excel for Statistics - Tips and Warnings (PDF)
- Disciplined Use of Spreadsheet Packages for Data Entry (PDF)
- The Role of a Database Package for Research Projects (PDF)
- Guidelines for Good Statistical Graphics with Excel (PDF)
- Good Tables for Excel Users (PDF)
- Colin Grayer's Tutorial on Writing Macros
- Example spreadsheets:
- Training notes from the
University
of Reading IT Services (restricted access)
- Microsoft Excel 2003 - A Beginners' Guide
- Microsoft Excel 2003 - An Intermediate Guide
- Microsoft Excel Hints and Tips
- Adding Comments in Microsoft Excel 2003
- Cell Formats and Styles in Microsoft Excel 2003
- Cell Validation in Microsoft Excel 2003
- Dealing with Dates and Times in Microsoft Excel 2003
- Extending a Series and Creating a Custom List in Microsoft Excel 2003
- Getting Data using MS Query in Microsoft Excel 2003
- Goal Seek and Solver in Microsoft Excel 2003
- Iteration and Animation in Microsoft Excel 2003
- Setting Options and Customising Microsoft Excel 2002
- Setting Security in Microsoft Excel 2003
- Some Useful Functions in Microsoft Excel 2003
- Sorting in Excel 2003
- Splitting Windows and Fixing Panes in Microsoft Excel 2003
- Templates in Microsoft Excel 2003
- Using Filters in Microsoft Excel 2003
- Using Forms in Microsoft Excel 2003
- Using Pivot Tables in Microsoft Excel 2003
- Writing Macros in Microsoft Excel 2003
- ASSUME resources
For queries about these resources, contact Sandro Leidi or Roger Stern
Last updated 18 February, 2009