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

Microsoft Excel 2010 can be a huge help for a business when it comes to crunching the businesses numbers. Excel has a number of financial functions revolving around the periodic interest rate ...

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.

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.

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.

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

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.

Excel Master – rarely is unable to perform even the most advanced/expert tasks, builds 3rd party applications using the Excel environment, IT level understanding of how Excel can integrate with ...