Applied Financial Forecasting with Excel and VBA
Applied Financial Forecasting with Excel & VBA
3-Day Professional Development Training Course
East Asia Training & Consultancy Pte Ltd invites you to attend a three-day professional development workshop, using Excel & Visual Basic Applications (VBA) to create and build models with financial applications.
Financial Modeling is an essential skill for finance and non-finance professionals, and Excel and its built-in programming language, VBA, are the preferred tools for the job.
Many employees are familiar with using the most basic functions in Excel in building simple models. This is exemplified by the common use of macros by users. However, with the constant changes in the business environment being the norm of the day, there is a need to move organizations beyond efficiency.
The objective of the course is to build on the current skill level of the participants to build more complex models using the advanced Excel financial functions and tools and to enhance participants’ knowledge of modeling languages such as VBA.
The acquisition and development of corporate models are a means to retain organizations knowledge and promote knowledge-sharing, and these are tangible direct benefits for participants. This course will introduce to the Excel
users the additional programming capability in the context of building powerful, flexible and usable spreadsheet models.
In this public course, you will learn how to create macros, functions, and execute financial modeling techniques in Excel. Start from the basics of creating your own VBA forms and custom function development within Excel VBA, to advanced stochastic modeling in finance and packaging your application for deployment
This course will be hands-on in using Excel to build VBA applets and models with financial applications. Participants are required to bring their own laptops.