Financial Analyst Training Program (Self-Paced)

Self-paced online training with expert support 3 modules

Master Excel, brush up on corporate finance, and build a valuation model for a public company. You'll develop intermediate Excel skills and learn how to read financial statements, build valuations, and predict 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 basic and intermediate Excel skills, review corporate finance and financial accounting concepts, and construct a comprehensive valuation model for a public company. This bootcamp is the most effective and affordable way to gain the skills you need to succeed at a top financial firm. The program covers core Excel skills, giving you a strong foundation with formulas, functions, Pivot Tables, and shortcuts. You'll also dive into advanced Excel for financial modeling, learning techniques like Goal Seek, financial functions, shortcuts, and cash flow projection tools. On the finance side, you'll review accounting, corporate finance, and valuation concepts, including enterprise value, financial statement analysis, DCF modeling techniques, and corporate valuation principles.

The program wraps up with financial modeling, where you'll build an integrated 3 statement financial model and create a DCF model for a public restaurant company using current financial data. You'll work through company presentations, earnings releases, and financial reports to determine the model drivers and assumptions. Applying valuation principles, you'll derive a value per share and evaluate the equity as a potential investment. Prior knowledge of finance and accounting is helpful but not required, since these topics are covered throughout the program. Attendees will receive a short pre learning guide one week before the course begins.

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.

  • Business Analyst Certificate (Self-Paced)
    63 hours $2,995

    Master the essential skills to become a Business Analyst at your own pace with this comprehensive certificate program. Learn Excel, PowerPoint, SQL, and Tableau while gaining hands-on experience in data analysis, visualization, and presentation design.

  • AI for Excel (Self-Paced)
    6 hours $649

    Learn to harness AI tools to eliminate tedious Excel tasks, automate data cleaning, and accelerate analysis.

  • Financial Modeling Bootcamp (Self-Paced)
    18 hours $995

    Take this self-paced financial modeling class to learn core finance and accounting concepts, build a discounted cash flow model in Excel, strengthen advanced Excel skills, and explore corporate finance and valuation using real company data. The course focuses on practical, job-ready financial modeling skills you can apply at your own pace.

  • 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.

Yelp Facebook LinkedIn YouTube Twitter Instagram