Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
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 will teach you how to use the new ChatGPT powered AI.Formula. First, we'll discuss how to install it as an Excel add-in for free. Then we will learn how to use it by using the AI.ASK function and asking simple questions. We then 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 teach the AI.TRANSLATE to automatically translate any text and make it dynamic with a drop-down list using data validation. Finally, we generate tables with AI.TABLE. As a bonus, we'll see how this add-in works in PowerPoint to create slides from scratch.
TO LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
The Complete Finance and 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/courses
SOCIAL:
Instagram – https://www.instagram.com/careerprinciples/?hlen
TikTok – https://www.tiktok.com/@career_principles
LinkedIn – https://www.linkedin.com/company/careerprinciples/
Chapters:
0:00 - Introduction and installation
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
Please take the opportunity to connect and share this video with your friends and family if you find it helpful.