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.
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:)
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!
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!
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?
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.
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_ 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
చందూ గారు, మీ వీడియోలు చూస్తూ ఉంటాను. మీ వివరణ చాలా బాగుంటుంది. నా పనితీరు మెరుగుపరుచుకోవడానికి మీ వీడియోలు చాలా సహాయ పడ్డాయి. మీకు ప్రత్యేక ధన్యవాదాలు.
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
I am completing a free course on youtube uploaded by Simon Sez IT. Right now, i watching it linear trying to understand all the major things in excel. After this, i ll dive deep into each one of them.
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 👍
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.
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. 👍
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
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. 😋
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.
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
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.
Thank you Chandoo. At 74 years I am a boss who struggles to get things done on excel very slow and tiring way. Your video clips are really helping me a lot especially those shortcuts. Yes, I fully agree with you. More we share our knowledge more we are blessed to fill in more knowledge. It's the way our universe behaves.
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.
Thanks for the tips Chandoo. I got a question for you. How does being a professional Data Analyst impacts ones everyday life? After working with numbers on everyday basis helping businesses make better decisions, do you eventually learn to make better decisions on your personal life?
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?
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)
Почему блять ребята из Индии так классно объесняют, что я их даже на английском понимаю. В 2008 году я выучил SolidWorks по видео парня, который работал помошником преподавателя в институте, угадайте от куда он был родом)))
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 .
Sir i have been following you for past 10 years now...When you started blog....I was wondering if you think learning pandas IS better than Excel for newbies ?
Thanks JK for being with me all this time. I made a video comparing Python and VBA here - Please watch it to get my views. ua-cam.com/video/l0o7VMEf0yc/v-deo.html
I’ve avoided pivot table because I’ve had issues where they corrupt the excel file. IT has told me that I have too many non format type formulas and pivots take a lot of memory. Most of my sheets are word not number driven. Non finance in manner. Have you have this issue and how to get around it. Thanks!!!
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
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.
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.
Excel wasn’t even around 50 years ago, not even Lotus 123..😂
@Alpha Kilowatt exactly, how were these techniques in practice 50 years ago when computers itself were at a absolute nascent stage...Impossible
@@Alephkilo i mean, these techniques are applicable outside of excel, even outside computing
@@AlephkiloBut it was around 49 years ago. Last year it would have been around 48 years ago. So they are not far off.
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:)
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!
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!
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?
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.
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!!
Nice short list there Wayne...
@@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
watch at 1.5X and do whatever he says, it's pure gold🙏
చందూ గారు, మీ వీడియోలు చూస్తూ ఉంటాను. మీ వివరణ చాలా బాగుంటుంది. నా పనితీరు మెరుగుపరుచుకోవడానికి మీ వీడియోలు చాలా సహాయ పడ్డాయి. మీకు ప్రత్యేక ధన్యవాదాలు.
These guidelines can be generalized to learning a lot other skills!
Loved the video and subscribed.
Thank you and welcome to the channel.
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
I would also offer begin with the end in mind which marries well with go wide before going deep.
I am completing a free course on youtube uploaded by Simon Sez IT. Right now, i watching it linear trying to understand all the major things in excel. After this, i ll dive deep into each one of them.
is the course good or you recommend any other learning source?
As always, you manage to surprise us, thank you for your videos.
Thank you very much!
Chandoo is a very humble person...also an excel genius
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 👍
I have been learning from your website content, since 2013 and now here wow this is awsome 👍
Thanks AQ... Wow, almost 8 years now. Thanks for being with me on this journey. More awesomeness to you 😊😀
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.
Every single technique described is spot on man. Well done.
Great pieces of learning. Remove H, you can 👌
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. 👍
All the best Prateek...
Man this is high quality content. Fortunate to find your channel
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
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. 😋
Thanks Ryan... :) I am glad to find some fans for my horrible humour here.
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 :)
You are welcome Kunika 😀
This is great tips! Not only Excel, this also can use for Word and PowerPoint, thanks!
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.
As usual, very useful tips Chandoo! Many thanks!
Chandoo - “can do”- as always you succeed in delivering the message. 👏🏻
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
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.
I ❤️ my Excel guruji.
Shubh Pranam.👍🇮🇳🥰😊❤️
Chandoo why are you so Smart I'm seriously jealous of you !!!!
Loved the take out the H reference, for sure Candoo
I love your remove the "H" idea...!!😂
Nice tips , Chandoo and thank you for sharing your knowledge. Smalls steps are the best for moving forward successfully and with less hassle.
You just have to show us how you created a game...IN EXCEL!!! Looks awesome
Sure. I explained the game in this video - ua-cam.com/video/IzvU2ghe2jQ/v-deo.html
Thank you Chandoo. At 74 years I am a boss who struggles to get things done on excel very slow and tiring way.
Your video clips are really helping me a lot especially those shortcuts.
Yes, I fully agree with you. More we share our knowledge more we are blessed to fill in more knowledge. It's the way our universe behaves.
Thanks for the lovely comment sir. I also commend you for keeping the learning mindset.
"Marinate idea un your brain" brilliant!
Thanks for your video, you open my mind to learn more excel
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.
Your are really Guru!
lots of love from an old learner!!
Thank you for this. Really great advice for Excel and life in general!
These are life lessons, not only for excel. Tnks sir
Well said.. started following your videos recently and most of them are useful to me... Thank you CANDO
LOL...new name for Chandoo...
You are welcome Shoba... Yes, we *_cando_* :)
Hi. I see ur vedio. Really good. Plz make 100 days series to be excel pro
Thanks I'm just New in Excel but I'm determined learn
I liked all your video.
Its good one
Thanks for the tips Chandoo.
I got a question for you.
How does being a professional Data Analyst impacts ones everyday life? After working with numbers on everyday basis helping businesses make better decisions, do you eventually learn to make better decisions on your personal life?
Good question
Thank you Chandoo. I am much inspired and encouraged
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
Sir, Thank you very much for your advise... Really Appreciate and value your words..
Thank you for this tutorial.
Thank you for this very useful tips🙌
You are a great teacher, You have explain beautifully
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?
Thank you for the very interesting video. I really enjoyed your videos. Well done and I hope to see you soon again.
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)
Почему блять ребята из Индии так классно объесняют, что я их даже на английском понимаю. В 2008 году я выучил SolidWorks по видео парня, который работал помошником преподавателя в институте, угадайте от куда он был родом)))
Great video! Only quirk is you showed footage of NFL when making your rugby analogy haha.
👍 thanks sir tips 🙏
Make a video on Video- making ... Best tutor
HMMMM...great insight bro...thanks
Really great advice. Thank you!
your excel course price is too high for student.
Hi Chandoo, Thank you for a wonderful video. Really appreciate. 👍
This is beautiful advice, thank you very much.
Glad it was helpful!
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 .
Thanks for presenting this. So agree with.
You are welcome Pouvoir... 😀
Regarding your second point, which is first go wide instead of deep. so may i know number wise excel wide areas..? thank you
Thanks, good food for thought
Very helpful!
Very useful video, specially I like your second tactic.. 👍
One of my favourites too.. 😍😍😍
Baya Chandoo Thanks again. On spot 👌
Thank you sooo much for giving information sir. May I know the microsoft office what varsion r u using...
very useful , thanks
Awesome tips 👍❤❤
WOW! You taught Biology? That's beautiful. 🙌
It was fun and introduced me to the joys of teaching :)
Just awesome advice
Very nice. Clear, precise content. Great
You are welcome Saradha...
Sir i have been following you for past 10 years now...When you started blog....I was wondering if you think learning pandas IS better than Excel for newbies ?
Thanks JK for being with me all this time. I made a video comparing Python and VBA here - Please watch it to get my views.
ua-cam.com/video/l0o7VMEf0yc/v-deo.html
@@chandoo_ i meant Pandas from Python.. Thanks for replying Sir
thanks a lot you are the best.
Thank u for sharing great content
Game within Excel??? I had no idea
I’ve avoided pivot table because I’ve had issues where they corrupt the excel file. IT has told me that I have too many non format type formulas and pivots take a lot of memory. Most of my sheets are word not number driven. Non finance in manner. Have you have this issue and how to get around it. Thanks!!!
Check this video... I talk about few pivot techniques when you have lots of data -
ua-cam.com/video/u4aeZ4ukrqI/v-deo.html
Thanks Darling Chandoo!!, It's working for me as well
Great to hear that Yasasvi...
Very true
Exceptional.
Thanks sir
I want to say that you lookalike bollywood famous comedian Jhonny lever
You are welcome Meghna. I love Jhonny sir's work. Huge fan.
I found your video very helpful! Can you make a video on excel shortcuts for Mac? Thanks 🙏
I don't have (or even use) a Mac. May be in future...
Mr Chandoo I like your inspirational videos, but where I can learn Excel or Microsoft office, please guide me.
I think the title of the video should be “How to learn technology”
Awesome advices.
Great advice
I like take chandoo and take out h
Very helpful
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
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.
Beautiful Video
Well said !!
great sir
Thank you sir