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 Excel 2016 Advanced

The PD Training Microsoft Excel 2016 Advanced Training Course provides you with comprehensive training in the advanced features of Excel 2016, including creating and running Macros, Flash Fill, formulas and functions, data management, customizations, auditing, grouping and transporting data and sol...

by PD Training [Claim Listing ]
Zoe Training and Consulting Logo

MS Word (Beginner)

In this course, you’ll learn how to use Word to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.

by Zoe Training and Consulting [Claim Listing ]
City College Of San Francisco Logo

Microsoft Excel

This course provides in-depth coverage of the concepts and techniques required to use Microsoft Excel to create spreadsheets to express, analyze, and solve business-related problems, and to assist in the preparation for the Microsoft Office Specialist Excel certification exam.

by City College Of San Francisco [Claim Listing ]
Micro Assist Logo

Excel 2016 (Part 1)

Organizations around the world rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging.

by Micro Assist [Claim Listing ]
CompuTutor Logo

Microsoft Office Access 2010 (Level 1)

Microsoft Office Access 2010 training is offered by CompuTutor for beginners. Upon successful completion of this course, students will be able to identify the basic components of an Access database.

by CompuTutor [Claim Listing ]

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