Figure A shows two table objects in the same Excel sheet. We want to create a SharePoint list of the rate table in H2:I8 because a couple of managers refer to these rates regularly.

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

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.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

Find out how to use Microsoft Excel to calculate the coupon rate of a bond using its par value and the amount and frequency of its coupon payments.