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

If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.

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

The FILTER function has all the filtering power of the venerable filter feature but can perform more tasks, including setting up automated filters and showing results where the user wants them to be ...

When collaborating in Excel, sometimes the collaboration can be distracting. Here's how to make a static image so you can do your own work without interruption.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.