* All fees are exclusive of vat
** PREMIUM - Customize your learning experience
Course Description
The course is designed to take participants through different levels of modeling complexity to enable them to achieve their desired level of proficiency. The entire focus of the course is to teach techniques that will enable you to design and construct financial models that are not only functional but also accurate, reliable, flexible, user-friendly and maintainable. The course has been carefully designed to meet the needs of a variety of different users and their differing levels of expertise.
What Do Participants Learn?
- Become familiar with an impressive range of Excel facilities and tools;
- Appreciate the nature and use of new facilities in the latest versions of Excel;
- Use a variety of simple and complex Excel functions with confidence;
- Create dashboards and reports that are informative, enlightening and insightful;
- Formulate and solve problems using optimization techniques;
- Design and build macros and user-defined functions;
- Use macros to extend the functionality and enhance the usability of financial models;
- Clean up, enhance and generally manage raw data for modeling purposes;
- Understand the nature of financial models and their application areas;
- Plan, design, construct and prove modeling applications for planning and decision-making;
- Use the facilities of Excel to prepare forecasts of financial statements and cash flows;
- Build models to evaluate projects and perform company valuations;
- Use tables, scenarios and other tools of sensitivity analysis;
Who Should Attend?
- Executives and managers
- Sales and marketing professionals
- Accountants and lawyers
- Corporate financiers
- Investment bankers
- Commercial Bankers
- Treasury professionals
- Financial and credit analysts
- Investment analysts and fund managers
- Engineers
- Front and back office staff
- Administrative professionals
What Will the Learning Experience Include?
Phase: 1
Introduce
- Comprehensive pre-program activities include:
- Web-based information forms & surveys completed by attendee.
- Direct consultation with the attendee about the expectations.
- During the training, participants engage in data, activities, and conversations that lead to insight and knowledge.
- Participants learn from expert trainers who have both academic and business experiences.
- Highly applicable training content & instructive activities for adding depth to training topics.
- **A half-day site visit for integrating the experience & plan next steps. Opportunities to provide connections, ideas & support.
Phase: 2
Explore & Practice
Phase: 3
Apply
- Apply & sustain the learning experience by using this ongoing support:
- To ensure participant has new skills or behavior progress.
- Optional, fee-based mentoring & coaching with the trainer.
- Training materials & additional documents (e-books, pdf files, presentations and articles)
- Evaluate your training experience by giving us feedbacks and help us to reach our organizational goals.
- Participant's Evaluation
- Trainer's Evaluation
Phase: 4
EVALUATE
Related Trainings
Download Brochure
Certification
Averest Training Certificate of Completion or delegates who attend and complete the training course
This course is certified by:
On-Site Training
This Course can be customized delivered to a group at your facility saving time and money.