Spreadsheets: An introduction to working with statistics

  • Excel Logo course pack | Publicly viewable | v. 2010

This introductory course covers some basic statistical concepts and is intended for staff who need to use statisitical information in their work but may also be useful for research staff who want to refresh their knowledge of simple statistics. It enables learners to apply these concepts in a spreadsheet environment using Excel. Topics covered by the course include:

Different types of average

Looking at variability in data

Summarising and charting data 

The course is a good preparation for more detailed courses in specific areas such as pivot tables and charts