Tuesday, February 23, 2016

What is Excel Filter And How its Work?


Before starting know about excel advance filter we must have the knowledge of what is filter in excel? In this tutorial I will teach you how to use excel filter? I hope that will you really enjoy this.

What is filter in MS Excel?
As we know that filter is a process that removes from a single some unwanted component or feature as you want. For example, first create a sheet of data then select the heading of the data.
And go to data tab, in sort & filter group select the data and click on it. When you click on data tab you see you tab header filtering controls are added to the table header automatically.
Above image shows that filtering added to the table header automatically.

Where is advance filter option in excel 2003, 2007, 2010?

In Excel 2003 when you open your excel spreadsheet select the data menu tab top of your excel spreadsheet click on it then go to filter option and click on it. When you click you see advanced filter option and click on it and use this option.











In excel 2007, when you open your excel spreadsheet select the data menu tab bottom top of your screen click on it, then go to sort & filter you see advanced option click on it and use this option.






In excel 2010 when you open your excel spreadsheet select the data menu tab bottom top of your screen click on it, then go to sort & filter you see advanced option click on it and use this option.

How to setup your database?

 Here I give some instruction how to setup your database?

1) First row has heading.
2) Each column has a unique heading.
3) Duplicate heading will cause problem when you use advance filter.
4) There are no blanks cells within your data base. If your cell is blank you can’t use advance filter option.

How to use filter option in excel?


Select the range of the data and go to data tab and press filter option you see filtering added to the table header automatically.  Select the any header of the cell and click on it.

Through the video you can better understand to given all description about excel filter in excel.
In this article you have studied about what is excel filter and how excel filter work. If you like this tutorial doesn’t forget to like us on Facebook and also follow me on twitter. And if you find anything missing than let me know through your commenting.

People also Interested: Conditional Formatting based on another cell. 
People also Interested: Consolidate in Excel.

21 comments:

  1. Replies
    1. 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 CSE

      JavaScript Training in Chennai

      Project Centers in Chennai for CSE

      JavaScript Training in Chennai

      Delete
  2. I am receiving compensation in the form of products and services, for the purpose of promoting The Home Depot. All expressed opinions and experiences are my own words. My post complies with the Word Of Mouth Marketing Association (WOMMA) Ethics Code and applicable Federal Trade Commission guidelines.
    Melbourne Security Installers

    ReplyDelete
  3. I’d have to check with you here. Which is not something I usually do! I enjoy reading a post that will make people think. Also, thanks for allowing me to comment!
    popcorn time download android

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. I read Many Post about Excel and Other Courses but I really Impressed about your Writing Way and How to Express to words.. It’s really helpful for us Thanks for sharing,, keep writing

    Advanced excel training in delhi
    Advanced excel training in Noida
    Advanced excel training in Gurgaon

    ReplyDelete
  7. Thanks for sharing informative article… learning driving from experienced instructors help you to learn driving very fast… Learn driving lessons Melbourne from experts at Sprint driving School.

    ReplyDelete
  8. There is lots of Writer but your writing way is so good and different. It’s really helpful for us and knowledgeable so thanks for sharing...
    Advanced Excel Training in Delhi
    Advanced Excel Training in Noida
    Advanced Excel Training in Gurgaon

    ReplyDelete
  9. Really your blog is very interesting.... it contains great and unique information. I enjoyed to visiting your blog. Its just amazing.... Thanks very much. privacy and security

    ReplyDelete
  10. This post is so informative and makes a very nice image on the topic in my mind. It is the first time I visit your blog, but I was extremely impressed. Keep posting as I am gonna come to read it everyday! gift printing singapore

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.