About Us

Group Members / Profiles

Professor Christi Deaton

Dr Stephanie Tierney

Michael Connolly

Mary Dodd

Tarnya Hulme

Stephen Woods

Events

Forthcoming

Past

Funding Opportunities

Projects

Audit

Research


TrusTECH

Resources

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