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.

The Problem: Dynamic Array Formulas Don't Work in Excel Tables A dynamic array formula is a formula whose result spills over from one cell to other cells. What's more, if the result of the formula ...

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula.

Excel's SEQUENCE function lets you create a list of numbers in a sequence in an instant. It also allows you to define the shape, number of values, and steps between each number in the sequence ...

How to Make a Cumulative Chart in Excel. By adding all of the data in each of your Excel columns and then creating a chart from the totals of each column, you can generate a cumulative chart in ...

How to Plot a Formula in Excel. Unless you are an accountant or a math whiz, the formulas used in financial calculations may seem like random, nonsensical strings of numbers, letters and Greek ...

One of the most powerful features of Excel is the array—a formula designed to act simultaneously on sets of two or more values in order to calculate other values. Yet, because arrays appear to be ...

If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.