Financial Analyst Training Program in NYC or Live Online

Hands-on Classes in NYC

  • tag-solid $1333 $1195
  • clock-solid 35 Hours
  • display-solid Mac or PC provided help-solid
  • users-solid Small in-person class
  • map-marker-solid 185 Madison Avenue, NYC
  • cloud-line Also available live online
All Financial Modeling Courses Financial Analyst Training Program

Financial Analyst Course in Manhattan, NYC

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.

Questions?

Do you have questions that aren't answered in the program descrtiption? Email the program director directly to find out if this is the right course for you.

Related Courses

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.

Upcoming Class Dates help-solid

Corporate training classroom
Career Centers teacher helping a student

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com
phone-handset-solid 212 • 684 • 5151
file-group-solid Download Syllabus

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

file-group-solid Download PDF Outline

Excel for Business Fundamentals

Introduction

  • Interface
  • Data Entry

Formulas

  • Autofill
  • Calculations
  • True or False
  • AutoSum Functions
  • Text Functions
  • Multi-Input Functions
  • Absolute Cell References

Formatting

  • Formatting
  • Format Painter
  • Conditional Format

Charts & Tables

  • Line Chart
  • Column Chart
  • Pie Chart
  • Tables

Workbook Management

  • Printing
  • Worksheets
  • Repeat Action
  • Shortcuts

End of Class Project

  • Project
  • Save and Close

Intermediate Excel for Business

Worksheet Management

  • Navigation
  • Paste Special

Working with Text

  • Splitting Text
  • Joining Text
  • Named Ranges
  • Data Validation
  • Sort & Filter
  • Remove Duplicates

Database Functions

  • VLOOKUP
  • HLOOKUP
  • VLOOKUP - Closet Match

Logical Functions

  • AND, OR
  • IF statements

Pivot Tables

  • Pivot Tables
  • Pivot Tables & Grouping
  • Multiple Pivot Tables

Statistical Functions

  • Ranking
  • COUNTIFS
  • SUMIFS

Advanced Charts

  • Combo Charts

End of Class Project

  • Project

Financial Modeling Bootcamp

Day I: Advanced Excel for Financial Modeling

  • Advanced techniques to Expedite Workflow
  • Advanced Analytical Tools & Sensitivity Analysis
  • Database Functions for Finance
  • Functions for Financial Modeling

Day II: Intro to Corporate Finance, Accounting, & Modeling

  • Intro to Corporate Finance
  • Enterprise value
  • Financial Accounting & Statement Analysis
  • Integrated Financial Modeling
  • Intro to DCF Modeling
  • Sensitivity Analysis
  • Intro to LBO Modeling

Day III: In-depth Financial Modeling & Valuation

  • Company Analysis
  • Financial projections
  • Terminal Value
  • Discounting Cash Flows
  • Corporate Valuation
  • Final Analysis & Reasonability Testing

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