MS Excel Lesson32 | how to change pivot table value field setting |Design and styling of pivot table
Asslam_u_Alaikum!
Dear Students!
welcome to 32th lesson of MS Excel. in this lesson you will learn about pivot table in excel using Mouse and Short cut Commands.
In this video I show you how to change pivot table value field setting,Design and styling of pivot table in excel.
Creating a Pivot Table
1)Select any cell in the source data table.
2)On the Ribbon, click the Insert tab.
3)In the Tables group, click Recommended PivotTables.
4)In the Recommended PivotTables window, scroll down the list, to see the suggested layouts. ...
5)Click on the layout that you want to use, then click OK.
what is pivot table
1)A pivot table is a statistics tool that summarize and reorganize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.
2)A Pivot Table lets you rotate the data summary and look it from different angles.
3)It allow user to change column into Row and Vice versa.
Important benefit of pivot tables is that it helps to summarize data in a quick and easy manner.
In the PivotTable, select a row field.
1)This displays the PivotTable Tools tab on the ribbon.
2)You can also double-click the row field in outline or tabular form, and continue with step 3.
3)On the Analyze or Options tab, in the Active Field group, click Field Settings.
4)In the Field Settings dialog box, click the Layout & Print tab, and then under Layout, do one of the following:
5)To show field items in outline form, click Show item labels in outline form.
6)To display or hide labels from the next field in the same column in compact form, click Show item labels in outline form, and then select Display labels from the next field in the same column (compact form).
7)To show field items in table-like form, click Show item labels in tabular form.
Like my Video and Subscribe my Channel. Have any Question comment in video.
Here is the link of practice file. watch video again and again and practice daily Because "Practice Makes Permanent"
https://drive.google.com/open?id=1W0_...
#pivot
#pivot_table
#style
what is pivot table
what is a pivot table
what is pivot table in excel
pivot table excel advanced
introduction to pivot tables
pivot
excel pivot tables
pivot tables excel
excel pivot table
pivot tables
pivot table excel
pivot excel
how to create a pivot table