Mastering Excel for Finance: Build Balance Sheet and Financial Statements
Created by Team Mammoth
01
Skill level
All levels
02
Sections
4
03
Lectures
24
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
4
Sections
✓
24
Lectures
✓
24
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ Introduction to the Course 4 lectures
1.1 Introduction To The Course
Locked
1.2 Why Should You Learn Financial Analysis
Locked
1.3 Introduction Of The Instructor
Locked
1.4 Course Requirements (what Software, Experience)
Locked
+ Excel Statement Models 10 lectures
2.1 What Will We Learn In This Section
Locked
2.2 Preparing Data Source For P&l
Locked
2.3 Create P&l Structure
Locked
2.4 Adding Data To P&l
Locked
2.5 Calculating Variances
Locked
2.6 Balance Sheet Structure
Locked
2.7 Adding Values On Bs From Different Files Format
Locked
2.8 Cash Flow Structure
Locked
2.9 Calculating Cash Flow
Locked
2.10 Challenge
Locked
+ Excel Finance Methods 9 lectures
3.1 What Will We Learn In This Section
Locked
3.2 Forecast With Scenarios
Locked
3.3 How To Calculate Finance Main KPI's
Locked
3.4 Fixed Assets Roll Forward
Locked
3.5 Loan Schedule
Locked
3.6 Ar Management Basics
Locked
3.7 Customers Rank
Locked
3.8 Create Budgets Categories
Locked
3.9 Challenge
Locked
+ Conclusion 1 lecture
4.1 Course Summary And Next Steps
Locked
Instructors
Taught by people who ship.
Team Mammoth
Instructor
Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.