This bootcamp combines advanced Excel training with real-world finance and accounting concepts, letting you learn on your schedule. You'll create professional financial models step by step, including integrated three-statement and discounted cash flow models, while developing the essential skills used in high-stakes financial analysis across corporate finance and investment roles.
As you work through the course, you'll strengthen Excel skills specific to finance, including advanced functions, data tables, auditing tools, data validation, and Goal Seek to create dynamic, accurate models. You'll also explore fundamental finance and accounting concepts such as enterprise value, accrual accounting, and market capitalization, then apply them by building complete valuation models with real company data. By the end, you'll know how to test your models, run sensitivity analysis, and use your outputs to support valuation and decision-making in professional settings.
What You Will Learn
- Essential financial concepts, including market capitalization and enterprise value
- Financial accounting fundamentals, with a focus on accrual versus cash accounting
- Discounted cash flow modeling, covering assumptions, cash flow projections, sensitivity analysis, and model auditing
- Advanced Excel techniques such as Data Validation, CHOOSE, Data Tables, and Goal Seek
- Leveraged buyout modeling and valuation fundamentals
- Real company financial analysis using practical data
- Structuring financial models and building clear, reliable projections
- Corporate valuation methods, how to calculate value per share, and interpreting and evaluating model outputs for accuracy and decision-making
This course 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.
