In excel if you type in a cell
=P*power((1+r),n)-P
where P, r and n are different cells the answer would give you the compound interest on P for a term on n years at an interest rate of r.
In your question you were after the interest rate, the formula in excel would go like this...