About Us

Group Members / Profiles

Professor Christi Deaton

Dr Stephanie Tierney

Michael Connolly

Mary Dodd

Tarnya Hulme

Stephen Woods




Funding Opportunities






Glossary of Terms

Useful Links

Key Documents

MERG logo

Audit Projects

Using Excel to Analyse Audit Data A Basic Introduction

The following Word document was written for a training session that members of MERG ran in January 2009. The Excel dataset created for this session is also provided. The booklet runs you through a series of tasks using the dataset and Excel. You can use these resources to learn how Excel can help with basic analysis for audits.

Data Analysis using Excel Crib Sheet Data Analysis using Excel 
 Crib Sheet 
  Adobe PDF Document
Data Analysis using Excel Example Data for use in Excel Tasks Data analysis using Excel 
 Example Data for use in Excel Tasks.xls 
  Microsoft Excel Document

Audit on Pulse Oximetry Audit on Pulse Oximetry 
 Adobe PDF Document

Audit on Cystic Fibrosis and Pregnancy Audit on Cystic Fibrosis and Pregnancy 
 Adobe PDF Document

Get Adobe Reader