Welcome to this Kimi AI tutorial. In Lesson 21, you will learn how to generate Excel formulas using Kimi AI. Writing formulas manually can sometimes be challenging, especially when working with complex calculations or unfamiliar spreadsheet functions.

You will explore how to describe your requirements using prompts and ask Kimi to generate suitable Excel formulas. This can help you perform calculations, organize data, automate tasks, and understand different spreadsheet functions. Always test generated formulas to make sure they work correctly with your data.

Follow the complete Kimi AI tutorial series to explore its features and learn how to use AI more effectively.

Watch the complete playlist: https://dailymotion.com/playlist/xe2hpi

#KimiAI #ExcelFormulas #AITutorial

Category

📚
Learning
Transcript
00:09so over here you can see that I have an Excel seat and I got these names right here and
00:14the
00:14number but let's say what I want is I want to remove the numbers before the name so but I
00:21don't
00:22know how to write a formula for it that is where Kimmy actually can help so I'm just going to
00:28go
00:28around and say in Excel I got a cell with one dot two dot three dot in the beginning of
00:38text I want
00:40to remove them write a formula for it the source text is in A1 right here so I'm just going
00:56to go
00:56around over here and type that in so I'm saying source text as A1 right here and it says substitute
01:02the function so you can see that it says one two three only right here so I'm just going to
01:07go
01:07around and say I'm going to add in from remove all numbers from one to ten right here just like
01:17this
01:18so I can simply go ahead right here and then what happens is that it'll go ahead and give me
01:23the
01:23updated formula right here just like this you can see that it removed from one to ten so let me
01:30just
01:30go ahead and copy this out right here it's using the trim fold formula so let's just go ahead and
01:35paste this and then you can see that the number is removed simply click and drag it and everything
01:41will be removed so you can see that I got first name and last name right here and let's say
01:46I want
01:47another formula to remove first name and last name so I'm going to say in B1 I got I got
01:55first name and
01:57last name write a formula to divide them into first name in one cell and last name in another cell
02:10so
02:11just like this I'm simply going to write everything in plain English and it'll go ahead and give me a
02:17formula for it so it says to split the first name and last name from single B1 to two separate
02:22cells
02:23this is what you have right here so it give me two formulas so let's just go ahead and copy
02:28this first
02:28formula out right here and then I'm going to go ahead and paste this and you can see that you
02:33got the
02:34first name and then I'm going to go ahead and copy out the last name right here just like this
02:39and paste this
02:40out and you got the last name right here so let's just go ahead and then paste this out so
02:46there is
02:47an error right here that's going on so let's just go ahead on to write copy this out right here
02:53and then
02:54I'm simply going to go ahead and paste this out right here so it says there is a problem because
03:00it's
03:00not working so I can simply go ahead and see like let's say for example this um formula isn't working
03:10right here just like this so let's just go ahead and then say that and then it'll give me a
03:16correct
03:17uh code so sometimes it does actually go ahead and then um uh fine um do do an error so
03:25I'm just
03:26going to go ahead and copy this out it gave a corrected code as you can see let's just go
03:30ahead
03:30and there you go so now you can pull this out and then you got the first name and last
03:35name divided
03:36and this is how you can actually go ahead and then uh generate out uh excel seed formulas um inside
03:45of
03:45kimi so hope you guys learned something as always and as always please like comment share and subscribe
04:00you

Recommended