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