Microsoft Excel and Metrics Reporting Skills in Research and Clinical Trials

There are four workshop types to suit different skill levels, from beginner to advanced. They are designed to further develop day-to-day skills required to successfully support business management responsibilities in a unit, as well as higher-level reporting on clinical trial metrics.

Our online workshops are capped at small numbers to ensure interactivity and tailoring. You are encouraged to bring along queries and/or examples from your experience in your unit.

Facilitated by Andrew Chong from SimplyThat Training, several dates are available for each workshop. You are welcome to enrol in all three as a series, or pick a workshop most relevant to you.  

1. Introduction and Intermediate Microsoft Excel 

This 4-hour online workshop will prepare participants to understand the fundamentals of Microsoft Excel. They will learn to create a worksheet from scratch, implement formats and adjustments, create formulas and basic charts and graphs from their data. 

Dates: Thursday 11 April, Thursday 2 May, Wednesday 15 May 

Time: 9.00am–1.00pm 

Register here

2. Intermediate and Advanced Microsoft Excel 

This 4-hour online workshop will be the next step from Introduction and Intermediate Microsoft Excel, where participants will further advance their skill sets. Participants will learn how to create datasets, create complex formulas, automate steps using macros and learn to use essential financial tools.  

Dates: Wednesday 17 April, Friday 10 May, Thursday 6 June 

Time: 9.00am–1.00pm   

Register here

3. Charts and Pivot Tables 

This 4-hour online workshop will improve participants' skills on creating complex charts and graphs to best suit their datasets. Participants will then learn how to summarise their dataset into a table using Pivot Tables. Participants will learn how to create a pivot table from scratch, refresh it when new data has been recorded, and how to include several pivot tables into their spreadsheet. This workshop is for participants who are confident with Intermediate Excel skills.  

Dates: Thursday May 23, Wednesday 12 June 

Time: 9.00am–1.00pm 

Register here

4. PowerBI  

This online course will run based on received interest. Participants will require robust understanding of Excel (Introduction - Advanced) as well as Charts and Pivot Tables. To register your interest, please contact Eleonora Kay at [email protected]

Get the most out of your workshop

Please ensure you are confident with the content and skills covered in the workshop’s prior level. You will require two monitors (or laptop plus monitor) and an internet connection to participate in these online workshops.

View course outlines

Further Learning

This workshop series forms part of the larger work in the Clinical Trial Innovations portfolio to upskill the clinical trials workforce. Other resources that are available include:

• Business Skills for Clinical Trial Research Managers: A tailor-made course created by current research managers and clinical trial staff covering the content they wish they knew when they began their roles. It covers: hospital finance, feasibility in clinical trials, insurance, contracts and agreements, budgeting a single clinical trial, budgeting a clinical trial unit, staffing a clinical trial unit, and business negotiations. It is hosted on the VCCC Alliance’s Centre for Cancer Education.
  
  
• Clinical Trial Metrics “Cheat Sheet” Tool: Clinical trial metrics are data points that provide insight into operational performance and are powerful tools for assessing progress, decision-making, and measuring the strength of evidence used in clinical trials. Leveraging the National Clinical Trials Governance Framework, and incorporating business and quality improvement metrics, a Minimum Data Set resource and accompanying guidance booklet has been developed by the VCCC Alliance to provide a benchmark to help Clinical Trial Units and departments determine their reporting requirements.

If you have enquiries or would like to chat about the best workshop for you, please e-mail [email protected]