Skip to Main Content

More events like this...

 

Event box

Beyond Basics: Conditionals and Visualisation in Excel Online

This course will cover conditional syntax, nested functions, statistical charting and outlier identification. Armed with the tips and tricks from our introductory Excel for Researchers course, you will be able to tap into even more of Excel’s diverse functionality and apply it to your research project.

Learning Objectives

  • Cell syntax and conditional formatting
  • IF functions
  • Pivot Table summaries
  • Nesting multiple AND/IF/OR calculations
  • Combining nested calculations with conditional formatting to bring out important elements of the dataset
  • MINIFS function
  • Box plot creation and outlier identification
  • Trendline and error bar chart enhancements

Prerequisites:

Familiarity with the content of Excel for Researchers, specifically: 

  • the general Office/Excel interface (menus, ribbons/toolbars, etc.)
  • workbooks and worksheets
  • absolute and relative references, e.g. $A$1, A1.
  • simple ranges, e.g. A1:B5

Enquiries: Dr Jeff Wang

Register: https://www.eventbrite.com.au/e/beyond-basics-conditionals-and-visualisation-in-excel-at-wsu-online-registration-1849765952759

Date:
Friday, November 28, 2025
Time:
9:30am - 12:30pm
Time Zone:
Sydney, Melbourne (change)
Online:
This is an online event.
Event URL:
https://www.eventbrite.com.au/e/beyond-basics-conditionals-and-visualisation-in-excel-at-wsu-online-registration-1849765952759
Audience:
  Academics & researchers     Post-graduate students     Western staff  
Categories:
  Training Sessions  
Browse/Search for more events

Time Zone: Sydney, Melbourne (change)

Time Zone: Sydney, Melbourne (change)

Before You Submit: AI and Academic Integrity

In-Person
Location: Bankstown Library Worried you’ve leaned too much on AI for your assignment? Visit the library for a practical drop-in session where librarians show you how to review whether your...  More
Date:
Thursday, September 17, 2026
Time:
12:00pm - 2:00pm
Location:
Bankstown City Campus Library (Map ), Bankstown
Audience:
  Undergraduate Students     Post-graduate students     General Interest     New to WSU     Future students  
Categories:
  Training Sessions  
Registration Type:
In-Person Registration
Register! - 16 seats left
Assignment Checks: Have You Overused Generative AI?

Before You Submit: AI and Academic Integrity

In-Person
Location: Bankstown Library Worried you’ve leaned too much on AI for your assignment? Visit the library for a practical drop-in session where librarians show you how to review whether your...  More
Date:
Wednesday, September 30, 2026
Time:
12:00pm - 2:00pm
Location:
Bankstown City Campus Library (Map ), Bankstown
Audience:
  Undergraduate Students     Post-graduate students     General Interest     New to WSU     Future students  
Categories:
  Training Sessions  
Registration Type:
In-Person Registration
Register! - 19 seats left
Assignment Checks: Have You Overused Generative AI?

Before You Submit: AI and Academic Integrity

In-Person
Location: Bankstown Library Worried you’ve leaned too much on AI for your assignment? Visit the library for a practical drop-in session where librarians show you how to review whether your...  More
Date:
Thursday, October 15, 2026
Time:
12:00pm - 2:00pm
Location:
Bankstown City Campus Library (Map ), Bankstown
Audience:
  Undergraduate Students     Post-graduate students     General Interest     New to WSU     Future students  
Categories:
  Training Sessions  
Registration Type:
In-Person Registration
Register! - 20 seats left
Assignment Checks: Have You Overused Generative AI?