Beyond Basics: Conditionals and Visualisation in Excel at UTS Online

Intersect is a pivotal part of Australian research landscapeWe provide robust, innovative services and collaborative technology to support world-class research at our member organisations and in the wider research communityIntersect delivers data storage, compute and analysis platforms, custom engineering, expert consulting and training programs to thousands of researchers every yearIntersect works closely with the ARDC (Australian Research Data Commons) built from ANDS, Nectar, and RDSIntersect is a member of the Software Carpentry Foundation, the NCI (National Computational Infrastructure) and the AAF (Australian Access Federation)

Intersect Australia

This course explores functional syntax and statistical charts in Excel.

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.
<ul>
	<li>Cell syntax and conditional formatting</li>
	<li>IF functions</li>
	<li>Pivot Table summaries</li>
	<li>Nesting multiple AND/IF/OR calculations</li>
	<li>Combining nested calculations with conditional formatting to bring out important elements of the dataset</li>
	<li>MINIFS function</li>
	<li>Box plot creation and outlier identification</li>
	<li>Trendline and error bar chart enhancements</li>
</ul>
<h3>Prerequisites:</h3>Familiarity with the content of Excel for Researchers, specifically: 

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

Beyond Basics: Conditionals and Visualisation in Excel at UTS Online

More events from Intersect Australia

Follow organisers to get events picked for you

Beyond Basics: Conditionals and Visualisation in Excel at UTS Online

More events from Intersect Australia

Follow organisers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.