Test ChatGPT's AI for Excel to make formulas, macros, and more.
π Our Excel Course:
π§βπ» Try ChatGPT:
π DOWNLOAD Free Excel file for this video:
In this video we test chatGPT (artificial intelligence chatbot) for Excel asking it to write basic formulas, all the way to advanced Macros on VBA.
Specifically we test the following:
– Use a formula to find unique values in a range
– Use a statement to check if a condition is true
– Create a dropdown list (data validation)
– Write code using VBA for Excel Macros to automate tasks
Finally we also test Excel's built in AI tool under "analyse data"
LEARN:
π The Complete Finance & Valuation Course:
π Excel for Business & Finance Course:
π All our courses:
SOCIALS:
πΈ Instagram –
π€³ TikTok –
π§βπ» LinkedIn –
β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬β¬
Chapters:
0:00β β – Easy Test (Excel Formula)
1:50β – Intermediate Test (IF Statement)
3:21β – Advanced Test (Data Validation)
6:05β – Expert Test (Macro)
9:45 – Excel's AI Tool
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.