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