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.

Upcoming
DATE

Monday, March 16, 2026
2:30 pm - 4:30 pm

INSTRUCTOR

David Ringstrom

FORMAT

Webinar

CREDIT TYPE

2 CPE Credits

$299.00 or 1 Token

Includes: Live Access, 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.

Field of Study:Computer Software & Applications

Skill level:Basic

Prerequisites:None

Advanced Preparation:None

David Ringstrom

Instructor Bio

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).

Continuing Education Credit Information

Excel Explained: AI-Based Features has been approved for 2 CPE credits. Credits are redeemable for Live attendance only.

OnCourse Learning is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Students can contact OnCourse Learning via email at support@oncourselearning.com to lodge complaints or issues.

Print this page