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

  Рет қаралды 367,418

Chandoo

Chandoo

Күн бұрын

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

Пікірлер: 221
@bhoomika2002
@bhoomika2002 Жыл бұрын
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 Жыл бұрын
Excel wasn’t even around 50 years ago, not even Lotus 123..😂
@vedantmehra6970
@vedantmehra6970 11 ай бұрын
​@Alpha Kilowatt exactly, how were these techniques in practice 50 years ago when computers itself were at a absolute nascent stage...Impossible
@jerbear97
@jerbear97 10 ай бұрын
@@Alephkilo i mean, these techniques are applicable outside of excel, even outside computing
@notinavacuum5966
@notinavacuum5966 21 күн бұрын
@@AlephkiloBut it was around 49 years ago. Last year it would have been around 48 years ago. So they are not far off.
@Soulenergy31
@Soulenergy31 Жыл бұрын
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:)
@karakol86
@karakol86 2 жыл бұрын
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 жыл бұрын
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!
@CDeeez94
@CDeeez94 Жыл бұрын
Thank you for this. Really great advice for Excel and life in general!
@NovisOrbis
@NovisOrbis 9 ай бұрын
Every single technique described is spot on man. Well done.
@xplorYT
@xplorYT 11 ай бұрын
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 👍
@taniarabisheva8381
@taniarabisheva8381 Жыл бұрын
Nice tips , Chandoo and thank you for sharing your knowledge. Smalls steps are the best for moving forward successfully and with less hassle.
@wayneedmondson1065
@wayneedmondson1065 2 жыл бұрын
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 жыл бұрын
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
@jamesstramer5186
@jamesstramer5186 2 жыл бұрын
These guidelines can be generalized to learning a lot other skills! Loved the video and subscribed.
@chandoo_
@chandoo_ 2 жыл бұрын
Thank you and welcome to the channel.
@siddusidd5571
@siddusidd5571 Жыл бұрын
Man this is high quality content. Fortunate to find your channel
@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.
@kunikaverma72
@kunikaverma72 Жыл бұрын
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 😀
@surauar-raudhahkempadangse5478
@surauar-raudhahkempadangse5478 Жыл бұрын
This is great tips! Not only Excel, this also can use for Word and PowerPoint, thanks!
@eddi3007
@eddi3007 Жыл бұрын
Thank you for the very interesting video. I really enjoyed your videos. Well done and I hope to see you soon again.
@mateotinoco2393
@mateotinoco2393 Жыл бұрын
Chandoo is a very humble person...also an excel genius
@nolatari
@nolatari 2 жыл бұрын
As always, you manage to surprise us, thank you for your videos.
@chandoo_
@chandoo_ 2 жыл бұрын
Thank you very much!
@Deedington
@Deedington 2 жыл бұрын
As usual, very useful tips Chandoo! Many thanks!
@ichsyanfachrian5118
@ichsyanfachrian5118 2 жыл бұрын
Thanks for your video, you open my mind to learn more excel
@manassehyohanna7922
@manassehyohanna7922 Жыл бұрын
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
@krishnateja7728
@krishnateja7728 Жыл бұрын
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?
@niamulbary8162
@niamulbary8162 Жыл бұрын
Your are really Guru! lots of love from an old learner!!
@deepakadroja6065
@deepakadroja6065 2 жыл бұрын
You are a great teacher, You have explain beautifully
@stevenweaver3109
@stevenweaver3109 Жыл бұрын
Really great advice. Thank you!
@isampellisandhyaranisandhy6214
@isampellisandhyaranisandhy6214 Ай бұрын
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
@hcandts
@hcandts 5 ай бұрын
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
@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
@aq2237
@aq2237 2 жыл бұрын
I have been learning from your website content, since 2013 and now here wow this is awsome 👍
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks AQ... Wow, almost 8 years now. Thanks for being with me on this journey. More awesomeness to you 😊😀
@successdiaries3605
@successdiaries3605 Жыл бұрын
Loved the take out the H reference, for sure Candoo
@prateekmaggo9278
@prateekmaggo9278 2 жыл бұрын
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 жыл бұрын
All the best Prateek...
@chanakyas5801
@chanakyas5801 Жыл бұрын
చందూ గారు, మీ వీడియోలు చూస్తూ ఉంటాను. మీ వివరణ చాలా బాగుంటుంది. నా పనితీరు మెరుగుపరుచుకోవడానికి మీ వీడియోలు చాలా సహాయ పడ్డాయి. మీకు ప్రత్యేక ధన్యవాదాలు.
@syedaneesdurez7197
@syedaneesdurez7197 Жыл бұрын
Sir, Thank you very much for your advise... Really Appreciate and value your words..
@notesfromleisa-land7893
@notesfromleisa-land7893 Жыл бұрын
I would also offer begin with the end in mind which marries well with go wide before going deep.
@pillsber
@pillsber Жыл бұрын
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.
@canirmalchoudhary8173
@canirmalchoudhary8173 2 жыл бұрын
Great pieces of learning. Remove H, you can 👌
@aggu08
@aggu08 Ай бұрын
Thank you for this very useful tips🙌
@sk_cuteact1704
@sk_cuteact1704 2 жыл бұрын
Well said.. started following your videos recently and most of them are useful to me... Thank you CANDO
@user-jc6te1vm8v
@user-jc6te1vm8v 2 жыл бұрын
LOL...new name for Chandoo...
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Shoba... Yes, we *_cando_* :)
@ryanschumacher5149
@ryanschumacher5149 2 жыл бұрын
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 жыл бұрын
Thanks Ryan... :) I am glad to find some fans for my horrible humour here.
@vidyasworld26
@vidyasworld26 Жыл бұрын
Chandoo - “can do”- as always you succeed in delivering the message. 👏🏻
@mariafernandaassis9210
@mariafernandaassis9210 Жыл бұрын
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?
@Thihgi
@Thihgi Жыл бұрын
Thank you Chandoo. I am much inspired and encouraged
@yashjain6810
@yashjain6810 Жыл бұрын
These are life lessons, not only for excel. Tnks sir
@theresabell2492
@theresabell2492 Жыл бұрын
Thank u for sharing great content
@anujrawat5886
@anujrawat5886 Жыл бұрын
watch at 1.5X and do whatever he says, it's pure gold🙏
@AshishUV
@AshishUV Жыл бұрын
Just awesome advice
@rmmccarthy1240
@rmmccarthy1240 2 жыл бұрын
Exceptional.
@vivek-placardcommunication9705
@vivek-placardcommunication9705 Жыл бұрын
Hi Chandoo, Thank you for a wonderful video. Really appreciate. 👍
@mohamedswaray470
@mohamedswaray470 Жыл бұрын
This is beautiful advice, thank you very much.
@chandoo_
@chandoo_ Жыл бұрын
Glad it was helpful!
@amol6445
@amol6445 Жыл бұрын
Well said !!
@pouvoirsonghai187
@pouvoirsonghai187 2 жыл бұрын
Thanks for presenting this. So agree with.
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Pouvoir... 😀
@nirmalabolar1382
@nirmalabolar1382 2 жыл бұрын
Awesome advices.
@timeslog
@timeslog Жыл бұрын
Thanks, good food for thought
@dreamdecor888
@dreamdecor888 2 жыл бұрын
great sir
@rameshgoddumari601
@rameshgoddumari601 Жыл бұрын
👍 thanks sir tips 🙏
@Gorgeous-Excel
@Gorgeous-Excel Жыл бұрын
I liked all your video. Its good one
@aatifrashid5413
@aatifrashid5413 Жыл бұрын
Great advice
@underdog6516
@underdog6516 Жыл бұрын
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.
@drissgougili2350
@drissgougili2350 2 жыл бұрын
thanks a lot you are the best.
@generalfacts6238
@generalfacts6238 Жыл бұрын
Great Tips
@abdullah_alhathloul_
@abdullah_alhathloul_ 2 жыл бұрын
very useful , thanks
@sarkarisowlabya812
@sarkarisowlabya812 Жыл бұрын
Thank you sooo much for giving information sir. May I know the microsoft office what varsion r u using...
@shubhikadam9685
@shubhikadam9685 Жыл бұрын
Beautiful Video
@feimohach
@feimohach Жыл бұрын
Baya Chandoo Thanks again. On spot 👌
@priyankaraman8343
@priyankaraman8343 Жыл бұрын
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 .
@ngwangemile4321
@ngwangemile4321 2 ай бұрын
Thanks I'm just New in Excel but I'm determined learn
@RajendraPatel.
@RajendraPatel. 5 ай бұрын
Awesome tips 👍❤❤
@seshulatha
@seshulatha 6 ай бұрын
Very helpful
@vaishnawsingh3726
@vaishnawsingh3726 2 жыл бұрын
HMMMM...great insight bro...thanks
@shoaibrehman9988
@shoaibrehman9988 Жыл бұрын
You are awesome 👌 👏
@saradhalakshmanan3832
@saradhalakshmanan3832 2 жыл бұрын
Very nice. Clear, precise content. Great
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Saradha...
@durgaprasad-up8hc
@durgaprasad-up8hc Жыл бұрын
Thank you sir
@I_am_Romey
@I_am_Romey Жыл бұрын
Great video! Only quirk is you showed footage of NFL when making your rugby analogy haha.
@71Deba
@71Deba Жыл бұрын
Thanks Sir.
@makarand1985
@makarand1985 2 жыл бұрын
Chandoo why are you so Smart I'm seriously jealous of you !!!!
@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...
@anonymous2150
@anonymous2150 Жыл бұрын
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.
@gakobok626
@gakobok626 2 жыл бұрын
You just have to show us how you created a game...IN EXCEL!!! Looks awesome
@chandoo_
@chandoo_ 2 жыл бұрын
Sure. I explained the game in this video - kzbin.info/www/bejne/f6vZhmWdncploLM
@vikastiwari7134
@vikastiwari7134 2 жыл бұрын
Very useful video, specially I like your second tactic.. 👍
@chandoo_
@chandoo_ 2 жыл бұрын
One of my favourites too.. 😍😍😍
@nithinks9088
@nithinks9088 2 жыл бұрын
Thank you
@mohammadjalal7500
@mohammadjalal7500 Жыл бұрын
Hi. I see ur vedio. Really good. Plz make 100 days series to be excel pro
@avinashgotu7209
@avinashgotu7209 2 жыл бұрын
Very effective advice 👌
@chandoo_
@chandoo_ 2 жыл бұрын
Glad you think so. Happy learning.
@muhammadbilal3900
@muhammadbilal3900 Жыл бұрын
Make a video on Video- making ... Best tutor
@askarkalliyath-jk2yx
@askarkalliyath-jk2yx 2 ай бұрын
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...
@manissery1956
@manissery1956 Жыл бұрын
Excellent. Thanks for the tips. Was thinking if we have some formula/function in excel so that we can instruct excel to jump to a required position in an excel sheet. Any help here pls.
@chandoo_
@chandoo_ Жыл бұрын
You are welcome Haridas. You can use HYPERLINK() function of Excel. See this page for some examples - chandoo.org/wp/excel-hyperlinks/
@MrRanjithm1
@MrRanjithm1 Жыл бұрын
I love your remove the "H" idea...!!😂
@mamalik1088
@mamalik1088 2 жыл бұрын
Nice knowledge
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks mate...
@jatinnandwani6678
@jatinnandwani6678 Жыл бұрын
Thanks
@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)
@monikaibrahim6443
@monikaibrahim6443 Жыл бұрын
"Marinate idea un your brain" brilliant!
@krismurahari1975
@krismurahari1975 Жыл бұрын
I ❤️ my Excel guruji. Shubh Pranam.👍🇮🇳🥰😊❤️
@manishkansara7120
@manishkansara7120 Жыл бұрын
Mr Chandoo I like your inspirational videos, but where I can learn Excel or Microsoft office, please guide me.
@shabarilucky5
@shabarilucky5 2 жыл бұрын
Thank you Chando, Can we have any session on audit sampling selection in excel.
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Shabari. I will add this to my list of topics and make a video as time permits.
@shabarilucky5
@shabarilucky5 2 жыл бұрын
@@chandoo_ thank you chandoo, we will wait for ur teachings.
@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!
@fliptop157
@fliptop157 Жыл бұрын
Chandoo Rocks!
@shivashanker6625
@shivashanker6625 2 жыл бұрын
Sir can you please provide power bi video for biggener
@lancelotdsouza4705
@lancelotdsouza4705 Жыл бұрын
Hi Chandoo, Really love your your tips and videos,can i get your course at a lesser price cause I'm without a job and am learning excel to improve my skills
@benjaminnzioki8815
@benjaminnzioki8815 Жыл бұрын
There is plenty of free material at Excel School as well as bits of educational material you get if you create a user account. That's where I started before getting money to enroll at Excel School.
@hypermoose5794
@hypermoose5794 8 ай бұрын
I guess I’ll just have to drop out of college now because I just can’t understand excel and I have to have it for my major
@PritamPaul717
@PritamPaul717 7 ай бұрын
👍🙂❤
Where to get FREE Datasets to practice Data Analytics
9:41
Chandoo
Рет қаралды 115 М.
How to make $100,000+ with Excel Skills (6 strategies)
20:22
Chandoo
Рет қаралды 199 М.
Kitten has a slime in her diaper?! 🙀 #cat #kitten #cute
00:28
Stupid man 👨😂
00:20
Nadir Show
Рет қаралды 24 МЛН
Monster dropped gummy bear 👻🤣 #shorts
00:45
Yoeslan
Рет қаралды 12 МЛН
The *ONLY* 10 Excel keyboard shortcuts  you need to master
10:39
This ~NEW~ Excel Function is Shockingly Powerful!
9:37
Chandoo
Рет қаралды 227 М.
50 things you didn't know Excel can DO 💡
30:03
Chandoo
Рет қаралды 257 М.
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Kenji Explains
Рет қаралды 728 М.
Data Cleaning in Excel - 10 Tricks (Beginner to PRO)
15:20
Chandoo
Рет қаралды 363 М.
Hidden buttons in Excel that only PROs use 🔒
15:00
Chandoo
Рет қаралды 18 М.
FASTEST Way to Become a Data Analyst and ACTUALLY Get a Job
10:55
Stefanovic
Рет қаралды 2,9 МЛН
The power button can never be pressed!!
0:57
Maker Y
Рет қаралды 37 МЛН
Рекламная уловка Apple 😏
0:59
Яблык
Рет қаралды 794 М.