More events like this...

 

Event box

Beyond Basics: Conditionals and Visualisation in Excel

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)

Exhibition: The Next Generation Project  In-Person

This exhibition showcases a series of collaborative artworks created through The Next Generation Project, an initiative of Western Sydney University Library and the Wellbeing and Belonging Team. This...  More
From:
8:00am, Wednesday, October 29, 2025
To:
5:00pm, Friday, December 12, 2025
Location:
Penrith Campus, Penrith
Audience:
  Undergraduate Students     Post-graduate students     Western staff     General Interest     Academics & researchers     Future students  
Categories:
  Community Events     First Nations Events  
Exhibition: The Next Generation Project 

Native Insect Crop Pollinator Diversity - Dr Amy-Marie Gilpin and Professor James Cook In-Person / Online

Around 75% of Australian crops benefit from pollination. Some — including most apple cultivars — can’t produce fruit without it. Most pollination is enabled by commercial hives and feral nests of the...  More
Date:
Wednesday, November 26, 2025
Time:
12:00pm - 1:00pm
Location:
Hawkesbury Campus, Hawkesbury
Audience:
  Post-graduate students     Western staff     General Interest     Academics & researchers  
Categories:
  Community Events     First Nations Events     Thought Leadership Events  
Registration Type:
In-Person Registration / Online Registration
Register! - 111 seats left
Native Insect Crop Pollinator Diversity - Dr Amy-Marie Gilpin and Professor James Cook

Academic Literacy Resources Community of Practice Online

Dear Western Sydney University Community, We would like to invite you to join the Western Sydney University Academic Literacy Resources Community of Practice (CoP). This CoP has emerged from the...  More
Date:
Thursday, November 27, 2025
Time:
3:00pm - 4:30pm
Audience:
  Undergraduate Students     Post-graduate students     Western staff     General Interest     Academics & researchers     New to WSU     Future students  
Categories:
  Community Events  
Registration Type:
Online Registration
Register! - 34 seats left
Academic Literacy Resources Community of Practice

Film Screening: Genocide in the Wildflower State In-Person / Online

Documentary 57 min 2024 (PG) Time and location TBC “My father and my mother never got the chance to be parents to me. I’m 66 years of age now and the only thing I can do to moving forward and to...  More
Date:
Thursday, December 11, 2025
Time:
1:00pm - 2:00pm
Location:
Parramatta South Campus, Parramatta Sth
Audience:
  Undergraduate Students     Post-graduate students     Western staff     General Interest     Academics & researchers  
Categories:
  Community Events     First Nations Events     Thought Leadership Events  
Registration Type:
In-Person Registration / Online Registration
Register! - 150 seats left
Film Screening: Genocide in the Wildflower State
No events are scheduled.