After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table:

Excel provides numerous predefined table styles that you can use to quickly format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style.

Rename an Excel table to make it easier to find and refer to in formulas and references.

Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.

After you create an Excel table, you may only want the table style without the table functionality. To stop working with your data in a table without losing any table style formatting that you …

To edit a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. You may find the Queries & Connections pane is more …

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

In Excel, you can change the layout and format of the PivotTable data to make it easier to read and scan.

To change any source data that you associate with a workbook, use the tools in Power Pivot to edit connection information, or update the definition of the tables and columns used in your …

After you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data.