TAP> Intermediate Microsoft Excel
Course Purpose: Deepen your understanding of functions, delve into data analysis tools such as pivot tables and charts, and explore advanced formatting and conditional formatting techniques to efficiently manage and present complex data sets. Additionally, you’ll learn to work with …
Course Purpose:
Deepen your understanding of functions, delve into data analysis tools such as pivot tables and charts, and explore advanced formatting and conditional formatting techniques to efficiently manage and present complex data sets. Additionally, you’ll learn to work with larger datasets, employ more sophisticated formulas, and streamline processes through data validation and automation features.
What you’ll learn
“The Intermediate Microsoft Excel course is for those who understand the basics of Excel and are familiar with the Excel screen, formatting and basic formulas. You will explore basic VLOOKUP and pivot tables to ensure that you understand the more advanced formulas and functions of MS Excel.”
Duration: 1 Day
Featured Course
Fundamentals of project management
Course Curriculum
Featured Course
Advanced Microsoft Excel
Course Content
Requirements
- Grade 11
- NQF Level 3 or 4
You May Like
TAP> Demonstrate an understanding of the use of different number bases and measurement units, and an awareness of error in the context of relevant calculations
COURSE PURPOSE This unit standard is designed to provide credits towards the mathematical literacy requirements of the NQF at Level 2. The essential purposes of...
TAP> Mathematics Level 3
COURSE PURPOSE Mathematics is used to manage various financial instruments like insurance, stocks, bonds while helping understand situations like home loans, annuities, and optimising profit...
TAP>Processing of automotive orders and payments
Course Purpose: This course provides students with the knowledge and skills necessary to efficiently process automotive orders and payments. Topics include order management, payment handling,...
TAP> How to Start Your First Business
Course Purpose: Embark on the exhilarating journey of entrepreneurship with our eLearning course, ‘How to Start Your First Business.’ From ideation to execution, learn essential...
TAP> Set Priorities for Team and Personal Tasks
Description This unit standard enables learners to manage time and prioritise tasks in a work environment. What you’ll learn This unit standard enables learners to...
Course Features
- Lectures 37
- Quizzes 0
- Duration 3 days
- Skill level All levels
- Language English
- Students 1580
- Assessments Yes