Microsoft Excel for Finance Professionals

NPV, IRR, XNPV, XIRR, PMT, FV, NPER, WHAT-IF ANALYSIS, AMORTIZATION, DEPRECIATION, FITTING CURVE, SOLVER

If you want to learn Excel for finance, then you’ve come to the right spot. Microsoft Excel has hundreds of functions and formulas to store, analyze, and alter data efficiently. However, no one really needs to know all of them to be able to work effectively on Excel.

Who should take this course:

Accounting students
Finance students
Accounting professionals
Finance professionals
Entrepreneurs and Business Owners with Finance knowledge
Investors with Finance knowledge

Why you should learn Excel for Finance:

This course will change the way you work and will save your hours otherwise spent on complex calculations. You will be able to calculate the values you need for analysis and decisions just by writing small and easy formulas. The rest of your time can then be spent on tasks that matter!

Finance:

Concept of Time Value of Money
Present Value and Future Value concept
Conversion from present value to future value, and from future value to present value
Concept of Discount factor and Annuity
Concept and calculation of NPV
Concept of calculation of IRR