
Financial Analyst Training Program Course Online
Prefer to enroll directly? Open the course website.
Financial Analyst Training Program Course Online
Summary
A 30-hour bundle pairing Excel fundamentals and intermediate Excel with a financial modeling bootcamp. It covers corporate finance, financial accounting, and valuation from the ground up, and assumes no prior finance or accounting background.
The program builds toward a full valuation model for a real public company, working through three-statement models and discounted cash flow analysis along the way. VDCI sends a short pre-learning guide about a week before the course begins.
Who this course is for
People preparing for financial analyst roles, and professionals who need modeling and valuation skills without an existing finance background.
Certifications covered by this course
No certifications are covered by this course.
Topics included
No specific topics are covered by this course.
Curriculum
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
Course outline
- 1 Excel Fundamentals Course Online 6 hours
- 2 Excel Intermediate Course Online 6 hours
- 3 Financial Modeling Bootcamp Online 18 hours
What's included
- 30 hours of project-based instruction
- 40 training videos
- Software access during the course
- Instructor support for questions during the course
- Class recordings for 30 days
- Verified digital certificate of completion
- Instruction at an ACCET-accredited school
Stated by the provider. Confirm what your tuition covers before enrolling.