10x Your Excel With This New AI Formula

Подписаться 526 тыс.

Просмотров 165 тыс.

50% 1

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

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 110

@KenjiExplains 3 месяца назад

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

@richardbryanesq 3 месяца назад

Holy cow this is outstanding! Thank you!

@StepByStepExcelTutorials 3 месяца назад

This is extremely useful! thanks for uploading!

@filipafernandes2449 3 месяца назад

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 3 месяца назад

Thank you for your lovely comment Filipa!

@mohammedkhaledhossain7374 3 месяца назад

Can it extract attachnent from outlook?@@KenjiExplains

@adityanugraha7454 2 месяца назад

Awesome ! Thank you Kenji !

@euniceliciousTV 2 месяца назад

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.

@jsimmons834 Месяц назад

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

@MEETMEKANNAN 3 месяца назад

Fantastic Kenji

@DinoDelight 3 месяца назад

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

@UpcomingJedi 3 месяца назад

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

@utpalsarmahDigital24 3 месяца назад

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

@KenjiExplains 3 месяца назад

Thank you!

@abdelhafidassadiki2124 3 месяца назад

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

@Dexter101x 3 месяца назад

Simply brilliant

@mohammadalbizri2013 3 месяца назад

Literally amazing

@zhiqizhang4348 Месяц назад

Thank you, it is helpful

@yazid6058 3 месяца назад

Thanks for this video, a wonderful and smooth explanation

@KenjiExplains 3 месяца назад

Glad it was helpful!

@manjit.sarania 3 месяца назад

I'm excited to learn sir

@unnikrishnansanthosh 3 месяца назад

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

@KenjiExplains 3 месяца назад

Thank you!

@neochannelforall649 Месяц назад

Really an awesome tutor 😊

@brothertoughlove 3 месяца назад

Amazing 👍🏿

@faridqanet4709 2 месяца назад

This is awesome!

@faizansayed9203 3 месяца назад

this will surely increase productivity. thanks for updates

@UpcomingJedi 3 месяца назад

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.

@camlex6310 3 месяца назад

What a great hack!! Thanks Kenji

@KenjiExplains 3 месяца назад

thank you

@soyoyeoluwafunso4586 3 месяца назад

Wow this is great

@snydahyuanangi-xb6kb 3 месяца назад

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

@Blueboy30 2 месяца назад

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?

@Ruud-ed6nv 3 месяца назад

Great video and examples

@KenjiExplains 3 месяца назад

Glad you like them!

@edmundchan8923 3 месяца назад

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?

@anishbanerjee1642 2 месяца назад

good and informative video

@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

@jbg1575 3 месяца назад

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

@hassanelfakey4708 3 месяца назад

Amazing

@leopoldgaming8774 3 месяца назад

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

@sdggassdggas9621 2 месяца назад

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.

@KennyLaLaLa 2 месяца назад

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?

@radheradhe9643 3 месяца назад

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.

@pauljacobi340 27 дней назад

Thing to note with that add-in that you can see at approximately the 1 minute mark in the lower right corner of the add-in window, "free trial". It isn't free if you're working with even relatively small samples of data. I frequently get location files from clients with incomplete date like missing area codes. Was thinking this could be a handy way to populate missing ones. Working with a file of just 90 rows and having to take a couple swings at ai.fill and ai.ask to get the results I finally wanted, it filled about 28 rows before stating "ERROR: Free trial ended. Choose a plan to continue using functions." The "Starter" sub is $8/mo when I followed the link in the add-in.

@Skill-tube 2 месяца назад

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

@sharmilisen7791 3 месяца назад

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

@vaclavlev5214 2 месяца назад

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

@user-px7yl2wb9b 2 месяца назад

I have excel 14.7.7 what are you using?

@dennisoppong4883 3 месяца назад

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

@MJ-cg8vp 3 месяца назад

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

@KenjiExplains 3 месяца назад

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

@MJ-cg8vp 3 месяца назад

@@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.

@luigibru8677 3 месяца назад

Great video! Thanks!

@andrewkeen97 3 месяца назад

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 3 месяца назад

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.

@georgedzotsenidze3537 3 месяца назад

Amazing! Great quality!

@KenjiExplains 3 месяца назад

Thank you!

@Prajwalgk27 3 месяца назад

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

@Alkeje 3 месяца назад

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

@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 ?

@UpcomingJedi 3 месяца назад

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

@alikoohi8265 3 месяца назад

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 3 месяца назад

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

@manosvenianakis9323 3 месяца назад

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.

@sarojkumarrath4632 12 дней назад

It's Free upto 50 AI message... beyond that chargeable..can you suggest for completely free AI tool for excel

@ooolol 3 месяца назад

This is super cool 👍

@KenjiExplains 3 месяца назад

Yupp 🚀

@user-qu9bn7st7w 2 месяца назад

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

@questionresearch8721 3 месяца назад

Thank you. Wow more.

@KenjiExplains 3 месяца назад

Thanks for watching!

@rajmisal4517 3 месяца назад

im not find ai add ins in my excel sheet

@noor-rrr 3 месяца назад

productivity 10X

@arindambhattacharya7848 2 месяца назад

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

@Sanjuhere 24 дня назад

why dont you say if its free for life time or trail use only?

@AbhishekGupta-li5es 3 месяца назад

Course fee must be in Indian currency and rate like wise

@francishubertovasquez2139 3 месяца назад

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

@Jinglemyberries 18 дней назад

Whats the point of that if you can just go to chat gbt

@Testmailudz 7 дней назад

00:03 Excel's AI formula can extract names, create tables, and more 01:30 Excel AI can generate professional emails and excel formulas based on prompts. 02:55 Using AI.Fill to auto-populate data in Excel 04:20 Excel AI feature - Extract makes data extraction easier 05:50 Excel's AI features can improve productivity 07:27 The equals AI do translate feature allows text translation and language selection. 09:03 Using AI formulas to generate structured data and lists in Excel. 10:25 AI formula may not work well with larger datasets.

@exceltips.andtricks 2 месяца назад

❤

@lloydl2943 3 месяца назад

Great information. Music is distracting.

@KenjiExplains 3 месяца назад

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

@abdelkaioumbouaicha 3 месяца назад

📝 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

@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.

@krishnatate4765 3 месяца назад

This add-in is free life time??

@-PE53 3 месяца назад

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

@willzinner8813 3 месяца назад

how much is the full version one?

@manosvenianakis9323 3 месяца назад

about 12$

@MBAGirl 3 месяца назад

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

@satyamjha05 3 месяца назад

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

@richardbryanesq 3 месяца назад

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.

@SanjaySingh-su4rn 3 месяца назад

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

@McMorgan1312 3 месяца назад

Better hope that translation is accurate.

@bossok6572 3 месяца назад

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 3 месяца назад

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

@md.zahidurrahman5442 3 месяца назад

OMG

@KenjiExplains 3 месяца назад

🚀🚀🚀

@antoniobacic5674 3 месяца назад

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?