Sorting Examples

Please purchase the course before starting the lesson.

Data Sort Ex 1

Sort the data so that the order is firstly by

  • City but in the order of Johannesburg, Paris, London, New York
  • Then by Product in the order of Basic, Standard, Deluxe

Data Sort Ex 2

This data is out of our Sales system but we need to columns to be in a different order. The order we want is shown in row 1 i.e. first Product, then Salesperson, then City, then Sales. Use Data Sort to Achieve this

Data Sort Ex 3

The manager has worked through the list and coloured the cells. We need to sort the data so that in appears in the following order:: Red, Yellow, Green

 

Back to: Intermediate Excel Course > Filtering and Sorting