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.

Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such ...

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

When manipulating large amounts of data in an Excel spreadsheet, it can be challenging or time-consuming to select specific items by hand. This is where the data filtering feature of the program can ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

Have you ever struggled with Excel formulas, trying to calculate running totals only to be left with errors and frustration? Many of us have faced the challenge of managing datasets where each row’s ...