FREE 3 Month Road Map to Learn Advanced Excel and Becoming a Data Analyst
Vložit
- čas přidán 27. 07. 2024
- 💥Download the Roadmap 👉 chandoo.org/wp/3rmap
💻 Learn Excel on demand ▶▶ chandoo.org/wp/excel-school-p...
I have been using Microsoft Excel for the last 20 years. I have also been teaching, consulting and sharing Excel knowledge with the world for 15 of those last 20 years. Many times, people ask me how to learn Excel in a structured manner. This roadmap video is my answer to that question.
In this comprehensive and detailed video, I share my ideal 3-month roadmap to learn Advanced Excel Skills.
I call this "433 PLAN".
4 Topics
3 Lanes
3 Months
⏱ In this video:
=============
0:00 - Why you need a roadmap to learn "advanced Excel"?
1:22 - My roadmap (the 433 plan) overview
3:48 - Month 1 (How to get & clean data with Excel?)
8:26 - Month 2 (How to analyze data?)
14:15 - Month 3 (How to present the results?)
17:44 - The end result (what you can expect)
📂 DOWNLOAD THE ROADMAP PDF:
===============================
I have made a FREE Roadmap PDF guide for you to help you learn all these skills. Please visit chandoo.org/wp/3rmap to download it.
💻 Want to learn Excel? Watch these videos too:
=======================================
If you want to learn Excel and do amazing work, I suggest enrolling in my Excel School program. This comprehensive and advanced Excel course will teach you everything you need to learn, practice and perfect your Excel skills.
▶▶ Visit chandoo.org/wp/excel-school-p... to sign up.
If you don't want to enrol in a course, but just want to use CZcams to learn, check out these videos:
▶ Introduction to Excel (Must watch) - • How to use Microsoft E...
▶ Beginner to PRO Data Analysis with Excel (1mn+ views) - • Beginner to Pro FREE E...
▶ How to use Power Query (introduction) - • Learn Power Query & Au...
▶ How to use Power Query (Advanced) - • Power Query Tutorial -...
▶ How to clean data in Excel (Beginner to Advanced) - • Data cleaning in Excel...
▶ Top 10 Essential Excel Formulas - • Top 10 Excel Functions...
▶ How to use Excel Pivot Tables - • How to use Pivot Table...
~
Happy Learning 😀🌼🌞
#dataanalytics #advancedexcel - Věda a technologie
You are real hero chandoo, saving no of employees time by teaching excel techniques
Chandoo Sir Placed In Every Person's Heart.
Long Live! Long Live!
@@jagatkrishna1543 He is really amazing! Thanks aren't enough for him.
Dear sir, from sri lanka age of 72 fallen love with excel and intrest with formulas and functions, i watch many of ur video its very useful to our childrens , to,elders any one can do good think for the student , including u, i realy wish u, all the best.thanks selvaraj❤❤❤❤❤
So I'm not only one in late love with Excel!
I have subscribed and followed Chandoo since 2017 and he’s one of the best Excel instructors! providing clear & concise instructions. Bought some of his video instructions and they were useful.
One thing I love about you is that you always provide PDFs along with videos, which help us understand and apply practical knowledge. Love you, buddy!
Thank you for the structured approach to a daunting task! Awesome!
Chando, I love how you teach and I have had a great deal of learning from your channel. And the best quote from you is “ don't learn in Isolation
Wow, this guy is simply amazing, less confusing and direct to the point
Thanks for laying out the learning map strategy. Great info, thank you!
Thank you for taking the time to pass on your knowledge to others.
Thanks so much, Chandoo. Many blessings to you!
Thanks for sharing. I love the way you've simplified learning
Incredible video Chandoo! Thank you for creating your content and inspiring people to structure their own learning and thought process! Being self taught and actually doing it well takes a lot of discipline along with the passion to learn it. Great story of your journey and congratulations to your successes and future acheivements
Your structured approach makes great sense. Bringing a personal project in and using this method creates a great foundation. I don't typically take courses, but I had a trial by fire project, and I took a Power Query course. I would highly recommend that method (to break in fast--allowing a gifted teacher (such as you and several others) to provide a structured learning environment for focused approach.
Younger viewers may not realize, that way-back-when, there was not instant access to experts such as yourself. Now, if you are working with a problem, friendly, experienced faces are there in a video to remind/tell us how to get it done!
I am using your videos a lot for a project I am working on.learning a lot about power query; thanks!
Chandoo thank you so much for sharing your experiences and providing your guidance.
I am a huge fan and follower you know - that was really fantastic and utmost helpful!
I've been following you for some time now. God bless your good heart sharing quality knowledge. Thanks Chando
That was super insightful and helpful. Thanks a ton Chandoo. Liked and subscribed.
agreed you are a SuperHero; thank you for sharing a very well structured roadmap, this is very usefull for all of us
Love the tips already changed my life
God bless you chandoo.. thanks for making it
Thank you chandoo for your timely video
చాలా బాగా చెప్పారు,మీరు చేస్తున్న సహాయం మా లాంటి వాలకి ఎంతో ఉపయోగపడుతుంది..
I really like your video, whenever I watched I start learning excel again and giving my best...🙏
Thanks a lot chandoo sir.
Very nicely explained structural way to do
Thank you, Chandoo!👌🙏
Thanks a ton brother you made my day by finding awesome content 🙏🙏
What an amazing video sir!
Thank you Chandoo. I have downloaded the guide and will follow it with videos. 👍🏽
Really Awesome 👌 road map...
Thanks for sharing this....😊
Dear Chandoo sir, I just can't stop thanking you for the value you have added in my life through your amazing excel knowledge. You are one of the most Genuine guy I have ever came across in my life who is providing such a brilliant stuff in excel. God bless you sir and thank you so much once again.. Love from India.
You are most welcome Parashuram. 😍
Thank you i will follow these steps
Super learning/teaching experience shared as usual SIR C
Very helpful, Thanks
Best utilization of time
thank you
god bless you
I love the way you think, structure, and organize everything. I know Baby Excel. I will follow your recommendation to grow my Excel knowledge. Thank you for your fabulous videos.
This is a good way to put it. I need to learn more excel.
Awesome chandoo
Appropriate your good work
Thank you.
You are one of my inspiration Chandoo.. Fyi I got the highest rating for 2022 performance evaluation in my life and got such an amazing bonus. All these due to dedication of building the dashboard. You were part of it.. tqvm..
Wow. Congratulations and more power to you Acik 😍
We are currently using Jira at my company. I can relate!!!
You are the best Chandoo mama
If you're a mathematician, use of SERIESSUM for polynomials will be a good start...and continue with Taylor Series and Maclaurin series.
The speaker worked as a summer intern in 2005 and had to analyze survey data for Glenmark Pharmaceuticals.
The 433 plan includes four areas of focus: 'Get' data, 'Clean' data, 'Analyze' data, and 'Present' data.
The three lanes of the 433 plan are the Technical Lane, Project Lane, and Domain Lane.
In month 1 of the 433 plan, the focus is on learning how to import data from text files, CSV files, databases, and web pages.
The speaker recommends using Power Query to import data into Excel.
Cleaning data involves removing duplicates, ensuring data is in the correct format, and dealing with missing values.
🙏🏻🔥thank you so much sir 😊
Good info thanks
Thank You Sir for all your help. God Bless You. Request you to please post videos on DAX
ThankYou Sir ☺️
you are realy doing neice chandoo, I am watching most of your video and how to become a data analysics
Thanks 🙏 Sir
great video brother
Bravo!!! Your videos are very informative and knowledgeable. Could you plz do a video on slow changing dimentions? As I have question how could we work in pivot table measures on periodically changing price of product/services. Greetings from Pakistan. Regdd
This is what I wanted
Thanks Sir for your generosity and providing insightful and practical knowledge for free. I am an aspiring Data analyst switching from Civil Engineering background with Master's degree. I hope one day I will be able to support you with some amount bigger like buying your courses.
You are welcome Mukhtar for this lovely gesture and appreciation of my work :)
You are the one who make success me in my career, I still remember the date I joined your excel school course long back.
Daily I thinking about you while doing any work in excel.
Thanks a lot
Wow.. thanks for that lovely testimonial EC. More power to you ⚡
Can u give me link of the course i want to learn i am a beginner
Thank for sharing its very useful.
Glad it was helpful!
thank you so much
super inspiring sir
Great Sir
Hii Sir!
Thank you so much! I am really glad that you put this video at this time as I am about to graduate in a period of 3 months and I was really confused about what things should i learn In excel to get myself job ready but now because of you i have a good plan which i can focus on and execute. Thank you once again! 🤗
Same Situation bro.
Yeah and me too thanks
Hi I've just discovered your channel and thank you for this shared that's very interested.
You are very welcome
Thanks!
You are welcome Sarinaht. Thanks for the super 😍
Thank you sir
Love you chandu bro
thanks a lot
Thanks
Sir,
You are doing a wonderful job for newcomers like me who have only limited knowledge of excel.
I just want to know is it possible for a person that he or she would become a professional data analyst with only excel tool.
A very good one. Can you make a similar one for python too?
Материал передан понятно, спасибо
If you ever start any excel or powerBI bootcamp, I would be your first student to enroll. Waiting for that day to come❤
👌👍❤️ thanks sir
@Chandoo Sir - this was such an informative video. Can you make something similar for someone who is thinking to learn PowerBi from Scratch
Hi Chandoo. Whenever I see your videos I feel excited and you seem very familiar. I tried to sign up with your Excel School Program, when I hit the button I was speechless with your price. I accept that you are not running charity but the people like me paying 10K Or 16K it's not a piece of cake. Most of the people are often think that they have to learn something, but they don't know the correct path and correct mentor, once they found like you then the 2nd challenge is money. It always be more than their capacity. I have wish to learn advanced excel and I attended for Jatan Sha workshops few time,he said nicely but end of the workshop he explain about the packages and set a price that was so high than my financial position. Same here I felt like that. But your explanation was awesome. Thank you so much.
You are welcome Shiva. No matter how I price these courses, there will be someone who will find them unaffordable. That is why I give away 90% of everything I create for free thru CZcams and my website. I charge for other 10% so I can live and support my family. Please use my channel + other resources to learn for free.
thank you
Good job
Your way can also be applied in web development or software engineering 😊 thank you
Anyway , this respectful person makes good videos. One fine day i dropped a message to him asking about data analysis. He never replied back and I was following his videos even after that message. But after a few days i thought that there was no point in waiting for a reply from him. Guys Please learn yourself instead of following these types of videos. It will work for you in a long run
If I start replying to all the 1000 emails I get every week, I wouldn't be able to do anything else. So please be kind to others. I understand your question and problem is much bigger to you but believe me when I say this. It is one of the many things for everyone else in the world.
Please make a video on "Excel vs Google Sheets".
Hello Sir!!
Could you even make videos teaching us "Tableau" and as someone like me from commerce background which Programming languages should I know if I want to pursue as a Data Analyst and will just the basics of those language would work or should I be having deep knowledge about it
I really like Power BI, Tableau , Excel ... Inshort visualization makes me happy
Your genuine passion and interest in sharing knowledge is absolutely coming through in your videos (one after another after another...) evidenced by the thought-process you put into making each one, especially, I continue to notice that the more recent ones have gotten very insightful and more effective, topics beautifully explained in a thoughtful pace and context. I wish you were my roommate 35 years ago...we would have created amazing stuff together. But hey, learning never stops for me and with knowledge from people like you, along with my own efforts of course, I'm always getting more advanced and more knowledgeable and with the same spirit, I love mentoring and teaching (although I haven't started that idea at all yet...maybe after retirement). Keep up the great work! Cheers from Greater Seattle, WA.
Thanks for this video. I’ve just started a new project and this way of thinking, learning and doing over 3 months will be very useful. I have most of my research month 1 get data done already.
This was great, can you do something similar for PowerBI?
Pls make a separate course for maths and statistics for data analysis
And another one also for Domain knowledge and business terminologies for Data analytics
Tq..sir
Chandoo G, can you please explain an easy way to analyze multiple response questions in a pivot in Excel?. My data is currently in multiple columns with Yes or No answer. Thanks
4-3-3: in fairness you are talking about important tactics 😁👏 ⚽
hey chandoo.. im looking at rolling out a nationwide survey online for my PhD study. Any site or recommendation on what platform I should use?
Chandoo sir, I wanna say you something; I really loving you 💋❤,
Thanks for your efforts🎉
Than you for your love and appreciation. More power to you ⚡
great video sir do you have a tutorial on how to use excel one combine
Hi Chandoo, love your clips with great details! I got a question if you can help me ! If the huge raw data (report pdf format)under imported into excel! How can I clean up under non proper columns before using pivot table ! Looking forward to hearing from you
You need power query!
My friend who knows python will Always Says Excel is enough to do all the entire things for Data analysis ❤❤❤
Chat GPT and excel, expect ur vedios
I want telugu video.. Chandooooo
Plz do on videos power pivot
Dear Chandoo, i really appreciate your hard work and great knowledge. but i want to request that to join your excel school. kindly make your excel class fee affordable. so every student can get chance to register your course.
Hi sir, I want to learn excel from basic to advanced including data analysis using excel and VBA. Can you please suggest your course.
Hi! I like you.Because you seem so smart.🙂
Do you have videos on tableau as well
Sir what's the starting salary as a data analyst ( fresh college bachelor graduates ) ?
Hi, what's difference between excel n a data scientist work? How much time it will take to reach from Excel to data science?
What are the job opportunities available for freshers after mastering Microsoft Excel & Power BI tool ????
Hi sir can you please tell me how to do autosum from top to bottom