Part -18 – Excel Sort Function
Download Excel Templates – Excel Sort Function
Learn how to organise, format and calculate data smoothly. Develop skills to master excel tools, formulae and function. Analyze data from different perspectives.
Transcript For The Video – Excel Sort Function
In this set of video tutorial, we are going to talk about one of the amazing features that are excel sort function. Now when you look at sort, as the word says you want to sort this data in a particular order, so in doing so it is further enabling us to get deeper insights about the data which we are using, say for example this data here which we have in terms of our case study, this is the data that we have, if u look at this data very closely you will find employees come from different departments, different genders, they have different salaries and they are not in any particular order, so let’s say if we want to sort this data out, depending on specific criteria’s or condition, say for example to start with I want to sort this data by name all in alphabetical orders so since this table is not sorted we need to kind of sort that out. In this way we can use excel sort function. I will just demonstrate how that can be used, the first thing that we have to do is we need to select the whole table on which we want to perform a sort depending on a condition, so the condition which I am using as of now is to sort the names by alphabetical order so once I have selected this table like this click on sort so, when we click on sort you will find that there is a sort dialogue box that opens up, so when we click on this button sort by you will find that it tasks us for different kinds of options, sort by name, sort by department, gender, monthly salaries, annual salaries, taxes so all the headings are essentially identified automatically by the sort function, so let me sort them by name and what kind of sort it should be for us it should be a sort by values because we have not had different kind of color combination for different fonts, let’s say a if specific cell was colored in red you could have actually sorted by that as well , so however in our case values is what we will kind of choose, the order should it be z to a or a to z, so I will here choose a to z and click ok, so the moment I do that you may notice that all your names get sorted automatically and the other things that also happens is the corresponding entries which are related to the respective sort also gets updated automatically so if I quickly do an undo, in order to show you what has happened so let me show you Aaron which comes on the top. Aaron is a marketing professional and he is a male, his monthly salary is 8700 dollars and his percentage total annual salary is 9.14 so let me perform a sort again in order to check that the corresponding entries also gets sorted as far as sort goes. So let’s click on sort and I click on name, value, A to Z and we click ok. And now let’s check for Aaron, Aaron is a is a marketing professional and a male, his salary is the same as we just saw 8700 dollars and his percentage annual salary was 9.14 as a total salary, so looks like this table gets updated automatically so it can provide you a very systematic way of looking at your data or having a fresh perspective of the data. Maybe you know alphabetically name is not making sense you may like to kind of sort your data by maybe annual salaries so let’s try and do that and see that if that is making sense click on sort , choose annual salaries and in this annual salary you will find that it is prompting us from smallest to largest or from largest to smallest let’s say I want the largest on the top and smallest at the bottom so I do that and i click ok so as you can see the annual salaries the professionals who have higher annual salaries are at the top and lower are at the bottom so it provides you a schematic way of doing deeper analysis and you can make a more efficient way of using excel sort function.
This has been a guide to the Excel sort function, how to sort the data using the inbuilt function provided in the MS office excel.This post is a complete heads-up on Excel sort function. Following are the external link related to the excel so go through the links for more details.