Lesson 51 – How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than

In this lesson, I’m going to be showing you how to:

  1. Filter Data in Excel
  2. Use Number Filters:
    1. Greater Than Or Equal To
    2. Less Than

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered anything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 52 – COUNTIF function in Excel | What it is & how to insert the COUNTIF function in Excel?

Or go back to:

Lesson 50 – How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

Lesson 49 – How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

Lesson 48 – How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

Lesson 47 – How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

Lesson 46 – Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel

Lesson 45 – How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel

Lesson 44 – Use the IF function to work out if you are over BUDGET or not in Excel

Lesson 43 – How to change a DATE to different FORMATS in Excel

Lesson 42 – How to set and print rows & titles automatically at the top of each page in Excel

Lesson 41 – How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

Lesson 40 – How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel

Lesson 39 – How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Lesson 38 – How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Lesson 37 – How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel

Lesson 36 – Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!

Lesson 35 – How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

Lesson 34 – What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Lesson 33 – How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30 – Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29 – Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24 – How to SORT data in ASCENDING order in Excel

Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22 – How to RENAME a worksheet in Excel

Lesson 21 – How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20 – How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18 – What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

20 thoughts on “Lesson 51 – How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than”

  1. Hi Habib,
    I am learning a lot from your lessons on Excel. I wonder how u became such a pro in this program. Did u do a course or something?
    Please let me knoww bacause i would like to learn too.
    Aparna

    Reply
  2. Of all of your lessons that I have watched, how to use filter data in Excel may just be my favourite one! I learned so much from this video and can see the incredible possibilities that this technique has for Excel users.

    I was surprised (and impressed) to see all of the filtering options available within Excel and I’m glad that you showed this option as part of this lesson.

    Thank you for another interesting and informative lesson.

    Michael

    Reply
    • Hi Michael,

      Thanks for stopping by and leaving us your valuable feedback. It’s very much appreciated.

      Keeping learning and also you can share these lessons with your family and friends so they can benefit from it.

      All the best
      Habib (ICT Tutor)

      Reply
  3. Hi Habib,

    Thank you for sharing. It is another useful technique for filtering data from Excel. I can find out my desired data by using this filtering function. May I ask can I use this function in more than one column? For example, can I filter out Unit Price= 30 at the same time?

    All the best,

    Alex

    Reply
    • Thank you Alex. Yes, absolutely you can filter out data from each column by clicking on the drop down arrow and selecting the desired data you want to filter. Hope this helps and answers your question. Take care 🙂

      Habib (ICT tutor)

      Reply
  4. Hello Habib,

    Thank you for putting this series of tutorials together.

    I actually took an advanced Excel course through LinkedIn, but have found your teaching style to be easier to follow.

    You have a real knack for keeping a good pace, and explaining things in an easy to understand format.

    Please, keep up the great work!

    Reply
    • Thank you so much for the compliment and feedback. My students often give me similar feedback as well, lol 😉

      Glad my video tutorials are useful for you.

      Please keep visiting our site and YouTube channel for more upcoming video contents.

      Thank you

      Habib (ICT Tutor)

      Reply
  5. Wow, I am so happy that I have found your website!

    Excel has never been my strength, but with your step-by-step tutorials, its gets easier to finlly learn it.

    Thank you for creating these videos, I know it takes a lot of work!

    Best Wishes,

    Natalie

    Reply
    • Dear Natalie,

      Thank you for your feedback. Yes, they surely do take alot of time, but it’s worth it when I hear such great feedback from people who are benefiting from my video lessons.

      Thank you

      Habib (ICT Tutor)

      Reply
  6. Hi Habib: thank you for this great lesson on lesson 51 how to use FILTER DATA in Excel | Number Filters. I appreciate all of your lessons.

    Reply
  7. As someone who doesn’t use excel for much more than keeping track of books I’ve read, this walkthrough video is really helpful. You take the time to explain the steps and show us how to do it rather than just telling. I don’t often use excel, mostly because I don’t understand it. But, in the event that I need to filter any of my lists, I will definitely be returning to this video to walk me through it.

    Reply
    • Thank you so much! You are very kind! 🙂 I’m glad you liked my style of teaching. Please let us know if there is anything else in Excel you would like to know and I will try my best to make a video around that.

      Best wishes to you

      Habib (ICT Tutor)

      Reply
  8. Great video. What you are teaching is very clear and understandable.

    I am skilled in Excel and I love excel. Excel solves all the number problems in a few seconds.

    I hope in the near future you can give us nice visualization video about amazing excel.

    Reply
    • Thank you Daisy for your comment and feedback. It’s highly appreciated. I will try to make more videos on this topic.

      Please keep visiting our site and YouTube channel for many more upcoming contents.

      Best wishes

      Habib (ICT Tutor)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap