10x Your Excel With This New AI Formula

Use the ChatGPT powered =AI.Function in Excel.
🔥 Take our Excel Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
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: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / 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

[@KenjiExplains]

🔥 Take our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance

[@richardbryanesq]

Holy cow this is outstanding! Thank you!

[@euniceliciousTV]

This Ai new function is so cool. Totally game changing, it can replace a lot of formula we use to remember. Thanks for sharing Kenji.

[@filipafernandes2449]

I spent the whole video with my jaw dropped.... I have been praying for some of these features for years! Thank you very much for sharing! By the way, congrats on all the videos, you always explain Excel features in a very simple and practical way 👌👌

[@KenjiExplains]

Thank you for your lovely comment Filipa!

[@mohammedkhaledhossain7374]

Can it extract attachnent from outlook?​@@KenjiExplains

[@StepByStepExcelTutorials]

This is extremely useful! thanks for uploading!

[@DinoDelight]

Its so bloody insane what Excel can do now....love this and great video with great examples

[@UpcomingJedi]

It still hasnt been able to help me pick winning lottery numbers....or make me understand how to do a multiple line graph

[@utpalsarmahDigital24]

This is really amazing. I did not know any of them. Thank you so much 😍

[@KenjiExplains]

Thank you!

[@jsimmons834]

That....was...crazy! I didn't know this existed. THX

[@abdelhafidassadiki2124]

I liked this particular video very much Because you provided exclusive things

[@adityanugraha7454]

Awesome ! Thank you Kenji !

[@unnikrishnansanthosh]

whatever you have shared in this video is totally new for me, thanks a lot for sharing

[@KenjiExplains]

Thank you!

[@Dexter101x]

Simply brilliant

[@MEETMEKANNAN]

Fantastic Kenji

[@mohammadalbizri2013]

Literally amazing

[@faizansayed9203]

this will surely increase productivity. thanks for updates

[@UpcomingJedi]

Pray your boss doesnt see this or youll just get extra work (without extra pay) which your coworkers should have done if they knew how to do this. And even if they do, theyre smart enough not to brag but act stupid and let you do all the work while they goof off in the breakroom, on their cellphones.

[@yazid6058]

Thanks for this video, a wonderful and smooth explanation

[@KenjiExplains]

Glad it was helpful!

[@zhiqizhang4348]

Thank you, it is helpful

[@snydahyuanangi-xb6kb]

Hi Kenji, can you run some tutorials for census data 1 and 2 which all are in the same worksheet were species code did not match census 1 and 2,,,,,, because I'm trying to make left = right and I'm manually insert-shifting cell down to make left=to right

[@neochannelforall649]

Really an awesome tutor 😊

[@manjit.sarania]

I'm excited to learn sir

[@brothertoughlove]

Amazing 👍🏿

[@faridqanet4709]

This is awesome!

[@Blueboy30]

Fantastic. Am I right in saying it doesn't work when the column the new extracted data is to go into, is in a table format?

[@edmundchan8923]

It is awesome. just a quick question, when i use Ai.fill or extract, it just returns a single result in the first row, any idea?

[@AshokKumar-hd7pz]

Hello Kenji I am great fan of yours and learned lot of excel formulas by seeing your vedios now i need a help hope you would help me in our office we have a daily tracker in that we have 12 agents and works in 24/7 shifts we work on incident tickets as soon as the ticket arrives we have enter the ticket number in that sheet and change the color of the cell manually according to the time the ticket arrived for eg. if ticket came in between 8am to 9 am it will be green if it is between 9 am to 10 am then red if it is between 10 am to 11 am then purple so on so instead of changing the color manually i need a formula or a steps so based on current time when the data entered into a cell the color should change please suggest

[@camlex6310]

What a great hack!! Thanks Kenji

[@KenjiExplains]

thank you

[@soyoyeoluwafunso4586]

Wow this is great

[@anishbanerjee1642]

good and informative video

[@MJ-cg8vp]

Jadon Sancho....tell me you are an United diehard fan without telling me! Keep up the great work Kenji

[@KenjiExplains]

hahaha im actually a barcelona fan lol (I'm from Barcelona). We're both going through some rough times haha

[@MJ-cg8vp]

@@KenjiExplains Barcelona is doing a lot better than United does. United has been brutal under the Glazer ownership. Hope the new owner brings in some changes.

[@sdggassdggas9621]

Hello, thank you for sharing your knowledge, I have a question how I can obtain the lowest number that is repeated the most. That is: Ex: 0, 1, 2, 2, 4, 5, 6, 1. In this case the lowest number that is repeated the most is 1.

[@leopoldgaming8774]

bro, pls kindly advise formula for say in currency ex : 1,000 be One Thousand i hope u can advise the formula. thank you

[@Ruud-ed6nv]

Great video and examples

[@KenjiExplains]

Glad you like them!

[@jbg1575]

Is it possible to remove select words or numbers from a list of sentences which have those?

[@hassanelfakey4708]

Amazing

[@KennyLaLaLa]

Wondering if I could use the AI table function to make a table which the data source is from some specific and massive financial data, instead of the information from the internet?

[@Skill-tube]

Its good . Dude this chatgpt excel can support persian language?

[@radheradhe9643]

Hi Kenji, I am able to get all kinds of info using formula AI.ASK but in the result I did not receive image/pic. Could you please suggest me how to get image with answer.

[@andrewkeen97]

This looks like a promising add-in, but I'd imagine it's not ready for professional use just yet. The most powerful feature is ai.table, but when it's used to generate data, any analyst is going to be spending the same amount time, if not more, verifying that the generated data is correct than they would have spent generating the table themselves with a Google search. As ai gets more reliable with time, I think this add-in will have much greater use in a professional setting. Until then, it feels like just a gimmick.

[@feronanthus9756]

You'd definitely be better served learning how to pull xml data from a trusted website which excel can do natively without needing some third party plugin.

[@sharmilisen7791]

Do we need to be paid member in chat gpt to leverage these features?

[@georgedzotsenidze3537]

Amazing! Great quality!

[@KenjiExplains]

Thank you!

[@user-px7yl2wb9b]

I have excel 14.7.7 what are you using?

[@vaclavlev5214]

@KenjiExplains It says I have 50 AI calls for free within trial version. Is it total or 50 a day?

[@alikoohi8265]

Please record a video on date type data in excel. I have a big excel file in which the date column has lots of different formats such as m-d-y and d-m-y and the regular ways do not work for me to fix it😢.

[@shivanshshukla5883]

Try Ctrl 1 and try to change the format to date if that that does not work maybe try to custom formats

[@manosvenianakis9323]

I would try to combine some date functions. Try year(), month(), day() to extract the right values (it might not be possible depending on the formatting) and then date(year, month, day) to combine back. Otherwise I would try ai.extract first and then same last steps.

[@luigibru8677]

Great video! Thanks!

[@Prajwalgk27]

unable to add add ins how to do it is telling that failed to install custom functions even though iam having good internet connections please tell what to do

[@user-qu9bn7st7w]

The current functionality is not fully compatible with my requirements. Specifically, it only provides a single cell as the output.

[@dennisoppong4883]

Hi, i can't find the ChatGpt in excel 2016. what else can i use????

[@UpcomingJedi]

Vwhat ELSE can excel do that ive never heard of? It would be nice if these things were mentioned in theuser manual instead of a quick blurb about the simple and self evident tasks, up in the ribbon

[@vaibhavsoni8024]

This will not work in excel version 2016 Should I update my excel version to use this AI Function or its work on Excel 2016 ?

[@Alkeje]

I am getting an error message when I try. Does it need to be formatted exactly like this?

[@noor-rrr]

productivity 10X

[@AbhishekGupta-li5es]

Course fee must be in Indian currency and rate like wise

[@nessim.liamani]

ChatGPT summary : Sure, here's a textual summary of the tutorial on useful Excel add-ins: 1. **AI.ASK Formula**: This feature allows you to ask questions directly in Excel using the AI.ASK formula. It can provide answers to simple queries and even draft emails based on prompts. 2. **AI.FILL Formula**: The AI.FILL formula helps in auto-filling data based on examples provided above. It's useful for completing lists of data or populating tables with consistent information. 3. **AI.EXTRACT Formula**: Similar to Flash Fill, AI.EXTRACT helps extract specific information from text strings. It's particularly useful when dealing with inconsistent data formats. 4. **AI.TRANSLATE Formula**: With the AI.TRANSLATE formula, you can translate text from one language to another directly within Excel. It's a handy tool for multilingual users. 5. **AI.TABLE Formula**: AI.TABLE generates tables based on prompts provided. It can create structured tables from data or even generate tables with random data. Bonus Feature: **AI in PowerPoint**: The AI add-in also works in PowerPoint, allowing you to generate slides based on prompts. It can create presentations on various topics, although some manual tweaking might be needed for design. These add-ins leverage AI technology to automate tasks, enhance productivity, and provide valuable insights directly within Excel and PowerPoint.

[@ooolol]

This is super cool 👍

[@KenjiExplains]

Yupp 🚀

[@questionresearch8721]

Thank you. Wow more.

[@KenjiExplains]

Thanks for watching!

[@francishubertovasquez2139]

That's right you ask the AI so that you can gauge how AI answers from the many right answers programmed and unprogrammed from AI own branchings of learnings inorder to gauge if AI progress by information or self thinking or if there's derangements dictated by the spiritual intrusions and to gauge how AI thinks and to know AI mindset in real time. You ask AI

[@arindambhattacharya7848]

doesnt work for me - my organization has disabled access to office store so I cant "Add-In"

[@rajmisal4517]

im not find ai add ins in my excel sheet

[@bossok6572]

At first i was also amazed by this tools, but after few attempts it asked me your trail period is over. Disclaimer Not free

[@KenjiExplains]

Hey, I mention that at the start of the video that I'm on the trial version

[@lloydl2943]

Great information. Music is distracting.

[@KenjiExplains]

Thank you for the feedback. Would you prefer it turned down or completely off?

[@abdelkaioumbouaicha]

📝 Summary of Key Points: 📌 The video introduces the AI formula in Excel, showcasing its capabilities like answering questions, generating emails, and suggesting formulas. 🧐 Another feature highlighted is the AI fill function, which can populate tables based on examples provided, making data entry more efficient. 🚀 The AI extract feature is demonstrated to extract specific information like names or emails from unstructured data, surpassing traditional methods like Flash Fill. 💡 Additional Insights and Observations: 💬 "The AI formula in Excel offers a range of powerful features to enhance productivity and streamline tasks." 📊 The AI translate function can swiftly translate text into different languages, saving time compared to external tools like Google Translate. 🌐 The AI do Table feature can generate tables based on prompts, making data organization and analysis more convenient. 📣 Concluding Remarks: The video showcases the diverse capabilities of the AI formula in Excel, from answering queries to translating text and generating tables. These features can significantly boost productivity and efficiency in Excel tasks, offering a valuable tool for users seeking to streamline their workflow. Generated using TalkBud

[@McMorgan1312]

Better hope that translation is accurate.

[@SanjaySingh-su4rn]

Sir, please teach in Hindi or with subtitles in Hindi, thanks.

[@exceltips.andtricks]

❤

[@satyamjha05]

I'm not able to see the add-in button in Excel

[@richardbryanesq]

It's very hard to find. You have to go into one of the drop down menus, because the button is only on the ribbon if the ribbon is customized by the user. Or something like that.

[@krishnatate4765]

This add-in is free life time??

[@-PE53]

I haven't used it but I believe it uses your ChatGPT account and the credits you may have previously bought for it.

[@willzinner8813]

how much is the full version one?

[@manosvenianakis9323]

about 12$

[@MBAGirl]

NOT ABLE TO FIND THESE FORMULA IN MY EXCEL, PLEASE GUIDE

[@antoniobacic5674]

Thank you for the always very excellent presentation, Kenji. However, the new AI is very underwhelming imo. On top of that, what does a photo of two black children have to do with either Messi or Ronaldo?

[@md.zahidurrahman5442]

OMG

[@KenjiExplains]

🚀🚀🚀

[@ronin2963]

You literally can't use the same formula symbol for every single formula in your application

[@cwnmaster]

This add-in is not free for lifetime. One has to pay to Microsoft after the trial period.

[@shettyboyfrommangalore4598]

But the question is is it free ?

[@hiyaworld2170]

of course not

[@logikaibukfenc4599]

only 25 ai calls are free

[@pritamkundu2779]

This is why I hate automation

[@alicetang962]

wow!!!

[@pedrofaia6972]

Not working 🥲