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)
2. Adding Values On Bs From Different Files Format
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience