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.

To easily filter data in Excel, you can create a custom filter based on different criteria (e.g., text, numbers, and dates). If you want to filter the data based on multiple conditions, you can ...

The Excel Filter function is a powerful and versatile tool that can transform your data analysis workflow, dramatically boosting your productivity.

This post will show you how to filter or sort Excel data using Cell Color and Font Color the easy way. This helps organize cells & improve productivity.

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

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Topline Spreadsheets aren’t just for business owners and data analysts—here are some easy ways to integrate Microsoft Excel into your life.

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

Journal-entry testing using Excel In this example walk-through, learn how to use Microsoft’s spreadsheet application to perform several tasks, including sampling.