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
Application
For more details about our services contact:
Dave Temane
Email: info@cesar-africa.com
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
