# Financial Analyst Training Program

Canonical URL: <https://www.careercenters.com/courses/financial-analyst-training-program>

## Overview

### Financial Analyst Course in NYC or Live Online

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 and financial reports, and use this information to evaluate business decisions.

## What you'll learn

- **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

## Curriculum
1. **Financial Modeling Bootcamp**
2. **Intermediate Microsoft Excel**
3. **Beginner Microsoft Excel**

## Schedule
- Aug 24, 2026 – Aug 28, 2026 — NYC
- Oct 19, 2026 – Oct 23, 2026 — NYC

## Pricing

**Tuition:** $1295