Excel Financial Analysis
If you do any type of financial analysis, you know that Excel is the tool of choice and it understanding its nuances is essential for you. This program helps you to understand how to use Excel in any financial analysis.
Segment - 01 - Introduction to the Course
Segment - 02 - Why should you learn Financial Analysis
Segment - 03 - Introduction of the Instructor
Segment - 04 - Course Requirements (what software, experience)
Source File
Segment - 05 - What will we learn in this section
Segment - 06 - Preparing Data Source for P&I
Segment - 07 - Create P&I Structure
Segment - 08 - Adding Data to P&I
Segment - 09 - Calculating Variencies
Segment - 10 - Balance Sheet Structure
Segment - 11 - Adding Values on BS from different Files Format
Segment - 12 - Cash Flow Structure
Segment - 13 - Calculating Cash Flow
Segment - 14 - Challenge
Source File
Segment - 15 - What will we learn in this section
Segment - 16 - Forecast with Scenarios
Segment - 17 - How to Calculate Finance Main KPI's
Segment - 18 - Fixed Asset Roll Forward
Segment - 19 - Loan Schedule
Segment - 20 - AR Management Basics
Segment - 21 - Customer Rank
Segment - 22 - Create Budget Categories
Segment - 23 - Challenge
Source File
Segment - 24 - Course Summary and Next Steps