Advanced Excel
Kaplan’s 4th Industrial Revolution (4IR) Courses encapsulate a wide range of soft and technical skills. The courses are catered to supplement students’ academic training and prepare them for the future of work. The 4IR courses are carefully selected to equip students with interpersonal, digital and practical skills that are industry relevant.
Course Objectives
• Master complex computations with advanced excel functions and formulas
• Save time and increase productivity
• Gain accurate analysis skills
Course Structure
• Functions: COUNTIF(S), SUMIF(S), SUMPRODUCT
• Lookup functions
• Manipulating text
• Sorting data
• Splitting data into columns
• Filtering data
• Subtotals and grouping
• Excel tables
• PivotTables & PivotCharts
• Solutions
Rewards
• E-Certificate of Completion by Kaplan will be awarded upon completion of the course.
