Excel Essentials: Real-World Data Skills
Session overview
Excel is everywhere in health and research but it can be difficult to know where to start and easy to make mistakes.
This hands‑on session will help you build confidence with real-world data: structuring spreadsheets, avoiding common mistakes, and using Excel’s built‑in tools to analyse and visualise your results.
No prior Excel or research experience required.
By the end of the session, you’ll know how to:
- Identify and avoid common Excel pitfalls that lead to errors
- Set up a clean, well‑structured dataset for analysis
- Use a small set of core formulas to summarise data
- Create and interpret a pivot table to quickly analyse data
- Build a simple, clear chart to communicate findings
You’ll also get a realistic dataset to practise spotting issues and applying these skills.
DATE
Wednesday 5th August 2026, 3:00pm-4:00pm (AEST)
Location
Microsoft Teams - Once you have registered the meeting link will be provided in the confirmation email and calender invitation.
** Please note: All seminars are recorded and will be posted to the RR-CLaN YouTube channel after the session. If this seminar interests you, please register—even if you cannot attend live—as you will receive an email notification when the recording is available, along with any resources shared during the session.
About the PresenterS
Daniel Barry is a data analyst working for Northern NSW Local Health District. Daniel is a biostatistician and a graduate of the NSW Health Biostatistics Training Program. He has worked on a range of projects within health and currently works within value-based care.
Gen O’Neill is an epidemiologist at the Australian National University. She is a critical care nurse and a graduate of Australia’s Field Epidemiology Training Program (Master of Applied Epidemiology). Her work spans critical care research, pandemic preparedness, and communicable diseases.
Who are the Rural Research Collaborative Learning Network (RR-CLaN)?
The RR-CLaN is a rural led initiative that aims to provide high-quality research education and training to healthcare staff working in rural, regional and remote areas. Our aim is to provide you with the education and training opportunities to build key skills in how to use and undertake research to improve healthcare delivery.
RR-CLaN collaborators:
NSW: Central Coast Local Health District; Far West Local Health District; Hunter New England Local Health District; Illawarra Shoalhaven Local Health District; Mid North Coast Local Health District; Murrumbidgee Local Health District; Nepean Blue Mountains Local Health District; Northern New South Wales Local Health District; Southern New South Wales Local Health District; Western New South Wales Local Health District; Health Education and Training Institute (HETI).
QLD: Tropical Australian Academic Health Centre (TAAHC); Darling Downs Hospital and Health Service; Wide Bay Hospital and Health Service; Queensland Rural Health Innovation and Research Collaborative (QRHIRC) which includes South West Hospital and Health Service.