Microsoft Excel for Finance, Accounting & Financial Analysis

1.0 /5

(1 Rating)

Offered byUDEMY

Microsoft Excel for Finance, Accounting & Financial Analysis
at
UDEMY
Overview

Learn everything you need to know about Microsoft Excel and give a boost to your professional career

Duration	4 hours
Total fee	₹2,699
Mode of learning	Online
Credential	Certificate

Microsoft Excel for Finance, Accounting & Financial Analysis
at
UDEMY
Highlights

Earn a certificate of completion from Udemy
Learn from 12 downloadable resources & 1 article
Get full lifetime access of the course material
Comes with 30 days money back guarantee

Microsoft Excel for Finance, Accounting & Financial Analysis
at
UDEMY
Course details

Skills you will learn

Excel Accounting Valuation Data analysis Mortgage

Who should do this course?

For Accounting and Finance Students
For Accounting and Finance Professionals
For Aspiring Financial Analysts
For Business owners with finance knowledge

What are the course deliverables?

Calculation of depreciation with Excel formulas
Calculation of PV and FV with Excel formulas
Calculation of NPV with Excel formulas
Calculation of IRR with Excel formulas

More about this course

Microsoft Excel has hundreds of functions and formulas to store, analyze, and alter data efficiently
In this course, you will learn key functions that are required most used by Finance and Accounting users when they are working with their business data
These functions include finding, replacing, sorting, filtering, summarizing, and analyzing data
Additionally, you will also learn how to bring in a particular data against a specific row parameter from other excel sheets

Microsoft Excel for Finance, Accounting & Financial Analysis
at
UDEMY
Curriculum

Depreciation with Excel

SLM Straight Line Method

DB Declining Balance Method

SYD - Sum of Years Digits Method

DDB - Double Declining Balance

VDB - Variable Declining Balance

Present Value & Future Value

Introduction to PV and FV

Calculating FV - Future Value

Calculating PV

Calculating PV of Annuity

Calculating FV of Annuity

Calculating FV with changing interest rates

Net Present Value and IRR

Net Present Value - NPV

XNPV

IRR - Internal Rate of Return

XIRR

Nominal and Effective Rate of Interest

Converting Nominal Rate to Effective Rate

Converting Effective rate to the nominal rate

Loan & Mortgage Repayment

PMT

PPMT

IPMT

CUMIPMT

Bond Valuation

Price( Market Value)

Yield (Investor's required rate or kd)

Microsoft Excel for Finance, Accounting & Financial Analysis
at
UDEMY
Faculty details

Irfan Sharif

He is a Chartered Accountant from ICAEW (Institute of Chartered Accountants of England and Wales) and a Chartered Certified Accountant from ACCA (Association of Chartered Certified Accountants in England)

Microsoft Excel for Finance, Accounting & Financial Analysis
at
UDEMY
Entry Requirements

Eligibility criteria Up Arrow Icon

Prerequisite: Basic working knowledge of Excel
Depreciation and common methods of depreciation
Basic knowledge of Finance like time value of money, compounding and discounting
Concept of NPV and IRR

Conditional Offer Up Arrow Icon