Learn Excel in Under 3 Hours | Pivot Tables, Lookups, Data Cleaning

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 ม.ค. 2025

ความคิดเห็น • 50

  • @theo2765
    @theo2765 2 หลายเดือนก่อน +4

    Are you crazy Alex yesterday i finished your SQL series and today everything about excel ?

  • @Dojo.FinancialData
    @Dojo.FinancialData หลายเดือนก่อน +1

    Thanks for the tutorial Alex. It's always great seeing how other people use Excel, learnt a couple of new tricks!

  • @trivagravia4837
    @trivagravia4837 2 หลายเดือนก่อน +7

    Are you reading our minds...? just what l wanted...last month l built my portfolio website on github using your video..now l want projects..this video would do it

    • @MUNTAZIR-H
      @MUNTAZIR-H 2 หลายเดือนก่อน

      Thats great

  • @carinacruz1659
    @carinacruz1659 2 หลายเดือนก่อน +2

    Amazing Alex! Really loved it. Thank you so much for sharing your knowledge with us about such relevant topics! You're an amazing trainer. Thank you!

  • @shein0404
    @shein0404 2 หลายเดือนก่อน

    Thank you so much Alex, I badly needed this kind of playlist, it really helps a lot... Greetings from PH...🇵🇭

  • @MarkUSAfreedom
    @MarkUSAfreedom 2 หลายเดือนก่อน +44

    My brother Paul is studying chemistry right now in college, he wants to learn Excel, where he can buy good Office?

    • @joshuaLLM1
      @joshuaLLM1 2 หลายเดือนก่อน

      Mark just go for BNH Software, which college he is going? I'm interested

    • @Ann_779
      @Ann_779 2 หลายเดือนก่อน

      Nice option, my father in law is a chemist, you could go to BNH software or similar...

  • @prathamchatterjee732
    @prathamchatterjee732 2 หลายเดือนก่อน +3

    Hi, Alex.
    I'm a 21-year-old Economics graduate and I discovered your channel last month. Since then, I've been following your content and have gained so much valuable knowledge. Can you please tell me in short how much to master before I land my 1st internship or 1st job as a data analyst in the next 6 months as I heard that you only need to be great at 2 things from Excel, Python, SQL and Power BI or Tableau. Is this true? and if it is then can you suggest which two skills i should master keeping the rest fundamentally strong.
    I'm also completing your data analyst bootcamp.😊

  • @AdamAnalyst
    @AdamAnalyst 2 หลายเดือนก่อน +2

    Great Content!

  • @jessicabelamo
    @jessicabelamo หลายเดือนก่อน +1

    Hi Alex, Thanks for this video; it is a great one. I have a question as regards the full project, and I will be grateful if you reply.
    At the point where you tried to use the age groups along with the age bracket you created and it messed up the visualization, My question is, how will another person know from the visualization that adolescence is this certain age range, old is this certain age range and so forth because another analyst can use a different age range with the same name you used for the age bracket?

  • @CharlesMartel829
    @CharlesMartel829 26 วันที่ผ่านมา

    I'm a data analyst as well and of the rules I use the duplicate several times per day when I clean the data.

  • @CharlesMartel829
    @CharlesMartel829 24 วันที่ผ่านมา +1

    Hi Alex. Do you ever use Excel for statistical calculations (eg, descriptive statistics, regression analysis etc) or would you use something like Python, R, Stata or SAS for that?

  • @grant178
    @grant178 2 หลายเดือนก่อน +2

    Wow, I manifested this video 😎

    • @AlexTheAnalyst
      @AlexTheAnalyst  2 หลายเดือนก่อน +3

      You made it happen and I'm proud of you :)

    • @grant178
      @grant178 2 หลายเดือนก่อน +2

      @@AlexTheAnalyst ❤️❤️❤️

  • @Slang-b9r
    @Slang-b9r หลายเดือนก่อน

    @2:13:57 It says "There are no recommended charts for the data you selected". I cannot find a fix and am now stuck at this part of the project. Any help would be greatly appreciated.

  • @Muhammed_Sal
    @Muhammed_Sal หลายเดือนก่อน

    Awesome, yes u did it
    Thanks a lot

  • @I_am_Magic_Mothae
    @I_am_Magic_Mothae หลายเดือนก่อน

    Thank you for this.

  • @NormDave
    @NormDave หลายเดือนก่อน

    Hi Alex, just discovered your channel and have started the bootcamp - but can't find the file or link for the file you refer to in the pivot table section, sales.csv...can you help please. Shaun

  • @zahraalavy7463
    @zahraalavy7463 หลายเดือนก่อน

    Thanks a million

  • @ShreyaChakraborty-sp8tc
    @ShreyaChakraborty-sp8tc หลายเดือนก่อน +2

    I am not able to find the dataset used by you for making the pivot table. Can someone please help me find the dataset.

    • @RohanPrajapati-j5p
      @RohanPrajapati-j5p 24 วันที่ผ่านมา

      He has provided the link of his GitHub in Description

  • @bharaths4207
    @bharaths4207 หลายเดือนก่อน

    The office ❤

  • @no-_one
    @no-_one 2 หลายเดือนก่อน

    What should I do after I finish the IBM project based learning program in data analysis course october 2024?

  • @orkhangarajayev8026
    @orkhangarajayev8026 หลายเดือนก่อน

    you forgot to include the link in description from kaggle. can you please update it ? thanks

  • @ankuryadav9908
    @ankuryadav9908 2 หลายเดือนก่อน +7

    These videos are from the bootcamp, re-uploaded

    • @AlexTheAnalyst
      @AlexTheAnalyst  2 หลายเดือนก่อน +13

      Yes they are :) I'll have my entire bootcamp in one video in a few weeks

    • @oladipupoolatunde8327
      @oladipupoolatunde8327 2 หลายเดือนก่อน +2

      Anticipating, so I can download at once.

    • @mohamedmostafa-106
      @mohamedmostafa-106 2 หลายเดือนก่อน +1

      Why, when I create two mysql users, I notice that there are the same databases in both of them, and I don't want that I want every user to have their own database.?

  • @simplekindofman8867
    @simplekindofman8867 2 หลายเดือนก่อน +2

    I’m 65, Am I tool old to learn this stuff? I was thinking of working as a freelancer when I retire. I have a strong networking background. Thanks

  • @NolenNova33
    @NolenNova33 2 หลายเดือนก่อน

    Where is the data coming from? the Link in the bio?

  • @dawahboy320
    @dawahboy320 2 หลายเดือนก่อน

    The whole boot-camp workshop which was uploaded in the Freecodecamp channel starts with the SQL videos series which were your very old and beginning ones. So sir which will be better for us to take? The new SQL series which were newly uploaded by you with new interface and installation techniques? Or both are same and gonna be beneficial? Please give some advice, because I want to cover only one series among the both which will be enough for me and cover most of the parts.
    Please try to respond brother :')

    • @AlexTheAnalyst
      @AlexTheAnalyst  2 หลายเดือนก่อน +1

      That one has some outdated content now. I'd probably follow my TH-cam playlist

    • @dawahboy320
      @dawahboy320 2 หลายเดือนก่อน

      @AlexTheAnalyst Thank you soo much❣️
      If you don’t mind can you tell me a way to contact you directly via email or something else? Though I've tried to connect with you through various paths and waited for your response but was in vain :')

  • @ravikumaryadav007
    @ravikumaryadav007 2 หลายเดือนก่อน

    alex freberg pls start data science playlist

  • @AlchemistTasmi
    @AlchemistTasmi 2 หลายเดือนก่อน +1

    How do you I'm gonna search for it next 😁😁

  • @Raseena438
    @Raseena438 2 หลายเดือนก่อน

    hey, i can't able to use xlookup in excel can you plz help me to solve this

  • @olumayowasosina1852
    @olumayowasosina1852 หลายเดือนก่อน

    what version of excel is he using?

  • @naesokk
    @naesokk 2 หลายเดือนก่อน +1

    Hi, I dont see the Pivot Table dataset. Anyone else ?

  • @RitikKumar-zz4js
    @RitikKumar-zz4js 2 หลายเดือนก่อน +1

    🔥🔥

  • @OnielsAgribusinessHub
    @OnielsAgribusinessHub หลายเดือนก่อน

    Can’t download the data sets

  • @blackpillred
    @blackpillred 2 หลายเดือนก่อน

    How did you learn this stuff?

    • @AlexTheAnalyst
      @AlexTheAnalyst  2 หลายเดือนก่อน +4

      Working as a Data Analyst

  • @donovannell8453
    @donovannell8453 2 หลายเดือนก่อน +1

    🎉

  • @MUNTAZIR-H
    @MUNTAZIR-H 2 หลายเดือนก่อน +1

    Hi Alex,
    Please check your email.