xyz 軟體補給站

Lynda.com 出品的時長2小時20分的Excel 2010: 深入學習財務功能視頻教程。由Curt Frye講述如何有效的使用Excel 2010中的許多財務功能來創建并快速進行大量的財務函數計算。教學詳細的講解了現金流量評估、折舊計算、確定收益率、債券息票日期和保證期限等等幾十個功能。本教程附帶練習文件。


Course name:
Excel 2010: Financial Functions in Depth

Author:
Curt Frye

Duration:
02h 20m

Released on:
6/28/2011


In Excel 2010: Financial Functions in Depth author Curt Frye shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in Excel 2010. The course details dozens of functions for evaluating cash flows; calculating depreciation; determining rates of return, bond coupon dates, and security durations; and more. Exercise files accompany the course.
Topics include:
Analyzing loans, payments, and interest
Discovering the interest rate of an annuity
Determining depreciation using the straight line, declining balance, double-declining balance, and other methods
Calculating the future value of an investment with variable returns
Finding the discount rate of a security
Converting between fractional prices and decimal prices
Determining the yield of securities that pay interest periodically