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 Will Learn
- Write essential formulas and functions, including lookup 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 ranking functions, 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
This program is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
