Introduction
  • Introduction
  • Course Overview
  • Download Course Worksheets Here
Excel Overview
  • Basic Overview
Simple Financial Setup
  • Objectives
  • Freeze Panes, Formatting,
  • Simple Forecasting, Copy & Paste, Percentages
  • Formatting, Grouping, Copy Tabs
  • Simple Setup Quiz
Simple Functions
  • Objectives
  • Averages, Weighted Averages, Median
  • Dates
  • If Statements
  • Min, Max, Small, Large
  • Simple Functions Quiz
Advanced Financial Setup
  • Objectives
  • Common Size Income Statement
  • Naming Cells
  • Advanced Setup Quiz
Advanced Functions
  • Objectives
  • Data Validation, Drop Down List
  • Vlookup, Hlookup, Index & Match
  • NPV, IRR, Payback Period
  • Advanced Functions Quiz
Macros
  • Objectives
  • Macros
Times Series Forecasting
  • Objectives
  • Forecasting Part 1
  • Forecasting Part 2
  • Forecasting Part 3
  • Forecasting Quiz
Financial Modeling
  • Objectives
  • Income Statement
  • Balance Sheet
  • Statement of Cash Flows
  • Debt Schedule
  • PP&E Schedule
  • Performance Ratios
  • Liquidity Ratios
  • Financing Ratios
  • Activity Ratios
  • Financial Modeling Quiz
Pivot Table & Dashboard
  • Objectives
  • Pivot Table 1
  • Pivot Table 2
  • Dashboards
Conclusion
  • Conclusion