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. Right-click a cell in the table column next to where you wish to insert the new column.

Create a table and insert data . Now that you are aware of the basics of pivot tables, letâ s create one. In the example below, we have created a database for salespeople with relevant details ...

How to create an Excel table. 1. First, enter the field names in the columns across the top, ... Cells group, Insert or Delete buttons. JD Sartain / IDG Worldwide. Easily add new columns & rows.