# Financial Analyst Training Program (Self-Paced)

Canonical URL: <https://www.creativelive.com/classes/financial-analyst-training-program-self-paced>

## Overview

In this financial analyst program, you'll build foundational and intermediate Excel skills, brush up on corporate finance and financial accounting concepts, and construct a comprehensive valuation model for a public company. It's one of the most effective and affordable ways to pick up the skills you need to succeed at a top financial firm.

You'll start with core Excel skills like formulas, functions, Pivot Tables, and shortcuts before moving into advanced techniques including Goal Seek, financial functions, and cash flow projection tools. From there, you'll dig into accounting, corporate finance, and valuation concepts like enterprise value, financial statement analysis, and DCF modeling, then put it all together by building an integrated three-statement financial model and a DCF model for a real public company. Prior knowledge of finance and accounting is helpful but not required, as these topics are covered throughout the program.

## What you'll learn

- Write essential formulas and functions, including database functions like VLOOKUP and HLOOKUP
- Create persuasive data visualizations using line, column, and pie charts, and print and share your work
- Build Pivot Tables and work with logical statements like AND, OR, and IF, along with statistical functions like Ranking, COUNTIFS, and SUMIFS
- Perform real company analysis and set up models and projections using real world data
- Work with Discounted Cash Flow modeling, corporate valuation, and leveraged buyout modeling techniques
- Get comfortable with key financial accounting concepts, including market capitalization, enterprise value, and accrual and cash accounting

## Curriculum
1. **Excel Level I: Fundamentals Course Online (Self-Paced)**
2. **Excel Level II: Intermediate Course Online (Self-Paced)**
3. **Financial Modeling Bootcamp (Self-Paced)**

## Pricing

**Tuition:** $1295