Excel 2010深入学习财务功能视频教程

语言：英语
网址：http://www.lynda.com/Excel-2010- … -Depth/83199-2.html
类别：教程

（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

本文链接: https://www.books51.com/29340.html

上一篇: Excel 2010: 高级公式和函数视频教程

下一篇: Excel 2010: 深入学习数据验证视频教程

(0 次顶, 0 人已投票)
你必须注册后才能投票！

Loading...