Getting started – Introduction

Modern Excel Reporting with FILTER Getting started Getting started - Introduction

Summary

This module covers the foundations for using FILTER effectively. It covers:

  • Getting started with FILTER
  • Understanding boolean logic
  • Broadcasting
  • Spilling
  • Working with multiple conditions
  • Using the if_empty argument

You will learn not just how FILTER works, but why it works.