Excel for Financial Analysis

Introduction
Welcome to the course
Course Resources
Prerequisites: Excel formulas and functions
Basic Formula Operations
Mathematical Functions
Difference between RANK, RANK.AVG and RANK.EQ
Textual Functions
Logical Functions
Date-Time Functions
Lookup Functions (V Lookup, Hlookup, Index-Match)
Time Value of Money
Future Value
Excel: Simple Interest and Compound Interest
Net Present Value
Internal Rate of Return
EXCEL: NPV and PV for calculating Present Value
Excel: Internal Rate of Return
Excel: NPV and IRR for particular dates
Analysis of Profit and Loss Statement
Horizontal and Vertical Analysis
Excel: Vertical Analysis
Excel: Horizontal Analysis
Loan Repayment Calculations
Loan Repayment concepts
1 of 5
Previous Lesson
Next Lesson

Mathematical Functions

Excel for Financial Analysis Mathematical Functions
Previous Lesson
Back to Course
Next Lesson
Login
Accessing this course requires a login. Please enter your credentials below!

Lost Your Password?
Register
Don't have an account? Register one!
Register an Account

Registration confirmation will be emailed to you.