Description:

After cleaning your database, 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.

You'll learn:

  • 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

For more information, please click here.

Start: Thursday, 01 August 2024 @ 09:30

End: Thursday, 01 August 2024 @ 12:45

Timezone: Sydney

 Country: Australia

Eligibility:
  • Host institutions

Organiser: Intersect Australia

Contact: training@intersect.org.au

Host institution: UTS

Beyond Basics: Conditionals and Visualisation in Excel at UTS Online https://dresa.org.au/events/beyond-basics-conditionals-and-visualisation-in-excel-at-uts-online-877d1985-4c49-400e-bc84-c59aa96a2a83 After cleaning your database, 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. #### You'll learn: - 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 **For more information, please click [here](https://intersect.org.au/training/course/excel201).** 2024-08-01 09:30:00 UTC 2024-08-01 12:45:00 UTC Intersect Australia Australia Australia UTS training@intersect.org.au [] [] [] host_institution []