Sir there is a minor mistake in dashboard while you're formatting the Unit Value you forget to remove the ₹ symbol because unit value can't be in rupees and thank you very much for enhancing our excel knowledge with these amazing videos ❤
Hello sir I also want to start freelancing i know everything in excel Please make a video on how to set up ”FIVER , UPWORK or FREELANCER PROFILE? Please sir i need your assistance in this Thank you
I work on these stuffs but on a ready made tool instead of Excel. Lokesh bhai, you are awesome and very kind to share such things in details. I hope this will help lot of youngsters of our country in gaining skills. Keep up the good work!
hi, I am from Bangladesh. It would be good to see how you did the workings before dashboard making or if you cover any of your videos to know about the workings it would be good to give the link.
I'm waiting to learn something new, I have already learnt a lot from Mr. Lokesh. thank you so much to provide us such amazing knowledgeable content, Thanks again Mr Lokesh.
Well i have learned data analytics and i didn't know i can do freelancing with it too.... though the earnings you've showed are for a very very experienced person but still.....
Sir, we really respect your skills & knowledge But please takedown that part of the video The map you used is irrelevant & doesn't make sense. Proud to be an Indian 🇮🇳 Jai Hind Jai Bharat
Sir, the dashboard that you have created is a dynamic one or static dashboard. It will be really helpful if you introduce a dashboard chapter in the Excel Advance Masterclass course.
hello sir your videos are very good please make video on how to submit dashboard project to clients, love from Hyderabad thanks your videos taught me good knowledge
Very good video. I tried to make it. Funnel chart and map chart option not available :( Further selection in doughnut chart seems difficult. otherwise baaki sab hogyaa. thanks
Sir plz provide video of all the procedure of Earning second salary like how to earn and How to connect with client and How to work and how to take payment from client.
Sir aapki video bhot achi hai pr jo india ka map aapne use kiya hai wo complete nhi hai usme kuch hissa dikhaya hi nhi hai jese ladakh or arunachal pardesh plz esa map use my karo ❤❤❤❤
Yes, you are right Sir, we really respect your skills & knowledge But please takedown that part of the video The map you used is irrelevant & doesn't make sense. Proud to be an Indian 🇮🇳 Jai Hind Jai Bharat
Thanks, Sir for this amazing video. I can create the sales table in the Final Working sheet but the KPIs how can I create these? Could you please tell me it will be helpful for me?
Thank you so much for your kind words! I'm really glad to hear that you've found our sessions helpful and that you've learned a lot in Excel. Your dedication and eagerness to learn are truly inspiring. If you have any more questions or need further assistance, feel free to reach out. Keep up the great work!
Sir firstly aapne TH-cam channel create ker ke 11lakh subscriber ker liye aapki money income waise hi jada hogi so make a vidio on how to be a youtuber in our present generation...
I understand your concerns about getting customers to notice your gig. Creating a gig and making it public is just the first step; impressing potential customers requires a bit more strategy. I'll be creating a detailed video covering the entire process from gig creation to making it public, along with tips on how to attract and impress customers. Stay tuned for that! In the meantime, here are a few quick tips to get you started: Profile Optimization: Make sure your profile is complete and professional. A good profile picture, a clear and concise bio, and showcasing your skills can make a huge difference. Gig Description: Write a compelling gig description. Clearly state what you offer, how it benefits the customer, and why they should choose you over others. Keywords and Tags: Use relevant keywords and tags to make your gig easily discoverable. Think about what your potential customers might search for. Portfolio and Samples: Include examples of your past work. If you don't have any, consider creating some samples to showcase your skills. Competitive Pricing: Start with competitive pricing to attract your first few customers. You can always increase your rates once you have some reviews. Customer Communication: Be responsive and professional in your communications. This builds trust and can lead to positive reviews. I'll dive deeper into these points and more in the upcoming video. Keep an eye out for it!
There are already many videos. But still for the complete road-map to earn Second salary, do join my free masterclass. Here is the link : - event.webinarjam.com/register/13/m4851s2
I am very motivated myself but do not want to do job on fever or any other platform. If you want a job for a permanent company then what kind of preparation should you do for MIS EXECUTIVE?..❤❤ pls reply Sir 🙏
Hlo lokesh sir apne starting m jesa kaha ki row data hame samne mil company kr through mill jata h but jesa apne kaha ki KPI,s agr hame samne client se provide nhi hota h to use kese creat kre
Sir my name is priyash rathaur and I'm 20 year old i want to become data analyst my question is mene tier3 college se btech ke bjaye ............. mene(((((( bsc data analyst and computer science kr raha hu vo bhi IIT PATNA)))))) is it worth it
Thank you so much for your kind words about the Excel formula webinar! I'm thrilled to hear that you found it valuable. To earn a second salary using your Excel skills, freelancing can be a great option. Here are a few steps to get started: Identify Your Skills: Besides Excel formulas, think about other related skills you might have, such as data cleaning, data merging, data validation, creating Power BI dashboards, PDF to Excel conversion, sorting, and filtering. Create a Portfolio: Showcase your skills by creating sample projects or sharing previous work. This will help potential clients understand what you can offer. Join Freelance Platforms: Sign up on platforms like Upwork, Freelancer, Fiverr, or even LinkedIn. These platforms have numerous job listings where clients seek help with Excel and data-related tasks. Start Small: Initially, you might have to take on smaller projects to build your reputation. As you gain experience and positive reviews, you can start bidding on higher-paying jobs. Network: Join Excel and data-related forums and groups on social media. Engage with the community, share your expertise, and you might find opportunities coming your way. Continuous Learning: Stay updated with the latest trends and tools related to Excel and data analysis. The more you know, the more valuable you become to potential clients. Feel free to reach out if you have any specific questions or need further guidance. Good luck on your journey to earning that second salary!
FREE Live Masterclass. Register Now. 🔥🔥
event.webinarjam.com/register/13/m4851s2
Sir kindly working data create karna bhi sikha do🥲
Yes sir working shika do
Working data kaise create Krna hota hai....?
Last ma text ko kese link kiya sir 24:50
Finally! A dashboard creation video from my favorite Excel guru. Thanks for this!
Hope this video helped you :)
Bhagwan ko yani maa bap pahla selry
Your Excel tutorials have been a game-changer for me. I've increased my productivity tenfold. Thanks for sharing your knowledge!
Great to hear! Thank you so much.
Nice
How much have you earned by excel?
i want to give it to my mother for her cancer treatment
You always know what your audience needs. Thank you for this valuable content!
Thanks for your amazing comment :) Wish you happy second salary :)
Sir there is a minor mistake in dashboard while you're formatting the Unit Value you forget to remove the ₹ symbol because unit value can't be in rupees and thank you very much for enhancing our excel knowledge with these amazing videos ❤
Hello sir
I also want to start freelancing i know everything in excel
Please make a video on how to set up ”FIVER , UPWORK or FREELANCER PROFILE?
Please sir i need your assistance in this
Thank you
EXCEL BEGINNING TO ADVANCE FREE COURSE START KARO SIR
Join my free webinar. Link given in the description.
@@learnwithlokeshlalwanisir a course to paid ha.
@@bablughosh1322bhai khuch pay to krna padta hai value add krne ke liye free me khuch nhi milta my brother 😊
@@bablughosh1322 Yeh masterclass free hai, aapko bohot kuch seekhne ko milega freelacning ke baare main. All the best :)
How much the course cost ?@@bablughosh1322
I work on these stuffs but on a ready made tool instead of Excel. Lokesh bhai, you are awesome and very kind to share such things in details. I hope this will help lot of youngsters of our country in gaining skills. Keep up the good work!
What Tools
@@mayurkumar1277 Power BI
hi, I am from Bangladesh. It would be good to see how you did the workings before dashboard making or if you cover any of your videos to know about the workings it would be good to give the link.
This is what I was waiting for 🙆🏻♂️🤷♂️🤷♂️
Please make more videos on dashboard creation 🙏
Sure. keep watching.
So excited to see this! Your Excel tips have helped me so much in my job.
I am glad that my content is helping you :)
I'm waiting to learn something new, I have already learnt a lot from Mr. Lokesh.
thank you so much to provide us such amazing knowledgeable content, Thanks again Mr Lokesh.
Thank you so much for your comment.
You are helpping all the youth bread & Butter basic
Hello please start beginning to advance level excel learning series
I will definitely meet my mother, kids, and younger brother needs.
Well i have learned data analytics and i didn't know i can do freelancing with it too.... though the earnings you've showed are for a very very experienced person but still.....
Sir, we really respect your skills & knowledge
But please takedown that part of the video
The map you used is irrelevant & doesn't make sense.
Proud to be an Indian 🇮🇳
Jai Hind Jai Bharat
"Great tutorial! The step-by-step instructions were easy to follow, and the final dashboard looks impressive. I'm excited to try creating my own!"
Glad it was helpful!
Which version of excel are you using Sir
I've been struggling with dashboards for a while. This is going to be a game changer!
I am sure that this piece of content will enhance your knowledge regarding Dashboard :)
Really nice demonstration!! Thanks for the beautiful content!! Much appreciated.
Glad to hear it!
Lalwani G, many many thanks for such a nice lecture. I learned a lot from this video lecture
Thank you so much for your comment!
Wow it was so appealing and explained so easily
Great Teaching Sir, Thank u
Great work. Explained in a very simplified way.
like the way you remind things softly
Awesome Dashboard guide...... I am new for this channel. Is there any video for how to make working tables from data files?
very very helpfull video please sir recomend video for complete ms learning as a bigginer
Sir, the dashboard that you have created is a dynamic one or static dashboard. It will be really helpful if you introduce a dashboard chapter in the Excel Advance Masterclass course.
The Dashboard is basic Static. We will come up with a dynamic dashboard video very soon. Also thank you for your suggestion. Will surely look into it.
Sir m student hun ho .. or self depend banan chata hun apna kharcha khud uthna chata hun exel seekh ke .😊
Glad to hear it.
hello sir your videos are very good please make video on how to submit dashboard project to clients, love from Hyderabad thanks your videos taught me good knowledge
Thank you so much for your comment. Will make a video soon.
Very nice video.
Sir...Final worksheet apne banaye kayese? Iske liye pivot table banana padega kya? Pls reply.
Yes, The final worksheet can be created by, Pivot table and Conditional functions.
@@learnwithlokeshlalwani And d "Target" components and d KPIs?
PowerBi is Best Ever than Excel...now nobody talks of excel dashboard, by the way good for beginners 😊
Great Job and Keep going..Love from Hyderabad India
Thank you so much for your comment.
Amazing Video Sir , Appreciated your Efforts 🙏🙏
It's my pleasure
Very good video. I tried to make it. Funnel chart and map chart option not available :( Further selection in doughnut chart seems difficult. otherwise baaki sab hogyaa. thanks
This is really amazing I watched it with full concentrate inshallah when I practice it I will comeback to see next videos
Sure, Thank you so much for your comment.
Your Videos are worthy. I wait for your Videos.
Sir, can you tell me how we got the Data for KPIS in this Video.
Sir plz provide video of all the procedure of Earning second salary like how to earn and How to connect with client and How to work and how to take payment from client.
join my free webinar. Here all your doubts will be cleared. Link given in the description and first comment.
@@learnwithlokeshlalwani okay sir
Sir from where do we get similar kinds of logos for other projects ?
I like so much. I have no words what i am writing Further
Thank you so much for your comment!
Nice sir ... Kya ap school ke result ke liye dashboard bana sakte ho please??
Sir excel ka kaun sa version use karna hei because muje charts ke liye options nahi mil raha.. im using ms excel 2010
Data ka working kaise karnge ispe ek full video bnaeye kpi's kaise banana hai...?
Sir aapki video bhot achi hai pr jo india ka map aapne use kiya hai wo complete nhi hai usme kuch hissa dikhaya hi nhi hai jese ladakh or arunachal pardesh plz esa map use my karo ❤❤❤❤
I liked your video very much, its too good and motivating as well.
Thanks a lot
Sir...how do we make final working from data .... I don't have any knowledge about it...can you please make video on it...please ❤
your video is very good sir. But how to get work from fiverr
Good afternoon sir I am from Pakistan I am. Jobless i had worked as a computer accounts aprox 25 years
Sir KPI's kaise nikale uske bare ma bhi video banaye.. Huge data ko short list kaise kare??..
Sure, will make a video in future.
Well-explained but needs to tell some more functions ,that are still hidden
Sir final working sheet ksa ready kiya aapn ne please ek baar usko bhi bata do 🙏
Bohot mehennat ki apne
hi, sir can you make a detailed course on excel for those how are binger's to start their excel journey. thanks
Join my free webinar. here all your doubts will be cleared. Here is the link to register and join: event.webinarjam.com/register/13/m4851s2
THANK YOU SIR..... BUT SIR I HAVE A DOUBT- SIR Kpi's kaise find krte h?
God tussi great ho awesome 👍👍 Jai hind sir Deepak Lucknow
Sir Apna kPI create kaisa kari video banaho please
thanku Sir maine sara kuch last tak done kr diya but last mein no. of sales , units and cities mein format painter nahi laga mujhse
Indian map used in this video is wrong please correct them or remove that part of video
Proud to be an Indian
Yes, you are right
Sir, we really respect your skills & knowledge
But please takedown that part of the video
The map you used is irrelevant & doesn't make sense.
Proud to be an Indian 🇮🇳
Jai Hind Jai Bharat
Sir! You are a great mentor!
Thank you so much.
SIR KINDLY MADE A VIDEO ON HOW TO CREATE A "KPIS " THAT USED IN THIS VIDEO
very informative video sir thanks
Thanks for liking
Thanks, Sir for this amazing video. I can create the sales table in the Final Working sheet but the KPIs how can I create these? Could you please tell me it will be helpful for me?
You can create with Pivot table and Conditional functions.
Why slicers aren't working for this dashboard
thank u so.........much sir, i really appreciate you, you are so hardworking man, and i learnt a lot of things in excel with you.
Thank you so much for your kind words! I'm really glad to hear that you've found our sessions helpful and that you've learned a lot in Excel. Your dedication and eagerness to learn are truly inspiring. If you have any more questions or need further assistance, feel free to reach out. Keep up the great work!
Sir firstly aapne TH-cam channel create ker ke 11lakh subscriber ker liye aapki money income waise hi jada hogi so make a vidio on how to be a youtuber in our present generation...
GIG create se lekar GIG public tk and customer ko kaise impress kare iska full video banao sir mere gig me to abhi tk ek bhi customer Nazar nahi aaya
I understand your concerns about getting customers to notice your gig. Creating a gig and making it public is just the first step; impressing potential customers requires a bit more strategy. I'll be creating a detailed video covering the entire process from gig creation to making it public, along with tips on how to attract and impress customers. Stay tuned for that!
In the meantime, here are a few quick tips to get you started:
Profile Optimization: Make sure your profile is complete and professional. A good profile picture, a clear and concise bio, and showcasing your skills can make a huge difference.
Gig Description: Write a compelling gig description. Clearly state what you offer, how it benefits the customer, and why they should choose you over others.
Keywords and Tags: Use relevant keywords and tags to make your gig easily discoverable. Think about what your potential customers might search for.
Portfolio and Samples: Include examples of your past work. If you don't have any, consider creating some samples to showcase your skills.
Competitive Pricing: Start with competitive pricing to attract your first few customers. You can always increase your rates once you have some reviews.
Customer Communication: Be responsive and professional in your communications. This builds trust and can lead to positive reviews.
I'll dive deeper into these points and more in the upcoming video. Keep an eye out for it!
Bro can you please make a complete tutorial video of earning money please
There are already many videos. But still for the complete road-map to earn Second salary, do join my free masterclass. Here is the link : - event.webinarjam.com/register/13/m4851s2
We are waiting for this video 📷
👍
Your are great guy to provide best knowledge, thanks you
Please make on videos that completely methalogy of fivrr online market place
Sir aap ms-office ka kaun version use kar rhe hai...?
❤Great efforts❤
Really appreciate you,
Can we know the version of Excel please ???
Thank you so much for your comment. Excel version is (Office 365)
Dear Sir, please advise how to make kpis
I am very motivated myself but do not want to do job on fever or any other platform. If you want a job for a permanent company then what kind of preparation should you do for MIS EXECUTIVE?..❤❤ pls reply Sir 🙏
Hello Sir, I am from Pakistan and a big fan of your, can i join your webinar please?
Sir yeh dashboard excel p hi banana necessary h kya because power bi p more easier way me ban jata
Make it interactive without which it's not called dashboard. It just visual representation.
Please don't call it Dashboard. Anyway Nice work
Power bi use karle Bhai woh better rahega
Sir, can you please a video on how to make the working page by using the data?
Sure, will make a video in future.
I will also give it to my parents.
Sir power BI se bhi bna sakte hai na ❤
how to make the workings ....in what basis
I'll enroll for courses prepared by you Sir
Hlo lokesh sir apne starting m jesa kaha ki row data hame samne mil company kr through mill jata h but jesa apne kaha ki KPI,s agr hame samne client se provide nhi hota h to use kese creat kre
Sir my name is priyash rathaur and I'm 20 year old i want to become data analyst my question is mene tier3 college se btech ke bjaye ............. mene(((((( bsc data analyst and computer science kr raha hu vo bhi IIT PATNA)))))) is it worth it
awesome,,,,,, these contents are free,, hats off
Thank you so much for your comment!
My Logos are not getting selected on pressing ctrl+A
And alsopage layout me groupingnahi aa raha.
What to do?
Love From Bangladesh ❤️🇧🇩
Great! Very simple way to make it
Thanks
Thank you so much for your comment.
How to find work on various platforms....and how do you find this types of works..???
Sir aapke konsi excel version use krte ho
Thanks sir very informative ❤
Your excel formula webinar is really a game changer for me but I want a second salary, how? and where will I get work, please guide me.
Thank you so much for your kind words about the Excel formula webinar! I'm thrilled to hear that you found it valuable.
To earn a second salary using your Excel skills, freelancing can be a great option. Here are a few steps to get started:
Identify Your Skills: Besides Excel formulas, think about other related skills you might have, such as data cleaning, data merging, data validation, creating Power BI dashboards, PDF to Excel conversion, sorting, and filtering.
Create a Portfolio: Showcase your skills by creating sample projects or sharing previous work. This will help potential clients understand what you can offer.
Join Freelance Platforms: Sign up on platforms like Upwork, Freelancer, Fiverr, or even LinkedIn. These platforms have numerous job listings where clients seek help with Excel and data-related tasks.
Start Small: Initially, you might have to take on smaller projects to build your reputation. As you gain experience and positive reviews, you can start bidding on higher-paying jobs.
Network: Join Excel and data-related forums and groups on social media. Engage with the community, share your expertise, and you might find opportunities coming your way.
Continuous Learning: Stay updated with the latest trends and tools related to Excel and data analysis. The more you know, the more valuable you become to potential clients.
Feel free to reach out if you have any specific questions or need further guidance. Good luck on your journey to earning that second salary!
Hello sir
I'm Amiya from odisha
i explor your excel course
how to acces this course please tell me
Sir can we make the dashboards in all these websites on powerbi rather than excel?
In dashboard, u removed the product names in funnel chart . So how will users understand sales are for each product
Sir Excel ka poora course krwa skte h aap?
guru ji love from saudi arabia
Thank you so much for your comment.
Sir plz make a video on how to create profile on websites like feverr, upwork and freelancer ...we need a complete tutorial plz
Sure, Will make a video in future.
Hello Sir
Main salary collect kar k, apne family members ko flight se Shirdi le kar jungi😊
Arey wah. Such a nice thought !
How to apply
i got E-book after take masterclass