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
- 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)