Advance Excel

Excel Session 2: Formula’s and Functions

  • Trace Formula precedents and dependents.
  • Data Validation tool and check for errors in a file.
  • Implement Iterative Calculations.
  • Usage of Single Cell and Multiple Cell Array formulas.
  • Use SUMIFS(), COUNTIFS(), Basic Counting Functions.
  • Text, Logical & Lookup functions.
  • Quick Analysis Tool for Data Analysis.
  • Data Consolidation
Excel Session 1: Sharing & Maintaining Workbook (Prev Lesson)
(Next Lesson) Excel Session 3: Advance Chart Features
Back to Advance Excel

No Comments

Give a comment

×