Pivot Table is a summary table of your original spreadsheet. Based on your field selections and how the data should be displayed, a pivot table can aggregate and show a different view of your data. All your comments, suggestions and corrections are welcome on this articles. Feel free to add on this article and help me and others learn more of this powerful tool. This is specially for my wife. For example, create a pivot table for Canada and USA sales report per quarter and year. Create a Table as data source (see the screenshot below) Create a PivotTable . • Click the first left data , in A1 cell, Year field (see black-rectangle in the screenshot above). • Click Data menu, select PivotTable and PivotChart Report submenu. In PivotTable and PivotChart Wizard window, "Where is the data that you want to analyze?" , click Microsoft Office Excel list or database option (see yellow-rectangle in the screenshot above). "What kind of report do you want to create?" , c...
Comments