Course Content

  • group-pivot-table-items

Course Content


  • Select PivotTable Options from the PivotTable Options menu by right-clicking a cell in the pivot table.
  • Remove the check mark from Autofit Column Widths On Update in the Format settings on the Layout & Format tab.
  • Select Preserve Cell Formatting on Update from the drop-down menu.
  • Press the OK button.

  • Right-click a value in the PivotTable and choose Group.
  • Select the Starting at and Ending at checkboxes in the Grouping box, then modify the values as necessary.
  • Select a time period under By. Enter a number that specifies the interval for each group in numerical fields.
  • Choose OK.

A calculated item becomes a pivot field item. The total of additional items in the same field can be used in its calculation. The results are summed after the individual records in the source data are calculated. In the Row or Column portion of the pivot table, calculated items are shown alongside other elements.

Table vs. Pivot Chart Pivot Tables allow us to summarise vast amounts of data in a grid-like matrix. You can pick and select the fields to use in the table's rows and columns. The pivot chart depicts the pivot table as a graphical representation.

In Excel, formatting refers to a technique for altering the presentation of data in a worksheet. With the styles and format option in the Home tab, we may format the data in a variety of ways, such as changing the font of the cells or the table.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere