# Financial Analyst Training Program Course Online

Canonical URL: <https://vdci.edu/courses/financial-analyst-training-program-course-online>

## Overview

This financial analyst bootcamp gives you a well-rounded set of skills spanning Excel, corporate finance, financial accounting, and valuation, all built around practical, real-world application. You'll work your way from core Excel fundamentals through advanced modeling techniques, and finish by building a comprehensive valuation model for a real public company, giving you exactly the kind of experience that top financial firms are looking for.

No prior knowledge of finance or accounting is required, as both are covered thoroughly throughout the program. You'll receive a short pre-learning guide a week before the course kicks off to help you hit the ground running, and by the time you're done, you'll have hands-on experience with three-statement financial models, DCF analysis, and the kind of valuation work that drives real investment decisions.

## What you'll learn

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

## Curriculum
1. **Excel Fundamentals Course Online**
2. **Excel Intermediate Course Online**
3. **Financial Modeling Bootcamp Online**

## Instructors

### Colin Jaffe — Instructor

Colin Jaffe is a programmer, writer, and teacher with a passion for creative code, customizable computing environments, and simple puns. He loves teaching code, from the fundamentals of algorithmic thinking to the business logic and user flow of application building—he particularly enjoys teaching JavaScript, Python, API design, and front-end frameworks.

Colin has taught code to a diverse group of students since learning to code himself, including young men of color at All-Star Code, elementary school kids at The Coding Space, and marginalized groups at Pursuit.

Colin lives in Brooklyn with his wife, two kids, and many intricate board games.

## Pricing

**Tuition:** $1295