->
Lynda - Excel 2016: Financial Functions in Depth - 504663
Lynda - Excel 2016: Financial Functions in Depth
Analyzing financial data can seem intimidating, but Excel has a wide range of functions to perform these calculations quickly and easily. This course shows users how and when to use each of the financial functions available in Excel 2016. Author Curt Frye covers evaluating loan payments; calculating depreciation; determining rates of return, bond coupon dates, and security durations; calculating prices and yields; and more.


Table of Contents

  • Introduction
  • 1. Analyzing Loans, Payments, and Interest
  • 2. Calculating Depreciation
  • 3. Determining Values and Rates of Return
  • 4. Calculating Bond Coupon Dates and Security Durations
  • 5. Calculating Security Prices and Yields
  • 6. Calculating Prices and Yields of Securities with Odd Periods
  • Conclusion
  • Lynda - Excel 2016: Financial Functions in Depth


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss