Master Excel, review corporate finance, and build a valuation model on a public company. Gain basic and intermediate Excel skills and learn how to read financial statements, build valuations, and predict market trends.
Overview
Syllabus
- Excel Level I: Fundamentals
- Learn how to use functions to speed up your workflow
- Add formatting and other visual effects
- Turn data into visual charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
- Excel Level II: Intermediate
- Learn to split and join text, add data validation, and named ranges
- Use database functions and logical statements
- Create Pivot Tables to quickly summarize large databases
- Create advanced combo charts from multiple charts
- Financial Modeling Bootcamp
- Learn essential finance & accounting concepts
- Discover Excel formulas & functions for financeÂ
- Build a comprehensive discounted cash flow (DCF) model
Taught by
Mourad Kattan and Dan Rodney
