A pivot table is a spreadsheet tool that simplifies the process of extracting useful information from raw data. A spreadsheet might contain historical data about a company’s product sales in the form of a daily list that shows the type of products sold, the location of the buyer, the amount paid for each purchase and the name of the salesperson. A pivot table would allow you to quickly retrieve information such as the total dollar amount of sales made by a given salesperson in a given month. Microsoft Excel 2003 allows you to create pivot tables based on spreadsheet data and customize the appearance in great detail. One way is you can change row colors in a pivot table. Writer Bio
