Login
Excel Yourself/FILTER function
Buy now

  • $25

FILTER function

  • Course
  • 6 Lessons

The FILTER function automates filtering and allows you to better add user interaction to your spreadsheet. Topics: • FILTER function basics • Handling errors • AND vs OR comparisons • Using wildcards characters • Using TRIMRANGE • Working with functions • Using checkboxes Version: M365 Recorded: August 2026 Level: Intermediate Duration: 65 minutes Price: AUD25
Buy now

Contents

FILTER Function

Session Materials

The session materials

  • a pdf manual which you can print out and make notes in

  • Excel file to work through during the session

  • the completed file to review if you need to

Excel_FILTER_Function.pdf
Excel_FILTER_Function.xlsx
Excel_FILTER_Function-completed.xlsx

Course video - August 2026

FILTER_2026.mp4

Quiz

Test your new found knowledge with 10 multiple choice questions.

FILTER Function Quiz