This series of spreadsheet tutorials for excel 10, from the Howard Hughes Medical Institute, work through a range of spreadsheet functions that can be used when analysing data.
Each tutorial contains detailed instructions and a series of exercises to work through. The tutorials start with some of the more basic spreadsheets functions, eventually building up to performing t-tests and creating histograms. The five tutorials cover:
- Formulae, functions and averages
- Auto-fill, cell reference and standard deviation
- Graphs, error bars and standard error of the mean
Show health and safety information
Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.