Скачать или смотреть Automate Your Excel Formulas With ChatGPT | How To Use ChatGPT To Automation |

Automate Your Excel Formulas With ChatGPT | How To Use ChatGPT To Automation | #excel #chatgpt #ai
In this is video i will show you how to make excel formula on automated mode with the help of chatGPT and AI. I will teach you how to make a AI Prompt to create this sheet and make your formulas automated. In this video you will learn how make macro button and assign macro to then, using shape tool we create buttons and get our result by chatGPT. If you like this video please subscribe my channel🙏.

Practice File link... https://docs.google.com/spreadsheets/...
Prompt:
"this is an example of my dataset create 5 buttons (1-vlookup ,2-xlookup ,3-Total sale , 4-average and 5-count)
when click on 1 button take reference from sheet named result cell c2 and using vlookup formula find result giving criteria on cell d1 and e1 and give result in d2 and e2 cell
when click on 2 button take reference from sheet named result cell c2 and using xlookup formula find result giving criteria on cell d1 and e1 and give result in d2 and e2 cell
when click on 3 button result will show in sheet result d5 cell
when click on 4 button result will show in sheet result d7 cell
when click on 5 button result will show in sheet result d9 cell
use vlookup ,Xlookup ,sum ,average and count formulas on given buttons"