Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

By using advanced Excel functions, you can create a dynamic total row that seamlessly adapts to additions or deletions in your array.

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.