Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this 3rd video in the series we look at how to apply filters to multiple columns. You will learn about the rules Excel uses to apply filters with AND logic. I also explain how to filter multiple columns with OR logic, where any of the criteria can be true.

Click here to download the file used in the video: https://www.excelcampus.com/tables/filters-training-part-3/

We typically work with large data sets that contain a lot of columns, and it's great to know how to apply filters to multiple columns. This video covers tips and techniques to make this process faster and easier.

I also explain how to determine what the filter criteria is for the column. This can be a time consuming task when you have filters applied to multiple columns.

At the end of the video I explain how Filter Mate can help with this. The Filter Mate window contains a list of all the column names and allows you to quickly see the columns that have filters applied to them. You can also see the filter criteria for each column. This saves a lot of time and eliminates the need to scroll horizontally to find filtered columns.

I also have a new online course on Excel filters called Filters 101. This course will help you learn filtering and sorting techniques to prepare and analyze your data faster.

Filter Mate & the Filters 101 Course are now available. Click here to learn more. https://www.excelcampus.com/filter-mate/

Please leave a comment below with any questions about this video. Thank you!

Video #1: https://www.youtube.com/watch?v=cB5koQvGwsA
Video #2: https://www.youtube.com/watch?v=Z1_oq-uPUBU