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.

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.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.