In the last four years, a lot has changed in Excel. Changes have been made to the very core of Excel - the Calc Engine. And with the dynamic arrays came the lambda functions and a few other additions that changed how we (should) use and will use Excel going forward. In this session, I will go through some business scenarios using modern Excel and all its benefits to show you how the Microsoft BI landscape has changed from the ground up.