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