Lynda.com出品Excel 2010深入学习财务功能视频教程 Lynda.com Excel 2010 Financial Functions in De

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: Lynda.com出品Excel 2010深入学习财务功能视频教程 英文名: Lynda.com Excel 2010 Financial Functions in Depth 资源格式: 光盘镜像 学校: Lynda.com 主讲人: Curt Frye 发行日期: 2011年 对白语言: 英语 文字语言: 英文 概述:

语言：英语 网址：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 目录: Introduction Welcome 01m 06s Using the exercise files 00m 36s Disclaimer 00m 29s 28m 32s 1. Analyzing Loans, Payments, and Interest PMT: Calculating a loan payment 03m 31s PPMT and IPMT: Calculating principal and interest per loan payment 04m 18s CUMPRINC and CUMIPMT: Calculating cumulative principal and interest paid between periods 04m 30s ISPMT: Calculating interest paid during a specific period 02m 13s EFFECT and NOMINAL: Finding nominal and effective interest rates 03m 31s ACCRINT and ACCRINTM: Calculating accrued interest for investments 04m 15s RATE: Discovering the interest rate of an annuity 02m 41s NPER: Calculating the number of periods in an investment 03m 33s 19m 05s 2. Calculating Depreciation SLN: Calculating depreciation using the straight-line method 01m 48s DB: Calculating depreciation using the declining balance method 03m 10s DDB: Calculating depreciation using the double-declining balance method 03m 20s SYD: Calculating depreciation for a specified period 02m 13s VDB: Calculating declining balance depreciation for a partial period 03m 24s AMORDEGRC: Calculating depreciation using a depreciation coefficient 02m 27s AMORLINC: Calculating depreciation for each accounting period 02m 43s 24m 11s 3. Determining Values and Rates of Return FV: Calculating the future value of an investment 02m 48s FVSCHEDULE: Calculating the future value of an investment with variable returns 02m 21s PV: Calculating the present value of an investment 03m 44s NPV: Calculating the net present value of an investment 03m 17s XNPV: Calculating net present value given irregular inputs 02m 33s IRR: Calculating internal rate of return 02m 32s XIRR: Calculating internal rate of return for irregular cash flows 01m 48s MIRR: Calculating internal rate of return for mixed cash flows 02m 02s DISC: Calculating the discount rate of a security 03m 06s 24m 12s 4. Calculating Bond Coupon Dates and Security Durations COUPDAYBS: Calculating total days between coupon beginning and settlement 03m 02s COUPDAYS: Calculating days in the settlement date's coupon period 02m 48s COUPDAYSNC: Calculating days from the settlement date to the next coupon date 03m 01s COUPNCD: Calculating the next coupon date after the settlement date 02m 43s COUPNUM: Calculating the number of coupons between settlement and maturity 02m 55s COUPPCD: Calculating the date of a coupon due immediately before settlement 03m 04s DURATION: Calculating the annual duration of a security 03m 20s MDURATION: Calculating the duration of a security using the modified Macauley method 03m 19s 28m 43s 5. Calculating Security Prices and Yields DOLLARDE and DOLLARFR: Converting between fractional prices and decimal prices 02m 36s INTRATE: Calculating the interest rate of a fully invested security 02m 50s RECEIVED: Calculating the value at maturity of a fully invested security 02m 46s PRICE: Calculating the price of a security that pays periodic interest 03m 19s PRICEDISC: Calculating the price of a discounted security 02m 48s PRICEMAT: Calculating the price of a security that pays interest at maturity 01m 57s TBILLEQ: Calculating the bond-equivalent yield for a Treasury bill 01m 50s TBILLPRICE: Calculating the price for a Treasury bill 01m 31s TBILLYIELD: Calculating the yield of a Treasury bill 01m 41s YIELD: Calculating the yield of a security that pays periodic interest 02m 59s YIELDDISC: Calculating the annual yield for a discounted security 02m 09s YIELDMAT: Calculating the annual yield of a security that pays interest at maturity 02m 17s 12m 01s 6. Calculating Prices and Yields of Securities with Odd Periods ODDFPRICE: Calculating the price of a security with an odd first period 03m 17s ODDFYIELD: Calculating the yield of a security with an odd first period 03m 03s ODDLPRICE: Calculating the price of a security with an odd last period 02m 44s ODDLYIELD: Calculating the yield of a security with an odd last period 02m 57s 01m 05s Conclusion Additional resources 01m 05s 代码 .– ░░░ –■. ▀ ▓▄■ ■ ▄░ ■▄░ ▀▄ zk ■ ▄▓█████▓▄ ▀▄ – ▄▓ ▄███▄░ ▄▄▄▄████ ░▄███▄ ▀▓█▄▄▄▄▄▄░ – ████▀▀▀███▄ ██▄ ▄██ █████████▄ ▒█████▀▀██ ▄█████████▄ ██████████▄ ▒███ ▓██░███ ███ ▓██▀ ▀██▓ ▓██▓ ▓██░███▀ ▓███ ███ ▀██▓ ▓███ ▓██▓███░ ███░███░ ▓██░███░ ▄██▀ ██▓ ░███░███ ▓█▓ ▓███ ▓██████░ ███████ ▀██████ ▀ ██▀ ███▓███░ ▄▓█▓ ▓██▓ ███████░ ████████████████████████████████████████████████▀▀ ▒██▓ ░▄ ███▓███░ ███░██▀▀▀▀▀▀▀██▓▀▀▀▀▀▀▀▀███▓██▀▀▀▀▀▀▀██▀███▀▀▀▀███▄ ███▄ ▓█▄███░███░ ███░███░ ▓██░ ▄▄▄■ ███░██▓░ ░███ ▓██ ███░ ▀█████████░ ███▓░ ▄███ ██▀ ▀██ ███ ░██▓ ██▀ ▓██ ▓██ ▓██▓ ▀▀▓▓░███▄ ▀█████████▀ █▀ ▀█ ████▄▄▄███▒▄▀ ▀█▓███ ░███ ▀██▄ ▀▀▓▓░▀▀ ▀ ▀ ▀▀█████▀▀ .░ ▓██ ▀ .– ▄█▀ ▀ ▀ QUASAR PROUDLY PRESENTS – ───────────────────────────────────────────────────────────────────────── – Excel 2010 Financial Functions in Depth (c) Lynda.com Supplier . : QUASAR Size ..... : 10 x 15MB Cracker .. : QUASAR Protection : Condom Packager . : QUASAR Type ..... : Brain Enhancement Date ..... : 07-10-2011 OS ....... : Win/Mac – ───────────────────────────────────────────────────────────────────────── – ♀Excel 2010 Financial Functions in Depth ♀Author: Curt Frye ♀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 – ───────────────────────────────────────────────────────────────────────── – INSTALLATION ──────────── Unpack, burn or mount and enjoy. – ───────────────────────────────────────────────────────────────────────── – GREETINGS ───────── We salute our friends, our loyal members and our fair competitors. – ───────────────────────────────────────────────────────────────────────── – ░▓██████████████▓░ ––– THE ALMIGHTY QUASAR – 2011 ––– ░▓██████████████▓░ – ───────────────────────────────────────────────────────────────────────── – 下载链接来自TLF 未经过安装测试与安全检测，使用者后果自负与本论坛无关 软体版权归原作者及其公司所有，如果你喜欢，请购买正版