RELATED COURSES
Analysing Data with Excel
Azure Fundametals
Data Modelling with M and Power Query
DAX Programming
Excel Boot Camp
Excel Dashboards and Power Pivot
Excel for Statistical Analysis
Excel Productivity
Excel VBA
Microsoft Access
Microsoft Azure Administrator
Microsoft Excel For Human Resources Analytics
Microsoft Excel Fundamentals
Microsoft Excel: Intermediate
Microsoft Office 365 Overview
Microsoft OneNote Fundamentals
Microsoft Outlook Level 1
Microsoft Power Automate
Microsoft Power BI Bootcamp
Microsoft Power BI Desktop Advanced
Microsoft Power Query
Microsoft PowerApps
Microsoft PowerBI Dashboard User Course
Microsoft PowerPoint Level 1
Microsoft PowerPoint Level 2
Microsoft Project
Microsoft SharePoint User
Microsoft Teams
Microsoft Visio
Microsoft Word Level 1
Microsoft Word Level 2
MS Office Level 1
OneDrive Training
Details
Transform your Excel skills today with our Advanced Excel Training, designed to provide the expertise you need to excel in data management and analysis in the South African business environment.
Our Advanced Excel Training course is designed to empower you with the skills to confidently tackle complex data analysis and automation tasks. This course goes beyond basic Excel usage, focusing on practical, real-world applications that will significantly enhance your productivity and data management capabilities.
Delivery Methods
Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.
| Delivery Method | Duration | Price (excl. VAT) | ||
|---|---|---|---|---|
| Classroom | 1 Day | ZAR 2,550.00 | Get a Quote | |
| Live Virtual Training | 1 Day | ZAR 2,250.00 | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
Gauteng Provincial Treasury
The facilitator was very patient, ensured everyone was on the same page and ensured participation from everyone.
Gauteng Provincial Treasury
Examples were so friendly user and the trainer was explaining very well
Audience
This course is tailored for professionals who need to leverage advanced Excel capabilities to drive efficiency and make informed decisions. If you're looking to:
- Automate repetitive tasks: Create macros to streamline your workflow and save valuable time.
- Collaborate seamlessly: Master tools for effective teamwork on shared workbooks.
- Ensure data integrity: Learn advanced auditing and analysis techniques for accurate reporting.
- Integrate diverse data sources: Import and export data from various applications to create comprehensive reports.
Pre-Requisites
To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel Basic and Microsoft Office Excel Intermediate
Course Outline / Curriculum
Lesson 1:Working with Multiple Worksheets and Workbooks
-
- Use Links and External References
- Use 3-D References
- Consolidate Data
Lesson 2: Using Lookup Functions and Formula Auditing
-
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
Lesson 3: Sharing and Protecting Workbooks
-
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
Lesson 4: Automating Workbook Functionality
-
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Lesson 5: Creating Sparklines and Mapping Data
-
- Create Sparklines
- Map Data
Lesson 6: Forecasting Data
-
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
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.
Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.
| Start Date | End Date | Branch | Status | |
|---|---|---|---|---|
| Wed 14 May 2025 | Wed 14 May 2025 | Fourways | Scheduled | |
| Wed 11 Jun 2025 | Wed 11 Jun 2025 | Fourways | Scheduled | |
| Wed 9 Jul 2025 | Wed 9 Jul 2025 | Fourways | Scheduled | |
| Wed 6 Aug 2025 | Wed 6 Aug 2025 | Fourways | Scheduled | |
| Wed 3 Sep 2025 | Wed 3 Sep 2025 | Fourways | Scheduled | |
| Wed 1 Oct 2025 | Wed 1 Oct 2025 | Fourways | Scheduled | |
| Wed 29 Oct 2025 | Wed 29 Oct 2025 | Fourways | Scheduled | |
| Wed 26 Nov 2025 | Wed 26 Nov 2025 | Fourways | Scheduled |