Microsoft Excel Intermediate: Level Up with Advanced Formulas, Pivot Tables & Data Analysis | Online Short Course
About this Course
Take your Microsoft Excel skills to the next level with this practical intermediate Excel training course. Perfect for Excel users looking to advance their spreadsheet knowledge, this course consists of 8 modules covering the intermediate key concepts you should master to become more effective and efficient in your daily operations. Through a balanced focus on functions, formulas, and tools, you'll gain the Excel skills to make your work easier and more streamlined. Course highlights include filters and advanced filters, lookup and logical functions, basic recorded macros, conditional formatting, goal seek and solver, basic array calculations, and much more! Elevate your Excel proficiency and become an indispensable power user in your organization.
Course highlights include filters and advanced filters; lookup functions and logical functions; basic recorded macros; conditional formatting; goal seek and solver; basic array calculations; and much more!
Learning Objectives
After successful completion of this course, you should be able to demonstrate the following competencies:
- Use intermediate functions and formulas, such as INDEX, MATCH, SUMIFS
- Use nested functions for data clean-up and data analytics
- Incorporate form controls, graphs and charts, and grouping into worksheets
- Compile pivot tables, basic array calculations and two-variable data tables
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 basic understanding of Excel and it is therefore recommended that you first complete the Basic 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 - Advanced Filters, Data Tables, and Absolute References
- Module 2 - Logical Functions, Maths Functions, and Nested Functions
- Module 3 - Sparklines, Form Controls, and Data Visualisation
- Module 4 - Data Cleaning, Lookup Functions, and Text Functions
- Module 5 - Formula Auditing, Data Validation, and Group and Outline
- Module 6 - Recorded Macros, and Goal Seek
- Module 7 - Pivot Tables, and Array Calculations
- Module 8 - Solver, Scenario Planner and Sensitivity Analysis
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 QCTO, SAICA - AT(SA), ICB and BANKSETA 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, 25% of your Skills Expenditure can be claimed on non-accredited training or courses.
Course Fees
The course fee is R 5 750.00 and consists of:
Educational Resources
- Online Materials: Access a wealth of online resources, from e-books to webinars, enhancing your learning experience. Online videos explaining functions and tools. Examples in Excel to illustrate concepts. Exercises in Excel to practice concepts.
Learning Support
- Facilitation: Benefit from expert-led facilitation sessions that offer personalized guidance, addressing individual queries and ensuring a thorough understanding of the subject matter.
- Formative Assessments: Reinforce your understanding with assessments on different topics.
- Learner Forum: Engage in meaningful peer-to-peer interactions through our dedicated learner forum. Share insights, ask questions, and collaborate on projects to enhance your learning experience.
- Continuous Support: Our dedicated team is always on standby to assist with any academic or administrative queries, ensuring a smooth learning process.
Flexibility and Convenience
- Study Online: Complete your course and take your assessments online, giving you the freedom to learn from anywhere.
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
Other Microsoft Excel Courses
Enhance your Microsoft Excel skills and take your spreadsheet knowledge to the next level with our comprehensive suite of Excel courses:
Microsoft Excel Essentials: Master Basic Formulas, Functions & Tools
Perfect for beginners, this course covers the fundamental concepts and tools of Excel. Learn basic formulas, functions, data formatting, and charts to boost your productivity and streamline your daily tasks. Click here.
Microsoft Excel Mastery: Conquer Complex Problems with Advanced Functions, Macros & Dashboards
Take your Excel skills to the next level with this advanced course. Learn advanced functions, array formulas, and data analysis tools. Automate repetitive tasks with macros and VBA, and create interactive dashboards to communicate insights effectively. Click here.
Microsoft Excel Specialist: Unlock the Power of Power Query, Power Pivot, VBA & Dynamic Arrays
Developed for Excel power users and data professionals, this specialized course covers cutting-edge tools and techniques for data analysis and visualization. Master Power Query, Power Pivot, advanced Excel functions, and dynamic arrays to solve complex data challenges and drive business insights. Click here.
Whether you're a beginner looking to master the essentials or an experienced user seeking to unlock the full potential of Excel, our courses offer a comprehensive learning path to help you achieve your goals. Explore our course offerings and start your Excel learning journey today!
Corporate Training Solutions
At the SA Accounting Academy, we recognize the evolving needs of businesses in today's dynamic environment. Beyond our standard webinar offerings, we provide tailored corporate training solutions designed to empower your team with the latest in accounting and professional skills. Whether you're looking for online sessions or face-to-face training, our programs are crafted to ensure a comprehensive and engaging learning experience.
Drawing inspiration from modern training methodologies, our corporate solutions are interactive, adaptable, and focused on real-world applications. We prioritize hands-on learning, ensuring your team can immediately apply their newfound knowledge in practical scenarios.
Interested in a bespoke corporate training experience? Reach out to us at [email protected] or call 010 593 0466. Together, let's design a training program that elevates your team's capabilities and aligns with your organizational goals.
Contact Us
- Online chat through our website
- WhatsApp: Start chatting (+27635026114)
- Phone: 010 593 0466
- E-mail: [email protected]