Wednesday, November 5, 2014

3 Tutorials Explaining Excel Financial Functions

1.  Hun Kim Youtube Video

A very nice, short and sweet video tutorial/demonstration of the PMT function in Excel.  Narrator does a good job of explaining how to use the function.

Address:  https://www.youtube.com/watch?v=WiVU5qeX48Q
Link:  Hun Kim PMT Function Tutorial

2.  TVM Calcs

This site shows a couple different examples of the future value function.  No video with this one but it shows several screenshots and instructions for you to follow along with a practice worksheet to see the results for yourself.

Address:  http://www.tvmcalcs.com/calculators/excel_tvm_functions/excel_tvm_functions_page1
Link:  TVM Calcs

3.  ExcelFunctions.net

This site shows several different financial functions in Excel; this particular one talks about the yield function and how to properly use it.  It also tells you of some common mistakes that can be made and how to quickly correct them so the function works.

Address:  http://www.excelfunctions.net/Excel-Yield-Function.html
Link:  ExcelFunctions

No comments:

Post a Comment