《Lynda.com出品Excel 2010深入学习财务功能视频教程》

语言：英语
类别：教程



（xuehui@TLF）
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