< Excel Financial Analysis

24 casts | 5:01:47 for the total course

created by Mammoth Interactive INC

• 1. Intro to the Course
  • Excel Financial Analysis | Intro to the Course | 1.1

  • Excel Financial Analysis | Why Should You Learn Financial Analysis | 1.2

  • Excel Financial Analysis | Intro of the Instructor | 1.3

  • Excel Financial Analysis | Course Requirements | 1.4

• 2. Excel Statement Models

  • Excel Financial Analysis | What Will We Learn In This Section | 2.1

  • Excel Financial Analysis | Preparing Data Source For P&I | 2.2

  • Excel Financial Analysis | Create P&I Structure | 2.3

  • Excel Financial Analysis | Adding Data To P&I | 2.4

  • Excel Financial Analysis | Calculating Variances | 2.5

  • Excel Financial Analysis | Balance Sheet Structure | 2.6

  • Excel Financial Analysis | Adding Values On Bs From Different Files Format | 2.7

  • Excel Financial Analysis | Cash Flow Structure | 2.8

  • Excel Financial Analysis | Calculating Cash Flow | 2.9

  • Excel Financial Analysis | Challenge | 2.10

• 3. Excel Finance Methods

  • Excel Financial Analysis | What Will We Learn In This Section | 3.1

  • Excel Financial Analysis | Forecast With Scenarios | 3.2

  • Excel Financial Analysis | How To Calculate Finance Main KPI's | 3.3

  • Excel Financial Analysis | Fixed Assets Roll Forward | 3.4

  • Excel Financial Analysis | Loan Schedule | 3.5

  • Excel Financial Analysis | AR Management Basics | 3.6

  • Excel Financial Analysis | Customers Rank | 3.7

  • Excel Financial Analysis | Create Budgets Categories | 3.8

  • Excel Financial Analysis | Challenge | 3.9

• 4. Summary

  • Excel Financial Analysis | Course Summary and Next Steps | 4.1