Summary
Congratulations, you’ve completed the course.
During this course we’ve covered a lot of ground:
- Getting started – Went deep into how FILTER works by understanding logical values, spilling and broadcasting.
- Shaping outputs – Looked at how to change the values returned through column selection, handling blanks and adding total rows.
- Advanced scenarios – Covered advanced filter scenarios, such as lookup tables, partial matches, lists, slicers, and more.
- Group Filter Aggregate Method – Introduced a framework for approaching calculation.
Hopefully, you now agree that FILTER is more than just a function for extracting values from a table. Actually, it’s a key component for modern Excel reporting.