About this course
Master foundational Excel skills and best practices for financial analysis.
Prerequisites & Readiness Check
1 Parts
- 0:15 Hr
Prerequisites for Mastering Excel for Financial Analysis
15 Min
Chapter 1: Excel Fundamentals
2 Parts
- 3:30 Hr
Excel Basics
120 Min
Excel Best Practices
90 Min
Chapter 2: Data Preparation in Excel
3 Parts
- 5:30 Hr
Data Cleaning
120 Min
PivotTables
120 Min
Date Calculations
90 Min
Chapter 3: Financial Statements
2 Parts
- 3:30 Hr
Statement Creation
120 Min
Linking Statements
90 Min
Chapter 4: Financial Ratios
2 Parts
- 3:30 Hr
Basic Ratios
120 Min
Advanced Ratios
90 Min
Chapter 5: Time Value of Money
2 Parts
- 3:30 Hr
TVM Fundamentals
120 Min
Amortization Schedules
90 Min
Chapter 6: Advanced Excel Functions
2 Parts
- 3:30 Hr
Lookup Functions
120 Min
Advanced Logic
90 Min
Chapter 7: Scenario and Sensitivity Analysis
2 Parts
- 4:00 Hr
Scenario Tools
120 Min
Financial Dashboards
120 Min
Chapter 8: Financial Modelling
3 Parts
- 7:00 Hr
DCF Modelling
150 Min
LBO Modelling
150 Min
Cash Flow Modelling
120 Min
Chapter 9: VBA and Advanced Tools
3 Parts
- 6:00 Hr
VBA Automation
150 Min
Solver and Analysis ToolPak
120 Min
Cloud Collaboration
90 Min
Capstone Project 1
1 Parts
- 1:40 Hr
Comprehensive Financial Dashboard for Small Business Performance Analysis
100 Min
Capstone Project 2
1 Parts
- 1:40 Hr
DCF Valuation Model with Scenario & Stress Testing Automation
100 Min
No Reviews Yet
