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.