* All fees are exclusive of vat
** PREMIUM - Customize your learning experience
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
All Excel Users particularly:
Financial Analyst
Chief Executive Officers
Chief Financial Officers
Portfolio managers
Corporate accountants
Credit analysts
Private equity managers
Venture capitalists
Corporate finance analysts
Risk managers
Board members
Investment bankers
Regulators
Financial government officials
Strategic planners
Trustees
Compliance officers
Management consultants
Bank lending officers
Internal auditors
Management consultants
Corporate Finance lawyers
Design principles for good model building
Exploring Excel functions
Helpful starting hints
The 40 functions you will work with as a financial modeler
Financial functions
Modeling forecast financial statements
Modeling Ratio Analysis and Key Performance Indicators
Optimization Solutions with Excel Solver
Pivot Tables
Power Pivot Extensions
Monte Carlo Simulation using Crystal Ball
Introduction to VBA
Case Study: Automating database update with new month data
Loops
Building custom new functions in Excel using VBA
Case study: Building a loan amortization table using VBA
Averest Training Certificate of Completion or delegates who attend and complete the training course
This course is certified by:
This Course can be customized delivered to a group at your facility saving time and money.