Microsoft Excel Essentials: Master Basic Formulas, Functions & Tools | Online Short Course
✔ 100% Online | ✔ Available On Demand | ✔ Start Anytime | ✔ Self-Paced | ✔ No Prerequisites | ✔ Certificate on Completion
- Delivery: 100% online, available on demand
- Level: Beginner – no prerequisites
- Structure: 8 modules
- Effort: 4 to 8 hours per week
- Assessment: Online formative assessments
- Certification: Certificate of completion
- Course fee: R 5 750.00
About this Course
Master the essentials of Microsoft Excel with this practical basic Excel training course. Designed for beginners, this course covers the key concepts and tools you need to become more effective and efficient in your daily operations. Learn essential Excel formulas and functions, data formatting, charts and graphs, and time-saving tips and tricks. Through a balanced focus on functions, formulas, and tools, you'll gain practical Excel skills to streamline your work.
Course highlights include shortcuts and hyperlinks; date and text functions; spin buttons and sparklines; basic tables and basic charts; text-to-columns; lookup functions; and much more! Start your Excel journey today and unlock the power of this versatile spreadsheet software.
Learning Objectives
After successful completion of this course, you should be able to demonstrate the following competencies:
- Use basic functions and formulas, such as SUM, ROUND, COUNT, AVERAGE
- Use lookup functions and logical functions, such as VLOOKUP, XLOOKUP, IF
- Compile basic tables and basic charts, as well as perform basic filtering
- Incorporate hyperlinks, spin buttons and sparklines into worksheets
Curriculum
Modules:
- Module 1 - Dynamic Selection, Copy and Paste, Transpose and Hyperlinks
- Module 2 - Basic Calculations, Maths Functions and Date Functions
- Module 3 - Spin Buttons, Sort and Filter, Formatting and Cell Styles
- Module 4 - Grouping, Automatic Subtotals, Conditional Formatting
- Module 5 - Data Tables, Slicers, Charts and Graphs
- Module 6 - Text Functions, Text-to-Column
- Module 7 - Logical Functions and If-Statements
- Module 8 - Lookup Functions and Reference Functions
For more information on what will be covered in the curriculum please download the prospectus.
Course Delivery, Duration, and Effort
This course is 100% online and available on demand. Enrol and start whenever suits you, work through the 8 modules at your own pace, and complete your assessments online, from anywhere. There are no fixed class times, so you can upskill while keeping a healthy work-life balance. The recommended effort is 4 to 8 hours per week.
Is this for you?
The following persons will benefit from this course:
- All accountants and financial/business experts
- Support staff and administrative/logistics staff
Prerequisites and Your Excel Learning Path
There are no prerequisites for this course – it is the starting point of our Excel learning path. Once you have completed it, you can continue building your skills with the next levels:
- Step 1 – Beginner: Microsoft Excel Essentials – basic formulas, functions, formatting and charts. ← You are here
- Step 2 – Intermediate: Microsoft Excel Intermediate – advanced formulas, pivot tables and data analysis.
- Step 3 – Advanced: Microsoft Excel Advanced – advanced functions, array formulas, macros and dashboards.
- Step 4 – Specialist: Microsoft Excel Specialist – Power Query, Power Pivot, VBA and dynamic arrays.
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.
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.
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 practise concepts
- 100% online, on-demand access – start when it suits you and study at your own pace
Enrol online and start learning at your own pace. No fixed class times – this course is 100% online and available on demand.
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
All our Excel courses are 100% online and available on demand. When you're ready for the next level:
Microsoft Excel Intermediate (Intermediate)
Level up with advanced formulas, interactive pivot tables and data analysis.
View course »
Microsoft Excel Advanced (Advanced)
Conquer complex problems with advanced functions, array formulas, macros and dashboards.
View course »
Microsoft Excel Specialist (Specialist)
Unlock Power Query, Power Pivot, VBA and dynamic arrays to solve complex data challenges.
View course »
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.
Corporate Training Solutions
At the SA Accounting Academy, we recognise the evolving needs of businesses in today's dynamic environment. Beyond our standard 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 programmes 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 prioritise 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 corporate@accountingacademy.co.za or call 010 593 0466. Together, let's design a training programme that elevates your team's capabilities and aligns with your organisational goals.
Contact Us
- Online chat through our website
- WhatsApp: Start chatting (+27635026114)
- Phone: 010 593 0466
- E-mail: support@accountingacademy.co.za