Module Two Homework

Source data for PivotTable report You can use the data to the left to experiment with creating sample PivotTable reports using the PivotTable template on the worksheet named PivotTable Template. If you scan through this source data, you'll notice that it's difficult to see the trends and results, even if you sort or filter the data. There are just too many records to analyze at a glance. Compared with the large databases your company may have available, or you may have found on the Internet, this 800-row list is fairly short and simple. Excel can retrieve much larger amounts of data than this, and PivotTable reports are one of the best Excel tools for extracting the significance from a large, detailed data set. The data is organized in list format, similar to how a query returns database records: each column contains similar data, the columns have headings in the first row, and the list isn't interrupted by any blank rows or columns (although blank cells within the data are OK). The list is sorted by Order Date. This workbook contains sample source data (on the current worksheet named Source Data), a PivotTable structure based on the source data (on the worksheet named PivotTable Template), and a sample PivotTable that was created from the source data and PivotTable structure. The sample is on the worksheet named Sample PivotTable Report.

Sample PivotTable report This PivotTable report was created using the source data on the worksheet named Source Data. To see the sales activity for a particular country, click the drop-down arrow next to Country and select the country from the list. This PivotTable was created by placing the Salesperson field in the Drop Row Fields Here area of the PivotTable structure. Then, the Order Amount field was placed in the Drop Data Items Here area. The Country field was placed in the Drop Page Fields Here area.