【Excel 金融函数教学视频】Excel 2010, 2013, 2016: Financial Functions in Depth

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

Lynda - Excel 2010 + 2013 + 2016: Financial Functions in Depth



以下是 Excel 2010 + 2013 + 2016 三个版本的关于金融函数的 Excel 教程视频，请笑纳



Excel 2010:

In this course, 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.

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

本帖隐藏的内容

Lynda - Excel 2010_Financial Functions in Depth.part1.rar (90 MB, 需要: 5 个论坛币)

2016-10-9 07:37:50 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2010_Financial Functions in Depth.part2.rar (90 MB, 需要: 5 个论坛币)

2016-10-9 07:39:16 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2010_Financial Functions in Depth.part3.rar (90 MB, 需要: 5 个论坛币)

2016-10-9 07:40:38 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2010_Financial Functions in Depth.part4.rar (33.83 MB, 需要: 5 个论坛币)

2016-10-9 07:41:07 上传

需要: 5 个论坛币  [购买]

内容截图：



Excel 2013:

Analyzing financial data can seem intimidating, but Excel 2013 has a wide range of functions that you can use to perform these analyses quickly and easily. This course shows users how and when to use each of the functions available to them in Excel 2013. Learn how to evaluate cash flows; calculate depreciation; determine rates of return, bond coupon dates, and security durations; and more.

Topics include:
• Analyzing loans, payments, and interest
• Calculating depreciation
• Determining values and rates of return
• Calculating bond coupon dates and security durations
• Calculating security prices and yields
• Calculating prices and yields of securities with odd periods
• Analyzing simulation results

本帖隐藏的内容

Lynda - Excel 2013_Financial Functions in Depth.part1.rar (75 MB, 需要: 5 个论坛币)

2016-10-9 07:26:29 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2013_Financial Functions in Depth.part2.rar (75 MB, 需要: 5 个论坛币)

2016-10-9 07:27:48 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2013_Financial Functions in Depth.part3.rar (75 MB, 需要: 5 个论坛币)

2016-10-9 07:28:46 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2013_Financial Functions in Depth.part4.rar (72.28 MB, 需要: 5 个论坛币)

2016-10-9 07:30:04 上传

需要: 5 个论坛币  [购买]

内容截图：



Excel 2016:

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.

Topics include:
• Analyzing loans, payments, and interest
• Calculating depreciation
• Determining values and rates of return
• Calculating bond coupon dates and security durations
• Calculating security prices and yields
• Calculating prices and yields of securities with odd periods

本帖隐藏的内容

Lynda - Excel 2016_Financial Functions in Depth.part1.rar (90 MB, 需要: 5 个论坛币)

2016-10-9 07:32:21 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2016_Financial Functions in Depth.part2.rar (90 MB, 需要: 5 个论坛币)

2016-10-9 07:33:09 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2016_Financial Functions in Depth.part3.rar (90 MB, 需要: 5 个论坛币)

2016-10-9 07:34:00 上传

需要: 5 个论坛币  [购买]

Lynda - Excel 2016_Financial Functions in Depth.part4.rar (37.93 MB, 需要: 5 个论坛币)

2016-10-9 07:34:38 上传

需要: 5 个论坛币  [购买]

内容截图：

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏26 回帖

关键词：financial Functions inancial Financia function security details include course return

谢谢分享

下载学习
谢谢楼主的分享

thank a lot

多谢楼主分享

Thanks for sharing

载入中

2016第一个链接不好用 白费了5个币啊~~

thanks

看起来好厉害的样子