How to Use Filter in Google Docs

Google Docs is great product of Google and it can easily be used by accountant, students and teachers. But sometime, most simple things can increase your efficiency in this. One of simple thing in Google Docs is Filter option. Filter means to get only useful data out of large number of data in Google Docs. In the main above menu right side you can see filter in your Google docs spreadsheet.


Now, question is how to use filter in Google Docs. I can explain with my own example. You know, I am an online teacher. I have many students who come to Accounting Education for learning. Some face problem and write in ask a question database. All these data is collected in Google docs spreadsheet. Now, I am interested to  know about a student who have asked questions many times. But, I do not know, how many times, he has asked question from me. Now, for knowing this question, I will use filter option. For this, I will select name column and then click filter button. Suppose, his name is Krishna. I will select Krishna. Only Krishna's data will show date wise. From this, I can see no. of times, he has asked me the different questions.

If you want to learn same, you can learn from my following video. Please don't forget to rate it.

{ Important Note : Some time, you can select sort Z to A in the filter of name. With this, your all name will be Z to A. But due to this, your time setting may be changed by Google docs system. Side-effect will be that some of data of today may go to middle of Google docs and other beginning data may be in end. There is no undo of this in google docs. But, you can again use filter option for timeline column. Just select timeline, then click filter and then choose A to Z sort and then OK. After this, your google docs shows from old time to current time because A's meaning in time is oldest time data and Z's meaning in time is new data}