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


内容截图：



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


内容截图：



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


内容截图：