Financial Analyst Training Program (Self-Paced)

Self-paced online training with expert support 3 modules

Build your Excel skills, sharpen your corporate finance knowledge, and construct a valuation model on a real public company. You'll cover everything from fundamental and intermediate Excel techniques to reading financial statements, building valuations, and predicting market trends.

$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

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.

Read more

Courses & Videos in This Package

Download Syllabus PDF

Unit 1 6 Hours

Excel Level I: Fundamentals Course Online (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

Excel Level II: Intermediate Course Online (Self-Paced)

Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.

  • 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 build a strong foundation in finance and accounting while developing practical, real-world modeling skills. You'll learn how to create a discounted cash flow (DCF) model in Excel, strengthen advanced Excel techniques, explore corporate finance and valuation concepts, and build a complete financial model using real company data.

  • Master core financial concepts, including market capitalization, enterprise value, and the difference between accrual and cash accounting
  • Build 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, build 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

Related Courses: Compare to Financial Analyst Training Program (Self-Paced)

These related courses share skills and topics with Financial Analyst Training Program (Self-Paced). Select up to two and tap Compare selected courses to view a side-by-side comparison.

  • AI for Financial Services (Self-Paced)
    12 hours $899

    Use Claude to streamline drafting, analysis, and documentation with a personalized workflow that supports client communications, reporting, compliance work, and professional review.

  • Excel for Data Analytics Course Online (Self-Paced)
    18 hours $595

    Improve your data analysis skills with our Excel for Data Analytics class. Learn essential functions, formulas, and advanced techniques like Pivot Tables and VLOOKUP. Gain hands-on experience and optimize your workflow for efficient data analysis.