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

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	1 Day	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	1 Day	Get a Quote

Discounts Available

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

Brochure:

Information may change without notice.

Customer Testimonials

United Exports South Africa (Pty) Ltd

The patience Lawrence shows towards anyone struggling or getting stuck is amazing!

World Vision International

Friendly trainers, good pace, practical examples, self practice notes/files shared

Splashworks (Pty) Ltd

Yes, highly recommend your company.

United Exports South Africa (Pty) Ltd

The course will surely make working with excel must better and easier

United Exports South Africa (Pty) Ltd

The excel sessions were very practical and easy to follow.

World Vision International

the training was very beneficial to our work

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

There are currently no scheduled dates.

Add me to the waiting list

Submit Enquiry

Name

Email

Telephone

Query