8 strategies I used to learn & master Excel in a short time

แชร์
ฝัง
  • เผยแพร่เมื่อ 31 พ.ค. 2024
  • Do you need to learn Excel Quickly? May be you have a job interview or need to transition to a role where Excel skills are mandatory. In this video, I share 8 tactics & mindset that worked REALLY well for me when I had to learn Excel / Power BI and other technical tools.
    The tactics: 💡
    ============
    1) Pick "a" problem
    2) Go W I D E before going DEEP
    3) Connect the dots
    4) Play to learn
    5) Stop nit-picking
    6) Share what you learn
    7) Reflect & Revise
    8) Knockout the H
    9) Bonus: Go for a course
    Timestamps: ⏱
    =============
    0:00 - Pick a problem (1)
    1:19 - Go wide before going deep (2)
    2:54 - Connecting the dots (3)
    3:45 - Having a play with Excel (4)
    4:54 - Stop worrying about small details (5)
    5:39 - Share what you learn (6)
    7:17 - Reflect and Revise (7)
    8:35 - Knockout the H (8)
    9:07 - Join a course
    Playlists & videos for learning Excel: 📚
    ================================
    FREE beginner Excel Course - • What is Excel and How ...
    Top 10 Excel Formulas - • Learn these top 10 Exc...
    FREE Data Analysis Course - • Beginner to Pro FREE E...
    Getting started with Pivot Tables - • How to use Pivot Table...
    🔥🔥🔥 Excel School online classes - chandoo.org/wp/excel-school/
    Happy Learning 🌼🌞😀
    #ExcelTips #learnexcel
  • วิทยาศาสตร์และเทคโนโลยี

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

  • @bhoomika2002
    @bhoomika2002 ปีที่แล้ว +176

    My Dad is a hero. All these techniques he did 50 years ago. But he passed away 22 years back. We never knew his hardship and now when we meet his old friends and colleagues they tell us how My Dad bagged a Job and kept upfront in the skill. Kudos to you Dad. May ur soul rest in peace . Thanks a lot Chandoo for sharing this.

    • @Alephkilo
      @Alephkilo ปีที่แล้ว +3

      Excel wasn’t even around 50 years ago, not even Lotus 123..😂

    • @vedantmehra6970
      @vedantmehra6970 ปีที่แล้ว

      ​@Alpha Kilowatt exactly, how were these techniques in practice 50 years ago when computers itself were at a absolute nascent stage...Impossible

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

      @@Alephkilo i mean, these techniques are applicable outside of excel, even outside computing

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

      @@AlephkiloBut it was around 49 years ago. Last year it would have been around 48 years ago. So they are not far off.

  • @karakol86
    @karakol86 2 ปีที่แล้ว +25

    I used this approach for python (no prior compsci experience at all) and it is very helpful and trying to do an advanced problem is a great way to learn how to do something.

  • @hammerdata1603
    @hammerdata1603 2 ปีที่แล้ว +75

    Great advice gor all! People forget: we never quit learning. I watch some videos thinking most likely nothing new, then SURPRISE! A different method, keyboard shortcut, etc. is provided. A million thanks for continuing to share your knowledge and "lessons learned" in a clear, concise and efficient way w/"real" world examples!

  • @Soulenergy31
    @Soulenergy31 ปีที่แล้ว +60

    1:01 learn how to extract data from the system
    1:40 going wide before going deep
    3:51 play w/ excel
    5:44 share what u learn
    7:50 actice recall
    Thanks for these refreshers Chandoooooóooo:)

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

    Every single technique described is spot on man. Well done.

  • @wayneedmondson1065
    @wayneedmondson1065 2 ปีที่แล้ว +24

    Great advice Chandoo! Practice, solve, share and learn. Those are four things I try to do every day to keep moving forward. Thanks for your insights and wisdom. Thumbs up!!

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว +2

      Nice short list there Wayne...

    • @priyankaraman8343
      @priyankaraman8343 ปีที่แล้ว

      @@chandoo_ hello sir ,i am from India ,i really want to do your course it definitely help me in my career growth but right now i am a student and i can't afford your 147 dollars course , please tell me how to access it . Could you pls give me some concession , i really want to do it . I love the structure you have designed for your course , i think person like me who have basic knowledge in Excel can easily understand and learn from it . Pls help

  • @xplorYT
    @xplorYT ปีที่แล้ว +2

    Great advice Chandoo! I owe you a big thanks when it comes to excel. Learned a lot from your website, Still remember the days (back in 2007) I used to visit your website during my initial days developing Dashboards. Keep rocking 👍

  • @user-gh4zy8gu6q
    @user-gh4zy8gu6q ปีที่แล้ว

    Thanks for the video. Pick a problem - this one works really well for me. Go wide before going deep - this one is new for me, but I am sure it works. We often keep focusing on one feature and it takes so much time to master it. But the truth is that in most cases we need a lot of different feautures (liabraries etc.) to actually solve a problem.

  • @krishnateja7728
    @krishnateja7728 ปีที่แล้ว +30

    Excel was just another tool for me for most part of my life, until my outlook changed towards the excel. It’s just fun and powerful tool to do anything.
    I’m on the journey to mastery. I’ll stick around with your tutorials, and your guidance.
    Om guruve namah!

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

      Hi there. I am working in finance/accounting domain. I wish to enhance my skills in excel in terms of understanding and using Formulas. Can you suggest any book for learning fast?

  • @mateotinoco2393
    @mateotinoco2393 ปีที่แล้ว +2

    Chandoo is a very humble person...also an excel genius

  • @CDeeez94
    @CDeeez94 2 ปีที่แล้ว +2

    Thank you for this. Really great advice for Excel and life in general!

  • @taniarabisheva8381
    @taniarabisheva8381 ปีที่แล้ว +1

    Nice tips , Chandoo and thank you for sharing your knowledge. Smalls steps are the best for moving forward successfully and with less hassle.

  • @jamesstramer5186
    @jamesstramer5186 2 ปีที่แล้ว +18

    These guidelines can be generalized to learning a lot other skills!
    Loved the video and subscribed.

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว +3

      Thank you and welcome to the channel.

  • @siddusidd5571
    @siddusidd5571 ปีที่แล้ว +3

    Man this is high quality content. Fortunate to find your channel

  • @chanakyas5801
    @chanakyas5801 ปีที่แล้ว +1

    చందూ గారు, మీ వీడియోలు చూస్తూ ఉంటాను. మీ వివరణ చాలా బాగుంటుంది. నా పనితీరు మెరుగుపరుచుకోవడానికి మీ వీడియోలు చాలా సహాయ పడ్డాయి. మీకు ప్రత్యేక ధన్యవాదాలు.

  • @kunikaverma72
    @kunikaverma72 ปีที่แล้ว +5

    This is such an awesome video! I LOVE how I was able to relate using these strategies to improve other aspects of work + life. Thank youuuu :)

    • @chandoo_
      @chandoo_  ปีที่แล้ว

      You are welcome Kunika 😀

  • @Deedington
    @Deedington 2 ปีที่แล้ว +4

    As usual, very useful tips Chandoo! Many thanks!

  • @surauar-raudhahkempadangse5478
    @surauar-raudhahkempadangse5478 ปีที่แล้ว

    This is great tips! Not only Excel, this also can use for Word and PowerPoint, thanks!

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

    My steps into Excel and in everything realy, is common logic and common sense, 1 + 1 = 2 (there are, of course mathematicians that will try to proof you wrong, but; that's another dicussion), so building on that logic I advanced and time and lots of practive brought me where I am nowand am proud of what I have achieved en learn (more) every day, never too old to learn.
    Chandoo, you're a great asset for us

  • @nolatari
    @nolatari 2 ปีที่แล้ว +7

    As always, you manage to surprise us, thank you for your videos.

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว +2

      Thank you very much!

  • @deepakadroja6065
    @deepakadroja6065 2 ปีที่แล้ว

    You are a great teacher, You have explain beautifully

  • @thgirl1970
    @thgirl1970 15 ชั่วโมงที่ผ่านมา

    Thank you for this tutorial.

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

    HI Sir, i have been following your content since lockdown, its was superb easy and seemlessly learn the things related to work arounds, please do more and more such oriented stuff... much needed

  • @niamulbary8162
    @niamulbary8162 ปีที่แล้ว

    Your are really Guru!
    lots of love from an old learner!!

  • @aq2237
    @aq2237 2 ปีที่แล้ว +1

    I have been learning from your website content, since 2013 and now here wow this is awsome 👍

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว +1

      Thanks AQ... Wow, almost 8 years now. Thanks for being with me on this journey. More awesomeness to you 😊😀

  • @stevenweaver3109
    @stevenweaver3109 ปีที่แล้ว

    Really great advice. Thank you!

  • @manassehyohanna7922
    @manassehyohanna7922 ปีที่แล้ว +1

    Thank you for positively changing my life with your videos tutorials. I am looking forward to more videos from you on Excel, SQL, PYTHON, and R

  • @lifeofdifferenceld7484
    @lifeofdifferenceld7484 ปีที่แล้ว

    Good Morning Chandoo thank you so much this is helping in other new fields I am currently learning. What a simplified way of instituting lifelong learning. Once more Thank you so much

  • @ichsyanfachrian5118
    @ichsyanfachrian5118 2 ปีที่แล้ว +1

    Thanks for your video, you open my mind to learn more excel

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

    Thank you for this very useful tips🙌

  • @notesfromleisa-land7893
    @notesfromleisa-land7893 ปีที่แล้ว +1

    I would also offer begin with the end in mind which marries well with go wide before going deep.

  • @canirmalchoudhary8173
    @canirmalchoudhary8173 2 ปีที่แล้ว +3

    Great pieces of learning. Remove H, you can 👌

  • @vidyasworld26
    @vidyasworld26 ปีที่แล้ว

    Chandoo - “can do”- as always you succeed in delivering the message. 👏🏻

  • @anujrawat5886
    @anujrawat5886 ปีที่แล้ว +1

    watch at 1.5X and do whatever he says, it's pure gold🙏

  • @eddi3007
    @eddi3007 ปีที่แล้ว

    Thank you for the very interesting video. I really enjoyed your videos. Well done and I hope to see you soon again.

  • @yashjain6810
    @yashjain6810 ปีที่แล้ว

    These are life lessons, not only for excel. Tnks sir

  • @prateekmaggo9278
    @prateekmaggo9278 2 ปีที่แล้ว +16

    Having worked in the data analytics(at a basic level) I feel I know advanced techniques but lack knowledge on some of the basic stuff. I feel the point of going wide before going deep Shd help me improve that feeling. Good video. Thanks. 👍

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว +2

      All the best Prateek...

  • @successdiaries3605
    @successdiaries3605 ปีที่แล้ว +1

    Loved the take out the H reference, for sure Candoo

  • @syedaneesdurez7197
    @syedaneesdurez7197 ปีที่แล้ว

    Sir, Thank you very much for your advise... Really Appreciate and value your words..

  • @munibeats4493
    @munibeats4493 12 วันที่ผ่านมา

    Very helpful!

  • @pillsber
    @pillsber ปีที่แล้ว +2

    The idea of going wide is always the way I prefer to learn first. But, it often seems like teaching systems go deep in one area first. I hate that because then I still do not know all the other capabilites.

  • @Thihgi
    @Thihgi ปีที่แล้ว

    Thank you Chandoo. I am much inspired and encouraged

  • @AshishUV
    @AshishUV ปีที่แล้ว

    Just awesome advice

  • @nirmalabolar1382
    @nirmalabolar1382 2 ปีที่แล้ว

    Awesome advices.

  • @rmmccarthy1240
    @rmmccarthy1240 2 ปีที่แล้ว

    Exceptional.

  • @timeslog
    @timeslog ปีที่แล้ว

    Thanks, good food for thought

  • @mariafernandaassis9210
    @mariafernandaassis9210 ปีที่แล้ว +2

    Thanks a lot for the video! How did you raise your Excel level by yourself? I've taken a course but I don't feel good enough. I feel like I have empty blocks of learning and I know I have to study more but could you give me a tip on how you managed to raise your level on your own?

  • @mohamedswaray470
    @mohamedswaray470 ปีที่แล้ว

    This is beautiful advice, thank you very much.

    • @chandoo_
      @chandoo_  ปีที่แล้ว

      Glad it was helpful!

  • @aatifrashid5413
    @aatifrashid5413 ปีที่แล้ว

    Great advice

  • @Gorgeous-Excel
    @Gorgeous-Excel ปีที่แล้ว +1

    I liked all your video.
    Its good one

  • @RajendraPatel.
    @RajendraPatel. 6 หลายเดือนก่อน

    Awesome tips 👍❤❤

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

    Thanks I'm just New in Excel but I'm determined learn

  • @amol6445
    @amol6445 ปีที่แล้ว

    Well said !!

  • @sk_cuteact1704
    @sk_cuteact1704 2 ปีที่แล้ว +2

    Well said.. started following your videos recently and most of them are useful to me... Thank you CANDO

    • @user-jc6te1vm8v
      @user-jc6te1vm8v 2 ปีที่แล้ว +2

      LOL...new name for Chandoo...

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      You are welcome Shoba... Yes, we *_cando_* :)

  • @abdullah_alhathloul_
    @abdullah_alhathloul_ 2 ปีที่แล้ว +1

    very useful , thanks

  • @rameshgoddumari601
    @rameshgoddumari601 ปีที่แล้ว +1

    👍 thanks sir tips 🙏

  • @ryanschumacher5149
    @ryanschumacher5149 2 ปีที่แล้ว +7

    CANDOO 😆👍 Many thanks, Chandoo! I am always inspired by your videos and I always learn something new. We appreciate greatly the knowledge you share... and the dad jokes - at least I do. 😋

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว +4

      Thanks Ryan... :) I am glad to find some fans for my horrible humour here.

  • @theresabell2492
    @theresabell2492 ปีที่แล้ว

    Thank u for sharing great content

  • @generalfacts6238
    @generalfacts6238 ปีที่แล้ว

    Great Tips

  • @pouvoirsonghai187
    @pouvoirsonghai187 2 ปีที่แล้ว

    Thanks for presenting this. So agree with.

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      You are welcome Pouvoir... 😀

  • @saradhalakshmanan3832
    @saradhalakshmanan3832 2 ปีที่แล้ว

    Very nice. Clear, precise content. Great

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      You are welcome Saradha...

  • @anonymous2150
    @anonymous2150 ปีที่แล้ว +3

    Strategy to learn something quickly--
    1. Focus on a single problem and try to solve it.
    2. Go wide before going deep.
    3. Connect the dots.
    4.Play to learn.
    5. Stop worry about small details.
    6. Share what you learn.
    7. Reflect and revise.
    8. Confidence for solving any problem.

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

    Very helpful

  • @vivek-placardcommunication9705
    @vivek-placardcommunication9705 ปีที่แล้ว

    Hi Chandoo, Thank you for a wonderful video. Really appreciate. 👍

  • @dreamdecor888
    @dreamdecor888 2 ปีที่แล้ว +1

    great sir

  • @makarand1985
    @makarand1985 2 ปีที่แล้ว +1

    Chandoo why are you so Smart I'm seriously jealous of you !!!!

  • @drissgougili2350
    @drissgougili2350 2 ปีที่แล้ว

    thanks a lot you are the best.

  • @shubhikadam9685
    @shubhikadam9685 ปีที่แล้ว

    Beautiful Video

  • @feimohach
    @feimohach ปีที่แล้ว

    Baya Chandoo Thanks again. On spot 👌

  • @71Deba
    @71Deba ปีที่แล้ว

    Thanks Sir.

  • @berlomavingabaontv
    @berlomavingabaontv ปีที่แล้ว

    Thank you sir

  • @underdog6516
    @underdog6516 ปีที่แล้ว +5

    Hello chandoo sir. Its been a long time since i have come across your videos. You help me improve my excel knowledge from the beginning. But there is one point that I am lagging behind is from where do I start? So, I am requesting you to please suggest me some really good excel courses online that will provide me everything that I need. Please consider my comment and will be waiting for your reply.

  • @mohammadjalal7500
    @mohammadjalal7500 ปีที่แล้ว +1

    Hi. I see ur vedio. Really good. Plz make 100 days series to be excel pro

  • @shoaibrehman9988
    @shoaibrehman9988 ปีที่แล้ว

    You are awesome 👌 👏

  • @vaishnawsingh3726
    @vaishnawsingh3726 2 ปีที่แล้ว +1

    HMMMM...great insight bro...thanks

  • @nithinks9088
    @nithinks9088 2 ปีที่แล้ว

    Thank you

  • @MrRanjithm1
    @MrRanjithm1 ปีที่แล้ว

    I love your remove the "H" idea...!!😂

  • @sarkarisowlabya812
    @sarkarisowlabya812 ปีที่แล้ว

    Thank you sooo much for giving information sir. May I know the microsoft office what varsion r u using...

  • @gakobok626
    @gakobok626 2 ปีที่แล้ว +1

    You just have to show us how you created a game...IN EXCEL!!! Looks awesome

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว +2

      Sure. I explained the game in this video - th-cam.com/video/IzvU2ghe2jQ/w-d-xo.html

  • @muhammadbilal3900
    @muhammadbilal3900 ปีที่แล้ว

    Make a video on Video- making ... Best tutor

  • @mrtransmogrify
    @mrtransmogrify ปีที่แล้ว

    5:57 This is the Learning Pyramid where it is said 90% of what is learned is retained through teaching others (NTL institute of applied behavioral science)

  • @sivareddy3745
    @sivareddy3745 ปีที่แล้ว

    Hi Anna, please let me know this when I was using 2016 Excel at that time I don't have the options Forecasting and stock. But I did change to Office professional plus 2019 Key activated version. still I don't have the to options.

  • @avinashgotu7209
    @avinashgotu7209 2 ปีที่แล้ว

    Very effective advice 👌

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      Glad you think so. Happy learning.

  • @monikaibrahim6443
    @monikaibrahim6443 ปีที่แล้ว

    "Marinate idea un your brain" brilliant!

  • @vikastiwari7134
    @vikastiwari7134 2 ปีที่แล้ว +1

    Very useful video, specially I like your second tactic.. 👍

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      One of my favourites too.. 😍😍😍

  • @jatinnandwani6678
    @jatinnandwani6678 ปีที่แล้ว

    Thanks

  • @priyankaraman8343
    @priyankaraman8343 ปีที่แล้ว +1

    Hello sir ,i came across with your video ,it's really helpful i have a basic knowledge in Excel i want to become expertise in Excel ,VBA, please tell me do you provide courses with practice files .

  • @askarkalliyath-jk2yx
    @askarkalliyath-jk2yx 3 หลายเดือนก่อน

    Regarding your second point, which is first go wide instead of deep. so may i know number wise excel wide areas..? thank you

  • @yasasvikvn9607
    @yasasvikvn9607 2 ปีที่แล้ว

    Thanks Darling Chandoo!!, It's working for me as well

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      Great to hear that Yasasvi...

  • @krismurahari1975
    @krismurahari1975 ปีที่แล้ว +1

    I ❤️ my Excel guruji.
    Shubh Pranam.👍🇮🇳🥰😊❤️

  • @84Gekko
    @84Gekko ปีที่แล้ว

    Before signing up, there are English subtitles on videos in the Your Excel school because I am deaf?

  • @I_am_Romey
    @I_am_Romey ปีที่แล้ว

    Great video! Only quirk is you showed footage of NFL when making your rugby analogy haha.

  • @fliptop157
    @fliptop157 ปีที่แล้ว

    Chandoo Rocks!

  • @mamalik1088
    @mamalik1088 2 ปีที่แล้ว

    Nice knowledge

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      Thanks mate...

  • @kaviakashraghav
    @kaviakashraghav 2 ปีที่แล้ว

    Thank you chandoo for inspiring always

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      My pleasure 😊

  • @MIMGURU
    @MIMGURU 2 ปีที่แล้ว

    Very useful video,

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      Glad you think so!

  • @001hpatel
    @001hpatel 2 ปีที่แล้ว

    I found your video very helpful! Can you make a video on excel shortcuts for Mac? Thanks 🙏

    • @chandoo_
      @chandoo_  2 ปีที่แล้ว

      I don't have (or even use) a Mac. May be in future...

  • @zohadaditto1307
    @zohadaditto1307 ปีที่แล้ว

    Hello sir can you please tell me where I can practice for data analysis?

  • @frenan82
    @frenan82 2 ปีที่แล้ว +1

    We can doo!

  • @nareshmanthena8344
    @nareshmanthena8344 ปีที่แล้ว

    Hi ....Penalty shoot out game link not available in description