How to Use Excel to Calculate APR. Part of the series: Computer Help. There are two functions to use when calculating APR in Microsoft Excel. Use "PMT" and "Rate" functions in Excel to calculate APR, or what is being paid on a loan, with IT help from a software developer in this free video on using computers.