4IR: Advanced Excel

May. 25, 2021

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
Register Here