Microsoft Excel Advanced Level 3
The Microsoft Excel Advanced Level 3 Course is the most intense of the three Excel courses. Formulas, or functions, are what advanced users of Excel want from this course. When one uses formulas, not only can they see the data they require for their work, they can also analyse it and get answers to very complex questions. In addition to the knowledge of using of basic formulas, such as SUM, the advanced Excel will equip you with skills to use other formulas, both alone and combined, such as MATCH, INDEX, SUMIFS, and LOOKUP. In pursuit of top notch excellence the course will also teach you how to debug these formulas, how to audit them, and how to choose the perfect appropriate formula for the appropriate occasion and task. The programming and financial modeling have far reaching implications and users are an invaluable addition to the organisation.
Who should attend the course?
This course is primarily designed for the following target group in mind
- This Microsoft Excel Advanced Course targets existing users of Excel who have experience of building spreadsheets and want to take their skill and competencies to a higher level.
At the end of this course, Participants will be able:
- Give an insight into some of the most advanced features in Excel and will be of particular
interest to those who want to build or work with financial models, carry out detailed data analysis and automate tasks by recording macros.
- Fully prepare participants for virtually any complex task that requires advanced skills with this software; having access to the full functionality of Excel, and knowing how to use all formulas, functions, and capabilities. Though this course is the most involving of the three, once completed, participants will be equipped with the knowledge and skills that most Excel users can only dream of!.
The Learning Model
The trainer uses up-to-date training techniques and a variety of training methods, to give all participants the
best opportunities for learning including:
- Class session
- Group discussions
- Simulations exercises
- Case studies and problem solving exercises
- Individual assignments
- Templates and tools
- What-if Analysis
- Data Tables
- Working with Outlines
- Excel Macros