Lynda com Excel 2010 Financial Functions in Depth  英文版   CD

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


Coursename:
Excel2010:FinancialFunctionsinDepth

Author:
CurtFrye

Duration:
02h20m

Releasedon:
6/28/2011


InExcel2010:FinancialFunctionsinDepthauthorCurtFryeshowshowtoperformawiderangeoffinancialcalculationsquicklyandeasilyusingthemanyfinancialfunctionsfoundinExcel2010.Thecoursedetailsdozensoffunctionsforevaluatingcashflows;calculatingdepreciation;determiningratesofreturn,bondcoupondates,andsecuritydurations;andmore.Exercisefilesaccompanythecourse.
Topicsinclude:
Analyzingloans,payments,andinterest
Discoveringtheinterestrateofanannuity
Determiningdepreciationusingthestraightline,decliningbalance,double-decliningbalance,andothermethods
Calculatingthefuturevalueofaninvestmentwithvariablereturns
Findingthediscountrateofasecurity
Convertingbetweenfractionalpricesanddecimalprices
Determiningtheyieldofsecuritiesthatpayinterestperiodically