Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates.

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

Scientific and mathematical formulas frequently use exponents and square roots, and you can create a function to compute the square, cube, or square root of a value by using the formula creator.