Your Simple AI Prompt for Data Analysis and Chart Creation in Excel

How to use AI to take a single table of data, group similar items (sales people in this case), and then split them onto separate tabs, showcase their data, and chart their data.

Instead of using a macro or vba, you can use plain text and have AI do it for you in under a minute.

In this tutorial I also show you how to adjust the AI prompt to suit your needs and your specific data and use-case.

The AI prompt is provided from TeachExcel.com for free and is included in the downloadable file below.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~ AI Prompt for this Tutorial ~~
https://www.teachexcel.com/excel-tutorial/2710/your-simple-ai-prompt-for-data-analysis-and-chart-creation-in-excel?src=yt_v_kZAm4m-GSUU

~~ Last Week's Tutorial (ChatGPT Function) ~~
https://www.teachexcel.com/excel-tutorial/2709/advanced-chatgpt-function-for-excel-new-amp-improved?src=yt_v_kZAm4m-GSUU

~~ AI Course Pre-signup Discount Offer ~~
https://notify.teachexcel.com/

~~ Excel Email Course Discount [50% Off] ~~
https://www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_description_kZAm4m-GSUU

~~ Excel VBA Course Discount [60% Off] ~~
https://www.teachexcel.com/vba-course-update.php?src=youtube_v_description_kZAm4m-GSUU

~~ All of Our Online Excel Courses ~~
https://www.teachexcel.com/premium-courses/?src=yt_description_kZAm4m-GSUU

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

00:00 intro
01:00 How to create multiple charts from tables in Excel
02:16 Free AI prompt to chart your data
02:40 Prompt walkthrough and explanation

#ai #chatgpt #excel #tutorial