Data Analytics with Excel for Beginners

Wishlist Share

About Course

This is a live online cohort course. You will attend scheduled live classes with an instructor, complete a final project, and receive a certificate of completion after meeting the course requirements.

Classes are live and are not recorded unless expressly stated otherwise. Please make sure you can attend the scheduled sessions before enrolling.

Microsoft Excel is the most widely used data tool in South African businesses – and knowing how to use it for data analysis is one of the most in-demand skills in the workplace today. This 2-week live cohort teaches you how to organise, clean, analyse and visualise data using Excel. You will work with real datasets, build practical dashboards and learn how to turn raw data into clear, actionable business insights.

This course provides education and practical frameworks. It does not guarantee employment, promotion or business results. Results depend on your practice, application and individual circumstances.

This is a live cohort course

  • Format: Live Google Meet classes with an instructor
  • Duration: 2 weeks live classes (7 Sep – 18 Sep 2026) plus 1 week for the Final Project (due 25 September 2026)
  • Live Classes: 6 (3 per week – Mon, Tue, Fri)
  • Sessions: Early Morning 07:00–09:00 or Late Evening 20:30–22:30 SAST
  • Project: Final Excel Data Analysis Report due Friday, 25 September 2026
  • Certificate: Non-accredited certificate of completion
  • Recordings: No recordings unless stated
Show More

What Will You Learn?

  • Navigate the Microsoft Excel interface confidently and set up a proper data structure
  • Identify and fix common data quality problems including duplicates, blanks, formatting errors and inconsistencies
  • Apply core Excel functions for summarising and analysing data including SUMIF, COUNTIF, VLOOKUP, XLOOKUP and IF statements
  • Use Pivot Tables to summarise and explore data from multiple angles without writing formulas
  • Create professional charts and choose the right chart type for each data story
  • Use conditional formatting to highlight trends, outliers and performance thresholds
  • Build a dynamic, interactive Excel dashboard combining Pivot Tables, charts and slicers
  • Write a clear data analysis summary with business insights and recommendations
  • Present data findings confidently to a business audience
  • Apply Excel data analytics skills to real workplace and business scenarios

Course Content

Orientation
Welcome to the live cohort. Learn how live classes work, understand the final project and certificate requirements, and prepare your tools before Live Class 1.

  • Welcome to Data Analytics with Excel for Beginners
  • How Live Google Meet Classes Work on EduMzansi
  • Final Project and Certificate Rules
  • Excel Readiness Checklist

Week 1: Excel Foundations, Data Organisation & Core Analysis
Build a solid Excel foundation, learn to organise and clean data properly, and use core analysis functions to extract meaningful insights from a dataset.

Week 2: Pivot Tables, Charts, Dashboards & Insights
Use Pivot Tables and charts to summarise data, build an interactive Excel dashboard and present your analysis as clear, actionable business insights.

Final Project & Certificate
Submit your complete Excel Data Analysis Report and qualify for your certificate.

Student Ratings & Reviews

No Review Yet
No Review Yet