Commentary Logo
Japan Island disputes in SE Asia    World War III Alarm Anti-Islam video and anti-US sentiment    Skull Say no to brainwashing

       peace and anti-war Israel Iran strike imminent    sanctions as a result of nuclear tests Sanctions on Iran and workarounds    black lightning bolt India's massive blackout

Snapshots of news
Gearheads and mastheads
SHORTCUT TO MAIN SECTIONS & ARTICLES
Home  •  About this site  •  How did we once fight corruption in colonial Hong Kong?
 •  Historical US administrative thoughts  •  USA versus colonial Hong Kong
 •  Anti-corruption review of Nigeria  •  Procurement monitoring in Nigeria
 •  Syndicated news  •  Usman's blog  •  Anti-graft news  •  Socialist news

 Tuesday, August 20 2019 5:33am Hongkong Time

Posted Dec 9, 2012

Back to Blog Index   


How To Use Excel Sorting and Filtering Options With Ease

Data is an important resource to any organization and can be used to make business decisions. These decisions can be intelligent and useful if we are able to analyze data properly. For example, if you are maintaining a sales record for your shop then you should know which item is in demand regularly so that you can buy the item in time and avoid lack of sales.

It is difficult for a human to analyze data if it contains several rows and columns. Also during the collection of data, we enter data randomly without giving any consideration to its order. But at the end of the data collection, we need to bring it in proper ascending or descending order. We wish to specify a criteria of our choice to sort the data accordingly.

Microsoft Excel can be the perfect choice for analyzing and presenting random into meaningful bits and pieces. Today we are going to learn how we can apply sorting to our record to make it more readable. And how we can use the built-in Excel options to analyze data records quickly and effectively.

Sort Filter Excel

Sorting data in ascending or descending order

Let us start with a simple spreadsheet intended to keep a record of patient's blood pressure and level of glucose throughout the day. It has six columns date, time, event, systolic, diastolic,heart rate, glucose, level, status.

To apply sorting options:

  1. Select the first column to be sorted.
  2. Click \x{2018}Sort & Filter' in the \x{2018}Design' tab
    Opening sorting filter in Excel design tab
  3. Click on the arrow under Sort & Filter and sort the values in ascending/descending order.

Using custom sort option in Excel (Sorting by multiple columns)

Now let us assume that you want to sort the data on the basis of events and then arrange the events by time (in case both events have same value).

  1. Click on the \x{2018}Custom Sort' from the Sort & Filter menu.
    Custom sort
  2. A dialog box will appear. You can see the selected column already enlisted there.
  3. You can add as many levels of sorting as you want, by clicking on \x{2018}Add level' option.
  4. We had selected the \x{2018}Event' as our first column and then added \x{2018}Time' column. You can observe the sorting in the image shown below.
    Sorting by multiple columns in Excel

Applying filters to data in Excel

The procedure of applying filter to any column is the same as sorting but before that you must know why we need filters. Filters are a useful option that helps us analyze the results by narrowing our search.

Although our sample worksheet have only six rows and six column so data analysis is not difficult here. What if we had a hundred rows and columns? Let's say you are administering academic records of students and you want a list of students with percentages above 80.
Note that sorting will change the order of your spreadsheet but filters will only present your desired result in front of you removing all other rows that are irrelevant.

You can apply date, text and number filters depending on the type of data in a particular column. Consider the \x{2018}Event' column, if you apply text filter it will provide you with all possible values (values you have already entered in event column).

Now, let's say we want to see the blood pressure and glucose level details \x{2018}After Meal'. Un-check all other boxes and click OK. It will filter \x{2018}After Meal' results for you.

If you want to see every entry that has word \x{2018}Meal' in it then you can type it in the text box.It will now show \x{2018}Before Meal' and \x{2018}After Meal' results.

Applying a filter in excel

Clearing filters to bring back all data

You can clear the applied filters by following these steps:

  1. Click on \x{2018}Sort & Filter' in the design tab and select \x{2018}Clear'.
  2. It will undo the filter and will restore the original unfiltered data.
  3. If you want to keep the filtered results but do not want to apply any other filter,click on the \x{2018}Filter' again.
  4. You will notice that drop down arrow will disappear from column headers.

Editor’s note: In Excel 2013, you will be able to access ‘Sort & Filter’ option from the Home tab.

How To Use Excel Sorting and Filtering Options With Ease is a post from: Technize.NET

The post How To Use Excel Sorting and Filtering Options With Ease appeared first on Technize.NET.


Back to Blog Index   

© Usman Khurshid. Reproduced with permission of the copyright owner.



RELATED ARTICLES


OTHER CATEGORIES



GAMES


INTERNET


LIST


SECURITY


SOFTWARE


TIPS

ABOUT THE CONTRIBUTOR

Usman Khurshid is a network consultant who works in a mixed environment of Windows and Linux platforms. He studies about the latest advancements in computer technology and shares his views on this technology blog.

Email Usman at usman {at} technize {dot} com



Commentary and reflection pages by Raymond Cheng, PhD DPA FRSA

  Main • Commentary   Special Foci • Syndicated News | Corruption | Socialism | GuanXi

  Health Related • Traditional Chinese Medicine   Others • OXLL


© 1997-2018 The Commentary, Office of Dr Raymond Cheng. All rights reserved. Copyright of selected news articles, the headlines and logos belongs to the respective entities. Read disclaimer

Digital platform powered by Wyith Limited, Wyith Institute. Wyith Limited and Wyith Institute are associated businesses operated by the Office of Dr Raymond Cheng • Dr Raymond Cheng & Partners Ltd and The Commentary Ltd.

SHORTCUT TO MAIN SECTIONS & ARTICLES
Home  •  About this site  •  How did we once fight corruption in colonial Hong Kong?
 •  Historical US administrative thoughts  •  USA versus colonial Hong Kong
 •  Anti-corruption review of Nigeria  •  Procurement monitoring in Nigeria
 •  Syndicated news  •  Usman's blog  •  Anti-graft news  •  Socialist news

Contact the editor at raymond {dot} cheng {at} kellogg {dot} oxon {dot} org

RESERVED SECTION FOR MEMBERS
The RendezvousBuildersCommentatorsContributorsReadersResearchers
Reflection Pages • Miscellaneous Stuff
The difference between instant evaluation and improving recognition – November 20
Freddy Krueger revisited: Politically correct education? – October 23
From the evaluator's perspective: Justified conclusions and decisions – October 8
Online and distance-learning degrees from the evaluator's perspective – September 25
The moment fake degrees turned recognized and appraised – September 9

Photo credits for top title bar, from left to right: Iza H (Work), Lukasz Gumowski (Blue balls), Marcin Bania (Smiling and naked), Lautaro Gonda (Milan station), Jan Abt (Girl taking a picture), Daniel Tang (Hot switch), Barbara Henry (Moriah reading), Ralf Herrmann (Checkmate II), Marko Roeper (Led #4), Ian Russell (Girl in downtown LA).
Note: Animated GIF graphics and clipart obtained from amazing-animations.com, gifs.net, findicons.com, clker.com and sevenoaksart.co.uk. Sketches, cartoons and other handdrawings courtesy of Alice-the-Artist.

Special Alert! This is *NOT* the American Jewish Committee's Commentary Magazine! Special notice! This is not the American Jewish Committee's Commentary Magazine nor are we in any way affiliated with them. To visit AJC's magazine, please go to commentarymagazine.com instead, thank you for your attention.
Memo with pin Technical memos for members
Receiving using Gmail | Sending using Gmail
0x800ccc0e | 0x800ccc19 | 0x800ccc79

This site is best viewed with Microsoft® Internet Explorer 6.0 or above, minimum 1024x768 16M color-depth resolution. The Commentary Group and its personnel do not endorse external sites and are not responsible for the content of these websites. All external sites will open in a new browser window.




 
COUNT ON THE STATISTICS  100% Towels (c) Daniel Chittka
Photo © Daniel Chittka

This new section contains some interesting statistics in bribe and corruption, please check back for more as we pile up our numbers!

It's statistics time!  Using n-gram: kickback, graft, bribe and corruption - Comparison of their historical occurrences from 1810 to 2009 A.D.

  The word guanxi (collocation) and meanings of bribe: Deeply rooted, disgusting, sad endings

ADVERTISEMENT
Search for a domain name - no obligation!
www.  
 enter a name, word or phrase
 choose an extension
 click go!
LATEST STUFF TO PONDER UPON
Looking for a good book (c) Doug Logan
Photo © Doug Logan
tagged by area of interestBY AREA OF INTEREST
Trends
Pragmatics: Politeness trends from the historical perspective of global trade
Computer mediated communications: Social network – Came riding the waves of amazing coincidences
Analysis
Language acquisition:
A critique on "A corpus driven study of the potential for vocabulary learning through watching movies"

Grammatical analysis: "When a linguist stumbled upon a Buttonwood"
Lexicon and the corpus: "John Sinclair's lexical items – an introduction"
tagged by regionBY REGION • Anything AsiaUS Presence in Asia
ChinaTaiwanHong Kong and MacauJapanKoreaSingaporeMalaysiaPhilippinesPakistanIndiaAfghanistan0 • Vietnam, Laos, Cambodia, Thailand and MyanmarTimor-Leste and IndonesiaMongoliaNew Zealand and Australia
tagged by topicsBY TOPIC • BiofuelRhino and elephant poachingAmerican movies hit China marketChina Internet censorshipChina's outward FDI opportunitiesGlobal rice yield
GLUCK ON SOCIALISM AND CHINA Asia (c) Robert Churchill
Photo © Robert Churchill

Professor Sidney Gluck (c) Sandi BachomI am honored to have obtained Professor Sidney Gluck's (right) permission to allow me to repost here some of his work and interview related to China and socialism. Professor Gluck is professor emertius at the New School University in New York. A classical Marxist, Gluck has been studying China for 60 years in history and modern development. He has lectured all over the U.S. and still welcomes engagement at the age of 94 – photo © Sandi Bachom

FEATURED ARTICLES

COMING 2019 – COMPUTING CORPUS Active Network Hub (c) Phil Sigin-Lavdanski
Photo © Phil Sigin-Lavdanski

Oh, please do not get me wrong. This new section is not about computers, electronics or any engineering stuff, but rather I am currently constructing a new corpus based on Spectrum, the monthly publication from the Institute of Electrical and Electronics Engineers USA, from July 2007 to date. Having been a member for over 20 years since 1992, I am always fascinated by some of the terms scientists use when they talk about or envision their new inventions or methodologies. How many of them eventually come into practice? Could there be some insights we could possibly derive, from the linguistics perspective?

IMPORTANT NOTICE AND DISCLAIMER

This website is published and designed by Raymond Cheng, PhD DPA and reflects only his personal views and opinions in his individual capacity. It does not represent the views and opinions of his firm, employer(s), students, etc., and is not in any way sponsored or endorsed by any other thrid parties. Click here to read my full disclaimer
SHARE THIS WEBSITE WITH SOCIAL MEDIA

Share on Twitter  Add to Facebook  Share on LinkedIn  +1 on Google