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.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.