Financial Analyst Training Program

Excel & Financial Modeling Courses NYC

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 Finance: 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: 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.

College or grad student searching for a program during Winter Break? Check out our dedicated Winter Break Financial Modeling & Excel Intensive.

Financial Analyst Training Program

$1185 35 Hours 185 Madison Avenue, NYC In-person classroom training

Register for a Package

Customize your own schedule or expand the start dates below to see the full schedule.

Custom Schedule
Register

Excel for Business Fundamentals

Mon, Feb 25, 10am–5pm

Intermediate Excel for Business

Tue, Feb 26, 10am–5pm

Financial Modeling Bootcamp

Mon–Wed, Mar 4–6, 10am–5pm

Corporate training available

Call 212-658-1918 or email us

The Financial Analyst Training Program includes

Excel for Business Fundamentals

Master the core Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use MS Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.

Intermediate Excel for Business

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.

Financial Modeling Bootcamp

Learn essential finance & accounting concepts while building a comprehensive financial valuation model in Excel. This financial modeling class blends finance, accounting, and advanced Excel concepts into an intensive 3-day course.
  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Financial Analyst Excel & Financial Modeling Courses

Training Program for Financial Analysts

To become a successful financial analyst, you'll likely need two main skills: 1) Excel and 2) financial modeling. 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