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.

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

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.