Fundamental Excel Skills for Finance

New York Institute of Finance

ITEM FESF2017

07 Oct 2024 - 07 Oct 2024

09:00 AM - 04:30 PM

$1,099.00

group

In person

update

1

language

English

school

Professional

07 Oct 2024 - 07 Oct 2024

09:00 AM - 04:30 PM

$1,099.00

videocam

In person

update

1

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

Fundamental Excel Skills for Finance

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

This course is a component of the Excel and VBA Programming for Finance course

Prerequisite knowledge:

  • Some familiarity with financial instruments and markets
  • Basic mathematics and statistics

Experience NYIF Virtual:


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
Customize Fundamental Excel Skills for Finance

* Required Fields

Your Customization
Fundamental Excel Skills for Finance

In stock

$1,099.00

Summary