Advance Filter in Microsoft Excel is easy to use. Learn how to filter data based on complex conditions in Excel the right way.

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.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.

In the "Sort & Filter" group within Excel's "Data" tab, click the "Sort Oldest to Newest" or "Sort Newest to Oldest" button depending on how you want to organize your events.

If you intend to obtain a list of all dates or data between two given dates in Excel, then you can Use the Fill handle or use a Formula. Learn how.

Susan Harkins helps readers find simple Office solutions, including how to compare dates with a conditional format and filter with a macro.