[header] How to create and align two pivot tables in excel [title] Open the spreadsheet with your data in microsoft excel. [substeps] A pivot table will allow you to create visual reports of the data from a spreadsheet. You can perform calculations without having to input any formulas or copy any cells. 
In order to create a pivot table, you will need a spreadsheet with a lot of data. [title] Ensure that the data on the spreadsheet is set up properly.