HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU WAS USING ON YOUR PREVIOUS ORGANISATION.

Question

Accepted Answer

To create a pivot table in Excel, go to the 'Insert' tab, click on 'PivotTable', select the data range, choose the location, and set the fields.

Go to the 'Insert' tab in Excel
Click on 'PivotTable'
Select the data range you want to use for the pivot table
Choose the location where you want the pivot table to be placed
Set the fields for the pivot table by dragging and dropping them into the 'Rows', 'Columns', and 'Values' areas
Apply any necessary filters or formatting to the pivot table

Accepted Answer

Create a private table the go to excel sheet see you tata select all data and Praise the control alt-D-P-F shortcut of keyboard and your private able is ready private table

Accepted Answer

Go to the datasheet and go to the insert option then click pivot table. Choose the data that you want to analyze, select Select a table or range. then Table/Range then Choose where you want the PivotTable report to be placed. (New worksheet or Existing worksheet )

Press Alt - N - V - T.

Regularly used in my work.

Accepted Answer

Go to data sheet and go to insert option than click pivot table.

i useing eberday pivot table.

HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU WAS USING ON YOUR PREVIOUS ORGANISATION.

Top Vidal Health Tpa MIS Executive interview questions & answers

Popular interview questions of MIS Executive

Top HR questions asked in Vidal Health Tpa MIS Executive