Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

Open the Excel worksheet that contains your data table. Click the table cell next to where you wish to insert the data column. The colored Table Tools tab displays on the command ribbon.

For deeper dives, check out my earlier articles on creating relational tables and creating relational databases. How to create an Excel table 1. First, enter the field names in the columns across ...

Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.

Figure B Add a new field to the source Table. Right-click any cell in the PivotTable and choose Refresh to add the new field (Figure C). Figure C Refresh the PivotTable.