Fundamental Excel Skills For Finance

by NYIF (New York Institute of Finance) Claim Listing

This hands-on program develops the fundamental MS Excel skills essential for a wide variety of roles in finance and related disciplines.

$1099

Contact the Institutes

Fill this form

Advertisement

NYIF (New York Institute of Finance) Logo

img Duration

1 Day

Course Details

This hands-on program develops the fundamental MS Excel skills essential for a wide variety of roles in finance and related disciplines.

 

Content:

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
  • New York Branch

    160 Broadway 15th floor, New York

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy