Analysing Data with Excel Training Course

Details Audience and Pre-Requisites Course Outline / Curriculum Schedule Dates and Booking Enquiry

Details

In today's data-driven world, the ability to analyze and interpret data is a critical skill. Our Excel Data Analysis Course is designed to equip you with the practical knowledge and expertise needed to transform raw data into actionable insights.

We focus on teaching you how to effectively use Excel for data analytics, covering essential tools like pivot tables, advanced formulas, and data visualization techniques. This course will enable you to streamline your data analysis workflows, improve reporting, and make informed decisions.

 

Whether you're a beginner or an experienced Excel user, our course provides a comprehensive learning experience that will empower you to excel in data analysis.

Our Excel Data Analysis Course provides a comprehensive hands-on learning experience to master the art of data analysis using Microsoft Excel. This course is designed to equip you with the practical skills needed to transform raw data into meaningful insights.

Delivery Methods

Delivery Method Duration
Classroom
Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.
Classroom
3 days Get a Quote
Live Virtual Training
This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.
Live Virtual Training
3 days Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Download Brochure

Information may change without notice.

Customer Testimonials

Exxaro Resources Limited

The course is an outstanding learning experience that truly equips you with practical, in-demand skills. The course content is clear, well-structured, and progresses logically from basic to advanced Excel techniques, making it accessible for learners at all levels.

Bestmed Medical Scheme

I liked the V-Lookup and how to create Pivot chats.

Bestmed Medical Scheme

training was good and i have learned a lot about excel

Bestmed Medical Scheme

Mr. Lawrence is very patient well equipped when it comes to the training aspect. if you ask something he will slowly explain to you and ensure that you understand i would really like to applaud Ntate Lawrence. now i know how to navigate the excel spread-sheet thank you for the training

Exxaro Resources Limited

Great experience, excellent content, and great practical's which helped with the understanding of the concepts and applications. will definitely be using these acquired skills now in our master data environment.

Exxaro Resources Limited

Best relevant training in years!

Audience

This course is intended for students who are experienced with Microsoft Excel and who wish to add Business intelligence techniques and visualization. The course will take students beyond the capabilities of tables and charts using Pivot Charts and Excel Data Model.

Pre-Requisites

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Skills using Excel worksheets, particularly in creating formulas and functions.

Course Outline / Curriculum

Data Analysis Fundamentals

  • Introduction to Data Science
  • Create and Modify Tables
  • Sort and Filter Data

Visualizing Data with Excel

  • Visualize Data with Charts
  • Modify and Format Charts
  • Apply Best Practices in Chart Design

Analyzing Data with Formulas and Functions

  • Analyze Data with Formulas and Named Ranges
  • Analyze Data with Functions
  • Implement Data Validation, Forms, and Controls
  • Create Conditional Visualizations with Lookup Functions

Analyzing Data with PivotTables

  • Create a PivotTable
  • Analyze PivotTable Data

Presenting Visual Insights with Dashboards in Excel

  • Visualize Data with PivotCharts
  • Filter Data Using Slicers and Timelines
  • Create a Dashboard in Excel

Creating Geospatial Visualizations with Excel

  • Create Map Charts in Excel
  • Customize Map Charts in Excel

Performing Statistical Analysis

  • Visualize Trendlines and Sparklines with Excel
  • Analyze Data with the Data Analysis ToolPak

Getting and Transforming Data

  • Connect to Data with Queries
  • Clean and Combine Data
  • Shape and Transform Data

Modeling and Analyzing Data with Power Pivot

  • Install Power Pivot in Excel
  • Create Data Models with Power Pivot
  • Create Power Pivots
  • Perform Advanced Data Analysis and Visualization

Presenting Insights with Reports

  • Plan a Report
  • Create a Report

Schedule Dates and Booking

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date End Date Branch  
Wed 18 Feb 2026 Fri 20 Feb 2026 Not Applicable

Book Live Virtual Training

Wed 18 Mar 2026 Fri 20 Mar 2026 Not Applicable

Book Live Virtual Training

Submit Enquiry

Name
Email
Telephone
Query