This course is intended to make it easier for you to transform raw data into the ideal required format for pivot table analysis, simplify pivot table maintenance by way of Excel's Table feature and contrast different methods for performing calculations within and outside of pivot tables. By the end of this course, you may expect to reduce the effort you put in creating reports and instantly generate required documents.
The image below shows the sample sales data collated from North wind access database.
You can download the sample Excel data here.
Task is to create a summary of customers, group all of their orders by product, and show the quantities, unit price and subtotals for all the transactions.
Pivot table data - 159 KB