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

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 ]
Phoenix Computer Consultants Logo

PowerPoint 2010 Comprehensive Course

A comprehensive PowerPoint 2010 course, covering creating, editing, customizing and delivering PowerPoint presentations.  

by Phoenix Computer Consultants [Claim Listing ]
UC San Diego Extended Studies Logo

Intermediate Excel

This course will build a strong foundation of knowledge for you to use Excel in the most effective way to analyze your Excel data and keep up with market trends.

by UC San Diego Extended Studies [Claim Listing ]
Coastal Carolina Community College Logo

Office 365 Boot Camp Level I

This course is designed to help users get started with the collaborative cloud-based Office 365 environment. Learn to navigate and identify the components for the Office 365 environment, create, edit, share, and collaborate documents with team member.

by Coastal Carolina Community College [Claim Listing ]
Future Media Concepts Logo

Enabling & Managing Office 365 (M20347)

In this course, you will learn to evaluate, plan, deploy, and operate Microsoft Office 365 services, including its identities, dependencies, requirements, and supporting technologies. You will learn the skills required to set up and sustain an Office 365 tenant and users.

by Future Media Concepts [Claim Listing ]

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