FREE 3 Month Road Map to Learn Advanced Excel and Becoming a Data Analyst
ฝัง
- เผยแพร่เมื่อ 28 มิ.ย. 2024
- 💥Download the Roadmap 👉 chandoo.org/wp/3rmap
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 TH-cam 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 - วิทยาศาสตร์และเทคโนโลยี
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
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!
Wow, this guy is simply amazing, less confusing and direct to the point
Thank you for taking the time to pass on your knowledge to others.
Thanks for laying out the learning map strategy. Great info, thank you!
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 TH-cam 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.
Thanks so much, Chandoo. Many blessings to you!
I am using your videos a lot for a project I am working on.learning a lot about power query; thanks!
I am a huge fan and follower you know - that was really fantastic and utmost helpful!
Chandoo thank you so much for sharing your experiences and providing your guidance.
That was super insightful and helpful. Thanks a ton Chandoo. Liked and subscribed.
Thanks for sharing. I love the way you've simplified learning
I've been following you for some time now. God bless your good heart sharing quality knowledge. Thanks Chando
Love the tips already changed my life
agreed you are a SuperHero; thank you for sharing a very well structured roadmap, this is very usefull for all of us
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. 😍
చాలా బాగా చెప్పారు,మీరు చేస్తున్న సహాయం మా లాంటి వాలకి ఎంతో ఉపయోగపడుతుంది..
Thanks a ton brother you made my day by finding awesome content 🙏🙏
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.
What an amazing video sir!
Thank you chandoo for your timely video
I really like your video, whenever I watched I start learning excel again and giving my best...🙏
Thank you Chandoo. I have downloaded the guide and will follow it with videos. 👍🏽
Thanks a lot chandoo sir.
Very nicely explained structural way to do
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 😍
If you're a mathematician, use of SERIESSUM for polynomials will be a good start...and continue with Taylor Series and Maclaurin series.
Really Awesome 👌 road map...
Thanks for sharing this....😊
Super learning/teaching experience shared as usual SIR C
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 :)
God bless you chandoo.. thanks for making it
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.
Thank you, Chandoo!👌🙏
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
Awesome chandoo
Best utilization of time
thank you
god bless you
Thank you i will follow these steps
You are the best Chandoo mama
Appropriate your good work
Thank you.
Very helpful, Thanks
Thank You Sir for all your help. God Bless You. Request you to please post videos on DAX
We are currently using Jira at my company. I can relate!!!
you are realy doing neice chandoo, I am watching most of your video and how to become a data analysics
This is what I wanted
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
🙏🏻🔥thank you so much sir 😊
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.
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
ThankYou Sir ☺️
A very good one. Can you make a similar one for python too?
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.
great video brother
Thanks 🙏 Sir
If you ever start any excel or powerBI bootcamp, I would be your first student to enroll. Waiting for that day to come❤
Love you chandu bro
Thanks!
You are welcome Sarinaht. Thanks for the super 😍
Great Sir
Good info thanks
Hi I've just discovered your channel and thank you for this shared that's very interested.
You are very welcome
Материал передан понятно, спасибо
thank you so much
@Chandoo Sir - this was such an informative video. Can you make something similar for someone who is thinking to learn PowerBi from Scratch
Thank for sharing its very useful.
Glad it was helpful!
super inspiring sir
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.
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
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.
Please make a video on "Excel vs Google Sheets".
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
Thank you sir
Your way can also be applied in web development or software engineering 😊 thank you
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
thanks a lot
👌👍❤️ thanks sir
This was great, can you do something similar for PowerBI?
Thanks
sir, Please do a Show on how CHATGPT can be installed in EXCEL and how CHATGPT can be used in EXCEL
Good job
thank you
My friend who knows python will Always Says Excel is enough to do all the entire things for Data analysis ❤❤❤
4-3-3: in fairness you are talking about important tactics 😁👏 ⚽
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.
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 ⚡
Tq..sir
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?
Sir what's the starting salary as a data analyst ( fresh college bachelor graduates ) ?
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!
Hi sir, I want to learn excel from basic to advanced including data analysis using excel and VBA. Can you please suggest your course.
Chat GPT and excel, expect ur vedios
I want telugu video.. Chandooooo
Plz do on videos power pivot
What are the job opportunities available for freshers after mastering Microsoft Excel & Power BI tool ????
Hi! I like you.Because you seem so smart.🙂
Hi Chandoo i appreicate your efforts but Data analyst role has become more complex in the recent past, its beyond excel, power bi, tableau..the role has become more of a hybrid mix of conventional data analyst+data engineer. Every job description I see has made things more and more complex for new aspirants can not enter into this domain.
am not totally agree with because in data analysis it's not just about the tool it's about the tool that can serve your need and take these things and idea's from your brain to the real world
Can you make a video how to get a job as a data analyst as a fresh grad with data analytics certificate?