Excel Financial Analysis
Learn Excel statement models and finance models.
Created by John Bura
01
Skill level
All levels
02
Sections
4
03
Lectures
27
04
Instructor
John Bura
What's inside
This course includes.
✓
4
Sections
✓
27
Lectures
✓
27
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.
+ 01. Introduction to the Course 5 lectures
1.2 Why Should You Learn Financial Analysis
Locked
1.1 Introduction To The Course
Locked
1.3 Introduction Of The Instructor
Locked
1.4 Course Requirements (what Software, Experience)
Locked
Source Files
Locked
+ 02. Excel Statement Models 11 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
Source files
Locked
+ 03. Excel Finance Methods 10 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
Source Files
Locked
+ Summary 1 lecture
4.1 Course Summary And Next Steps
Locked
Description
About this course.
Learn everything you need to know about financial analysis in this hands on Excel course.
Build a balance sheet and learn to calculate cash flow with Excel statement models.
Learn finance methods to build practical projects.
And much more!
A SCHOOL YOU CAN TRUST
- Lifetime access that never expires
- Project-based curriculum to superboost your portfolio
- Graduation certificate for every course
- Absolute beginner-friendly
- New courses every month
- Efficient lectures with step by step explanations
- Relevant industry topics 8 years of award-winning course delivery
- 700,000 students in 186 countries
- Learn with free tools and affordable courses
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.
Instructors
Taught by people who ship.
John Bura
Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.
Ready to start building?
Learn Excel statement models and finance models.