Course details
The rapidly increasing computational power of personal computers in combination with the development of dynamic software solutions for computational needs have in the recent few years brought the advantage of fairly sophisticated financial models in to the reach of a broader audience. The increasing flow of financial information is covering the skill of quantitative modeling using computers from an advantage into necessity.
MS Excel offers a good balance of ease-of-use, flexibility and efficiency in financial modeling, and has become the standard in the financial community. A reasonable level of efficiency however requires rather good knowledge in the Visual Basic for Applications (VBA) programming language.
The intensive course will teach Excel users how to harness additional programming power in the context of building Excel financial spreadsheet models. The sessions will emphasize technical issues to give the participants the tools needed for the latter sessions which will focus on familiar spreadsheet financial models which participants have already acquired. A short introduction into each topic is offered during the lectures, generally accompanied with examples. This course will be held in an interactive fashion where participants have the chance to instantly work with each presented example using a building block approach in learning.
COURSE OUTLINE
- Using Spreadsheet And Financial-Modeling Languages
- Introduction to VBA Development in Excel
- Getting Started with VBA
- Arrays
- Control Logic and Loops
- Working With Excel Objects
- More On Variables And Subroutines
- Integrating a VBA Application
LEARNING OUTCOME
What you will learn:
- Learn how to develop sophisticated spreadsheet models using Visual Basic for Applications (VBA) programming language.
- Gain hands-on experience on how to build Excel spreadsheet models.
- Learn how to improve your current spreadsheet models.
- Know what is spreadsheet models and its limitations.
- Increase your skills and capabilities in building advanced financial and corporate models.
Course Location
About COMAT Training Services Pte Ltd
To be or not to be; this is the question which resides in us. All man of clay, our innate differences are subtle and few. The void spanning greatness hinges on existence of mean and will. COMAT holds an intrinsic belief that every inpidual has a potential to be realised. Betterment of society through advancement of its basic unit, empowerment through continuous learning – Upon these axioms were we founded, and today proudly uphold.
Love for the people around us, a desire for a better world, our passion is our profession. COMAT believes learning is a lifelong process and key to a meaningful existence. Spearheaded by a renowned team of highly experienced and motivated trainers, COMAT offers an extensive array of IT, safety and leadership & professional development courses, providing inpiduals with the means to excel.
While adhering to globally accepted quality standards, our intention goes beyond training and certification - COMAT provides a holistic experience, focusing on generation of inductive environments for stimulating philosophical thoughts. True learning lies in instillation of a sense of self-realisation, a will to become who they can be.
We pride ourselves on our innovations, our desire for continuous improvement, and the ability to perceive the needs and wants of each inpidual. Customized approaches for varying needs, we conjure solutions tailored to fit.
See all COMAT Training Services Pte Ltd courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft OneNote Global CoursesSGD 20
SGD 189Duration: 1 Hour - Basics of Microsoft Power Automate Skill-UpSGD 18Duration: Upto 1 Hour
