Explore Courses

KZN Course

Excel 3 - Advanced

  • Credits: Non Credit Bearing
  • Accredited: No
Download Course Outline

Duration: 2 Days
Time: 8:15am - 4:00pm

Master Excel’s most powerful features for data analysis and automation

Excel is an indispensable tool for professionals handling complex data. If you’ve mastered intermediate functions and want to unlock Excel’s most powerful capabilities, this course will equip you with advanced techniques.

Learn how to automate tasks with macros, perform sophisticated data analysis, and create dynamic reports with pivot tables and charts. Whether you need to enhance financial models, streamline decision-making, or visualise data effectively, this course will help you achieve it.

PRE-REQUISITE

  • Have completed both the Excel Essentials and Excel Intermediate courses OR
    • be able to create basic formulas (addition, subtraction, multiplication and division)
    • have an understanding of how to insert basic functions and which range to use in the function argument (AutoSum, Average, Max and Min)
    • have an understanding of absolute vs relative cell referencing

DISCLAIMER: This is an advanced programme. The above content will not be taught during this course.  Basic formulas and functions are covered in our Essentials course. Data functions and absolute vs relative cell referencing are covered in our Intermediate course.

WHO SHOULD ATTEND

Anyone who wants to take their Excel skills to the next level.
People who are in, or aspire to, the following job functions/roles:

Request Full Course Schedule

If you want the full course schedule, leave your details and we will get in touch.