Discover Classes. Earn Rewards.

Financial Analyst Training Program

Master advanced Excel, corporate finance, and corporate valuation in this intensive five-day bootcamp at NYC Career Centers. Gain the skills to work as a financial analyst and impress potential employers with your expertise in financial modeling and cash flow projection tools in Excel. Take your career to the next level with this comprehensive training program.

  • All levels
  • 18 and older
  • $1,295
  • 185 Madison Ave, New York, NY & Virtually Online
  • 35 hours over 5 sessions

Start Dates (2)

  • $1,295
  • Career Centers @ 185 Madison Ave Suite 1104, New York, NY 10016
  • 35 hours over 5 sessions
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
Showing 12 of 2

Class Description

Description

What you'll learn in this financial analyst training:

Master advanced Excel, corporate finance, and corporate valuation in this intensive five-day bootcamp.  You’ll learn the terms and vocabulary used within the industry to prepare you for interviews and have a valuation model to present from your portfolio. After this course, you’ll be prepared to work as a financial analyst.

Learn Microsoft Excel and Corporate Finance. The five-day Financial Analyst Training program offers the most affordable and comprehensive training available for complete beginners to learn the necessary skills to become a financial analyst. By the end of this course, you’ll have the skills for a position at a Fortune 500 firm.

Throughout the course, you’ll develop the following skills:

  • Excel proficiency - Master formulas, functions, and Pivot Tables
  • Excel for Financial Modeling - Learn Goal Seek and other financial functions in Excel
  • Corporate Finance and Accounting - Learn corporate finance and accounting concepts
  • Financial Modeling - Build a three-statement DCF model on a public company

By the end of this course, you’ll have knowledge of cash flow projection tools in Excel. You’ll develop experience with financial statement analysis and DCF modeling techniques, and corporate valuation principles. Each student will learn to review financial data, including earnings releases, financial reports, and use this information to evaluate business decisions.

Prerequisites

  • None; Prior knowledge of corporate finance and accounting is helpful, but not required.

  • Course attendees will receive access to our free online corporate finance and accounting materials before the course.

The Financial Analyst Training Program Includes

Beginner Microsoft Excel

  • Get going with the basics of Excel and start working on projects in Excel. Get practice with calculations and formulas, charts and tables, worksheet and workbook formatting, and basic hotkeys to accelerate your workflow. 

Intermediate Microsoft Excel

  • Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.

Financial Modeling Bootcamp

  • Build a financial model and learn corporate finance and accounting principles. By the end of this course, you'll have a comprehensive Discounted Cash Flow (DCF) model to add to your portfolio. You'll have a fundamental knowledge of corporate finance and accounting concepts. Finally, your advanced Microsoft Excel skills will aid you in building financial models quickly and accurately.

Full Course Syllabus

Excel for Business Fundamentals

  • Introduction
  • Formulas
  • Formatting
  • Charts & Tables
  • Workbook Management
  • End of Class Project

Intermediate Excel for Business

  • Worksheet Management
  • Working with Text
  • Database Functions
  • Logical Functions
  • Pivot Tables
  • Statistical Functions
  • Advanced Charts
  • End of Class Project

Financial Modeling Bootcamp

  • Day I: Advanced Excel for Financial Modeling
  • Day II: Intro to Corporate Finance, Accounting, & Modeling
  • Day III: In-depth Financial Modeling & Valuation

Excel & Financial Modeling Courses for Financial Analysts

Training Program for Investment Banking, Hedge Funds, Private Equity, Real Estate & Finance Professionals

To become a successful financial analyst, you'll need several skills, including a strong comfort level in Excel, a background in accounting, finance, and valuation, and financial modeling capabilities. This training program is geared toward current or aspiring financial analysts, including investment banking, private equity, hedge funds, asset management, real estate, and venture capital.

After completing this program, you will:

  • Go from beginner to advanced in your  Excel capabilities
  • Learn accounting concepts: Financial statements, working capital, and footnotes
  • Learn financial concepts: Enterprise value, corporate valuation, Discounted Cash Flow Modeling, LBO Modeling
  • Build financial modeling skills: Learn how to project cash flows for companies in Excel



Learn more about Financial Analyst Training Program at NYC Career Centers

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 NYC Career Centers (679)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Read more about NYC Career Centers

CourseHorse Approved

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

NYC Career Centers

NYC Career Centers

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

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
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

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
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...