microsoft-excel-courses - excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Thu 20 Dec 2007, 17:00Delegate Haninder said...

Haninder has attended:
Excel Intermediate course

Excel

What are the advantages of pivot table over autosort?

For upcoming training course dates see: Pricing & availability

replyReply Sun 30 Dec 2007, 21:32Trainer Rajeev said...

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 >

 

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard