How to use the PivotTable in the MS-Excel during your professional and business life.

How to use the PivotTable in the MS-Excel during your professional and business life.

Use the following step to use the PivotTable in MS-Excel.

1. Arrange your data properly in the MS-Excel worksheet(like as below) and select the whole database or table.

How to use the PivotTable in the MS-Excel during your professional and business life.

2. Select the insert option and click the PivotTable in the MS-Excel.
How to use the PivotTable in the MS-Excel during your professional and business life.

     3. Then below dialog box will appear in the MS-Excel sheet and select the new worksheet or select the cells where you want to place the Pivot table (in professional work you should use the new worksheet) and then click on the OK button.

How to use the PivotTable in the MS-Excel during your professional and business life.

      4. Now PivotTable option will appear in the MS-Excel worksheet, and you find the screen like this.

How to use the PivotTable in the MS-Excel during your professional and business life.

       5. Now drop the months in rows box and other valuable data into the value box.

How to use the PivotTable in the MS-Excel during your professional and business life.

      6. Now your PivotTable will appear as below in the MS-Excel sheet.

How to use the PivotTable in the MS-Excel during your professional and business life.

7. Now click on the Sum of Dua or any other employee values under the value box and select the value Field Settings.

How to use the PivotTable in the MS-Excel during your professional and business life.

      8. After selecting the Value Field Settings and select the information you want like count, minimum and maximum, etc., now select the average option and press ok  in the MS-Excel.

How to use the PivotTable in the MS-Excel during your professional and business life.

     9. Now you got the average sale of Dua at the bottom of the table  in the MS-Excel worksheet.

How to use the PivotTable in the MS-Excel during your professional and business life.

     10. Same you can also try the same with others.

In upcoming days I also share the other functions that use in the PivotTable like charts, sorting, and many others.

If you have any queries or questions related to PivotTable or any other MS-Excel tool and even if you want the online practical training or special online lecture one to one then contact me on my below details.

Manish Kumar,

Student at Ulster University,

Knowledge4excel@gmail.com

You also follow me and give feedback on my Facebook page knowledgeforexcel, Instagram page knowledge4excel, and twitter knowledge4excel.

 

 







Comments

Post a Comment

Popular posts from this blog

How to use the HLOOKUP between two sheets in the MS-Excel during your professional and business life.

Image
How to use the HLOOKUP between two sheets in the MS-Excel during your professional and business life. Why did you need to learn HLOOKUP tool in your professional as well as in business life? 1.     You can easily maintain the data of your customers or other details. 2.     By this function, you did not need to buy complex database management software. 3.     Easy to use and need a basic understanding. 4.     No need to hire special staff and current staff will easily learn the HLOOKUP function. Key point (never forgot the rules) 1.     HLOOKUP work always work from top to bottom. 2.     There is should no empty row or column in your MS-Excel workbook but if there is any empty cell then no issue because sometimes we did not have the information.   Use the following step to use the HLOOKUP in MS-Excel. 1.     Arrange your data properly and heading should be o...
Read more

How to use the VLOOKUP between two sheets in the MS-Excel during your professional and business life.

Image
How to use the VLOOKUP between two sheets in the MS-Excel during your professional and business life. Why did you need to learn VLOOKUP tool in your professional as well as in business life? 1. You can easily maintain the data of your customers or other details. 2.   By this function, you did not need to buy complex database management software. 3.  Easy to use and need a basic understanding. 4.  No need to hire special staff and current staff will easily learn the VLOOKUP function. Key point (never forgot the rules) 1.  VLOOKUP work always work from left to right. 2.  There is should no empty row or column in your MS-Excel workbook but if there is any empty cell then no issue because sometimes we did not have the information. Use the following step to use the VLOOKUP in MS-Excel. 1.  Arrange your data properly and heading should be on the top in the MS-Excel (like as below)        2.  Now create the form or format for you ...
Read more