Financial Analyst Training Program (Self-Paced)
IDCFASP

Self-paced online training with expert support 3 modules

Develop genuine financial modeling skills by mastering Excel, reviewing essential corporate finance concepts, and constructing a valuation model for a real public company. You'll strengthen your Excel abilities, discover how to read financial statements, build valuations, and begin predicting market trends with confidence.

$1,295 30 clock hours Live Support Start anytime

This course includes

  • 30 hours of project-based training from experts
  • 40 training videos
  • Software Access
  • Answers from real instructors
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution

This financial analyst bootcamp provides you with a comprehensive set of skills spanning Excel, corporate finance, financial accounting, and valuation, all built around practical, real-world application. You'll work your way from essential Excel fundamentals through advanced modeling techniques, and finish by creating 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 starts to help you hit the ground running, and by the time you're finished, you'll have hands-on experience with three-statement financial models, DCF analysis, and the kind of valuation work that drives real investment decisions.

Read more

Courses & Videos in This Package

Download Syllabus PDF

Unit 1 6 Hours

Beginner Excel Course (Self-Paced)

In this beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.

  • Become familiar with the interface and data entry
  • Learn essential formulas and functions
  • Format and print your work
  • Create charts, including line, column, and pie charts
  • Learn tips and tricks for easy workbook management
  • Review key concepts in a final project
Lesson 1: Introduction
Lesson 2: Formulas
Lesson 3: Formatting
Lesson 4: Charts & Tables
Lesson 5: Workbook Management

Unit 2 6 Hours

Intermediate Excel Course (Self-Paced)
  • Learn to split and join text, apply data validation, and create named ranges
  • Use database functions such as VLOOKUP and HLOOKUP
  • Write logical formulas using AND, OR, and IF functions
  • Create Pivot Tables to efficiently summarize and analyze large datasets
  • Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
  • Build advanced combo charts by combining multiple chart types
  • Reinforce key concepts through a guided final project
Lesson 5: Workbook Management
Lesson 1: Worksheet Management
Lesson 2: Working with Text
Lesson 3: Cell Ranges
Lesson 4: Database Functions
Lesson 5: Pivot Tables
Lesson 6: Logical Functions
Lesson 7: Statistical Functions
Lesson 8: Advanced Charts

Unit 3 18 Hours

Financial Modeling Bootcamp (Self-Paced)

Take this financial modeling class to develop a strong foundation in finance and accounting while building practical, real-world modeling skills. You'll discover how to create a discounted cash flow (DCF) model in Excel, strengthen advanced Excel techniques, explore corporate finance and valuation concepts, and create a complete financial model using real company data.

  • Master essential financial concepts, including market capitalization, enterprise value, and the difference between accrual and cash accounting
  • Create a complete DCF model with assumptions, cash flow projections, sensitivity analysis, and model auditing
  • Apply advanced Excel techniques such as Data Validation, CHOOSE, Data Tables, and Goal Seek
  • Set up financial models, develop reliable projections, and calculate corporate valuation and value per share
  • Analyze and interpret model outputs to support informed financial decision-making
  • Apply leveraged buyout modeling concepts and structure using real company data
A group of adult learners sits in a classroom, smiling and engaged in a government training session.
A government training instructor in a suit gestures while teaching in front of a whiteboard covered with notes and diagrams.
A person in professional attire holds a Graduate School USA folder, symbolizing participation in government training programs.