What are the advantages of pivot table over autosort?

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 >£60000.

However, Pivot Table is more interactive than that. Not only you can view the specific records but also summarize their results. This can be Totals, Averages, Count, Min, Max, etc… All you have to do is to drag the fields to the appropriate areas in the Pivot and it does everything else for you. You have the option of displaying the fields’ headings either as rows or columns!! And with a simple click you can create a chart based on your pivot table!!

I hope this helps!

To look at the Excel Advanced course bookings please go to http://www.microsofttraining.net/order/pricing_availability.php

From here choose the relevant course, venue and the date.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003