How to use ChatGPT to write Excel Formulas 10X Better 👨‍💻

Ғылым және технология

AI tools like ChatGPT are great for enhancing your Excel skills. In this video, I present 7 tactics I use to 10x my Excel formula skills.
1️⃣ Asking AI for the formula
2️⃣ Explain it to me
3️⃣ Alternatives
4️⃣ Debug the formula with AI
5️⃣ Give me clues
6️⃣Test my skills
7️⃣ Critique my approach
📁 Download sample data file
=========================
Grab the sample data file from here chandoo.org/wp/wp-content/upl...
📚 Video topics:
==============
0:00 - Using AI to improve your Excel skills
0:25 - The data and setup
1:24 - The first tactic - asking AI to do the work for you
2:58 - Asking for Explanations
5:31 - Proof that AI can't do everything
6:01 - AI to make a few alternatives
7:17 - Debugging the problems with ChatGPT
9:00 - Going to the next level - truly improving your skills
9:50 - Getting AI to give you clues
11:55 - Asking ChatGPT to test your knowledge
13:09 - Using AI to critique your approach
15:26 - How to use CoPilot to build things for you in Excel?
🤖 MORE AI Videos
=================
Need to understand how AI will impact data analysis work? Check out these videos and rocket your skills.
10x your productivity with these AI tools in Excel - • 10x your productivity ...
Using CoPilot with Excel - • Honest review of Excel...
ChatGPT made this dashboard - • DON'T tell my boss, bu...
Using AI to write DAX for me - • What! We don't need to...
AI + Data - the playlist - • Using AI tools with Da...
💻💡 Full Excel Course
===================
Join my Excel School program and become a spreadsheet guru. Go here for all the details - chandoo.org/wp/excel-school-p...
~
#chatgpt #ai #excel
~
What does an Excel nerd tell the barber...? ✂
I need a shortcut 😂

Пікірлер: 46

  • @jatinsharma8287
    @jatinsharma82872 ай бұрын

    Thankyou vro ... I always use gpt for my excel related tasks... and trust me this is all you need for your daily tasks

  • @chrism9037
    @chrism90372 ай бұрын

    Thanks Chandoo. I've used it several times to construct some DAX formulas where I was stuck, and it was very helpful

  • @AbhiMaxJsr
    @AbhiMaxJsr2 ай бұрын

    Thanks chandoo ❤

  • @feriaschile3400
    @feriaschile34002 ай бұрын

    Ok my friend. Thumb up! Like your great work. Thanks

  • @deepakkapoor8202
    @deepakkapoor82022 ай бұрын

    great tips, GPT4-O launched yesterday and showcased its ability to talk to you and help you learn rather than getting the answers if you chose to. you can now share your screen to show the problem or even upload. Now the only thing remains for humans is to learn the skills ask questions effectively[prompt], the solving the problem is not a task anymore. Better the prompts better the response. Some jobs will be impacted for sure.

  • @Ak_computer_Gyan
    @Ak_computer_Gyan2 ай бұрын

    That's great sir I always like your video content ❤🎉 well done ✅

  • @shivampradhan3645
    @shivampradhan36452 ай бұрын

    Thats amazing, l thought this video was about learning excel with chatgpt but its more about learning how to learn with chatgpt

  • @90sGamingWizard
    @90sGamingWizard2 ай бұрын

    After painfully watching this, Im happy to say that a person with proper excel knowledge is far more better than using AI

  • @Hello-bn2yc
    @Hello-bn2yc2 ай бұрын

    thank you chandoo

  • @KleanthisSkoulikaris
    @KleanthisSkoulikaris2 ай бұрын

    Chandoo, you really are like a cool techy uncle to us all "nerdy" button-pushers and I really enjoy everything you post, be it a video or a blog. Thank you so much for everything you've done for the Excel community across the world!

  • @chandoo_

    @chandoo_

    2 ай бұрын

    T-shirt idea: "Cool techy uncle" 😂

  • @aryansfunzone
    @aryansfunzone2 ай бұрын

    Excellent

  • @subhashisbasak4348
    @subhashisbasak43482 ай бұрын

    Sir, honestly you are the one who is far beyond the reach of AI.

  • @shaikusman536
    @shaikusman5362 ай бұрын

    Chadoo sir ji , That was quite awsome GPT use case.............GPT enhances workflow....Thanks sir ji....

  • @palanivelshanmugam6159
    @palanivelshanmugam61592 ай бұрын

    Liked the video ❤

  • @nothingness627
    @nothingness6272 ай бұрын

    Chandoo is a legend. I think your channel has been around 10+ years now?

  • @geekatari4391
    @geekatari43912 ай бұрын

    I've been following this approach now that I am learning MySQL and Python.

  • @0rz4n
    @0rz4n2 ай бұрын

    Thanks Chandoo for the great video, as always. Just a quick question: Aren't you concerned about AI replacing data analyst jobs in the coming years

  • @snackplaylove
    @snackplaylove2 ай бұрын

    Getting the AI to help with writing VB was very useful, but not as useful as going to your website - taking the code and then tailoring it to my needs - then - getting the AI to suggest why it wasn’t quite working for my example. Using it like a colleague or a teacher is always the best way - you do your best, then get them to check it.

  • @talkinghat88
    @talkinghat882 ай бұрын

    Loving the Name column 😂

  • @Mahi_paul
    @Mahi_paul2 ай бұрын

    Praise the Lord Chandoo Bro 😎

  • @Ak_Seeker
    @Ak_Seeker2 ай бұрын

    Hope all is well, you did not sound well, I have learnt so much from you - Thank you

  • @chandoo_

    @chandoo_

    2 ай бұрын

    All is good. Not sure what you mean by sound well.

  • @Ak_Seeker

    @Ak_Seeker

    2 ай бұрын

    @@chandoo_ maybe my audio

  • @qwertabcdj
    @qwertabcdj2 ай бұрын

    Hi, Can we schedule reports from Power BI Service to Amazon S3?

  • @wasiffaheem4013
    @wasiffaheem40132 ай бұрын

    For beginners, First learn manually then jump to work with AI applications.

  • @MrHampelmann123

    @MrHampelmann123

    2 ай бұрын

    Actually, AI is perfect for getting you from beginner state to advanced state. The key is to not let AI write the formula for you but to ask the AI to help you write the formula. In this way, AI acts like a personal tutor that helps you exactly where you don’t yet have a full understanding.

  • @punchole
    @punchole2 ай бұрын

    Gemini give better answer than chat gpt, i work with both AI for some complex excel formula

  • @vv9730
    @vv97302 ай бұрын

    2:50 correct formula should be sumifs,not sumif...how the later is working herein..??

  • @ravitirunelveli
    @ravitirunelveli2 ай бұрын

    @5.48, 😂

  • @faizalrahiman3922
    @faizalrahiman39222 ай бұрын

    Is the chatgpt is free download?

  • @prabhakaran089

    @prabhakaran089

    2 ай бұрын

    It is just website based. You can just log in with gmail account.

  • @satishojhaMrblank
    @satishojhaMrblank2 ай бұрын

    Hi chando. I have challenge for you. For example in a column have lots of number value i wanted to add = in that particular value and 2 thing i wanted to make total but not using any formula it's like =200+340+ 300 etc etc. can you do it?

  • @chandoo_

    @chandoo_

    2 ай бұрын

    You can use SUM function for this. =SUM(A1:A100) to all the values in the range.

  • @satishojhaMrblank

    @satishojhaMrblank

    2 ай бұрын

    @@chandoo_ No. This the challenge. You don't have to use sum and subtotal formula.

  • @chandoo_

    @chandoo_

    2 ай бұрын

    Why don't you want to use the functions? And who is giving you these challenges?

  • @satishojhaMrblank

    @satishojhaMrblank

    2 ай бұрын

    @@chandoo_ This is the interview task. I search on chat GPT AI but also Copilate but both AI can't answer this question. Can you do it please?

  • @chandoo_

    @chandoo_

    2 ай бұрын

    I have a video that shows how to sum without the sum function. Try the options in that. kzread.info/dash/bejne/mIhsu7ircr2YodY.html

  • @bhajanmarg35
    @bhajanmarg352 ай бұрын

    I subscribed you today in hope that I will also become a good data analyst and ready for my first job with your free videos for us . Thank you very much For Your Kindness that you upload free courses for people like me who are either able to purchase a laptop for practice or a good course . I committed to my parents I will become data analyst give me some time and a laptop , I am ready to learn what you teach now it's your responsibility Please accept and reply me how I watch your videos in sequence or playlist in sequence please 🙏🏻

  • @shanabenjamin8945
    @shanabenjamin89452 ай бұрын

    Was chatgpt really faster at this task? Excel, in my view, was faster. Q: now building your dashboard, was the chatgpt calculation available on spreadsheet?

  • @NotaBetaMale
    @NotaBetaMale2 ай бұрын

    Boycott AI

  • @prabhakaran089
    @prabhakaran0892 ай бұрын

    If we start using Ai ,then your channel viewers and subscribers will reduce.

Келесі