BankNewswatch

Excel Explained: Spreadsheets and AI

Tuesday, June 18th, 2024 10:00 am - 12:00 pm Central Time

A BankWebinars.com Program

Click Here to register for program $299.00

Click Here to register for program and receive recording $449.00


Although AI seems like it is suddenly everywhere in our daily lives, AI has been part of Excel for 10+ years. In this webinar, we’ll discuss AI-powered features in Excel, and explore how to use ChatGPT to write and deconstruct formulas as well as automate repetitive tasks.

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

Instructors

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you", so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).