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.
I would suggest Absolute reference in 13:30 for the calculation of percentage
Hafiz Muhammad Talha
kindly share your slides for revision
Sohel Khalid Nadaf
How to get dataset
I am looking for this course in Telugu language, Is there any possibilities in Telugu.
Nitesh kumar gupta
nice course all the video explained very well from scratch to advance
Overall Lectures are good but also provide the practicing spreadsheets for students.