Microsoft Excel Data Analysis (Part 1): Sort Data

Microsoft Excel Data Analysis

Data Analysis, as defined by Wikipedia, is a process of inspecting, cleaning, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making.

Normally, data is raw, messy, apparently random and useless until it is organized. Analysis of data is usually done to process, organize, structure and present data in a given context for the purpose of obtaining useful information.

In these tutorial series, we shall be considering various Excel features for analyzing data, such as:

Conditional Formatting
Pivot Tables
Analysis ToolPak


In Excel you can sort your data in ascending or descending order, by one column or multiple columns, and even by color. 

Sorting is a quick way to reorganize your data. For instance, you can organize a list of sales information by total sales and quickly view low-sales or high-sales areas.

Sort on One Column

Follow the steps below:

1. Click any cell in the column you want to sort. Here, we want to sort by Sales Column.

Microsoft Excel Sort

2. To sort values from smallest to largest (ascending order), go to Data tab, in the Sort & Filter group, click AZ

Microsoft Excel Sort


Microsoft Excel Sort

Note: to sort the other way round (descending order), click ZA.

Sort on Multiple Columns

Follow these steps:

1. On the Data tab, in the Sort & Filter group, click Sort.

Microsoft Excel Sort

2. In the Sort dialog box, select City from the 'Sort by' drop-down list.

Microsoft Excel Sort

3. Click Add Level.

4. Select Sales from the 'Then by' drop-down list.

Microsoft Excel Sort

5. Click OK.

Result. Records are sorted by City first and Sales second.

Microsoft Excel Sort

Do you observe that sorting by one or multiple columns, you can easily and quickly see the city and/or sales person with largest or smallest sales. 

Sort data by color

If data or data cells are shaded in colors, we can sort the records by their respective cell or font colors.

Take below table for example:

Microsoft Excel Sort

1. Click any single cell inside the data set.

2. On the Data tab, click Sort.

3. In the Sort dialog box, select Sort by City (or any other column), sort on Cell Color (you can also sort on Font Color and Cell Icon), and select the yellow color (or any color you like) for the first level.

Microsoft Excel Sort

4. Click 'Copy Level' as many times as the number of colors and select colors you want each time.

5. Click OK.

Microsoft Excel Sort

Result: The data are sorted by cell colors

Microsoft Excel Sort

Watch out for next lesson. Follow me or subscribe to keep updated.


  1. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.

    big data training in chennai

  2. I am really enjoying reading your well written articles.
    It looks like you spend a lot of effort and time on your blog.
    I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..
    IELTS Coaching in Chennai
    IELTS Classes in Mumbai
    IELTS Training in Chennai
    IELTS Coaching Centre in Chennai
    IELTS Center in Mumbai

  3. This is an awesome post. Really very informative and creative contents. These concept is a good way to enhance the knowledge. Thank you for this brief explanation and very nice information.
    Data Science Training in Tnagar
    Data Science Training in Nungambakkam
    Data Science Training in Saidapet
    Data Science Training in Amjikarai
    Data Science Training in Vadapalani

  4. thank you for sharing such a nice and interesting blog with us. i have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information. I would like to suggest your blog in my dude circle. please keep on updates. hope it might be much useful for us. keep on updating...
    Salesforce Training in Chennai
    Salesforce certification Training in Chennai training in chennai
    Salesforce Admin Training in Chennai
    Salesforce Developer 501 Training in Chennai
    Salesforce Developer 502 Training in Chennai

  5. Nice Article,Great experience for me by reading this info.
    thanks for sharing the information with us.keep updating your ideas.
    AWS Training center in Bangalore
    AWS Training in Ambattur
    AWS Training in Saidapet

  6. It is a great post. Keep sharing such kind of useful information.


  7. Great post. I will also learn Digital marketing course to know more about marketing strategies. Thanks for sharing
    Data Science training in Chennai | Data Science Training Institute in Chennai | Data Science Course in Chennai

  8. Let's play together on the website of the online casino BGAOC. great gambling sites Do not miss the chance to win with us.

  9. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Cyber Security Projects for Final Year

    JavaScript Training in Chennai

    Project Centers in Chennai

    JavaScript Training in Chennai

  10. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    JavaScript Training in Chennai

    JavaScript Training in Chennai

  11. It was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks. how to install tensorflow anaconda

  12. Greetings! Very useful recommendation within this article! It is the little modifications that produce the largest modifications. site Many thanks for sharing!

  13. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.

    Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery

  14. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    digital marketing course in guduvanchery

  15. Nice reading, I love your content. This is really a fantastic and informative post. Containing all information about data analysis. it services companies in dubai

  16. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    about us

  17. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.

  18. Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work. ecommerce product data entry

  19. Data Recovery begins upon once its affirmed from Client. Affirmation should be possible by email, telephone or direct contact on Percentage of Recovery, required time span, cost and installment mode.

  20. Escort Service In Gurgaon - Our call girls agency is ready to meet your all needs. They are enjoying most seductive female call Girls from different parts of the World. Have you ever date any female in your life? If no then you do not know the real taste of dating fun with a call girl. Then our Gurgaon Escorts service will help you to tackle your dreams with one of the independent female escort agencies.

    Escort Service In Gurgaon

  21. I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
    business analytics courses

  22. Nice article. I liked very much. All the information given by you are really helpful for my research. keep on posting your views.
    data scientist course aurangabad

  23. wow this saintly however ,I love your enter plus nice pics might be part personss negative love being defrent mind total poeple , spss data analysis help

  24. In need of Rekordbox DJ License Key. Whats good homies,. So I recently purchased a preowned Pioneer DDJ-400 for a great deal but the license .RekordBox License Key

  25. Happy birthday to your better half, congratulations. 2 yrs Report. Tagewattie Indar, profile picture.Happy Birthday Beautiful

  26. Hypnosis is great to overcome abundance blocks and it works directly on your subconscious mind, this makes it such a powerful law of attraction tool.Self-Hypnosis-With-The-Law-Of-Attraction

    1. nice
      ">Devops Training Institute in KPHB


Powered by Blogger.