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)