Get this course

B - Growth Phase

022. Grow - Advanced Excel (CORE) (CPD202)


Description
Purpose of the Course:
To equip users to use Excel effectively within their work roles.

Outcomes:
Once the course has been completed, it should enable the learner to apply each of the functions in Excel.

Assessment Criteria:
Complete each unit
Content
  • Index and Match
  • Trace dependents/ precedents
  • Important functions bite size
  • Freeze panes
  • Keyboard shortcuts
  • Conditional formatting
  • Vlookups
  • Creating Pivot tables
  • Using recommended pivot tables
  • If function logic functions
  • Separating string
  • What if analysis (Goal seek and scenario manager)
  • Excel formulas the complete list
Completion rules
  • All units must be completed
Back