Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Excel does not have a built-in feature to sum or count cells by color, but this can be achieved using three methods: Filtering with Subtotal, Name Manager with Helper Columns, or Custom VBA Functions.

Learn how to create interactive dashboards and dynamic workflows in Excel using modern functions like SUBTOTAL, AGGREGATE, and SWITCH.