Log In to Register

Please note that this course is from a third-party vendor, The Carroll-Keller Group. If you cancel less than 7 days in advance of the session, fees are nonrefundable. We strongly recommend registering no later than 24 hours before the course begins. Please contact Sue Malan if you do not receive the event logistics via email at least 24 hours before the course begins: [email protected] or 630-495-0505. Thank you.

Date(s):

12/08/2025

Registration Open:

8:45 AM - 9:00 AM

Time:

9:00 AM - 4:30 PM

Facility:

Online

Meeting Type:

Courses

CPE Credit:

6.50

Field(s) Of Study:

Personal Development (6.50)

Level of Knowledge:

Intermediate

Price:

Member: $335.00
Nonmember: $365.00

Individual Discounts:

Not Available

Group Discounts:

10+ Registrants - Discount: 5.00%
20+ Registrants - Discount: 10.00%

Overview

Unlock the power of prompt-driven automation in Excel with this ‘hands-on’ ChatGPT workshop designed for professionals who want to build custom solutions without writing code from scratch.

This instructor-led session focuses on how to describe tasks in plain language and convert those instructions into fully functional VBA code using ChatGPT macros—perfect for automating repetitive steps, customizing dashboards, and building Excel tools from the ground up.

You will also learn how to describe the results you want from a calculation and have ChatGPT for Excel generate complete formulas, build nested logic, and even create custom user-defined functions tailored to your business needs. With the ChatGPT Excel formula generator, you’ll turn plain-language requests into accurate, reusable formulas without needing to manually write complex syntax.

Instead of wrestling with VBA or puzzling over how to structure multi-function formulas, this ChatGPT training lets you skip the technical complexity and go straight to results. By simply explaining what you want your macro or formula to do, watch ChatGPT deliver working solutions that used to take hours—now built instantly, ready to use, and fully customizable.

Whether you are new to macros or ready to automate like a pro, this ChatGPT course gives you the power to create with confidence, speed, and a whole new level of control—one intelligent prompt at a time!

Other Information:

  • The session will be delivered on the Zoom platform so all participants will work from their own workspace and use their own computer. Zoom has video capability but, if the participant’s computer is not equipped with a camera, audio will also work.
  • To register we will need the name of each participant and their email address.
  • Participants should enter the Zoom training room at least 15 minutes (8:45 AM) before the start time.

Highlights

What You Will Learn in This Workshop

Discover how ChatGPT can revolutionize your Excel workflow by effortlessly generating macros, custom functions, and advanced formulas from simple text prompts—no coding experience required. This interactive training empowers you to automate repetitive tasks, design specialized functions, and build sophisticated formula structures tailored precisely to your needs.

        Automate Common Macro Tasks:

o Repetitive Formatting & Layout Automation

o Data Consolidation & Report Assembly

o Bulk Data Cleanup & Processing

o Interactive User Prompts & Guided Actions

o Custom Workflow Shortcuts & Navigation

 

        Build Custom Excel Tools: Create powerful user-defined functions (UDFs) and macros that Excel does not offer natively, addressing specific business logic and repetitive processes with ease.

        Generate Advanced Formulas: Use ChatGPT to craft accurate arithmetic and deeply nested logic formulas, streamlining complex calculations and business analyses.

        Prompt Precision and Accuracy: Learn to structure your prompts effectively, providing context, sample data, and desired outcomes to ensure clean, reliable Excel automations.

        Troubleshoot and Refine: Master the art of refining and improving ChatGPTgenerated code for precise, professional-grade spreadsheet solutions.

        Creative Excel Solutions: Turn your innovative spreadsheet ideas into practical, working tools faster than ever, without needing to manually write VBA code.

 

Whether you are an Excel beginner or a seasoned professional, you'll leave the workshop equipped with the skills and confidence to harness ChatGPT for immediate productivity gains.

 

Speaker(s)