Excel Pivot Tables are tables that

Excel Pivot Tables are tables that summarise large amounts of data in an Excel spreadsheet. This is best explained by way of an example...


Imagine your company kept a spreadsheet of every sale that was made during the first quarter of 2013. The spreadsheet records the sale date, the invoice reference, the invoice total, the name of the sales person, and the sales region. This spreadsheet is shown below:

Kết quả (Anh) 3:

Excel数据透视表的表格，总结了大量的Excel表格中的数据。这是最好的解释，通过一个例子的方式………。电子表格记录销售日期，发票，发票，销售人员，销售区域。此电子表格显示如下：