Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find ...

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.

SEE: How to add a drop down list to an Excel cell (TechRepublic) This article assumes you know how to build a basic pivot table, but also provides instructions for building the example pivot table.