The links below are to PDF files describing how to analyse Health data using Excel. The version 2010 notes will work with Excel 2007 and the 2003 notes are for those still using that version. There are some videos (no audio track) of how to get started with Excel and enter data at the bottom of this page.
Versions
2010
- Entering Data into Excel
- Manipulating Cells & Worksheets
- Formulae, Functions and Cell References
- Pivot Tables
- Charts 1 and Charts 2
- Statistical Analysis Capabilities of Excel
- Organising Workbooks
2003
- What is a Spreadsheet?
- Adjusting the layout
- Naming Cells, Worksheets and Autofill
- Formulas, Cell References, Functions
- Charts
- Printing in Excel
- Organising Workbooks
- Pivot Tables
- Statistical Analysis Tools
- Appendix
iSolutions Excel documentation