Wednesday, November 5, 2014

3 Tutorials Explaining Excel Financial Functions

I found 3 websites with great resources for explaining Excel financial functions...


Pmt FunctionExcel Easy has easy to understand instructions for solving the most basic of financial functions in Excel, including NPer, rate, PMT, PV, and FV. Although only basic functions, they do a great job at laying the groundwork for other, more involved financial functions. 

Launch video!For a more in-depth look at financial functions within Excel, GCF LearnFree provides instruction for more advanced functions including what-if analysis. As with all other aspects of the Microsoft suite, I liked this site for explaining financial functions because they are easy to understand and the site provides more than just an explanation, but examples and video tutorials, as well.          


Excel Functions.net has a variety of tutorials for a wide range of financial functions, from the most basic to ones like YIELD and FVSCHEDULE. They start out by explaining what the function is, and what all parts of it mean. They then go on to provide an example for the function. What I found particularly helpful with this site as opposed to others I have found is that they explain common errors you might run into when performing various functions and what you can do to correct those errors.

No comments:

Post a Comment