Analyzing financial data can seem intimidating, but Microsoft 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. 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.

Note: This course was recorded in Office 365, but anyone using a recent version of Excel—including 2019, 2016, and some earlier versions—will be able to follow along.

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 security yields

Evaluating the yields of securities with odd periods

HOMEPAGE

https://www.lynda.com/Excel-tutorials/Excel-Financial-Functions-Depth/5030966-2.html