Sorting Data in Excel (Basic)

Link to YouTube video. Frequently, our data needs to be sorted into a logical order so that we can either find things quickly or to rank things in order of value etc. In this example we have a table of cricket records I copied randomly from the internet.  The data has not been sorted in any order I can tell: We might want this sorted in a number of ways:  Perhaps sorted alphabetically by Team or Player name, or maybe ranked in order of number of games; high to low, or low to high.  Let’s go through the steps needed. There are a few ways to do this, the quick and logical way, and an almost equally quick, but less logical way that is faster for any future sorts you might make.  There is also a method to sort by two or more columns at once, but we will leave that for another tutorial, to keep this one reasonably short. 1)     Quick and logical: Let’s say...
Read More

Sorting by 2 or more columns at the same time

In an earlier blog post we talked about how we can sort our data in Excel and Google Sheets by alphabetical or numerical order.  This was assuming you only wanted to sort by 1 column (e.g. sort a table of personnel records by Name in alphabetical order). But there are times when you will want to sort by 2 or more columns at once.  The technique is largely the same in Excel as it is in Google Sheets, although the menus are in different locations.  In this example we have a table I randomly downloaded from the Office for National Statistics, as we can see there are a number of ways we might want to sort this data: So let’s say for example we want this first sorted by “NUTS level” (whatever that means…) and then by Index from low to high.  First we select the table:  in Excel we click the “Sort & Filter” button in the Home tab and choose...
Read More