Jun 18, 2024
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.
June 18th, 2024
11:00 am - 1:00 pm EST
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
Who Should Attend
Professionals seeking to leverage artificial intelligence with regard to spreadsheets will benefit from this course.
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.
Available Upgrades
AyZha Hazelwood, Education Meeting Coordinator
Ahazelwood@indiana.bank
317-387-9380