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

Check out more MS Excel courses in USA

PD Training Logo

Microsoft Access 2016 Introduction Training

Access 2016 is the database application in the Microsoft Office suite. A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data.

by PD Training [Claim Listing ]
Computer Resource Center Logo

Access

Relational database management that allows you to access information based on your structure. First session is an overview of database concepts and the construction of tables, including field properties.

by Computer Resource Center [Claim Listing ]
Softek Services Logo

Introduction to Microsoft Visio

This instructor-led, hands-on course teaches students the skills needed to create any kind of diagram using Visio. In this course you will create a route map, a basic diagram and flowchart, and an organization chart.

by Softek Services [Claim Listing ]
Training Washington Logo

Microsoft Excel

This one-day course teaches you the basics of work books and work sheets. You will learn how to enter and format data, text, and formulas; how to use pre-defined functions for basic calculations; and how to avoid errors.

by Training Washington [Claim Listing ]
Computer Images Logo

Microsoft Word

This workshop will teach you how to use Microsoft Word efficiently to prepare typical business documents such as letters, memoranda and reports.

by Computer Images [Claim Listing ]

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