Excel and VBA Programming for Finance

New York Institute of Finance

ITEM EXVBA2018

07 Oct 2024 - 09 Oct 2024

09:00 AM - 04:30 PM

$2,489.00

group

In person

update

3

language

English

school

Professional

07 Oct 2024 - 09 Oct 2024

09:00 AM - 04:30 PM

$2,489.00

videocam

In person

update

3

language

English

school

Professional


Questions? We're here to help you

Please complete this form and a NYIF Career Advisor will assist you.



Please fill in the field.

Next

Please complete this form and a NYIF Career Advisor will assist you.



Please fill in the field.

Prev
Next

Please complete this form and a NYIF Career Advisor will assist you.


Please fill in the field.

Prev
Next

Select preferred contact method

Schedule call

call center image

or

Please fill in the field.

Send us your questions

email image
Prev

Where Wall Street Goes to SchoolTM!

Please select a time and date from the calendar to book a 15-minute call with a NYIF Career Advisor.

You can also reach us on +1 347 842 2501 or marketing@nyif.com

Something went wrong, please try again later!

17

Excel and VBA Programming for Finance

This course 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:

Prerequisite knowledge:

  • Basic familiarity with MS Excel
  • Basic mathematics and statistics
  • Some knowledge of financial instruments and markets

Learn now pay later with

To make it even easier to learn, you can finance your program through Affirm.

Loans offered through Affirm are available in the U.S. and Canada.

  • Easy monthly payments

    Learn more

  • Flexible payments

    Pay your monthly bill using a bank transfer, check, or debit card.

Module 1: Review of Excel Basics

  • Ranges
  • Basic functions
  • Creating formulas
  • Creating charts

Module 2: Useful Excel Functions

  • Logical and information functions
  • Text functions
  • Lookup functions
  • Date and time functions
  • Mathematical functions
  • Statistical functions
  • Arrays and matrices
  • Solving sytems of linear equations: Matrix algebra

Module 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

Module 4: Data Analysis

  • Sorting and filtering data
  • Data tables
  • Pivot tables
  • Importing Bloomberg data
  • Statistical and regression analysis

Module 1: VBA Fundamentals

  • The VBA IDE
  • Recording and running macros
  • Data types, variables, constants and arrays
  • Functions and subroutines
  • Private vs. public procedures
  • Built-in functions and statements

Module 2: 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

Module 1: Advanced VBA Topics

  • Passing arguments to subroutines and functions
  • Pass by value vs. pass by reference
  • The Excel object model
  • Debugging
  • Error trapping
  • Creating add-ins

Module 2: Working with Data

  • External data, files, databases and websites
  • Reading and writing .csv and .txt files
  • Sharing data with other MS Office applications
  • Accessing Bloomberg data with VBA
Customize Excel and VBA Programming for Finance

* Required Fields

Your Customization
Excel and VBA Programming for Finance

In stock

$2,489.00

Summary