Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Postgraduate Online Training: Microsoft Office Training

This guide provides step-by-step training, working through the various stages of the research cycle, to develop and improve the necessary skills to complete your research.

Quick Tips

Check out our quick tips videos:

  • Tip: Use the correct heading styles and automated numbering in MS Word

 

Microsoft Excel

MS EXCEL: A Researcher's basic guide (Part 1) (2020)

by Malebo Makunyane

MS EXCEL: a researcher's guide to Basic Data Analysis (Part 2)

by Malebo Makunyane

This presentation by Malebo Makunyane is designed for researchers using Excel for basic data analysis. In this training video you will work along with Malebo, as she takes you through basic data analysis using the example of weekly COVID-19 cases.

What you will learn in this video:

  1. Data Cleaning- Filtering and removing duplicate records
  2. Excel built in functions:
  • SUM
  • ROUND
  • AVERAGE
  • MEDIAN
  • COUNT
  • IF, COUNTIF, and COUNTIFA
  • Standard deviation, min and maximum value
  • ANOVA
  • PIVOT tables

Download the exercise files below: 

MS EXCEL: Data Visualization with MS Excel (Part 3)

by Malebo Makunyane

In this training video you will be guided through the following:

  1. Plotting graphs/charts in Excel
  2. Identifying which graphs to use for different scenarios
  3. From pivot tables to pivot charts
  4. Formatting and customising graphs

Microsoft PowerPoint