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.

Along with 13 courses on using Excel VBA, you’ll also get a full lifetime Microsoft Office License for Windows. With it comes Word, Excel, PowerPoint, Outlook, Teams, OneNote, Publisher, and Access.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before. Image: PixieMe/Shutterstock Microsoft 365 updates the way Excel handles dynamic functions.