How to Create Stunning Excel Dashboards with ChatGPT

hello everyone welcome to the video and in this video we are going to create this amazing dashboard using Chad GPT and Excel so yeah you heard it right you can also build this kind of dashboard just using chat GPT and Excel and we will see how to do that in this particular video but before we move forward let me tell you that beten X has an amazing workshop on M MS Office msxl using chat GPT and other AI tools the link is in the description and we will talk more about it later in the video do you want to convert boring looking data in Excel just like this to stunning looking dashboards in powerbi just like this if you want to learn all of this then join me in my 9 rupees powerbi domination Workshop so now talking about this dashboard if you see this particular dashboard here we have a slicer that shows the different product type that is clothing and electronics and here we see the total sales and then we have the total sales by month and then we can compare the sales for different regions like North and South regions are there and how the sales is going on right so this is a fictious data set uh just for demonstration that how we can leverage CH GPT to create this kind of dashboard and this is fully Dynamic you see if I click on electronics the data are changing you can see the totals and all these Trends this particular one it is changing so it is fully Dynamic so you see and we can create this in minutes using chat GPT now let's see how to do that this is my sales data right this is the data we have this is a very small data that I curated for this analysis so we have a month column where we have different months then a region column where we have North and South two regions and in the product type column we have two kinds of product one is electronics and clothing and then in the sales amount we have the different sales amount for different combinations of month region and product type now let's say You have given this data and you have no idea what to do so we we can craft a question and ask Chad GPD to give us something right so let's open Chad GPD so I have already opened chat gbd and let me U ask the question to okay so I have already written my question I'll just paste it and we will read it out together so it says I have a data set with the following column headers in Excel so I'm giving the context to Chad GB that whatever the things I had I have and then I'm asking tell me how can I create a dynamic data dashboard in Excel uh with slicer and filter so I'm not giving anything like you know I want to do this or do that I'm just giving I just want some kind of analysis and I want to create a dashboard which is dynamic that uses slicers and filters you know like just like that so let's ask this question and see what Chad GPT comes up with uh yeah you see it is giving us different steps very nice and let's see uh let it complete and we will go through it okay okay see so detailed uh the answer is so detailed man see eight step process it has given us so maybe some of the steps are not very useful but let's see so it says that ensure data is organized with headers in Excel so it is organized and we have month region product type and sales as you can see it everything is organized then it's saying that select your data set go to insert tab click on table uh make sure to check the box as table my table as a header so basically it's saying that make it as a table all right so basically if you go here if you could insert and click on click in this one this will become a table okay so let's make it a table okay my table has a header it says that you know check that so check that so now it becomes a table so table is actually if you have a data set and you have the luxury of converting that into table um always do that because table has a lot of advantages over you know just the cells in the spreadsheet okay especially when you're analyzing something and then it says that click on any cell within your table go to insert Tab and click on P tables in the dialogue box confirm the data range and choose whe whether to place P table in the new worksheet or the existing one then it's saying that drag the fields mon region and product type into rows or column section of the P tables right so yeah let's see now we know how to create a p let's say so so when we started we don't have any idea how to do or how to deal with this data but now we know so let's go to insert Tab and then click on the P table so now it says that table range so since we have converted this into a table it is telling that the table range is table one because the name of the table is table one this is a default name now I want to create a p table in a new worksheet okay so let me click on okay so you see it created a new worksheet okay and in the pivot field it is saying that drag the suitable things into filters columns and rows and values if you see it is saying that um here drag the fields month region product type into rows and column section of the pivot table so let me drag the month to rows and region to columns and maybe product type to filters and sales amount to values so now you see product type we can select uh clothing or maybe if you say you can select all or maybe you can select clothing so this is for clothing and then you can also select for Electronics this is for electronics and then we have months here and then we have north and south and then of for different regions sales for different regions and so this is already Dynamic you see just using a few drag and drop menu and using CH GPT we are able to create a pivot table like this before we move forward in the topic let me tell you that AI is not going to replace you but a person using AI will so if you don't want to lag behind then join the workshop to learn AI hacks in MS Office using chat GPT and other AI you don't need to have any prior knowledge for this and I'm pretty sure that you will become hyper efficient post this so what are you waiting for join our Workshop by clicking the link in the description below now let's get back to our topic now let's read it out what else what else so it's saying that adding uh slicer so click anywhere on the pivot table go to insert Tab and click on slicer choose any field you want to use as a slicer right so let's uh click here let's go to insert and let's go to it says slicer right slicer is right here so let's click on slicer now let's say we want product type A slicer right so if I click on okay so yeah so what is the difference between this filter and slicer uh well technically nothing uh but visually you can see it is uh looking more good so there is a drop down option and you can click here and see if I'm clicking this one this one is also changing so if I click on clothing this is also changing into clothing Electronics this is also changing into Electronics this is because this particular slicer is Created from this particular P table that's why it is on sync with the p table okay now let's see uh then it's saying creating charts select your P table go to insert tab choose the desired chart type bar or line chart customize chat as needed title access level okay now we know how to create chats there okay so click on anywhere in the pivot table go to insert as per the instruction given by chat GT create a suitable chart now we know for you know January February like this kind of data where monthly data it is better to show it in Trends so let me click on line chart and click it like this so yes you see we created this particular you know North South Region data here and this is dynamic as well wow you see just in a few minutes we created this amazing chat right let's see what else then it's saying testing and finalizing uh connecting slicer to chart click on the chart go to P table chart analyzer Okay click on the chat go to P table chart analyzer okay this one we have we got it already there then it say that click on insert slicer choose the slices you have created okay insert slicer and this is the product type slicer that we need click on okay so basically it created a duplicator since we already created this one so it's not required so maybe I can delete this one and now you see this is also working and it is also sync with the chart and the pivot TBL so everything is in sync perfect sync right so you see how easily I created this chart right and in case let's say you using all these things also you can also like for example here also I can change to product type so here also if I want let's say Electronics so you see everything changes to electronics and here also region also if I want to select like uh any region if I want to see only one region I can do that or you know month here also if I want to deselect some of the month then I can do that and the same changes will be reflected in this P table as well but I don't want to see all this in my chart right so what can I do if I go to P table chart analyzer there is a option called uh field buttons right and just click on hide all right so now it's gone and chat GPD also says that we can add chat data labs and everything Lo so let's say uh we have to provide some access title so right or not maybe access title maybe chart title right so chart title chart title is here and we can provide any chart title so something like monthly Trend so you can give it uh take your time to format it you know provide appropriate color or maybe if there is a brand color you can do that and but the main thing is um I want to create a separate sheet for my dashboard so how to do that how to move this chart so there is a very good option so just right click on the chart When selecting and then there is option called as move chart right so if I click on move chart then either I can create a new chart set or maybe I can place it on any of the uh basically on any of the sheets that is present so if I want to uh take it to the sales data sheet okay I click on okay now this is gone now here here it is here it comes okay and this is already in sync with um this one so if I change it to clothing right if I go here now this one is for clothing actually okay and if I want to take this particular slicer to the other sheet all I have to do is just you know control X to cut and here I just need to give control V and if I change it now see everything is in sync I change it to electronics if I go to sheet six this is also Electronics right and let's say I want to see the total numbers right so if you see my dashboard here I have total sales as well and this is also Dynamic how can I do that how can I get this particular one so very simple if you go to here let's say okay here I want click on equal to go to our P table this is my grand total right so I just click here and click on enter so now as I change this is also changing and this is nothing reflecting this particular number in this particular sheet simple formula and in this dashboard if you see all I did is those things only we created charts here also I created charts added titles then here I can uh change the slicer I have added slicer and you already know how to add slicers and this is the number equal Al to get pivot data which is I'm getting from this particular pivot which is driving this particular dashboard and then here I have another chart just to show the overall trend right and just coloring the background text font increasing the test font and then coloring the text font that's what I have done rest of the thing but now you got the technical stuff right you know how to create a chart how to move a chart to the other sheet how to create a slicer how to make everything Dynamic you know all of it and with just a little bit of uh you know designing skills you can create this amazing dashboard for you I hope you understand how easy it is with Chad GPT helping you to create such amazing dashboards in Excel in minutes even if you don't know much about Excel isn't that amazing so yeah we have more amazing stuffs coming on stay tuned stay safe and I will see you next time please do like comment share the video and subscribe to our channel for more such informative videos also do check out our Workshop Link in the description we'll see you there thank you

Channel: Office Master

Views: 17,966

Keywords: Excel dashboards, ChatGPT tutorial, Excel dashboard tutorial, AI in Excel, advanced Excel, Excel for beginners, ChatGPT and Excel, Excel tips and tricks, create Excel dashboards, Excel visualization techniques, automate Excel with ChatGPT, Excel dashboard design, Excel training, Excel charts and graphs, AI data analysis, dynamic dashboards Excel, Excel interactive dashboards, Excel dashboard 2023, ChatGPT Excel tips, Excel and AI tutorial, office master, aditya kachave, AI

Id: L7Nd9gujT5M

Length: 14min 53sec (893 seconds)

Published: Wed Dec 27 2023