More events like this...

 

Event box

Beyond Basics: Conditionals and Visualisation in Excel at WSU Online

Beyond Basics: Conditionals and Visualisation in Excel at WSU Online Online

After cleaning your dataset, you may need to apply some conditional analysis to glean greater insights from your data. You may also want to enhance your charts for inclusion into a manuscript, thesis or report by adding some statistical elements. 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.

  • 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: Jeff Wang

Register here

Date:
Wednesday, November 27, 2024
Time:
10:00am - 1:00pm
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-1047623860167
Audience:
  Academics & researchers     Post-graduate students     Western staff  
Categories:
  Training Sessions  
Browse/Search for more events

Time Zone: Sydney, Melbourne (change)

Exhibition: Turtles - A Species under Threat In-Person

This exhibition showcases the work of Western Sydney University’s Dr Ricky Spencer, Associate Professor of Ecology in the School of Science and Health and a School-based member of Hawkesbury...  More
From:
8:00am, Friday, June 27, 2025
To:
5:00pm, Monday, July 14, 2025
Location:
Penrith Campus Library, Penrith
Audience:
  General Interest  
Categories:
  Community Events  
Exhibition: Turtles - A Species under Threat

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:
Friday, July 4, 2025
Time:
12:00pm - 1: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! - 9 seats left
Academic Literacy Resources Community of Practice

Library Tours In-Person

At Western Sydney University Library, we’re here to support you throughout your academic journey. Discover a wide range of resources, services, and study spaces to help you succeed at...  More
Date:
Sunday, July 6, 2025
Time:
11:00am - 3:30pm
Location:
Parramatta South Campus
Audience:
  Undergraduate Students     General Interest     New to WSU     Future students  
Categories:
  Community Events     Future Students     Student Activities     Activity  
Library Tours

Library Tours In-Person

Visit the Library during Welcome Week to explore how we can support your assignment writing, study, and research skills. Easily access readings and resources, explore a variety of study spaces, and...  More
Date:
Tuesday, July 15, 2025
Time:
11:00am - 3:00pm
Location:
Parramatta Sth Campus Library, Parramatta Sth
Categories:
  Community Events     Future Students     Student Activities     Activity  
Registration Type:
In-Person Registration
Register! - 297 seats left
Library Tours

Time Zone: Sydney, Melbourne (change)

Literacy for LANTITE Workshop: Strategies to Prepare In-Person

Location: BK-1.1.31 Do you want to be a teacher in the future? You need to complete the Literacy and Numeracy Test for Initial Teacher Education (LANTITE) in order to work as a teacher in...  More
Date:
Tuesday, July 15, 2025
Time:
12:00pm - 1:00pm
Location:
Bankstown City Campus, Bankstown
Audience:
  Undergraduate Students     Post-graduate students     Western staff     General Interest     Academics & researchers     New to WSU     Future students  
Categories:
  Training Sessions  
Registration Type:
In-Person Registration
Register! - 32 seats left
Literacy for LANTITE Workshop: Strategies to Prepare

Think! Question! Evaluate! Generate new ideas In-Person

Are you ready to sharpen your critical thinking skills and learn how to evaluate ideas? Join us for "Think! Question! Evaluate! Generate new ideas," where you'll learn essential techniques to enhance...  More
Date:
Tuesday, July 22, 2025
Time:
5:00pm - 6:30pm
Location:
Bankstown City Campus, Bankstown
Audience:
  Undergraduate Students     Post-graduate students     Western staff     General Interest     Academics & researchers     New to WSU     Future students  
Categories:
  Training Sessions  
Registration Type:
In-Person Registration
Register! - 27 seats left
Think! Question! Evaluate! Generate new ideas

How to write an essay at uni In-Person

Struggling with essay writing at university? This workshop, "How to Write an Essay at Uni," will cover the essential structure and process of crafting a well-organized essay. You’ll learn the key...  More
Date:
Wednesday, August 20, 2025
Time:
10:00am - 11:30am
Location:
Bankstown City Campus, Bankstown
Audience:
  Undergraduate Students     Post-graduate students     Western staff     General Interest     Academics & researchers     New to WSU     Future students  
Categories:
  Training Sessions  
Registration Type:
In-Person Registration
Register! - 46 seats left
How to write an essay at uni

Think! Question! Evaluate! Generate new ideas In-Person

Are you ready to sharpen your critical thinking skills and learn how to evaluate ideas? Join us for "Think! Question! Evaluate! Generate new ideas," where you'll learn essential techniques to enhance...  More
Date:
Wednesday, August 20, 2025
Time:
1:00pm - 2:30pm
Location:
Bankstown City Campus, Bankstown
Audience:
  Undergraduate Students     Post-graduate students     Western staff     General Interest     Academics & researchers     New to WSU     Future students  
Categories:
  Training Sessions  
Registration Type:
In-Person Registration
Register! - 49 seats left
Think! Question! Evaluate! Generate new ideas

How to write a report at uni In-Person

Struggling to keep up with your academic reading? Join us for "Academic Reading: Making the Most of Your Time and Resources," where you'll learn effective techniques to enhance your reading skills...  More
Date:
Wednesday, August 20, 2025
Time:
2:30pm - 4:00pm
Location:
Bankstown City Campus, Bankstown
Audience:
  Undergraduate Students     Post-graduate students     Western staff     General Interest     Academics & researchers     New to WSU     Future students  
Categories:
  Training Sessions  
Registration Type:
In-Person Registration
Register! - 49 seats left
How to write a report at uni