the FILTER function

A quick intro

Here's a quick summary of what we will cover in this course

Overview of the XLOOKUP Syntax

This lesson covers how to use the FILTER function to extract data from a dataset based on one criteria

Practice using the FILTER function selecting one criteria

This lesson covers how to select two criteria with the FILTER function

Use this lesson to practice selecting data based on two criteria

This lesson covers how to select more than two criteria with the FILTER function 

Use this lesson to practice using the FILTER function to select 2 or more criteria

This lesson covers how to select dates and other criteria with the FILTER function

Use this lesson to practice using multiple criteria with different data types

This lesson covers how to use the FILTER function to select multiple items, but not limiting what data you extract by using the OR principle

Practice an example for multiple criteria and OR principle

This lesson covers how to handle errors and missing data using the FILTER function arguments

This lesson covers when to use the FILTER function vs a Pivot Table and the pros and cons of each

This lesson provides an overview of how we can transform raw data into dynamic and interactive reports with the FILTER function

This lesson goes through each step required to build a dynamic report with the FILTER function

Well done - you have completed the FILTER function workshop