* All fees are exclusive of vat ** PREMIUM - Customize your learning experience
F.M.M. Financial Modeling Master program will provide you with the ability to create and understand financial models as one of the most valued skills in business and finance today. Microsoft Excel with Visual Basic for Application (VBA) macros programming has been the dominant vehicle used by finance and corporate professionals in the preparation and utilization of the full range of financial models and other applications.
What Do Participants Learn?
Develop a thorough mastery of Excel and VBA software(s) for financial modeling purposes.
Learn the needed tools to build models that are less time and effort consuming
Learn the best practice in modeling forecast financial statements (Balance Sheet, Income Statement and Cash Flow Statement)
Learn and Work with over 1 million rows of data in seconds with Power Pivot Data Mashup and Data Exploration
Learn the way how to get from the basics of VBA to building a loan amortization table using a VBA macro
Who Should Attend?
All Excel Users particularly:
Chief Executive Officers
Chief Financial Officers
Private equity managers
Corporate finance analysts
Financial government officials
Bank lending officers
Corporate Finance lawyers
What Will the Learning Experience Include?
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.
Explore & Practice
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.
Design principles for good model building
Exploring Excel functions
Helpful starting hints
The 40 functions you will work with as a financial modeler
Modeling forecast financial statements
Modeling Ratio Analysis and Key Performance Indicators
Optimization Solutions with Excel Solver
Power Pivot Extensions
Monte Carlo Simulation using Crystal Ball
Introduction to VBA
Case Study: Automating database update with new month data
Building custom new functions in Excel using VBA
Case study: Building a loan amortization table using VBA