A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool for organizing tasks. Checkboxes can ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working ...

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

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

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.

Dynamic Array formulas Back in 2018, Excel announced functions like FILTER, SORT, UNIQUE, etc. to let you create dynamic arrays that automatically update.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.