Microsoft Excel Advanced Level 3

 

Course overview

The Microsoft Excel Advanced Level 3 Course is the most intense of the three Excel courses. Formulas, or functions, are what advanced users of Excel want from this course. When one uses formulas, not only can they see the data they require for their work, they can also analyse it and get answers to very complex questions. In addition to the knowledge of using of basic formulas, such as SUM, the advanced Excel will equip you with skills to use other formulas, both alone and combined, such as MATCH, INDEX, SUMIFS, and LOOKUP. In pursuit of top notch excellence the course will also teach you how to debug these formulas, how to audit them, and how to choose the perfect appropriate formula for the appropriate occasion and task. The programming and financial modeling have far reaching implications and users are an invaluable addition to the organisation.

Who should attend the course?

This course is primarily designed for the following target group in mind

  • This Microsoft Excel Advanced Course targets existing users of Excel who have experience of building spreadsheets and want to take their skill and competencies to a higher level.

Course objectives

At the end of this course, Participants will be able:

  • Give an insight into some of the most advanced features in Excel and will be of particular
    interest to those who want to build or work with financial models, carry out detailed data analysis and automate tasks by recording macros.
  • Fully prepare participants for virtually any complex task that requires advanced skills with this software; having access to the full functionality of Excel, and knowing how to use all formulas, functions, and capabilities. Though this course is the most involving of the three, once completed, participants will be equipped with the knowledge and skills that most Excel users can only dream of!.

The Learning Model

The trainer uses up-to-date training techniques and a variety of training methods, to give all participants the
best opportunities for learning including:

  • Class session
  • Group discussions
  • Simulations exercises
  • Case studies and problem solving exercises
  • Individual assignments
  • Templates and tools

Course Contents

  • What-if Analysis
  • Data Tables
  • Working with Outlines
  • Excel Macros

2019
Course Calendar
Dates

18 – 19 Mar

22 – 23 Apr

20 – 21 May

17 -18 June

22 – 23 July

19 – 20 Aug

23 – 24 Sept

21 – 22 Oct

18 – 19 Nov

Share this course

 

Cost: R 5 000

 

Interested in a custom programme?
Beginning with the content of our existing offerings, we’ll work with you
to create a program tailored to address the challenges of your organization.

Looking for more?

Let us follow up about more details about this program.