Some days back, i got a huge excel sheet with many columns and rows of data. The program manager in US requested analysis of the excel sheet and come up with a methodology. I went to the SDM(Service delivery manager) and had a word with him. I learned some cool tricks in excel that i am eager to share with you all. I feel that all mangers should give a try to learn PIVOT in excel.
I will highlight how to work with pivot.
Step 1: Open the excel sheet on which you want to work on.
Step 2: Select all the data from the excel.
Step 3: Open INSERT tab, and click on PIVOT.Click on “insert” tab and select “Pivot table”. The path will be
Insert >> Pivot Table >> Pivot Table.Create PivotTable pop up screen will be displayed as shown in the screen capture below. Click on the OK button.
Step 4: Another sheet will be displayed, as shown below. Pivot table field list will be also present on the right hand side of the window. Select the column that you want to sort out.
Step 5:Similarly select other two parameters. We can adjust the placement of these parameters in the 4 boxes that is present in the top screen. Drag and drop the parameters to generate the report.
I think this is a small step towards PIVOT in excel. Move on with PIVOT, it is really helpful to prepare and analyze data.