Summary
Welcome to the Modern Excel Reporting with FILTER course.
The purpose of this course is to give you a deep understanding of the FILTER function, which is one of the most important functions in Excel. It provides new ways to solve problems with formulas and create reports and analysis.
The topics covered in the course inclue:
- Getting started
- How FILTER works
- Core concepts such as boolean logic, broadcasting and spilling
- Working with multiple conditions
- Shaping outputs
- Column selection
- Handling blank values
- Adding total rows
- Advanced filter scenarios
- Combining multiple tables
- Advanced text matching
- Using lists and slicers
- Group Filter Aggregate Method
- Building financial reports
- Spilling and extending FILTER
The example files can be downloaded from the following lesson.
So… if you’re ready. Let’s get started.