Leading Training - Course Categories

Analysing Data with Excel

Master Advanced Data Analytics with Excel (Virtual & Classroom) In today's data driven world, transforming raw information into strategy is a critical competitive advantage. Our Analyzing Data with Excel Training Course is an intensive, expert-led program designed to bridge the gap between basic spreadsheets and professional business intelligence. We go beyond the basics, focusing on high-impact tools that automate your workflow. You will master: Data Automation with Power Query: Learn to connect, clean, and transform millions of rows of data automatically. Advanced Modeling with Power Pivot & DAX: Build sophisticated relational data models and custom business logic. Interactive Dashboards: Create executive-level visualizations that provide real-time actionable insights. Whether you join our Live Virtual Classroom from anywhere in the world or attend in-person training, you will gain the expertise needed to streamline reporting and drive informed decision-making. This course is ideal for professionals looking to master the full data lifecycle—from extraction to visualization—entirely within Microsoft Excel.

3 Days
From ZAR 6,750.00

Data Modelling with M and Power Query

Business Intelligence has its own unique requirements from a data model. Data must be structured in such a way as to serve the business goals of the system. A Data Model is created from disparate sources using ETL (Extract Transform Load) in Power Query (used by Microsoft Products like Power BI and Excel). Power Queries are written in a formula language called M.

1 Day
From ZAR 2,250.00

Excel Dashboards & Power Pivot

Attending this course equips you with hands-on skills to design and deploy compelling, interactive dashboards in Excel. You'll learn best practices (do's and don'ts) for visual layout, merging and consolidating data from multiple sources, and leveraging shapes, alerts, and KPIs to highlight important insights. The course addresses data quality issues, teaches you how to gather and link external data, and walks you through creating dynamic dashboards and pivot tables to analyze your results. Finally, you'll dive into DAX basics - using calculated columns, measures, and essential formulas. By the end, you'll have the know-how to build, customize, and publish professional dashboards tailored to your real-world projects.

1 Day
From ZAR 2,250.00

Excel for Statistical Analysis

This 2-day course will cover advanced Excel functionality related to statistical modeling and analysis. Learners will engage with charts, tables, slicers, (Power) Pivot tables and PowerQuery in order to harness data from a variety of sources.

2 Days
From ZAR 4,500.00

Excel Productivity

Excel Productivity Training is a training courses focused on building on your existing skills learning to develop sophisticated and automated reports that will substantially reduce the time spent working on spreadsheets. This practical 3 day course leads delegates through a structured method of building sophisticated spreadsheet templates where the data is separated from the Excel template. The latest data will be imported automatically from external sources ensuring that the latest and most up to data is being used. This approach eliminates all the manual effort which can drastically reduce the time to produce reports and simulations thereby drastically reducing the time to transpose data into information and information into knowledge. This training will build on the skills obtained from the Basic and Advanced Excel courses.

3 Days
From ZAR 6,750.00

Excel VBA

This course is designed for everyday Excel user who would like to program unique features and functions to improve the accessibility and usability of their data.

3 Days
From ZAR 6,750.00

Microsoft Excel Advanced

This course trains learners in Advanced skills for Microsoft Excel 365. Learners who have completed our Excel Fundamentals and Intermediate courses who wish to master Excel's most powerful and complex tools will learn vital skills for managing and analysing spreadsheet data in a professional setting. Learners will gain essential Excel skills such as linking and referencing external data sources, Lookup functions and advanced Excel formulas. They will also learn about workbook security and automation, as well as creating Sparklines to map and forecast data .Learners can take this course as a 1-day class led by an expert instructor, either online or in a classroom.  The material covered in this course assumes knowledge of the Excel basic skills learned in our Excel Fundamentals course as well as a grasp of Excel formulas and intermediate data analysis tools covered by our Intermediate Excel Training course. All three of these courses are available as a discounted bundle in our Excel Bootcamp. Professionals who want to gain further Excel skills centered on data analysis and high-level usage of Excel Power-Query functions should sign-up for our Excel Data Analysis course. 

1 Day
From ZAR 2,250.00

Microsoft Excel Complete Tutorial - Beginner to Advanced

Unlock your full potential with our comprehensive Excel Bootcamp! This intensive training program offers excel tutorials for beginners and is designed to take you from the absolute basics of Microsoft Excel navigation and data entry all the way to mastering advanced, real-world applications. Whether you're a complete beginner looking to understand microsoft excel for beginners user interface and perform fundamental calculations, or an experienced user aiming to leverage powerful features like excel basics for beginners formulas, functions, and efficient worksheet management, this bootcamp is for you. Dive deep into essential skills such as data manipulation, worksheet formatting, and effective printing. Progress to intermediate techniques including working with specialized Excel functions, mastering data sorting and filtering, and harnessing the power of PivotTables and PivotCharts for insightful data analysis and visualization. Finally, our advanced modules will equip you with the expertise to work with multiple Excel worksheets and workbooks, utilize lookup functions, ensure workbook protection, and even automate tasks with macros. Elevate your Excel skills and boost your productivity across any industry with this dynamic and practical microsoft excel for beginners training experience.

3 Days
From ZAR 5,750.00

Microsoft Excel For Human Resources Analytics

HR Data Analytics is a growing field in an increasingly data-driven world. Excel has tools to organize HR data and HR professionals need to know how to add these skills to their toolset to drive insight into HR metrics and deliver results to the business. This course covers the Excel tools and skills an HR professional will need to analyze HR data into meaningful presentations.

2 Days
From ZAR 4,500.00

Microsoft Excel Fundamentals

This course offers expert training in basic skills for Microsoft Excel 365. It is perfect both for Excel beginners and for Microsoft Office veterans looking to learn about new features in the latest Microsoft 365 edition of Excel. Learners will gain simple, essential Excel skills such as creating and naming spreadsheets, editing and formatting cells, searching and proofing Excel documents, as well as learning how to create and use basic formulas. Learners can take this course as a 1-day class led by an expert instructor, either online or in a classroom. They can also take the course in a budget-friendly e-learning format and learn the material in as little as 6-hours, or at their own pace. Learners who complete this course will benefit from taking our Intermediate Excel course. Excel experts who wish to learn more advanced Microsoft Excel skills such as Lookup functions or Sparkline creation will want to sign up for our Advanced Excel Training Course. All three of these courses are available as a discounted bundle in our Excel Bootcamp. Professionals who want to gain comprehensive Excel skills centered on data analysis and high-level usage of Excel Power-Query functions should sign-up for our Excel Data Analysis course. 

6 Hours
From ZAR 500.00

Microsoft Excel Intermediate

This course will expand learners' basic Excel 365 skills to include intermediate Excel skills to help them work with data at a professional level. Learners who have completed our Excel Fundamentals course that are looking to expand their skillset into using data analysis tools like tables and charts will find this course most rewarding. Learners will gain essential Excel skills such as using logical functions, working with date and time functions and organising cell data using lists. The course also teaches learners to create, populate, edit and format fundamental data analysis tools like tables and charts, including PivotTables and PivotCharts.Learners can take this course as a 1-day class led by an expert instructor, either online or in a classroom.  The material covered in this course assumes knowledge of the Excel basic skills learned in our Excel Fundamentals course. Learners who complete this course who wish to learn more advanced Microsoft Excel skills such as Lookup functions or Sparkline creation will want to sign up for our Advanced Excel Training Course. All three of these courses are available as a discounted bundle in our Excel Bootcamp. Professionals who want to gain Excel skills centered on data analysis and high-level usage of Excel Power-Query functions should sign-up for our Excel Data Analysis course. 

1 Day
From ZAR 1,850.00

Power Query Training (Microsoft)

Microsoft Power Query is a powerful data transformation and business analytics tool that allows users to connect to various data sources, clean and transform data efficiently, and automate data processing tasks. This Microsoft Power Query course provides participants with foundational knowledge and skills to use Power Query effectively in their data analysis and reporting work. The course covers topics such as connecting to different data sources, performing data transformation, creating queries, automating data import and processing tasks, and advanced data transformation techniques. Participants will also learn how to use formulas and functions, work with dates and times, perform conditional logic, handle large datasets, and optimize query performance. By the end of the course, participants will have gained practical skills and knowledge to use Microsoft Power Query to transform and analyze data, create reports and dashboards, and collaborate and share data with others. Microsoft Power Query is a valuable tool for business analysts, data analysts, and anyone who works with data and wants to streamline their data transformation and business analytics processes.

1 Day
From ZAR 2,250.00