Use the ChatGPT powered =AI.Function in Excel.
? Take our Excel Course: https://www.careerprinciples.com/courses/excel-for-business-finance
? DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/ncqwao47w9
In this tutorial we teach you how to use the new ChatGPT powered AI.Formula. First, we cover how to install it as an Excel add-in for free. Then, we learn how to use it by using the =AI.ASK feature asking simple questions. Next, we use the =AI.FILL formula to generate smart answers. Third, we use the =AI.EXTRACT for a superior version of the flash fill. Fourth, we learn the =AI.TRANSLATE to translate any text automatically and make it dynamic with a drop down list using data validation. Finally, we generate tables with =AI.TABLE. As a bonus, we see how this add in works in PowerPoint to create slides from scratch.
LEARN:
?Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
? The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
? Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
? All our courses: https://www.careerprinciples.com/all-courses
SOCIALS:
? Instagram - https://www.instagram.com/careerprinciples/?hl=en
? TikTok - https://www.tiktok.com/@career_principles
?? LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro & Set Up
1:03 - AI.ASK Formula
2:54 - AI.FILL Formula
4:27 - AI.EXTRACT Formula
7:27 - AI.TRANSLATE Formula
8:45 - AI.TABLE Formula
10:35 - Bonus Feature