Data Analysis and Visualisation Training using Microsoft Excel

All 3 days only R8,000.00 (Excl. VAT) per delegate

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

i

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
i

Day 2 - Data Analysis: Descriptive statistics and Subgroup analysis

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

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

Registration

For more details about our services contact:

Rose More
Email: [email protected]
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

Register for Traditional Training

Click to confirm

7 + 10 =

Register for Online Training

Click to confirm

12 + 4 =

Contact Us

Click to confirm

14 + 4 =

Call Us

+27 11 403 1411
+27 67 937 0310

Visit Us

Harrow Court 2, 1st Floor, Isle of Houghton, 36 Boundary Rd, Houghton Estate, 2041, South Africa.