Course Content

Introduction to Excel


  • 1. Introduction and Overview of Excel
  • 1. Basic Operations and Data Entry
  • 1. Introduction to formatting
  • 1. Introduction to Excel Formulas
  • 1. Excel Functions
  • 1. Cut copy, Paste Special
  • 1. Format Cells

Tips & Tricks in Excel


  • 1. Excel best practices
  • 1. Tips & tricks part 2
  • 1. Select Special & Dynamic Names
  • 1. Named Range & Hyperlink
  • 1. Custom Format No.
  • 1. Macros
  • 1. Freeze Panes & More
  • 1. Conditional formatting

Key Excel Functions


  • 1. SUM, SUMIF and SUMIFS
  • 1. Count, Average
  • 1. Text Modif, MaxMin
  • 1. VLookUP
  • 1. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP
  • 1. Choose and Goal Seek
  • 1. Rank and Iferror
  • 1.
  • 1.

Financial Functions in Excel


  • 1. Net Present Value
  • 1. Internal Rate of Return
  • 1. Loan and Interest Rate
  • 1. Date Functions

Mastering Excel Pivot Tables


  • 1. Intro Pivot Tables
  • 1. Modify
  • 1. GETPIVOTDATA
  • 1. Slicers

P&L from scratch in Excel


  • 1. P&L
  • 1. Compile Data
  • 1. Mapping, P&L

Building DCF Model


  • 1. Forcasting P&L Part 1
  • 1. Forcasting P&L Part 2
  • 1. Forcasting BS Part 1
  • 1. Forcasting BS Part 2
  • 1. Filling P&L
  • 1. Filling BS
  • 1. UFCF
  • 1. Net Cash Flow
  • 1. Completing Cashflow and BS
  • 1. Enterprise Value

Netflix Valuation | Practical Case Study


  • 1. Intro
  • 1. Revenue Modelling 1
  • 1. Revenue Modelling 2
  • 1. Other Items of P&L
  • 1. Other Items of the BS
  • 1. PP&E Schedule
  • 1. Content Assets Schedule
  • 1. Data Schedule
  • 1. Profit & Loss Part 1
  • 1. Profit & Loss Part 2
  • 1. Balance Sheet and Cash Flow Part 1
  • 1. Balance Sheet and Cash Flow Part 2
  • 1. WACC
  • 1. DCF & Outro