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

Подписаться 618 тыс.

Просмотров 242 тыс.

50% 1

💥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 RU-vid 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

Наука

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 183

@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 21 день назад

@@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 21 день назад

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

@txreal2 23 дня назад

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.

@Locomaid Год назад

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

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

@trendingone7479 6 месяцев назад

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!

@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

@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

@bjornironside8890 10 месяцев назад

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

@roberttaylor3594 Год назад

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

@Shiva-kl2wp 6 дней назад

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.

@chandoo_ 6 дней назад

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

@malcolmcoull1240 Год назад

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

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

@jonqn07 Год назад

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

@irenekend 3 месяца назад

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

@RobynLynn07 Год назад

Thanks so much, Chandoo. Many blessings to you!

@louisivara498 Год назад

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

@nithin51988 Год назад

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

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

@annoyingprecision2487 Год назад

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

@kikieandriw Год назад

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

@ghostlyverse2722 Год назад

Love the tips already changed my life

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

@venkateshtata3935 Год назад

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

@surajbhardwaj428 Год назад

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

@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

@prasathkumar2602 Год назад

Thank you chandoo for your timely video

@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. 👍🏽

@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 😍

@anishshipping7200 4 месяца назад

God bless you chandoo.. thanks for making it

@shivdhankumar9164 Год назад

What an amazing video sir!

@mamalik1088 Год назад

Super learning/teaching experience shared as usual SIR C

@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

@AzadAliKhan313 9 месяцев назад

Best utilization of time thank you god bless you

@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 :)

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

@arbazahmad7177 Год назад

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

@taizoondean689 Год назад

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

@behrad9712 Год назад

Thank you, Chandoo!👌🙏

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

@Kwasi1790 Год назад

Thank you i will follow these steps

@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 8 месяцев назад

Yeah and me too thanks

@piyalchatterjee2389 Год назад

You are the best Chandoo mama

@tiny136 Год назад

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

@muhammadrooman2138 Год назад

Very helpful, Thanks

@TstormVA2012 4 месяца назад

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

@rajappasubramanian Год назад

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

@asgharkhan-zf4hf Год назад

Appropriate your good work Thank you.

@manavpatel8397 Год назад

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

@jyotisingh6517 Год назад

Awesome chandoo

@gokulsumu4677 Год назад

🙏🏻🔥thank you so much sir 😊

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

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

@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

@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

@vishnuprasad2119 Год назад

ThankYou Sir ☺️

@bswill5077 Год назад

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

@perfectionist6624 Год назад

This is what I wanted

@dimlighty Год назад

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

@Vagaboong 8 месяцев назад

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

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

@jagatkrishna1543 Год назад

Thanks 🙏 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

@bbqworld2103 Год назад

Good info thanks

@ExcelStore Год назад

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

@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

@allaboutrosesandflowers1415 Год назад

thank you so much

@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?

@Simplicity00007 Год назад

Great Sir

@boonyarithdumrongpalasith5501 Год назад

Thank for sharing its very useful.

@chandoo_ Год назад

Glad it was helpful!

@girishggirishg1083 8 месяцев назад

super inspiring sir

@skrejaulhaque Год назад

Love you chandu bro

@praveenguduru160 Год назад

great video brother

@mrinalharsh6200 Год назад

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

@ramamurtithyagarajan559 Год назад

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

@natureisbest7632 5 месяцев назад

thanks a lot

@nagarajqs07 Год назад

Thank you sir

@sarinaht Год назад

Thanks!

@chandoo_ Год назад

You are welcome Sarinaht. Thanks for the super 😍

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

@shajikp1414 9 месяцев назад

Thanks

@PritamPaul717 8 месяцев назад

👌👍❤️ thanks sir

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

@andrewdove342 Год назад

thank you

@melvindias1249 Год назад

Good job

@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 ⚡

@cyptowithkelv Год назад

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

@Allan_A Год назад

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

@sadashivkage3133 Год назад

Tq..sir

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