Excel’s new AI Agent Mode performs complex multi-step task in Excel workbooks. It’s a mind-blowing feature that you have to see. Download the Excel files & chats: Microsoft’s Announcement: Tutorial on How to Compare Multiple Lists with a Pivot Table: 0:00 Intro 0:33 Build a dashboard 1:29 Agent's response 2:42 Pivot tables 3:33 How it works 4:07 Reasoning & Activity 5:07 Modernize formulas 5:25 Show Changes 6:07 Holiday planner 7:11 Cashflow statement 7:56 Limitations & Accuracy 9:02 Availability & Installation 9:36 My thoughts on Agent mode