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.
Question? Ask it in our Excel Forum
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.)
Macro: Delete all chart sheets and tabs in Excel using this macro. This will only delete the char...
Tutorial: How to make a drop down menu list using data validation and dynamic arrays in Excel 365. ...
Tutorial: Visually nice way to add Date and Location Filters in Excel. This combines Tables with Sl...
Macro: This free Excel macro allows you to display the print preview screen or window for the cur...
Macro: Remove all data validation from a cell in Excel with this free Excel macro. This is a grea...
Tutorial: In this tutorial I am going to introduce you to creating and managing charts in Excel. Bef...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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.)