We have already stated that Excel has powerful reporting features. One of these is pivot tables. By using pivot table tool, you can do automatic data sorting, calculating, merging and total acquiring; and you can make reporting in another page with the revealed summarized information. At the same time, you can use other functions of Excel, decorate it with visual features, create pivot tables and report from a large amount of data.

Below you will find a couple of samples made with pivot tables.

Report Samples with Pivot table
 

In the sample table displayed below, sale amount and detail information about the A, B, C and D products of a company is recorded as raw data.

Below, you can see some of the report samples that can be prepared with the data recorded in that table.

Periodical sale amount of products:

Sales amount by Period and Agent

Periodical sales performance by customer representative

Products customer buy by period

Total product sales by Product and period and the pertaining graph