Excel VBA Programming for Finance Professionals

Regular price Rs.5,999.00

 Basic Info : Excel VBA Programming for Finance Professionals
Level : Intermediate
Commitment  : 12 Hours
Language : English
Schedule Date : 17th October

 

What Will I Learn

VBA is a great tool to automate repetitive tasks on Excel and is also able to streamline long and complex calculations. This online course on Excel programming includes the application of Excel VBA for 3 financial applications which are generating payment schedules for interest rate swaps, Bootstrapping yield curves & generating risk-neutral scenarios for equity security.

Curriculum

Introducing Visual Basic for applications

  • Recording and running macros
  • Absolute vs relative referencing
  • Working with the Visual Basic Editor and Developer tab

Creating your own code

  • Understanding and creating modules
  • Common rules of programming
  • Where to store macros
  • Modifying / improving simple modules
  • Problem solving / finding concise solutions

Getting VBA to make decisions

  • Using logical comparisons
  • The IF...ENDIF structure
  • The SELECT CASE...END SELECT structure
  • Error handling and trapping

Introduction to repeating code

  • The need for and benefits of loops
  • Implementing a DO WHILE LOOP
  • Examples of the FOR... NEXT structure

Interaction between VBA and the end-user

  • Activating message boxes and user prompts
  • Processing end-user input via input boxes

Creating functions

  • Writing your own User Defined Functions (UDFs)
  • Working with multiple arguments
  • Using your bespoke function in Excel
  • Generating Payment Schedules for interest rate swaps
  • Bootstrapping Yield Curves
  • Generating Risk-Neutral Scenarios

 

How It works

   Live Online Sessions
Each session is interactive and informative, featuring case studies, quizzes and projects

   Interact, Learn and Grow
bsevarsity.com enables you to master the concepts, interact with expert faculty and other learners and be a part of the community whilst growing.

   Get Certified
Get Certified from bsevarisity.com. Share your success with the world

Training 5 or more people?

We provide custom courses and group sessions as well. To know more about our Customized Programs.

Try BSE Business Click here