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.

To make the most of it, though, you need to know the basics. Using Microsoft Excel to add a column is quick and easy. You can do it in just a few quick steps once you've learned how.

Add-in: Tools that you install on your computer to create additional functions in Excel, such as a translation or a calendar add-in. Array: A set of data within a range of cells.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.