Discover Classes. Earn Rewards.

Financial Analyst Training Program

Master Excel and corporate finance concepts while building a comprehensive valuation model in this intensive training program for aspiring financial analysts.

  • Level All levels
  • Age 18 and older
  • Price $1,295
  • Location Interactive Online Classroom

Start Dates (3)

  • $1,295
  • Interactive Online Classroom
20 seats left
Book
Show all 5 sessions
  • Mon, Mar 04 at 10:00am - 5:00pm
  • Tue, Mar 05 at 10:00am - 5:00pm
  • Wed, Mar 06 at 10:00am - 5:00pm
  • Thu, Mar 07 at 10:00am - 5:00pm
  • Fri, Mar 08 at 10:00am - 5:00pm
20 seats left
Book
Show all 5 sessions
  • Fri, May 17 at 10:00am - 5:00pm
  • Mon, May 20 at 10:00am - 5:00pm
  • Tue, May 21 at 10:00am - 5:00pm
  • Wed, May 22 at 10:00am - 5:00pm
  • Thu, May 23 at 10:00am - 5:00pm
20 seats left
Book
Show all 5 sessions
  • Thu, Aug 15 at 10:00am - 5:00pm
  • Fri, Aug 16 at 10:00am - 5:00pm
  • Mon, Aug 19 at 10:00am - 5:00pm
  • Tue, Aug 20 at 10:00am - 5:00pm
  • Wed, Aug 21 at 10:00am - 5:00pm
Save to WishList Purchase a Gift Card

Class Description

Description

What you'll learn in this financial analyst training:

Master Excel, key financial and corporate finance concepts, and build a full valuation model in this 5-day training program.

In this 5-day financial analyst program, you'll master Excel, review corporate finance and financial accounting concepts, and build a comprehensive valuation model on a public company. This bootcamp is the most effective and affordable course to gain the skills you need to succeed at a top financial firm.

  • Core Excel Skills: Build a strong foundation in Excel with formulas, functions, Pivot Tables, shortcuts, and more.
  • Advanced Excel for Financial Modeling: Learn advanced techniques including Goal Seek, financial functions, shortcuts, and cash flow projection tools.
  • Accounting, Corporate Finance & Valuation: Review corporate finance and accounting concepts, including enterprise value, the financial statement analysis, DCF modeling techniques, and corporate valuation principles.
  • Financial Modeling: Build an integrated 3-statement financial model. Create a DCF model on a public restaurant company using current financial data. Review company presentations, earnings releases, and financial reports to determine the model drivers and assumptions. Using valuation principles, you will derive a value per share and evaluate the equity as a potential investment.

Prerequisites

Since this program covers core Excel the first two days, there are no prerequisites. Prior knowledge of finance and accounting is helpful but not required as these topics are covered throughout the program. Attendees will receive a short pre-learning guide one week prior to the start of the course.

Curriculum

  • Excel for Business Fundamentals
  • Intermediate Excel for Business
  • Financial Modeling Bootcamp

What You’ll Learn at a Glance

Learn Excel, Finance, & Accounting in Hands-on Training

  • Functions: VLOOKUP, INDEX-MATCH, SUMIF
  • Excel Techniques including Pivot Tables, What-if Analysis
  • Shortcuts and tricks financial analysts need
  • Financial Accounting: Core statements, working capital, financial ratios
  • Financial Concepts: enterprise value, stocks, bonds, options
  • Financial Modeling: Projecting revenues, expenses, CapEx, and working capital
  • DCF Valuation: Deriving a share value from the financial model

Learn more about Financial Analyst Training Program at NYIM Training


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Also available in-person in NYC

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (742)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.

The company is known for its practical and hands-on approach to its instructor-led...

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

NYIM Training

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Choose from thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...