Automating Excel Using Chat GPT

hello everyone welcome to the lesson of Microsoft Excel so in this lesson we're going to learn about how we can automate Microsoft Excel using chat GPD so first off we're going to learn about what chat GPD is so chat GPD is an artificial intelligence chat box developed by open Ai and launched in November 2022. it is built on top of open ai's gp3 Family large language models that has been fine-tuned which is an approach to transfer learning using both supervised and reinforcement learning techniques okay so if you want to like use chat GPD it is very easy first off what you're going to do is just go to a browser and then just search for openai.com when you go to openai.com it's going to open a pop-up okay so first you have to do is try like click on try chat GPD and then sign in or log in so either make an account or maybe also you can use another account which is already made from someone you know or let's say anyone okay so when you open up or sign into chat GPD you will see an interface like this will appear up well now you might want to know how it works so as you can see that these are the examples the capabilities and limitations okay so these are limited knowledge of Worlds and events after 2021 and as you can see the capabilities of chat GPD as this is an AI so it's going to help you find out solutions for your problems or find out the required type of data you need to use it as a solution and you have to keep that in mind that chat GPD not always shows you the same type of solutions all the time sometimes it changes the type of solution you're going to require but it's going to give you the exact type of solution by following either the steps or even sometimes a formula as this is Excel we're going to use macros or either steps to like Auto from a chat like automate Excel using chat GPD as you can see that I have three examples here we're going to find out all of those by using chat GPD as I don't know or I'm gonna like let's say I don't know how we're gonna find out the data or result uh by using formulas on Excel but I'm going to use the help of chat GPD to find out the results so first off as you can see that on my first example so as you can see that on Excel use a formula to find each unique value from cell E3 to e 210 so first I'm going to do is click on it and then I'm going to select it and then copy after copying it by pressing on Ctrl C this is copied and then I'm going to go to chat GPD and then from Cheer as you can see the bar over here just type in or just paste the value okay and I'm gonna do is use this button click on your right mouse key and it will start like you know finding out solutions for you so it's going to take a while stay connected to the internet and after taking a while it's gonna start showing you what type of data you need to like you know generate the type of values to find out the exact result you need so as it's as you can see that it is starting to show me the formula so this is going to be the formula equal index and then the values and then match zero countifs and then you know it's going to go on let's wait for a while and it's going to show you the exact type of data you need so what I'm going to do right here is copy this exact formula however it is and I'm going to copy all of it till the bracket Ctrl C this is done I'm going to go to Excel and then find a cell open cell and I'm going to paste it and then I'm going to type it enter and as it is white over here as you can see that this is Fanta I'm going to use the fill header to find out the other ones let's say all of them are now Fanta but as you go down you will see Fanta and all of them okay as this is just Phantom I bet I'm gonna use chat GPD again Ctrl a I'm going to press delete I'm going to use this formula again Ctrl C go to chat GPD open another chat I'm going to delete this I'm going to type in the things or the same type of data again and now it's going to show me something else as as I said that that doesn't show me the exact type of formula all of the time but as this is quite how it works okay so I'm gonna do is copy that as you can see that this is quite the same type of formula Ctrl V it is done use the fill header okay you will find the data however you need by using the full header okay now it lets you use D3 to D 210. V my bad Undo It Ctrl C I'm gonna go to chat GPD again I'm gonna delete this delete this again go to new chat I'm going to paste this I'm going to find D3 to d210 and now it's going to generate it and now you can see that this is now on the steps so we're going to follow some of these steps and now what I'm going to do is make a list okay go to the tab ribbon and then sort in filter group okay and now what we're going to do is for example E3 to E10 okay so what I'm gonna do here is go to excel Excel now I'm going to select this shift and then down Ctrl shift down and now my bad it should be D3 okay now I'm going to go to insert and then from there or my bad we're gonna go to make okay we're gonna make uh like list so I'm gonna go here and then sort and filter filter them and now you can also find out what type of data you need if you need only like let's say I need only London so I'm going to select London and then press OK and you will see only London will appear here okay and if you can also do the same thing with the brands too that's that is like totally up to you now you might say that this is really simple and anyone can do that but now we're gonna go and show you example two so an example two you can see that there is a amount sheet okay and there are a lot of data so here we're gonna find out that in Excel IF D9 matches E21 okay D9 which is right here E21 which is e 21 right over here okay if it matches it as it does not okay you can see that if it matches it's going to say yes but if it does not it's going to say no so first off we're going to do is again copy this command and then go to chat GPD and I'm going to type in or like paste it Ctrl V and it's going to show me the solution how I can do it so the formula is going to be this one so I'm going to do is copy this exact how it is Ctrl C go to Microsoft Excel find a cell paste it and press enter and as you can see that this is a no because you can see D9 and e21d9 2000 and E21 does not match because this is 20 351 and E21 is 19326 so there is a difference thus it said no let's say uh D21 I'm going to change the data D21 I'm going to copy this Ctrl C I'm going to paste it to chat GPD use this button and this will show me the exact type of formula but this time as I if I press this you will see that this time it will say yes and so which just proves that Chad GPD is like really helpful now you can see that this is a yes now let's go to the third example which is going to be the final one now as you can see that I have a data and now I want to make a drop down box and how am I going to do it so first off just type in the command which you're going to type are like whatever like copy and paste it on chat GPD so I'm going to select on the cell tube and then copy this Ctrl C or just go the chat GPD and then type it if you want to delete what type of conversation would you were having you can also delete it by clicking on it and then just pressing on delete and go to new chat and then you can just paste in your data press enter and it's going to start generating you can also stop generating okay so as you can see now this time it's showing me again the steps but not the formula because I did not ask for the formula but I asked for the solution how I can do it to make a drop down box as it said to select the cell and the data tab Excel ribbon data validation data tools and go into settings and then select on list okay so I'm going to do or follow these steps I'm going to go to excel what I'm going to do is click on a cell I'm going to go to data and then select on data validation which is in the data tools select on it as it's set to be on settings and then from allow select list and then what we're going to do is my bad list and then from there I have to select the array so the array was D3 to the 11. so I'm going to select these click on it and then press ok now you can see the drop down box has been made so I'm going to select on it and you can see that my drop down box has been made I can select whichever one I want and it's going to show me the exact type of data I require so hope you guys understood everything and thank you for watching this video

Channel: Steve Learning

Views: 10,042

Keywords: automating excel using chat gpt, learn excel using chatgpt, automate excel using chatgpt, automate excel with chat gpt, master excel with chat gpt, excel test chat gpt, excel & chatgpt, if statement in chatgpt, chatgpt excel application, testing chatgpt for excel, python coding with chat gpt, how to use chat gpt, chat gpt excel macro, how to use chatgpt and excel to automate tasks, can chatgpt automate excel?, chatgpt excel, how to use chatgpt, chat gpt excel, steve learning

Id: KY1hkLX3N8M

Length: 10min 43sec (643 seconds)

Published: Fri Mar 10 2023