Author and Excel expert David Ringstrom, CPA will walk you through AI-powered features in Excel, including Flash Fill, Analyze Data, Power Query's Column From Example, extracting data from pictures and PDF documents, and more. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365.

David will also show you how to use ChatGPT to work more efficiently with only a minimal understanding of Excel's Visual Basic for Applications programming language.

David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations.What You'll Learn:

• Keep or remove rows from the start or end of an array with the TAKE and DROP functions
  
• Query ChatCPT directly within Excel by way of the LABS.GENERATIVEAI function in Excel for Microsoft 365
  
• Understand the nuance of editing dynamic array-based formulas in Excel 2021 and Microsoft 365
  
• Jump-starting PivotTables by way of the Recommended PivotTables feature
  
• Track your portfolio within Excel by using the Stocks Data Type in Microsoft 365