Lynda.com has a full range of videos explaining financial functions for Excel. Most are locked, open only to members, but a few are viewable to non members. This particular video is about principle and interest per loan payments (PPMT and IPMT). While finances are not an area I am tremendously knowledgeable about, the explanation on how to use the function was clear and concise.
Excel-easy.com has a page explaining Pmt, Rate, Nper, Pv, Fv in a brief graphical tutorial. It isn't the most clear, step by step tutorial, however I was able to follow along and get their results. If they provided more explanation between the pictures as to what steps were being taken and why, the results would be much better.
Functionx.com has a tutorial on depreciation functions. I followed along the first function taught,the Double Declining Balance function. The directions were simple to follow, with informative text, step by step directions, and images that can be followed. They have many other functions tutorials in the same format.
No comments:
Post a Comment