Course Content

  • Demo Example
  • Sorting, Filtering & Grouping Example

Course Content


In your pivot table, select any date cell. Click Group Field in the Group option on the Analyze tab. The date variant of the Grouping dialogue box appears if your field contains date information. The Months option is used by default.

Any cell in the range or table can be selected by clicking it. Click Sort & Filter on the HOME tab, then Filter. To see the filter choices for one of the columns, click the drop-down arrow at the top of the column. In the Category column, I select the drop-down arrow.

Expand the folder of the grouped column in the Groups pane, under the Groups folder. Drag the data items to be sorted to the Sort List folder from the Data Items pane. Data elements from the Detail Sort List folder can also be dragged.

The filter tool allows you to separate the important components you need by filtering a column of data within a table. You can sort by date, number, alphabetical order, and more with the sorting tool.

Introduction. Filters can be used to reduce the size of your worksheet's data and hide parts of it. While filtering may sound similar to grouping, it differs in that it allows you to qualify and display just the material that is relevant to you.

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