ABSTRACT NUMBER - 27

CLINICAL AUDIT ANALYSIS USING EXCEL


Meeting:  2016 RANZCO


SESSION INFORMATION

Date: 20 Nov 2016

Session Title: RANZCO Professional Development Session

Session Time: 4:00 pm - 5:30 pm

RANZCO Director, Dr Sam Lerts will explain how Microsoft Excel is a useful tool to analyse information exported from clinical audit tools or electronic medical records software, or data collected directly in Excel. This session will enable you to use advanced features of Excel to facilitate data analysis and enhance your ability to identify opportunities to improve your practise. This session will enable you to:

• Use excel formulas including sum/subtraction, percentages, average, count;
• Combine excel formulas;
• Use data validation to standardise data entry in Excel;
• Use PivotTables for data analysis; and
• Create charts to provide visual representations of your data.