Excel and VBA Programming for Finance (New York Institute of Finance)

Colleagues, this Excel and VBA Programming for Finance training from the New York Institute of Finance will teach you the essential elements of Excel and Visual Basic for Applications (VBA) to develop practically useful applications for finance. This course comprises the following component courses: 1) Fundamental Excel Skills for Finance (Day 1), 2) VBA Programming for Finance (Days 2 & 3). Acquire desk-ready skills - Learn how to use essential mathematical and statistical functions in Excel, Master data tables and pivot tables, Learn how to import data from Bloomberg, Employ goal seek and solver to solve equations, Learn the elements of programming in VBA, Build an option pricer in VBA, and Develop a Monte Carlo simulation engine with VBA. Skill-based training modules equip you in: 1) Review of Excel Basics - Ranges, Basic functions, Creating formulas, Creating charts; 2) Useful Excel Functions - Logical and information functions, Text functions, Lookup functions, Date and time functions, Mathematical functions, Statistical functions, Arrays and matrices and Solving systems of linear equations: Matrix algebra; 3) Modeling Tools -  Goal Seek and Solver, Solving non-linear equations, Optimization, Computing the yield to maturity for a bond, Sensitivity and scenario analysis, Simulation: Generating random numbers, 4)  Data Analysis - Sorting and filtering data, Data tables, Pivot tables, Importing Bloomberg data, Statistical and regression analysis; 5) VBA Fundamentals - VBA IDE, Recording and running macros, Data types, variables, constants and arrays, Functions and subroutines, Private vs. public procedures, Built-in functions and statements; 6) VBA Programming Tools - Variable scope, Flow control, loops and exception handling, A Black-Scholes function, Calling Solver with VBA, Automating bond yield computations, Monte Carlo simulation; 6) Advanced VBA Topics - Passing arguments to subroutines and functions, Pass by value vs. pass by reference, Excel object model, Debugging, Error trapping, Creating add-ins; and  7) Working with Data - External data, files, databases and websites, Reading and writing .csv and .txt files, Sharing data with other MS Office applications and Accessing Bloomberg data with VBA.

Sign-up today (teams & execs welcome):  https://tinyurl.com/22jt8nzv 

Much career success, Lawrence E. Wilson - Financial Certification Academy