Excel Financial Functions Urdu Tutorial
Rs.1,000
Excel Financial Functions Urdu Video Course covers all finance and accounting related functions in Excel. These functions are available in all Microsoft Office versions including 2007, 2010, 2013 and 2016. Here you will learn about the evaluation of Coupon Bonds, T-Bills, Depreciation and much more.
Course Features
- Lectures 38
- Quizzes 1
- Duration 2 hours
- Skill level All level
- Language Urdu
- Students 0
- Assessments Self
-
Chapter 00
- Lecture 1.1 01. Introduction
- Lecture 1.2 02. Exercise Files
-
Chapter 1
- Lecture 2.1 01. Monthly Loan Payment
- Lecture 2.2 02. PPMT and IPMT Functions
- Lecture 2.3 03. CUMPRINC and CUMIPMT Functions Locked
- Lecture 2.4 04. ISPMT Function Locked
- Lecture 2.5 05. EFFECT and NOMINAL Functions Locked
- Lecture 2.6 06. Accruend Interest on Periodic Investment Locked
- Lecture 2.7 07. Accrued Interest at Maturity Locked
- Lecture 2.8 08. Rate Function Locked
- Lecture 2.9 09. Number of Periods Locked
-
Chapter 2
- Lecture 3.1 01. Straight Line Depreciation Locked
- Lecture 3.2 02. Declining Balance Method Locked
- Lecture 3.3 03. Double Declining Balance Method Locked
- Lecture 3.4 04. Using Sum of the Years digit method Locked
- Lecture 3.5 05. Variable Declining Balance Method Locked
-
Chapter 3
- Lecture 4.1 01. Future Value Locked
- Lecture 4.2 02. FV Schedule Locked
- Lecture 4.3 03. Present Value Locked
- Lecture 4.4 04. Net Present Value Locked
- Lecture 4.5 05. Irregular NPV Schedule Locked
- Lecture 4.6 06. Finding Internal Rate of Return Locked
- Lecture 4.7 07. Irregular IRR Locked
- Lecture 4.8 08. Using MIRR Function Locked
- Lecture 4.9 09. Discount Rage Locked
-
Chapter 4
- Lecture 5.1 01. Finding Number of days before first interest payment Locked
- Lecture 5.2 02. Finding Number of Days in a coupon Locked
- Lecture 5.3 03. Finding Next Coupon Date on a Bond Locked
- Lecture 5.4 04. Finding Number of Coupons Locked
- Lecture 5.5 05. Finding Previous Coupon Date Locked
-
Chapter 5
- Lecture 6.1 01. Finding Interest Rate Locked
- Lecture 6.2 02. Finding Value at Maturity Locked
- Lecture 6.3 03. Finding Bonds Price Locked
- Lecture 6.4 04. Finding Price For A bond That pays interest at maturity Locked
- Lecture 6.5 05. Tbill Equivelant Locked
- Lecture 6.6 06. Tbill Price Locked
-
Chapter 6
- Lecture 7.1 01. Finding Price for Odd First Period Locked
- Lecture 7.2 02 Finding Price for odd last period Locked