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

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:
===============================

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

If you don't want to enrol in a course, but just want to use YouTube to learn, check out these videos:

~

Happy Learning 😀🌼🌞

#dataanalytics #advancedexcel

[ravi]

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

[selvarajsuppan]

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

[txreal]

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.

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

[parshuramnangare]

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.

[trendingone]

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!

[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

[mukhtarabdi]

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.

[germaingyesah]

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

[harsh]

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

[lallmanish]

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.

[Shiva-klwp]

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.

[p.j.]

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

[vishnusai]

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

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

[nithin]

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

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

[bjornironside]

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

[kikieandriw]

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

[aiasaiascon]

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