I cannot express just HOW relevant this video is for me right now. This is the exact topic I had been mulling over for the past few weeks - how to use my Excel (and other related) skills to generate an income. I guess I was more or less aware of the 6 options you discussed, but your video brought more clarity to my thoughts. What I found most valuable were your practical tips and advice on how to get started. Also, speaking about your personal experiences with the various avenues of income brought more authenticity to the video. PS: We're so lucky you chose the teaching option, Chandoo! You are genuinely making a difference in our lives and I'm so glad that that gives you satisfaction and happiness as well. Thank you for all you do! 🌻
Dear Chandoo, I am so happy that my 15yo son followed my advice to study Excel. He watches your tutorials day and night and he is so happy that he can follow along. He can successfully execute power query. We prepared our own data so we can work on it together. We are pretending I am the employer who wants this and that.... cheers to all parents, praise and thanks to Chandoo and family too. More blessings on your way. With love from Philippines.
Get him a Microsoft Power BI Data Analyst Certification. Not a certificate. He needs certifications. With a little python, SQL to boot. He would be set up for a career in Business Analytics, Data Science, etc.
We can see you are putting your heart and soul in creating content like this. Your are surprising us every time. Coming up with most relevant content for people at all levels is not a joke. 🙏🙏🔥🔥🔥💐💐💐
Liked the video ONLY BECAUSE he began the video with the actual steps without wasting anytime. That is what I want. This automatically makes u watch more.
Thankyou so much sir.....i gain so much knowledge here about excel..... because a couples of months back i totally neglect excel skills i though it's outdated but after researching a little bit excel is so important.....n you r the gems of teaching excel
i remember exploring your blog for intresting excel hacks & solution to my problems back in 2007, . really glad to see you uphere . keep the good work up , surely you have teaching in your blood. a blog back then only shows your love & passion for sharing knowledge. a true example of excellence through passion, who do it for a purpose & adds value
love this! better late than never. thank you Chandoo for your tutorials. they are all amazing! some may be a bit hard to understand for newbies like me, but i will get there sooner or later. i pray my son will include excel in his faves too. :)
you are a genuine person. some of the things you have listed, I have started to do. I see some traffic. Thanks for sharing a great content. All the Best !!
I know this guy he is legend in excel ,he and his awesome skills exists from before TH-cam started he has a blog as well i found him in 2008 used to read that as well in year 2008 , hello chandoo from dpak India an old fan
Appreciated your work chandru. I'm just a MIS Analyst as per profession. I'm following each and every video of your which helps me and I guess everyone to improve their skills. You are such a life changer love you chandoo anna😊🎉
Candid and professional as always. Chandoo you are genuinely helping people with fishing technology . Thank you for this valuable information. 1. Can you make a similar video for Business Analysis (Business Systems Analyst and Business Process Analyst) and Project Management skills. 2. And plus, how we can use excel for our business analysis and project management services for clients and creating products for business analysis and project management. Kindly, do consider, it is a humble request.
Great ideas, dankie. I will start with teaching as i have loads of teaching in South Africa and teaching is my passion. Need to find the right vehicle to use.
Make more videos about this topic And make a series how to build a data analyst profile and monetize profile in freelancing palteform like upwork, fiverr and LinkedIn How to get first Clint?
This is an excellent video. I recently started learning data analytics skills. I worked as a developer from 2006 to 2017 in healthcare domain more into clinical data management. After a long career gap I am planning to start my career as data analyst. Your videos are very helpful for me. Can you please let me know is it possible to work as a freelancer after completing the course in data analytics. can people with no idea in financial domain succeed in data analytics job?
Nice video, my five 🌟 are for you. Please sir, can u put down skill data entry job requires. Like all you need to know before saying you are ready to apply for a data entry job
Hi, I’m a beginner in excel especially macros, I wanna write on own but How can I learn to write macros without the help of internet ;) is there anything to start with because there’s lot of resource and lot of confusion to where to begin with! One of my friend just uses some AI or internet to generate whole macros! With this even if I learn macro in the upcoming years can I earn through this because of AI evolution!?
Hi Chandoo, thanks for all the videos...very helpful. Question for you: we have a situation where we have tons of survey feedback on open-ended questions (just open strings, lots of typos, misspellings, incorrect grammar, same name written in many different ways by different responders, etc.) as in 10K+ submissions, each survey with 10 questions (columns). We have the data in Excel but what we need to do is find common themes around some responses (e.g. "What's the most difficult part of your job?") and then rank them. If they were just numbers, it'd be easy, but these are open-ended strings. What tool(s) can I use (that's not expensive or complex to set up...we can't afford a local LLM installation for AI for example) to achieve this? TIA!
You are welcome Salmon... Excel is not the best tool for this. But if I must use it, I will try the below things: 1) Load the data in PQ and clean it. Remove excess spaces, punctuations, lowercase everything and discard unnecessary data (too short, too long or filler words). 2) See if you can use the "text analytics" feature of Power Query. This is a paid feature not available for all Excels. 3) Split responses into words and build a word list table. Substitute easy typos and synonyms. Load up both datasets back to Excel 4) Do a simple word count analysis on each column to see most frequent words to uncover themes. 5) Repeat the same (steps 3 & 4) for ngrams of 2 and 3 words if possible. 6) See if you can use Python in Excel to do some text analysis (you might try this first) 7) Pick 10 or 15 themes you want to evaluate. Assign weights to them and calculate scores for each response. I wrote a blog post about this many years ago (after analyzing 20k comments) here: chandoo.org/wp/analyzing-20000-comments/ Read it for some pointers. There is also a dashboard I made here: chandoo.org/wp/10k-comments-excel-dashboard/ All the best.
Hello sir please reply if u see my msg i work as an intern as a data analyst and i have a google sheet whose only one colomun. Is in jason formate i have to decode that jason formate i have tried all the things but i have failed to do so please give me any solution what should i do to decode one colomun of my jason data of my google sheet.
Sorry Anju. I have no interest in making such a course. I suggest following the guidance shared in this video and using your intuition and skills to build the business.
I cannot express just HOW relevant this video is for me right now. This is the exact topic I had been mulling over for the past few weeks - how to use my Excel (and other related) skills to generate an income. I guess I was more or less aware of the 6 options you discussed, but your video brought more clarity to my thoughts. What I found most valuable were your practical tips and advice on how to get started. Also, speaking about your personal experiences with the various avenues of income brought more authenticity to the video.
PS: We're so lucky you chose the teaching option, Chandoo! You are genuinely making a difference in our lives and I'm so glad that that gives you satisfaction and happiness as well. Thank you for all you do! 🌻
Thanks SC. I wish you all the best in your journey.
PS: Since my childhood days, I enjoyed teaching. I am so glad I could do this full-time now.
@@chandoo_ But Sir You are God Gifted to Nation . Like GANESH and Maa Saraswati
Dear Chandoo, I am so happy that my 15yo son followed my advice to study Excel. He watches your tutorials day and night and he is so happy that he can follow along. He can successfully execute power query. We prepared our own data so we can work on it together. We are pretending I am the employer who wants this and that.... cheers to all parents, praise and thanks to Chandoo and family too. More blessings on your way. With love from Philippines.
That is awesome to hear that. More power to your son :)
Wow sana all po
Get him a Microsoft Power BI Data Analyst Certification. Not a certificate. He needs certifications.
With a little python, SQL to boot. He would be set up for a career in Business Analytics, Data Science, etc.
@@FutureJacket thank you for your advice. maybe next year i can be able to enroll him to one of the online courses of Microsoft.
The fact that he got right to the point earned an upvote!
Agreed!!
We can see you are putting your heart and soul in creating content like this. Your are surprising us every time. Coming up with most relevant content for people at all levels is not a joke. 🙏🙏🔥🔥🔥💐💐💐
This is excellent Chandoo, thanks. I'm using my data analytics skills in my career 2.0 and loving it!
Fantastic Chris :)
I have been following you for more than 10 years, since you were a freelance in India.
Thanks for being with me all this while RAB :)
Kudos to you for groundbreaking work. Everybody is willing to teach excel but few like you can detail how to sell the skills.
Liked the video ONLY BECAUSE he began the video with the actual steps without wasting anytime. That is what I want. This automatically makes u watch more.
Thankyou so much sir.....i gain so much knowledge here about excel..... because a couples of months back i totally neglect excel skills i though it's outdated but after researching a little bit excel is so important.....n you r the gems of teaching excel
You changed the view to learn excel & be awesome in it. Love you ❤
Thank you Manan. Love you too :)
i remember exploring your blog for intresting excel hacks & solution to my problems back in 2007, . really glad to see you uphere . keep the good work up , surely you have teaching in your blood. a blog back then only shows your love & passion for sharing knowledge. a true example of excellence through passion, who do it for a purpose & adds value
love this! better late than never. thank you Chandoo for your tutorials. they are all amazing! some may be a bit hard to understand for newbies like me, but i will get there sooner or later. i pray my son will include excel in his faves too. :)
you are a genuine person. some of the things you have listed, I have started to do. I see some traffic. Thanks for sharing a great content. All the Best !!
The way you listed 6ways at the starting Is soo ❤
Chandoo; my favourite excel data skill source!
I know this guy he is legend in excel ,he and his awesome skills exists from before TH-cam started he has a blog as well i found him in 2008 used to read that as well in year 2008 , hello chandoo from dpak India an old fan
Thanks Deepak for being with me all this while 😍
Appreciated your work chandru. I'm just a MIS Analyst as per profession. I'm following each and every video of your which helps me and I guess everyone to improve their skills. You are such a life changer love you chandoo anna😊🎉
His name is Chandoo, not chandRu ! :-)))
@@romulusmilea2747 I'm so sorry,my sincere apologies @chandoo anna.
Thanks Chandoo, you motivate me to learn Excel deeply then make a website
Candid and professional as always. Chandoo you are genuinely helping people with fishing technology . Thank you for this valuable information.
1. Can you make a similar video for Business Analysis (Business Systems Analyst and Business Process Analyst) and Project Management skills.
2. And plus, how we can use excel for our business analysis and project management services for clients and creating products for business analysis and project management.
Kindly, do consider, it is a humble request.
Very interesting income generating ideas and educational information
Really knowledgeable points and advices discussed here. Thank you 😊
Thank you so much, Mr. Chandol! You're just an incredible soul, and I sincerely appreciate it.
Thank you so much Chandoo for your guidance.
Excellent video! Straight to the point. Also, sweet t-shirt, where is that from?!
Excellent 20 mins video! You got a new subscriber.
Thanks Chandoo. I hope I can start my own journey with your videos.
Thank you so much. I have been thinking about this for a while
Great ideas, dankie. I will start with teaching as i have loads of teaching in South Africa and teaching is my passion. Need to find the right vehicle to use.
Thanks for sharing your journey.
Its high time for me to start my teaching journey and develop on working a website.
Thanks Sir, we all Love You
❤
Make more videos about this topic
And make a series how to build a data analyst profile and monetize profile in freelancing palteform like upwork, fiverr and LinkedIn
How to get first Clint?
God Bless you Chandoo
Amazing trick thanks for the vedio please create more like this. Thanks in advance.
I appreciate your advice. Thank you.
You are really awesome chandoo $ir...
Really a inspiration for all excelites ...
This is an excellent video. I recently started learning data analytics skills. I worked as a developer from 2006 to 2017 in healthcare domain more into clinical data management. After a long career gap I am planning to start my career as data analyst. Your videos are very helpful for me. Can you please let me know is it possible to work as a freelancer after completing the course in data analytics. can people with no idea in financial domain succeed in data analytics job?
Thank You Brother.. I started my journey from now on.
Excellent video. Thank you for the advice.
🎉Thankyou man. I learn alot from you. And motivate me to become freelancer excel and move to NZ
Thank you very much. This information is really interesting and engaging
Thank you sir for sharing ideas ......you are great person
Wow! that was rich and inspiring. Thanks for sharing all these things. God bless you even more.
Glad you enjoyed it! More power to you Gospel ⚡
As far as Data Entry jobs are concerned, I see people on Fiverr willing to work for $1 per hour. Mostly from countries such as Pakistan or Haiti.
excellent video. but 2:26 monitor just cracked me up
love your video bro thanks alot for all the knowledge
So nice of you
Being a captian on Merchant ship and handling fleet of crew your knowldge helps me alot.@@chandoo_
Was thinking of the same yesterday, what if i take your course would it land me anywhere 😅
Thank you. This was very informative.
I don't know anything about the computer itself and I want to learn these skills, how I need to start and get into a job
Nice video, my five 🌟 are for you. Please sir, can u put down skill data entry job requires. Like all you need to know before saying you are ready to apply for a data entry job
Wow. It is really awesome. Thank you for giving such good tips for earning money through Excel skills.
Excellent ideas
Awesome video! Thank you!
Excellent suggestions, thank you
Fish curry. I love it!
finished watching
@chandoo you are great 🎉🎉
Thank you very much!🙏
Very useful points. I have one doubt, how can we sell our excel product? Which are the platforms for selling?
Awesome bro 👌
Your video is amazing good job ! I wanted to ask you if i sell my google sheet project how can i make it to impossible to coppy and re sell it ?
Hi Chandoo
Thank you for your valuable video..
Can you point out some platforms where we showcase or sell our products as explained in pt no 4
Thanks for the information
Sir can you please suggest any channel of data science
I'm an Excel Expert and need to find Ways to Make Money with my Excel Skills.
Thank you so much!
A teacher teaches, but himself. Long back I heard this
finished watchng
Hi Chandoo, how were you able to grow your channel? Any tips for a fellow TH-camr?
"Teach them how to swim. They became the fish"
-- Another Fishy Man --
Can i talk about how you moved to NZ?
Sir please tell me , I have some knowledge skill of excel and I increase my skill day by day, can I earn by excel as a freelanccer at that stage.
I want to learn power bi. Can you please post your online course details please.
Do you do tutoring/coaching? Once a week?
The wedding planner project sounds interesting..... could u share the project to study from it ?
It is no longer offered for sale. But you can review the sample (locked files) here - chandoo.org/wp/excel-wedding-planner-template/
@@chandoo_ thnks..tht will surely help
thanks you!
Hi, I’m a beginner in excel especially macros, I wanna write on own but How can I learn to write macros without the help of internet ;) is there anything to start with because there’s lot of resource and lot of confusion to where to begin with! One of my friend just uses some AI or internet to generate whole macros! With this even if I learn macro in the upcoming years can I earn through this because of AI evolution!?
Hi sir...how can I learn the complete excel
I am from india
Bro thanks 🙏
Hi Chandoo, thanks for all the videos...very helpful. Question for you: we have a situation where we have tons of survey feedback on open-ended questions (just open strings, lots of typos, misspellings, incorrect grammar, same name written in many different ways by different responders, etc.) as in 10K+ submissions, each survey with 10 questions (columns). We have the data in Excel but what we need to do is find common themes around some responses (e.g. "What's the most difficult part of your job?") and then rank them. If they were just numbers, it'd be easy, but these are open-ended strings. What tool(s) can I use (that's not expensive or complex to set up...we can't afford a local LLM installation for AI for example) to achieve this? TIA!
You are welcome Salmon...
Excel is not the best tool for this. But if I must use it, I will try the below things:
1) Load the data in PQ and clean it. Remove excess spaces, punctuations, lowercase everything and discard unnecessary data (too short, too long or filler words).
2) See if you can use the "text analytics" feature of Power Query. This is a paid feature not available for all Excels.
3) Split responses into words and build a word list table. Substitute easy typos and synonyms. Load up both datasets back to Excel
4) Do a simple word count analysis on each column to see most frequent words to uncover themes.
5) Repeat the same (steps 3 & 4) for ngrams of 2 and 3 words if possible.
6) See if you can use Python in Excel to do some text analysis (you might try this first)
7) Pick 10 or 15 themes you want to evaluate. Assign weights to them and calculate scores for each response.
I wrote a blog post about this many years ago (after analyzing 20k comments) here: chandoo.org/wp/analyzing-20000-comments/
Read it for some pointers.
There is also a dashboard I made here: chandoo.org/wp/10k-comments-excel-dashboard/
All the best.
@@chandoo_ These are great ideas, thanks for the tips (some of them I've already done; the rest I need to tweak more). I'll check out your blog. Best!
Thanks 🙏🙏
Chandoo mera Bandoo ❤🤗
@chandoo You're awesome
Sounds Good.
#3 ...where and how to sell the Excel product??
Love it. Thank you🎉😊
Thank you for the great video Chandoo. What platforms do you recommend to sell Excel products?
Thanks 🙏❤
Hello sir please reply if u see my msg i work as an intern as a data analyst and i have a google sheet whose only one colomun. Is in jason formate i have to decode that jason formate i have tried all the things but i have failed to do so please give me any solution what should i do to decode one colomun of my jason data of my google sheet.
What certificate can land eastern people a job in data analytics? Thanks a lot!!!
Do you have a course freelancing with excel
Do you provide this course online sir
Where else, i can di d these freelancing, i couldnt find much in feverr and upwork, not getting any recently i registered. Pls
From india,is it possible to do freelancing work?
hi buddy.
how much youtube pays for excel teaching channels ?
I want SUMIF formula with SUBTOTAL CONDITION if available please provide help video
Anna.....
Excel lo emaina data entry untee cheppu anna plz
great
please provide course on how to earn through excel
Sorry Anju. I have no interest in making such a course. I suggest following the guidance shared in this video and using your intuition and skills to build the business.
How did you become a pro ??
Sir i am bcom student i learn python and excel and mysql database what is my next level