How to sort data by multiple columns in Excel 2010

Posted on

 

Here I have a list of opportunities coming from our CRM system. Now I’d like to know how many opportunities each account manager has and what type of opportunities these are, so I want to sort on two columns. In order to do that; click the “Sort” dialog box.

So we’ll start with the Account Manager column and sort this A to Z. Then we’ll add one more level and then sort by Opportunity Type and again we’ll do this A to Z.

In Excel 2010 you can add 64 levels to sort by, and then I’ll just click OK. So now I can see that our account manager Abdullah has three “Consulting” opportunities, the majority “Corporate subscription” and then just one normal “Subscription” opportunity.

 

50 percent discount on Excel course