Course Description

This course will equip participants (those who are new or inexperienced in the use of MS-excel) with intermediate-level skills to most effectively use Microsoft Excel for data analysis, modelling and decision making. The course is therefore designed with a robust “beginners’ bouquet” that will enable the participants to learn some important analyses techniques in a fairly painless fashion. All these will be achieved in 2 days.

Expected Learning Outcomes

By the end of this course participants should be able to:

  • Use Outlines, Range Names, Databases & The Data Form
  • Use Auto-filter & Advanced Filters
  • Work With Data Series
  • Use Advanced Functions
  • Modify Charts
  • Use Scenario Manager & Goal Seek
  • Use Templates, Data Tables & Solve Problems
  • Use Automatic Formatting & Styles
  • Work With Views, Consolidate Worksheets
  • Create & Revise Pivot Tables