Expert Office Training

The Fastest, Easiest Way to become an Office Guru!

 

 

 

  • Home
  • Master Classes
    • Become an Excel Guru – Master Training – Get your Dream Job!
    • Learn Microsoft Word 2016 – From Beginner to Expert
    • Master Excel Formulas Tips & Tricks
    • Access for Excel – Manage Data & Create Amazing Excel Reports
    • Learn Microsoft Powerpoint 2016 – From Beginner to Expert
  • Free Video Tips & Tricks
  • Contact
  • Recommended Products & Services

Excel FILTER – Multiple ways to use filters in Microsoft Excel in the Real-World

August 24, 2017 By Scott

Filtering data is a very useful tool. You select your range of data and then click the filter icon in the Sort & Filter dropdown. Filtering will put dropdown arrows on ever column giving you access to select a value from any column really quick. You can select one value or multiple values, using the checkboxes next to each value (this multiple selection feature is nice when you want to see YTD values, you can select say January – June to see the see the June YTD). The other great feature about filtering data is when you click on the drop down on the top of one of the columns you can select filter by colors or number filters. Using number filters you can choose to filter number greater than x, or less than y, or in between x and y or equals. You have a lot of control over the criteria that data is displayed.

Filed Under: Excel, Microsoft Office Tagged With: Excel, Formulas, Microsoft Office

Get Your FREE Video Course Now!!

* indicates required

Get Your FREE Video Course Now!

Enter your email to get my FREE video training delivered right in your inbox!

Tags

Excel Formulas Microsoft Office

Recent Posts

  • Microsoft Excel – Text to Columns – Learn How to use this Great Function using Real-World Examples
  • Date Formula in Microsoft Excel – Learn how to Easily Format Dates
  • Excel FILTER – Multiple ways to use filters in Microsoft Excel in the Real-World
  • Microsoft Excel TRIM Formula – Remove all leading and trailing spaces in Excel
  • CONCATENATE – Merge Data from Different Cells into One Cell in Excel

New Developments

In the works, courses and videos covering the following: Microsoft Access Microsoft Outlook Microsoft One Note WordPress Installs Selling Online Hosting Amazon Web Services … Read more

Our Latest Tips & Tricks

Microsoft Excel – Text to Columns – Learn How to use this Great Function using Real-World Examples

August 24, 2017

Date Formula in Microsoft Excel – Learn how to Easily Format Dates

August 24, 2017

Excel FILTER – Multiple ways to use filters in Microsoft Excel in the Real-World

August 24, 2017

Connect With Us

  • Facebook
  • Twitter
  • YouTube
  • Home
  • About
  • Contact

Copyright © 2025 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in