SK Academy
Microsoft Excel Advance
Duration
5 Days
Level
Not Specified
Total Credits
N/A
SAQA ID
Pending
Delivery Mode
Online
Qualification Details
Introduction
Advanced Microsoft Excel competencies are developed, including complex formulas, data modelling, automation with macros, and advanced visualisation techniques essential for sophisticated business analysis and reporting tasks.
Rules & Curriculum
Curriculum Breakdown
01
Advanced Formatting
Conditional formatting and validation.
02
Complex Functions
VLOOKUP, XLOOKUP, IF statements.
03
Pivot Tables
Summarizing large datasets.
04
Data Analysis Tools
Goal Seek, Solver, and Scenarios.
05
Macros & Dashboards
Recording macros and visualization.
Total Investment
R 3,500
Deposit: R 799