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:

Sort 
Filter 
Conditional Formatting
Tables
Pivot Tables
Charts
What-if-Analysis
Solver
Analysis ToolPak

Sort:


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


Result:

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.

20 comments:

  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


    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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
    Salesforce.com training in chennai
    Salesforce Admin Training in Chennai
    Salesforce Developer 501 Training in Chennai
    Salesforce Developer 502 Training in Chennai

    ReplyDelete
  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

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

    globalpayrollexpert
    Technology

    ReplyDelete

Powered by Blogger.