Resources: Data

Intro to investigating health data using spreadsheets

This exercise is designed to give you an introduction to using Excel spreadsheets to make some basic calculations to find patterns and trends in health data. Spreadsheets are available to download so you can work step-by-step through the tutorial. The illustrated guide includes a glossary of terms, best practices when working with data, calculating differences, rates and ratios, percentages, using functions, filtering data and creating charts.