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.
Thank you for your interest in this workshop series to date. The series will be wrapping up in June.
1. Introduction and Intermediate Microsoft Excel
(THIS COURSE HAS ENDED)
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.
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 19 June
Time: 9.00am–1.00pm
Register here
3. Charts and Pivot Tables
(THIS COURSE HAS ENDED)
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.
4. Introduction to PowerBI
This online course is a full-day introduction to PowerBI. It is available for participants who have:
- Attended the Microsoft Excel Pivot Tables and Charts workshop in this series and are proficient in Excel at the Introduction and Intermediate levels: you can review your skills here.
- The full, paid-version of PowerBI (Desktop version) installed on your PC or laptop and have the correct user access (please note: this is different from the online version). You may need to contact your IT department to assist you with installation and access. In addition, you must be able to join the online training with two monitors (e.g. laptop and desktop, or two monitors).
In this session, participants will learn to:
- Use the Power BI desktop program and understand the various views of Power BI, including Report View, Table View, and Model View
- Connect to data sources with Power BI Desktop via MS Excel or other data sources
- Create and work with visualisations, including charts, tables, and matrices
- Create a report with visualisations as a dashboard page
- Create Slicers for users to filter information
- Modify and customise visualisations
- Work and maintain data via the Model view
- Transform, format and sanitise data via the Model view
- Use the Query Editor to create simple calculated fields known as DAX (Data Analysis Expression)
- Manage relationships within multiple tables to create to create tables using fields from multiple tables
- Create and manage report pages
- Change report view options
- Filter visualisations on a report page vs. all pages (and linking to multiple pages if required)
- Add static objects to a report such as logos, titles and text boxes
- Create other visualisations such as cards, gauges, and KPI
- Publish a Power Bi via Teams for other users to view the report
Date: Friday 28 June, 9.00am–4.00pm
To reserve a spot or get on the waitlist, 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.
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 would like to chat about the best workshop for you, please e-mail [email protected]
