Skip to content
Search
Search
Home
Our Courses
Our Team
Privacy Policy
Refund & Returns
Terms & Conditions
Contact Us
Home
FMVA
FMVA Course
2025 | FM | Complete Study Package
2025 | FM | Videos Only
2025 | FM | Books Only
2025 | FM | Questions Bank Only
Excel basics for financial modeling course
CMA
2025 | Part 2 | Complete Study Package
2025 | Part 2 | Videos Only
2025 | Part 2 | Books Only
2025 | Part 2 | Questions Bank Only
FMAA (AR)
2025 | FMAA | Complete Study Package
2025 | FMAA | Videos only
2025 | FMAA | Book only
2025 | FMAA | Questions Bank only
CFA
2025 | CFA level (1) | Quantitative Methods
●●●
Contact
App Installation
Our Team
Menu
Home
FMVA
FMVA Course
2025 | FM | Complete Study Package
2025 | FM | Videos Only
2025 | FM | Books Only
2025 | FM | Questions Bank Only
Excel basics for financial modeling course
CMA
2025 | Part 2 | Complete Study Package
2025 | Part 2 | Videos Only
2025 | Part 2 | Books Only
2025 | Part 2 | Questions Bank Only
FMAA (AR)
2025 | FMAA | Complete Study Package
2025 | FMAA | Videos only
2025 | FMAA | Book only
2025 | FMAA | Questions Bank only
CFA
2025 | CFA level (1) | Quantitative Methods
●●●
Contact
App Installation
Our Team
Account
Excel basics for financial modeling
Categories:
Financial Modeling
Wishlist
What Will You Learn?
Understand Microsoft Excel
Understand How to use MS Excel
Excel formulas and functions
Excel tools
Dynamic tables
Pivot tables & charts
Using Excel in financial analysis
Cover Sheet Formatting & Hyperlinks
Course Content
A. Introduction and Guide
Course introduction
05:42
Download PDF & Excel Files
B. Microsoft excel overview
Start With Microsoft Excel
03:44
Excel interface
15:29
C. Aggregation formulas
Sum – Sum IF
05:01
Count – CountA – Count IF
06:45
Aggregation Formulas | Quiz
D. Valuation Formulas
Valuation Formulas
11:56
Valuation Formulas | Quiz
E. Logical Formulas
If (Simple – Nested) – IFS
11:52
IF (And, Or)
04:37
Logical Formulas | Quiz
F. Lookup Formulas
Vlookup – Hlookup
06:25
Xlookup
06:36
Index – Match
03:12
Index – Match – Aggregate
07:50
Lookup Formulas | Quiz
G. Scenarios
Filter – Sort – SortBy
05:55
Choose – Offset
11:25
Indirect Method
16:08
Scenarios | Quiz
H. Text Functions
Text Functions
10:02
Mid – Sequence – Trim
06:47
Text Functions | Quiz
R. Date Functions
Date Functions
09:10
yearfrac
01:48
Dates | Quiz
J. Finance Formulas
Sum Product (WACC)
01:32
NPV – XNPV – IRR – XIRR
02:59
PMT – IPMT – CUMIPMT – PPMT
04:36
Round
02:04
Finance Formulas | Quiz
K. Excel Tools
Conditional formatting
07:44
Formula Auditing
05:01
Excel Tools | Quiz
L. Dynamic Tables
Dynamic Tables & Slicer Tool
10:59
Dynamic Tables | Quiz
M. Pivot tables & Charts
Prepare PivotTable (P&L)
06:30
Calculated Field Pivot Table (P&L)
10:06
Charts
05:51
Dynamic Charts
06:02
Pivot tables | Quiz
N. Financial Ratios
Financial Ratios
08:39
Financial Ratios | Quiz
O. Cover Sheet Formatting & Hyperlinks
Cover sheet formatting
14:56
Cover sheet Formatting | Quiz
Student Feedback
Please leave your feedback!
Want to receive push notifications for all major on-site activities?
Enable Notifications
Never
✕
Login Or Register
Home
FMVA
FMVA Course
2025 | FM | Complete Study Package
2025 | FM | Videos Only
2025 | FM | Books Only
2025 | FM | Questions Bank Only
Excel basics for financial modeling course
CMA
2025 | Part 2 | Complete Study Package
2025 | Part 2 | Videos Only
2025 | Part 2 | Books Only
2025 | Part 2 | Questions Bank Only
FMAA (AR)
2025 | FMAA | Complete Study Package
2025 | FMAA | Videos only
2025 | FMAA | Book only
2025 | FMAA | Questions Bank only
CFA
2025 | CFA level (1) | Quantitative Methods
●●●
Contact
App Installation
Our Team
Home
FMVA
FMVA Course
2025 | FM | Complete Study Package
2025 | FM | Videos Only
2025 | FM | Books Only
2025 | FM | Questions Bank Only
Excel basics for financial modeling course
CMA
2025 | Part 2 | Complete Study Package
2025 | Part 2 | Videos Only
2025 | Part 2 | Books Only
2025 | Part 2 | Questions Bank Only
FMAA (AR)
2025 | FMAA | Complete Study Package
2025 | FMAA | Videos only
2025 | FMAA | Book only
2025 | FMAA | Questions Bank only
CFA
2025 | CFA level (1) | Quantitative Methods
●●●
Contact
App Installation
Our Team
Facebook
Youtube