microsoft-excel-courses - excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Excel

microsoft-excel-courses - Excel

resolvedResolved · Low Priority · Version Standard

Haninder has attended:
Excel Intermediate course

Excel

What are the advantages of pivot table over autosort?

RE: 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 >


Server loaded in 0.1 secs.