Excel Financial Functions Urdu Tutorial

(0 review)
Rs.1,000
View cart
Excel Financial Functions Urdu Tutorial

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

  • Chapter 1

    • Lecture 2.1 01. Monthly Loan Payment 5m
    • Lecture 2.2 02. PPMT and IPMT Functions 6m
    • Lecture 2.3 03. CUMPRINC and CUMIPMT Functions Locked 5m
    • Lecture 2.4 04. ISPMT Function Locked 4m
    • Lecture 2.5 05. EFFECT and NOMINAL Functions Locked 3m
    • Lecture 2.6 06. Accruend Interest on Periodic Investment Locked 6m
    • Lecture 2.7 07. Accrued Interest at Maturity Locked 3m
    • Lecture 2.8 08. Rate Function Locked 4m
    • Lecture 2.9 09. Number of Periods Locked 4m
  • Chapter 2

    • Lecture 3.1 01. Straight Line Depreciation Locked 3m
    • Lecture 3.2 02. Declining Balance Method Locked 4m
    • Lecture 3.3 03. Double Declining Balance Method Locked 2m
    • Lecture 3.4 04. Using Sum of the Years digit method Locked 2m
    • Lecture 3.5 05. Variable Declining Balance Method Locked 7m
  • Chapter 3

    • Lecture 4.1 01. Future Value Locked 4m
    • Lecture 4.2 02. FV Schedule Locked 2m
    • Lecture 4.3 03. Present Value Locked 3m
    • Lecture 4.4 04. Net Present Value Locked 4m
    • Lecture 4.5 05. Irregular NPV Schedule Locked 2m
    • Lecture 4.6 06. Finding Internal Rate of Return Locked 3m
    • Lecture 4.7 07. Irregular IRR Locked 2m
    • Lecture 4.8 08. Using MIRR Function Locked 2m
    • Lecture 4.9 09. Discount Rage Locked 3m
  • Chapter 4

    • Lecture 5.1 01. Finding Number of days before first interest payment Locked 4m
    • Lecture 5.2 02. Finding Number of Days in a coupon Locked 5m
    • Lecture 5.3 03. Finding Next Coupon Date on a Bond Locked 2m
    • Lecture 5.4 04. Finding Number of Coupons Locked 2m
    • Lecture 5.5 05. Finding Previous Coupon Date Locked 2m
  • Chapter 5

    • Lecture 6.1 01. Finding Interest Rate Locked 2m
    • Lecture 6.2 02. Finding Value at Maturity Locked 2m
    • Lecture 6.3 03. Finding Bonds Price Locked 2m
    • Lecture 6.4 04. Finding Price For A bond That pays interest at maturity Locked 4m
    • Lecture 6.5 05. Tbill Equivelant Locked 2m
    • Lecture 6.6 06. Tbill Price Locked 1m
  • Chapter 6

    • Lecture 7.1 01. Finding Price for Odd First Period Locked 5m
    • Lecture 7.2 02 Finding Price for odd last period Locked 2m
Awais Kamran has been in the field of IT and Teaching for last 10 Years. Having a dual master degree in Computer Science and Commerce, he has been serving in the top educational institute of Pakistan "Punjab Group Of Colleges". He is the pioneer of Urdu Video Tutorials in Urdu language. He has completed more than 50 Urdu Video Tutorials in last 7 years. Beside coaching, he is an expert Web Developer and Search Engine Optimizer. He belongs to the city of Saints (Multan).

Reviews

Average Rating

0
0 rating

Detailed Rating

5 stars
0
4 stars
0
3 stars
0
2 stars
0
1 stars
0
Rs.1,000
View cart