Learn everything about Analytics

Excel 2010: Financial Functions in Depth – Lynda

0-6 Month Online
Intermediate Contact Institute
Online Business Intelligence
Online Self Paced 1122

[su_tab title = “Description”]

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.

[su_tab title = “Program Structure”]

Course Program:

  • 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


INR 15, 00 (assuming $ = INR 60)


2 hour 18 minutes


[su_tab title = “Faculty”]

  • Curt Frye

[su_tab title =”Tools”]

  • Excel

[su_tab title = “Contact”]

Name :
Email :
Contact Number :
Message :
Code :


This article is quite old and you might not get a prompt response from the author. We request you to post this comment on Analytics Vidhya's Discussion portal to get your queries resolved