With GPT 4 and code interpreter on, you can directly upload the excel sheet and ask for all sorts of insights including advanced analytics models using python (with ChatGPT). You just ask the right questions and it will do all the tasks (including the coding part). Very useful if you are into analytics or data science.
It's incredible what chat GPT can do for us in all professions. The key though is knowing what one wants from the data and how to articulate the prompt, which is how folk with that knowledge will greatly benefit from these AI tools. Lovely video nonetheless, well described and communicated. I love your videos. ❤
This is great, so far I am using only chatgpt for creating my measures, but after watching this video I got some ideas to create using this method. Thank you
Wow...👏Greate Work sir..Chat GPT answer very quickly than asking Google..😜.. I most like about your Dashboard, the way you applied colour ....Looks so nice😀..One of the best Excel trainer...In the world...🏆
This is great Chandoo! However, I see that you did all the work of making the charts, the VBA from the ChapGPT assistant bot gave directions and method steps. I'm still trying to figure out how to get the chart/dashboard itself to get something from the ChatGPT that would more directly create the illustration. It gives good VBA examples, but I have no VBA experience really and I need to find out more about errors that come after it works the first time.
As far as I know neither ChatGPT nor the "previewed" Copilot and do all the work for you. They can produce nuggets of info. The code interpreter functionality of ChatGPT (paid) has some potential but not to the extent what humans can do at this time. May be in future...
Hi there and thanks for the knowledge you share. I hope to get a solution with the following: I have an Excel table named "Tbl_Measures" with a column named "Measure". There are no records in this table. In another sheet named "Actuals", every three cells in column “C” are merged into one, starting from cell C4 downwards. So, cells C4:C6 are merged, then cells C7:C9, and this pattern continues down the column. I need a simple function where entering a measure name in the table automatically copies it to the first set of merged cells in the "MeasuresData" sheet, starting from C4 to C6. As I enter additional measures in the "Tbl_Measures" table, they should populate subsequent sets of merged cells, such as C7 to C9, C10 to C12, and so forth. If I delete a measure from the "Tbl_Measures" table, the corresponding rows in the "MeasuresData" sheet should also be deleted. How can I achieve this functionality without resorting to VBA?
Chandoo.. All fine with you.. u sound different than what u were sounding earlier.. I hope its jst some dental work and nothing else wrong.. My god.. please take care of yourself.. God bless u.. Lots of love..
Dear Sir, can you please guide us and provide insights for working as a freelance Data Analyst, 1. How to look job on Upwork or other fiver, 2. How pitch client, 3. How to send Proposal, etc. With your experience, would be really thankful to you..।। As I am looking work as a freelance but need guidence, if you do it would be really great।।
I love this content because I love dashboards and I love chatGPT ! 😁 I started using chat gpt with excel some weeks ago and I can't believe how strong it is! I ask it to write some code to manipulate my data, and it does in a few seconds while it would take me some time to figure out as I'm quite a beginner in VBA. I ask it to help on some advanced formulas, it does the job pretty well too! Sometimes it fails, but most of the time, it's a precious assistant! Many times I surprised myself thanking and congratulating "him" 😅
Chandoo, I'm confused. I noticed you do most of your data analysis in Excel. I’m delving in Analytics, and I’ve been learning Excel for a while, thanks to your channel and others. Things is, I don’t know whether learning VBA would be a waste of time. Or whether I should dive straight into python. Thanks
There are actually 3 parts in your question: 1. Excel is the ABC's of data analytics. You should learn the formulas and pivot functions, so you can quickly do sanity some checks. If you do Python, SQL, etc, you can always manually check those calculations using Excel. 2. Creating Dashboards in Excel is extra skill, because most big companies use other enterprise tools to create dashboards. 3. VBA just automates the Excel functions that you would create manually. It doesn't replace any underlying Excel skill, but rather builds on top of that.
What version of chatgpt are you using? I used the free version witch is 3.5, to convert some numbers intro grades, but almost every time it gave me a wrong formula. Maybe because is an outdated version. Anyway, with or without braces, you are a great guy and an astonishing teacher. I know it hurts while the teeth migrate in the crown, but in the end, you'll be able to advertise toothpaste. 😂 ऐसे ही जारी रखें🤗
Hi chandoo, i have questions. I observed in you are using exact values or object to map values in vlookup and all. Could you tell me how to find multiple results for not exact match. Example 1.happy customer and 2.Happy koustmer
You Guys are Promoting Chat GPT and providing Information to Senior managers. Data Analyst, MIS, Data entry....most of the Data related jobs will be included by plugins in softwares. So Data Jobs are going. Youngsters should be aware these people are giving details to seniors I request people to unsubscribe from these kinds of fraudsters.
@@chandoo_anna, I had to remove my 4 wisdom teeth due to impaction, have a small cross bite problem due to 1 tooth that's outside the arch the rest were near perfect. The doc suggested to take up braces but after bringing my cousin he said u may get gaps in other places after the treatment. So I dropped that idea. I will do it when it is absolutely necessary.
This is incredible! THank you for walking us through the process. Cheers 😎👍
With GPT 4 and code interpreter on, you can directly upload the excel sheet and ask for all sorts of insights including advanced analytics models using python (with ChatGPT). You just ask the right questions and it will do all the tasks (including the coding part). Very useful if you are into analytics or data science.
Can you help me how to do it?
Please guide@SavageShaunak
You are one who teaches Dil se. ❤❤
What a style Sir, got knowledge with style, Thanks
It's incredible what chat GPT can do for us in all professions. The key though is knowing what one wants from the data and how to articulate the prompt, which is how folk with that knowledge will greatly benefit from these AI tools. Lovely video nonetheless, well described and communicated. I love your videos. ❤
This is amazing, thanks!
Thank you for all the effort and work you have put into your videos over the years. Very informative, educational and inspirational. Well done sir.
This is great, so far I am using only chatgpt for creating my measures, but after watching this video I got some ideas to create using this method. Thank you
Great Job Chandoo Garu,, Thanks for sharing your knowledge
I wish I could lie, but Chandoo, you are a genious. Thank you for this trick.
You're welcome!
This is amazing. Thank you!
Chandroo Sir --- You are GOOD !!! 👌👌👌👏👏👏
You are an excellent presenter.
Chandoo! You're awesome!
You too!!
Great Video! Awesome!
SuperStar picture at the back
You got it!
You're such a awesome Man, Keep rocking !! love you 🙂
Wow...👏Greate Work sir..Chat GPT answer very quickly than asking Google..😜.. I most like about your Dashboard, the way you applied colour ....Looks so nice😀..One of the best Excel trainer...In the world...🏆
Amazing thanks for your effort and time you are the best!
Thanks Chandoo, You are Amazing.
Thanks from Karachi, Pakistan
This is incredible. It's takes Chat GPT to another level.
That's super impressive! A great tutorial, Chandoo 👍
Very nicely explained thank you
Love your content
Thanks for this video!
Thanks a lot brother!
Thanks Chandoo
Thank you for sharing!
Awesome chocolate sales charts. Hippi duper!
Great, thank you !!
Superb @chandoo anna..! thanks for the vid. expecting more content in coming days
Great video thankyou
Very informative
Amazing work.
Nice information
This is great Chandoo! However, I see that you did all the work of making the charts, the VBA from the ChapGPT assistant bot gave directions and method steps. I'm still trying to figure out how to get the chart/dashboard itself to get something from the ChatGPT that would more directly create the illustration. It gives good VBA examples, but I have no VBA experience really and I need to find out more about errors that come after it works the first time.
As far as I know neither ChatGPT nor the "previewed" Copilot and do all the work for you. They can produce nuggets of info. The code interpreter functionality of ChatGPT (paid) has some potential but not to the extent what humans can do at this time. May be in future...
Thank you!!
Hi there and thanks for the knowledge you share. I hope to get a solution with the following:
I have an Excel table named "Tbl_Measures" with a column named "Measure". There are no records in this table.
In another sheet named "Actuals", every three cells in column “C” are merged into one, starting from cell C4 downwards. So, cells C4:C6 are merged, then cells C7:C9, and this pattern continues down the column.
I need a simple function where entering a measure name in the table automatically copies it to the first set of merged cells in the "MeasuresData" sheet, starting from C4 to C6. As I enter additional measures in the "Tbl_Measures" table, they should populate subsequent sets of merged cells, such as C7 to C9, C10 to C12, and so forth. If I delete a measure from the "Tbl_Measures" table, the corresponding rows in the "MeasuresData" sheet should also be deleted.
How can I achieve this functionality without resorting to VBA?
U R Awesome thanks Anna
Nice vid
great, you should try the code interpreter and compare the results between this video and that video.
good one
BRO IS OBSESSED WITH CHOCOLATES😆BTW NICE VIDEO
Thank you 😋
Amazing
Good 👍
Chandoo.. All fine with you.. u sound different than what u were sounding earlier.. I hope its jst some dental work and nothing else wrong.. My god.. please take care of yourself.. God bless u.. Lots of love..
Hi, I interested in BI , thank for the explaination.
Thanking Your Chandoo Garu
Hi Chandoo. Take care of yourself.
Is there any way to highlight the max in power bi without dax
Could you post some tricks in power bi without dax.
Dear Sir, can you please guide us and provide insights for working as a freelance Data Analyst,
1. How to look job on Upwork or other fiver,
2. How pitch client,
3. How to send Proposal, etc.
With your experience, would be really thankful to you..।। As I am looking work as a freelance but need guidence, if you do it would be really great।।
I love this content because I love dashboards and I love chatGPT ! 😁
I started using chat gpt with excel some weeks ago and I can't believe how strong it is!
I ask it to write some code to manipulate my data, and it does in a few seconds while it would take me some time to figure out as I'm quite a beginner in VBA.
I ask it to help on some advanced formulas, it does the job pretty well too!
Sometimes it fails, but most of the time, it's a precious assistant! Many times I surprised myself thanking and congratulating "him" 😅
are you a dataanalyst?
@@atithembram9768 nope, I'm an accountant 😁
Sir, can you please create a full advanced ms excel course? It will be helpful for my future studies.
Sure. I have a course already. Sign up from here - chandoo.org/wp/excel-school-program/
thankyou sir
Chandoo, I'm confused. I noticed you do most of your data analysis in Excel. I’m delving in Analytics, and I’ve been learning Excel for a while, thanks to your channel and others. Things is, I don’t know whether learning VBA would be a waste of time. Or whether I should dive straight into python. Thanks
There are actually 3 parts in your question:
1. Excel is the ABC's of data analytics. You should learn the formulas and pivot functions, so you can quickly do sanity some checks. If you do Python, SQL, etc, you can always manually check those calculations using Excel.
2. Creating Dashboards in Excel is extra skill, because most big companies use other enterprise tools to create dashboards.
3. VBA just automates the Excel functions that you would create manually. It doesn't replace any underlying Excel skill, but rather builds on top of that.
Thank You Sir! Can you please prepare new dash board with DAX expression in Power BI please
Sir, will the dashboard data and pivot table change with the change or addition of data in Master Data?
Yes, it does. You just need to refresh the workbook.
What version of chatgpt are you using? I used the free version witch is 3.5, to convert some numbers intro grades, but almost every time it gave me a wrong formula. Maybe because is an outdated version. Anyway, with or without braces, you are a great guy and an astonishing teacher. I know it hurts while the teeth migrate in the crown, but in the end, you'll be able to advertise toothpaste. 😂 ऐसे ही जारी रखें🤗
Can you please make a Saas Accounting videos?
nice
Chandoo can do!
Thabk you! Does chat GPT can make the same for Google Sheets?
depends, considering there would be quite less processes and options available.
Hi all, can anyone tell how to do conditional formatting in power bi for individuals with different targets.
Can we make it in a spreadsheet?
Hi chandoo, i have questions. I observed in you are using exact values or object to map values in vlookup and all. Could you tell me how to find multiple results for not exact match. Example 1.happy customer and 2.Happy koustmer
Is there any threat for data analytics beacuse of chat gpt
how i build bi report using chatgpt ..& posting in linkedin
Gr8.
@ 2.20 to 2.22 My excel and here there is difference . Unable to proceed further
🔥🔥🔥🔥🔥🔥🔥🔥🔥
Wow, this is good on ideation; What happened Chandoo to your jaw?
I need the excel file you.used
Kaç bin abone sahibi olmuşsunuz, o dişleri neden yaptırmıyorsunuz?
Thalaivar Rajni is in the background?
😎
Too fast in explaining leads to delay in understanding
Run the video in slow motion
0:57 @@sandeepdixit5503
I'm surprised to see that people don't know that there is a pause button 😅
It's that the video is fast, it's just you are too slow
thank u for the information....but tell chatgpt how to add teeth/tooth hahahahahhaha
Analyze data would have done far quicker than ChatGPT 😂
Yes.. but it can't advise you on which KPIs to focus on.
Is that rajnikanth's caricature behind you?
IT IS!!!
Cupid STAY What does Fox Say Lonely Zam
hi big bro, what happened to your teeth , i feeling sad in seeing your changed look, get well soon😍
I have braces now. As they move my teeth around, my look will change.
Kya mai has du😂😂😂😂😂
the reacercher
do you have any hindi channel
Please forgive me because I have spoken bad about you in my mind. Please forgive me and pray for me so that I don't do it anymore.
what happened with your voice (awesome chocolates)
You Guys are Promoting Chat GPT and providing Information to Senior managers. Data Analyst, MIS, Data entry....most of the Data related jobs will be included by plugins in softwares. So Data Jobs are going. Youngsters should be aware these people are giving details to seniors I request people to unsubscribe from these kinds of fraudsters.
Wait you think the right thing is for people to be less knowledgeable about tools that are available for them to be better at their job? 😂
Hmm.. with that mindset, you can't go far in life. Think how to use the tools to your advantage instead of worrying about them.
For a moment I thought you are AI generated, because of your teath.
Just my braces...
😂
you can achieve the same with web search. come on.
2 rs u are
Thank you, boss. What happened to your teeth?
Most irritating voice
Get out of here...
NICE...bt something happened to ur teeth while u were busy with this..!!!
How foolish .......
Why would you create a video while chewing gum?
Why would I?
I have braces. That is why my voice sounds a bit different.
What happened to your teeths ??😮😮😮
What happened to your lower jaw?
I too felt the same what happened bro?
I have braces now. So my teeth are moving around in the mouth. Here is a the vlog of my braces if interested - ua-cam.com/video/3uNjbewTGGw/v-deo.html
So cool thanks Chandoo!
@@chandoo_ oh okay thank you letting know 😊
@@chandoo_anna, I had to remove my 4 wisdom teeth due to impaction, have a small cross bite problem due to 1 tooth that's outside the arch the rest were near perfect. The doc suggested to take up braces but after bringing my cousin he said u may get gaps in other places after the treatment. So I dropped that idea. I will do it when it is absolutely necessary.
Most valuable professional!
Thank you so much Chandoo for all Ur videos! You saved a lot of nerves)
MTFBWY Micrisoft MVP! ❤