Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering Excel for Finance: Build Balance Sheet and Financial Statements
Introduction to the Course
1. Introduction To The Course (4:16)
2. Why Should You Learn Financial Analysis (4:22)
3. Introduction Of The Instructor (6:24)
4. Course Requirements (what Software, Experience) (5:46)
Excel Statement Models
1. What Will We Learn In This Section (2:35)
2. Preparing Data Source For P&l (16:08)
3. Create P&l Structure (13:27)
4. Adding Data To P&l (19:48)
5. Calculating Variances (11:51)
Build a Financial Balance Sheet in Excel
1. Balance Sheet Structure (10:43)
2. Adding Values On Bs From Different Files Format (20:38)
3. Cash Flow Structure (10:25)
4. Calculating Cash Flow (11:05)
5. Challenge (1:36)
Excel Finance Methods
1. What Will We Learn In This Section (5:48)
2. Forecast With Scenarios (23:30)
3. How To Calculate Finance Main KPI-s (15:38)
4. Fixed Assets Roll Forward (18:29)
5. Loan Schedule (13:54)
6. AR Management Basics (20:49)
7. Customers Rank (11:56)
8. Create Budgets Categories (19:45)
9. Challenge (1:25)
Summary
1 Course Summary And Next Steps (31:21)
9. Challenge
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock