Pivot Tables are one of Excel's most powerful tools, and they're something that every serious Excel user should be familiar with. Pivot Tables are also one of the most challenging features to master without assistance.
Pivot tables are very handy if you have a lot of long rows or columns with values that you need to keep track of and compare. To put it another way, pivot tables help you make sense of the seemingly infinite mess of numbers on your computer.
Pivot tables are useful because they enable anyone to filter and retrieve information from the data set they're working with. Pivot tables enable anyone to see their data from a variety of angles.
Pivot Tables are Excel worksheet tables that allow you to summarise and analyse data. The ability to summarise using any data element and then go down to review the specifics is one of the advantages. When adding and deleting rows or columns, formulas may limit sorting capabilities or get corrupted.
Select Show Field List from the menu by right-clicking any cell in the pivot table. This will restore the field list's visibility and usual behaviour. When a cell outside the pivot table is selected, the field list will disappear, and when a cell inside the pivot table is selected, it will reappear.
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.