Loading...

Excel Explained: AI-Based Features

Although AI may feel new, Excel has been using AI-powered features for years. In this session, Excel expert and Excel for Dummies author David Ringstrom, CPA, explores tools like Flash Fill, Analyze Data, and Power Query’s Column From Example, then shows how ChatGPT can help write, understand, and automate Excel formulas and tasks with minimal VBA knowledge.

OnDemand
DATE

Recorded Monday,
March 16, 2026

INSTRUCTOR

David Ringstrom

DURATION

2 Hours

FORMAT

Webinar

$299.00 or 1 Token

Includes: 30 Days OnDemand Playback, Presenter Materials and Handouts

  • Artificial Intelligence (AI)
  • Computer Skills
  • Information Technology/Security
  • Branch Manager
  • Commercial Lender
  • Community Reinvestment Act Officer
  • Compliance Officer
  • Consumer Lender/Retail Banker
  • Controller/Accountant
  • Credit Analyst
  • Human Resources Officer
  • Internal Auditor
  • IT Professional
  • Loan Closer
  • Loan Operations Manager/Specialist
  • Marketing Officer/Business Development
  • Mortgage Lender
  • Privacy Officer/Information Security Professional
  • Risk Manager
  • Small Business Lender
  • Trainer
  • Trust Officer
  • Workout Specialist/Collector

Save on annual training costs with our Webinar Subscription Service and share webinars across your entire organization.

Become a subscriber

Learn about upcoming events, webinars and discounts.

Sign Up For Email Notifications

Although artificial intelligence seems like it is suddenly permeating every aspect of our daily lives, AI has been part of Excel for over a decade now. In this presentation author and Excel expert David Ringstrom, CPA will walk you through various 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. Of course, no discussion of AI would be complete without an exploration of ChatGPT, so David will show you how to write and deconstruct formulas as well as automate repetitive tasks with only a minimal understanding of Excel's Visual Basic for Applications programming language.

What You'll Learn

  • Jump-starting PivotTables by way of the Recommended PivotTables feature.
  • Merging text from two or more columns without using formulas or repetitive retyping with Flash Fill.
  • Integrating data on web pages into your workbooks and creating automatic links.
  • Creating PivotTables and PivotCharts based upon your data by asking natural language questions.
  • Deconstructing existing formulas by asking ChatGPT to explain the formula in detail.
  • Converting a range to a table and using the Total Row to summarize data

Who Should Attend

Professionals seeking to leverage artificial intelligence with regard to spreadsheets.

David Ringstrom

Instructor Bio

David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant, educator, and speaker. He has presented more than 2,500 live webinars to professionals nationwide.


David is the author or co‑author of ten books, including Microsoft 365 Excel For Dummies, Exploring Microsoft Excel’s Hidden Treasures, QuickBooks Online For Dummies, and Idiot’s Guide to Introductory Accounting.


 


 

Print this page