Data Analysis and Visualisation Training using Microsoft Excel

Traditional training – (3 days, R9,000.00 Excl. VAT)
Online training – (3 weeks, R7,500.00 Excl. VAT)

About This Course

The ability to analyse and present data in a meaningful way is an essential skill for researchers and data analysts of all disciplines. Microsoft excel is one of the most popular analytical and visualization tools which is used in the day to day functioning of many organisations. Excel provides a platform to perform simple analysis by sorting, filtering, using formulas. It also has powerful tools such as pivot tables and data analysis toolpak for more complex analysis.

Many organisations and institutions are embracing the world of brilliant data visualisation to present data in a more attractive, meaningful and easy to digest manner. Because Microsoft Excel is a software many organisations already use, this course will enable participants to maximise their use of a tool they already have and improve their data analysis and visualisation.

Course Content


Day 1 - Learn to Use Excel

  • Data collection methods
  • Understanding variables to datasets
  • Exploring the capabilities of Excel
  • Learning to use Excel
  • Organising data
    Variable formats: number, string, dates and others
    Ranges and tables
    Sorting and filtering
    Working with functions

Day 2 - Data Analysis: Descriptive statistics and Subgroup analysis

  • Introduction to descriptive statistics
  • Making sense of data using Excel
  • Stratified analysis

Day 3 - Data visualisation

  • Review of Excel graphs
  • Pivot charts
  • Building interactive dashboards

Course outcomes

The course will teach participants the following:

After the training, participants will achieve the understanding of descriptive statistics, stratified analysis and hypothesis testing. As a result, they will be able to take raw data and organize and analyse them efficiently. They will also be able to critically review research reports and papers. In essence, participants will be able to use excel optimally, making meaning of raw data and presenting them in a creative and easy to digest manner.

Who Should Attend?

  • Researchers
  • Biostatisticians
  • Research analysts
  • Data analysts
  • Economists
  • HODs
  • Clinicians
  • Epidemiologist
  • Programme managers
  • Postgraduate students
  • Market researchers
  • Clinical and medical researchers
  • Scientists
  • Government practitioners


For more details about our services contact:

Dave Temane
Tel: +27 11 403 1411

Price Includes

  • Course attendance
  • Full refreshments: lunch
  • Welcome tea
  • Two breaks for tea including pastries
  • Course lecture notes and training manual
  • Complimentary parking
  • Certificate of attendance

Application for Traditional Training

Click to confirm

8 + 13 =

Application for Online Training

Click to confirm

1 + 6 =