microsoft-excel-courses - Excel

Dear Haninder
Thank you for attending Excel Course with us and posting your question.

Pivot table is one of the many topics that we cover in Advanced level.

By Auto sort I assume you mean Auto Filter. Autofilter is a quick and easy way to display the specific data on the screen e.g. All the staff working in the Accounts dept. and even further filtering them to say who are in the working in the East Region. It is also possible to do Custom sort such as, all the staff who are in Accounts Dept. In the East Region earning >