4IR: Advanced Excel

Dec. 06, 2022

None

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 received within 1-2 working weeks upon course completion)
• 5 Kaplan Employability Statement (KES) points (only for eligible students)

Register Here