In this article, we have discussed 3 effective methods of how to calculate effective interest rate in excel with formula.