FREE 3 Month Road Map to Learn Advanced Excel and Becoming a Data Analyst

Рет қаралды 238,974

Күн бұрын

💥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 KZfaq 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

Пікірлер: 180

@0707ravi Жыл бұрын

You are real hero chandoo, saving no of employees time by teaching excel techniques

@jagatkrishna1543 Жыл бұрын

Chandoo Sir Placed In Every Person's Heart. Long Live! Long Live!

@ashrafbotany 7 күн бұрын

@@jagatkrishna1543 He is really amazing! Thanks aren't enough for him.

@selvarajsuppan8027 Жыл бұрын

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❤❤❤❤❤

@ashrafbotany 7 күн бұрын

So I'm not only one in late love with Excel!

@txreal2 10 күн бұрын

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.

@OmarPopioco Жыл бұрын

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

@Locomaid Жыл бұрын

Thank you for the structured approach to a daunting task! Awesome!

@trendingone7479 5 ай бұрын

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!

@bjornironside8890 9 ай бұрын

Wow, this guy is simply amazing, less confusing and direct to the point

@germaingyesah5724 Жыл бұрын

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

@roberttaylor3594 Жыл бұрын

I am using your videos a lot for a project I am working on.learning a lot about power query; thanks!

@louisivara498 Жыл бұрын

I've been following you for some time now. God bless your good heart sharing quality knowledge. Thanks Chando

@notesfromleisa-land Жыл бұрын

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!

@malcolmcoull1240 Жыл бұрын

Thank you for taking the time to pass on your knowledge to others.

@jonqn07 Жыл бұрын

Thanks for laying out the learning map strategy. Great info, thank you!

@aiasaiascon3894 Жыл бұрын

I am a huge fan and follower you know - that was really fantastic and utmost helpful!

@moisestatis5418 Жыл бұрын

Chandoo thank you so much for sharing your experiences and providing your guidance.

@annoyingprecision2487 Жыл бұрын

That was super insightful and helpful. Thanks a ton Chandoo. Liked and subscribed.

@irenekend 3 ай бұрын

Thanks for sharing. I love the way you've simplified learning

@RobynLynn07 Жыл бұрын

Thanks so much, Chandoo. Many blessings to you!

@kikieandriw Жыл бұрын

agreed you are a SuperHero; thank you for sharing a very well structured roadmap, this is very usefull for all of us

@surajbhardwaj428 Жыл бұрын

I really like your video, whenever I watched I start learning excel again and giving my best...🙏

@nithin51988 Жыл бұрын

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

@venkateshtata3935 Жыл бұрын

Thanks a ton brother you made my day by finding awesome content 🙏🙏

@p.j.882 Жыл бұрын

If you're a mathematician, use of SERIESSUM for polynomials will be a good start...and continue with Taylor Series and Maclaurin series.

@meghanadighe6421 Жыл бұрын

Thanks a lot chandoo sir. Very nicely explained structural way to do

@alio3876 Жыл бұрын

Thank you Chandoo. I have downloaded the guide and will follow it with videos. 👍🏽

@ghostlyverse2722 Жыл бұрын

Love the tips already changed my life

@sarinaht Жыл бұрын

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.

@JH-no8sy Жыл бұрын

This is a good way to put it. I need to learn more excel.

@arbazahmad7177 Жыл бұрын

Really Awesome 👌 road map... Thanks for sharing this....😊

@parshuramnangare8577 Жыл бұрын

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.

@chandoo_ Жыл бұрын

You are most welcome Parashuram. 😍

@kamransiddiqui4506 Жыл бұрын

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

@anishshipping7200 3 ай бұрын

God bless you chandoo.. thanks for making it

@prasathkumar2602 Жыл бұрын

Thank you chandoo for your timely video

@mamalik1088 Жыл бұрын

Super learning/teaching experience shared as usual SIR C

@taizoondean689 Жыл бұрын

Thank You Sir for all your help. God Bless You. Request you to please post videos on DAX

@farooqafzal4443 Жыл бұрын

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.

@AzadAliKhan313 9 ай бұрын

Best utilization of time thank you god bless you

@Edulap Жыл бұрын

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

@chandoo_ Жыл бұрын

Wow.. thanks for that lovely testimonial EC. More power to you ⚡

@altashakhan3349 Жыл бұрын

Can u give me link of the course i want to learn i am a beginner

@suhaimiabdazais Жыл бұрын

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..

@chandoo_ Жыл бұрын

Wow. Congratulations and more power to you Acik 😍

@TstormVA2012 3 ай бұрын

We are currently using Jira at my company. I can relate!!!

@Kwasi1790 Жыл бұрын

Thank you i will follow these steps

@mukhtarabdi824 9 ай бұрын

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.

@chandoo_ 9 ай бұрын

You are welcome Mukhtar for this lovely gesture and appreciation of my work :)

@tiny136 Жыл бұрын

you are realy doing neice chandoo, I am watching most of your video and how to become a data analysics

@behrad9712 Жыл бұрын

Thank you, Chandoo!👌🙏

@shivdhankumar9164 Жыл бұрын

What an amazing video sir!

@lallmanish90 Жыл бұрын

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.

@harsh4800 Жыл бұрын

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! 🤗

@amirdiriye1570 Жыл бұрын

Same Situation bro.

@soweto05 7 ай бұрын

Yeah and me too thanks

@madhavraval238 Жыл бұрын

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

@manavpatel8397 Жыл бұрын

@Chandoo Sir - this was such an informative video. Can you make something similar for someone who is thinking to learn PowerBi from Scratch

@asgharkhan-zf4hf Жыл бұрын

Appropriate your good work Thank you.

@muhammadrooman2138 Жыл бұрын

Very helpful, Thanks

@rajappasubramanian Жыл бұрын

A very good one. Can you make a similar one for python too?

@Vagaboong 7 ай бұрын

If you ever start any excel or powerBI bootcamp, I would be your first student to enroll. Waiting for that day to come❤

@piyalchatterjee2389 Жыл бұрын

You are the best Chandoo mama

@bswill5077 Жыл бұрын

Your way can also be applied in web development or software engineering 😊 thank you

@gokulsumu4677 Жыл бұрын

🙏🏻🔥thank you so much sir 😊

@houssinebenomar2762 7 ай бұрын

Hi I've just discovered your channel and thank you for this shared that's very interested.

@chandoo_ 7 ай бұрын

You are very welcome

@flyingsalmon 2 ай бұрын

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.

@dimlighty Жыл бұрын

Please make a video on "Excel vs Google Sheets".

@vishnusai5726 2 ай бұрын

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

@chandoo_ 2 ай бұрын

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.

@boonyarithdumrongpalasith5501 Жыл бұрын

Thank for sharing its very useful.

@chandoo_ Жыл бұрын

Glad it was helpful!

@jyotisingh6517 Жыл бұрын

Awesome chandoo

@mrinalharsh6200 Жыл бұрын

This was great, can you do something similar for PowerBI?

@WonderGurl 3 ай бұрын

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

@kroyle5328 Жыл бұрын

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.

@vishnuprasad2119 Жыл бұрын

ThankYou Sir ☺️

@DataVisulizations Жыл бұрын

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

@perfectionist6624 Жыл бұрын

This is what I wanted

@AdiRolf Жыл бұрын

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

@notesfromleisa-land Жыл бұрын

You need power query!

@bbqworld2103 Жыл бұрын

Good info thanks

@allaboutrosesandflowers1415 Жыл бұрын

thank you so much

@ramamurtithyagarajan559 Жыл бұрын

sir, Please do a Show on how CHATGPT can be installed in EXCEL and how CHATGPT can be used in EXCEL

@jagatkrishna1543 Жыл бұрын

Thanks 🙏 Sir

@praveenguduru160 Жыл бұрын

great video brother

@girishggirishg1083 8 ай бұрын

super inspiring sir

@user-xe7ev9cv9g Жыл бұрын

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?

@skrejaulhaque Жыл бұрын

Love you chandu bro

@nagarajqs07 Жыл бұрын

Thank you sir

@releveltamilupdates4989 10 ай бұрын

Chandoo sir, I wanna say you something; I really loving you 💋❤, Thanks for your efforts🎉

@chandoo_ 10 ай бұрын

Than you for your love and appreciation. More power to you ⚡

@natureisbest7632 5 ай бұрын

thanks a lot

@user-fz9ng3se4f Жыл бұрын

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.

@cyptowithkelv Жыл бұрын

great video sir do you have a tutorial on how to use excel one combine

@ExcelStore Жыл бұрын

Материал передан понятно, спасибо

@boddanapavankumar1866 Жыл бұрын

Hi sir, I want to learn excel from basic to advanced including data analysis using excel and VBA. Can you please suggest your course.

@Simplicity00007 Жыл бұрын

Great Sir

@sarinaht Жыл бұрын

Thanks!

@chandoo_ Жыл бұрын

You are welcome Sarinaht. Thanks for the super 😍

@shajikp1414 8 ай бұрын

Thanks

@PritamPaul717 7 ай бұрын

👌👍❤️ thanks sir

@Allan_A Жыл бұрын

4-3-3: in fairness you are talking about important tactics 😁👏 ⚽

@andrewdove342 Жыл бұрын

thank you

@paradeshnaidu253 Жыл бұрын

I want telugu video.. Chandooooo Plz do on videos power pivot

@gillallasaishekar174 Жыл бұрын

What are the job opportunities available for freshers after mastering Microsoft Excel & Power BI tool ????

@melvindias1249 Жыл бұрын

Good job

@justwatch564 Жыл бұрын

Chat GPT and excel, expect ur vedios

@Tempo-Turbic-ir2030. 10 ай бұрын

Sir what's the starting salary as a data analyst ( fresh college bachelor graduates ) ?

@divinelyblessed2497 Жыл бұрын

Do you have videos on tableau as well

@akkayyy Жыл бұрын

Hi, what's difference between excel n a data scientist work? How much time it will take to reach from Excel to data science?

@nazarkamal8831 6 ай бұрын

My friend who knows python will Always Says Excel is enough to do all the entire things for Data analysis ❤❤❤

@sadashivkage3133 Жыл бұрын

Tq..sir

@akibul_islam Жыл бұрын

Hey Chandoo, I have a question to you. Is Microsoft excel enough to be a data analyst???

@SayedMNaimKhalid Жыл бұрын

Can you make a video how to get a job as a data analyst as a fresh grad with data analytics certificate?