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.

Q. How do I use the FILTER function in Excel, and how is this an improvement over the filter feature? A. The FILTER function was introduced five years ago as part of the Excel Dynamic Arrays rollout.

Excel running totals made easy with dynamic arrays. Explore advanced functions for accurate, flexible data handling and improved performance.

What if you could unlock the full potential of Excel's dynamic arrays within your tables, making your data management more efficient and powerful?

One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better way to do this is to use a timeline, a dynamic filter option that ...

While static Excel charts are adequate for basic data analysis, they fall short when you want to explore trends, compare scenarios, and truly interact with your information. Here is where dynamic ...

Editor’s note: In the video, Brandon Vigliarolo uses Microsoft Office 365 and walks through the steps of building dynamic charts in Excel. The steps are very similar to the following tutorial by ...