# Fundamental Excel Skills for Finance

## How long?

• 1 day
• in person, online

## What are the topics?

New York Institute of Finance

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Business Analytics courses will introduce you to a popular and diverse profession. A business analyst is a specialist in many IT fields as well as in ...

Marketing courses will plunge you into the vast field of marketing. In these courses, you will learn a variety of topics that cover each stage of runn...

## Who should attend

• Financial analysts
• regulators risk managers and anyone seeking to be more productive by harnessing the power and functionality of MS Excel.

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

Prerequisite knowledge:

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

CURRICULUM

Day 1

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

WHAT YOU'LL LEARN

• Some familiarity with basic financial concepts
• Basic mathematics

Fundamental Excel Skills for Finance at New York Institute of Finance

From  \$989

Something went wrong. We're trying to fix this error.

## Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

To finalize your enrollment we will be in touch shortly.

### Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

What will you learn from Business Analytics courses? First of all, you will learn about the profession of a business analyst, his duties, and what such a specialist does. You will get various soft skills, such as organizing teamwork, for example, acc...

During Marketing courses, you will learn how to develop a business idea and create the right website to promote your product. You will gain the skills to analyze your business performance and make key decisions that improve the efficiency of your bus...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

#### Coursalytics

• Privacy
• All school and university names, program names, course names, brochures, logos, videos, images, and brands are property of their respective owners and not Coursalytics. All school and university names, program names, course names, brochures, logos, videos, images, and brand references used in this website are for identification and informational purposes only. Use of these school and university names, program names, course names, brochures, logos, videos, images, and brand references does not imply endorsement by, sponsorship by, or affiliation with the underlying school or university.

• Photos: UnsplashLogos provided by ClearbitFind jobs at Jooble

This product includes GeoLite2 data created by MaxMind, available from maxmind.com