Financial Analysis & Modeling in Microsoft Excel
Self-paced video training — 18 modules, 88 lessons. Work through it at your own pace — every lesson is real recorded training, not slide-reading.
▶INSIDE THE COURSE · 88 LESSONSABOUT THIS COURSE
In this intermediate course, students will enhance their Excel skills by focusing on financial analysis and modeling techniques. They will learn to apply key concepts such as the time value of money, including future and present value calculations, and analyze profit and loss statements using horizontal and vertical analysis methods. Practical exercises will reinforce these concepts, allowing students to build robust financial models.
CURRICULUM
18 modules, in order.
01Introduction1 LESSONS
this lesson introduces you to the course and its objectives.
02Prerequisites Excel formulas and functions7 LESSONS
learn about basic operations using formulas in excel.
this lesson marks a significant point in your learning.
explore how to use mathematical formulas in excel.
discover how to create textual formulas in excel.
learn to implement logical formulas in excel.
understand how to work with date and time formulas.
get familiar with lookup formulas including vlookup and hlookup.
03Time Value of Money7 LESSONS
learn how to calculate future value in financial analysis.
understand simple and compound interest calculations in excel.
explore how to determine net present value using excel.
learn to calculate internal rate of return in excel.
discover how to use excel functions to calculate present value.
explore excel methods for calculating internal rate of return.
learn to calculate net present value and internal rate of return for specific dates.
04Analysis of Profit and Loss Statement3 LESSONS
perform horizontal and vertical analysis of profit and loss statements.
learn to conduct vertical analysis using excel.
explore how to perform horizontal analysis in excel.
05Loan Repayment Calculations3 LESSONS
understand loan repayment concepts and their implications.
learn how to calculate loan payments using excel.
discover how to calculate rate or term for loans in excel.
06Methods of calculating Depreciation4 LESSONS
explore various depreciation methods, focusing on straight line method.
learn about double declining balance depreciation calculations.
understand the sum of years digits method for depreciation.
learn how to calculate depreciation using excel.
07Financial Ratio Analysis2 LESSONS
this lesson covers the theory behind financial ratios used in analysis.
learn how to build a template in Excel for financial ratio analysis.
08Financial Charts and Dashboards - Introduction1 LESSONS
introduction to financial charts and their importance in data representation.
CURATED BY
Selected from experienced educators' training libraries and kept whole — modules, worked examples and walkthroughs exactly as taught.
GOOD TO KNOW
Lessons stream in the browser and remember where you stopped.
Watch on two devices at once — phone, tablet or desktop.
Download buttons are disabled; delivery is encrypted and authenticated per request.
$99 · ONE PAYMENT
Own every lesson, for life.
One payment unlocks all 88 lessons instantly — start with lesson one the moment you check out.