How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Api Tutorials
CUMIPMT and CUMPRINC in Excel
The CUMIPMT and CUMPRINC functions allow you calculate the total interest or capital (principal) paid between any two periods without having to build an amortization table.
Using the PMT function in Excel
The PMT function calculates the required repayment amount to amortize (pay off) a debt or loan based on the original capital amount, interest charged and term of the loan
LOWER, UPPER and PROPER functions in Excel
These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper.