Course info

About this Course

This practical advanced Excel course consists of 8 modules which cover the advanced key concepts that you should master in order to become more effective and efficient in your daily operations. The course consists of a balanced focus on functions and formulas, tools to make your work easier and more streamlined, as well as tips and tricks to save you time.

Course highlights include combo charts and progress charts; advanced nested functions; statistical analysis and sample tools; financial functions; scenario planning and sensitivity analysis; and much more!

Learning Objectives

After successful completion of this course, you should be able to demonstrate the following competencies:

• Use advanced nested functions and formulas for data clean-up and analysis
• Use financial functions, such as NPV; IRR; XNPV; XIRR; IPMT; PPMT
• Compile a pivot table, and incorporate slicers and timelines
• Solve complex problems with solver, goal seek and scenario planner

Course Delivery, Duration, and Effort

SA Accounting Academy delivers this online short learning program course. This course is divided into 8 modules. In this way, you can maintain a work-life balance while studying a just-in-time course to upskill yourself. The required effort is 4 to 8 hours per week.

Is this for you?

The following persons will benefit from attending this webinar:

• All accountants and financial/business experts
• Support staff and administrative/logistics staff

Lecturer

Rona van Hoepen, CA(SA), ACMA, CGMA

Rona is a director and one of the founding members of IMPACT Financial Training Academy (Pty) Ltd, a company that specialises in Financial and Business Skills training, as well as consultation in related fields. She is a Chartered Accountant (SA), Associate Chartered Management Accountant, and holds a Master’s degree in Management Accounting.

She has a total of nine years lecturing experience at the University of Pretoria, University of Johannesburg and Northwest University respectively, for which she has received distinctive teaching awards. She specialised in lecturing Management Accounting, Costing, Financial Management, Risk Management and Business Strategy to students of various levels, as well as training to both government institutions and private sector companies in these subject fields.

She has been with IMPACT Financial Training Academy (Pty) Ltd as one of the full-time trainers and facilitators for the past eight years, and has consistently received outstanding feedback from course delegates. Her areas of expertise include advanced financial modelling in Excel, optimising power tools in Excel and Power BI.

Prerequisites / Admission Requirements

You should have a good working knowledge of Excel and it is therefore recommended that you first complete the Basic Excel Course and/or the Intermediate Excel Course.

Assessments

All formative assessments are conducted online. Candidates must achieve all competencies of the course. To achieve the course, learners must be declared competent in all assessments.

Certification

Successful completion (i.e. competence in all modules) of this course will lead learners to be awarded a Certificate of completion.

Curriculum

Modules:

• Module 1 - Combo Charts and Data Visualisation
• Module 2 - Table Tools and Pivot Tables
• Module 3 - Data Cleaning, Formula Auditing, Data Validation
• Module 4 - Logical Functions and Lookup Functions
• Module 5 - Statistical Analysis and Financial Functions
• Module 6 - Information Functions and Text Functions
• Module 7 - Solver, Scenario Planning and Sensitivity Analysis
• Module 8 - Dashboard Applications and Data Visualisation

For more information on what will be covered in the curriculum please download the prospectus.

About SA Accounting Academy

The SA Accounting Academy is an accredited private SAICA - AT(SA) and ICB qualifications provider. We are committed to providing our students with the highest quality training and support, to ensure that your skills and knowledge are up to date and ready to face the challenges of the modern workplace. Qualifications and courses delivered are designed to ensure that you reach your professional goals and advance your career. With our experienced faculty, staff, and resources, you can be confident that you will receive the highest quality of training.

SAAA is a Level 2 B-BBEE contributor, with 125% procurement recognition. Training spend on certain solutions can be allocated against the Skills Development element of the B-BBEE Scorecard through accredited and nonaccredited training or claimed through SETA grants. In addition, 15% of your Skills Expenditure can be claimed on non-accredited training or courses. In addition, 15% of your Skills Expenditure can now be allocated to non-accredited training or courses.

Course Fees

The course fee is R 5 750.00 and consists of:

• Study material - Online course material
• Online Facilitator support
• Online videos explaining functions and tools
• PowerPoint slides in PDF format
• Examples in Excel to illustrate concepts
• Exercises in Excel to practice concepts

Payment Methods

Debit / Credit Card or Instant EFT

You can pay directly on our website for an easy, secure, and instant transaction. During promotional periods, customers can take advantage of additional savings. This is the fastest and most efficient option, saving both time and money.

EFT / Bank Deposit

You can make a payment directly into our bank account using your Online Banking App, Online Banking services, or by visiting your local bank branch.

Your Company / Employer

It may be beneficial for your company to invest in training for its staff members. As there are financial and tax advantages for doing so, please speak with your employer or Training / HR manager about the possibility of paying for this training.

Third Party

If you have someone who is willing to pay for your studies, such as a parent or relative, they can either log in and pay on our website or they can pay via any of the payment options above on your behalf.

Payment Options

Option 1: Once off payment

• R 5 750.00

Contact Us

Online chat through our website https://accountingacademy.co.za

WhatsApp: Start chatting (+27635026114)

Phone: 010 593 0466

E-mail: support@accountingacademy.co.za