In Excel, three primary tools are available for performing What-If Analysis: Scenarios, Goal Seek, and Data Table. To recap the last couple of months, here are brief definitions of Scenarios and Goal ...

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.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.