Apply Excel's Insert command to add more table columns. Getty Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns.

Consider adding a new column of data if they’re available and will improve the resulting pivot table. For example, let’s say that you want to analyze sales information for your company.