Accept defaults ("Microsoft Office Excel list or database" and "PivotTable") and click Next. You can come back later and choose PivotChart report to make pretty charts for the PHBs.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.