Make Custom Excel Functions Using AI (Everyone can do it now)

Add to Favorites
Author:

How anyone can use AI (chatgpt) to create custom worksheet functions for excel that you can use in your workbooks.

Custom functions in Excel are functions that you create to do whatever you need to do; this example cleans and formats phone numbers using a single function, but your function can do anything so long as the result is output into the cell that contains the function.

This tutorial includes a professional AI prompt that you can use to create your own custom Excel functions, and I show you how to update the prompt to suit your needs.

Download link for the ai prompt is below.


Downloadable Files: Project File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
8 Tips to Become an Expert in Conditional Formatting for Excel
Tutorial: Become a master of Conditional Formatting in Excel! This tutorial covers 8 tips and trick...
Excel Workbook Reset with a Single Button Click [Easy Version]
Tutorial: How to easily clear or reset an entire workbook, specific worksheet, or just a few cells ...
3 Top Tips to Speed up Workbooks in Excel (Everyone can do it!)
Tutorial: Speed up your workbooks in Excel with my top 3 tips. This helps you improve efficiency an...
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
Simple Excel Function to Combine Values in All Versions of Excel - UDF
: Excel function that combines values from multiple cells or inputs using a delimiter - work...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Tutorial Details
Downloadable Files: Project File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course