Figure F After converting a data set to a Table, update the dependent references. When you create a Table object, Excel names it — use that name or give it a more meaningful name yourself.

Specifically, you can use Power Query to import a single dataset like an Excel workbook, a table from a website, or a database. Alternatively, you can import multiple datasets from worksheets in an ...

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

Microsoft is using artificial intelligence to convert photos of data tables into a table in Excel. Users will be able to take photos of hardcopy data and import it straight into a fully editable ...

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

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.