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 ❤
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!
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'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.
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.
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
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 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.
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
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
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!
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!
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 ❤❤❤❤
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.
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!
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 🙏
Sir firstly aapne UA-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...
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 practice to kat liya bina cheating new dashboard bhi bana leya . Problem to suru ab ho gaya sir ab save kis me karlu ? Client ko kese bhej sakte he kis format me save karna hota he
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 mera map ma world ka map show ho raha hai, India ka nahi... How to fix it? And also make a video where the company has only send the sales data, and we have to make the final workings..
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?
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?
You always know what your audience needs. Thank you for this valuable content!
Thanks for your amazing comment :) Wish you happy second salary :)
i want to give it to my mother for her cancer treatment
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 ❤
Thanks for your Efforts.
Grand Salute to you.
This is what I was waiting for 🙆🏻♂️🤷♂️🤷♂️
Please make more videos on dashboard creation 🙏
Sure. keep watching.
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
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
"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!
You are helpping all the youth bread & Butter basic
Really nice demonstration!! Thanks for the beautiful content!! Much appreciated.
Glad to hear it!
Great Job and Keep going..Love from Hyderabad India
Thank you so much for your comment.
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'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 :)
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.
Wow it was so appealing and explained so easily
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.
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!
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.
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.....
Hello please start beginning to advance level excel learning series
I will definitely meet my mother, kids, and younger brother needs.
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.
Awesome Dashboard guide...... I am new for this channel. Is there any video for how to make working tables from data files?
Great work. Explained in a very simplified way.
Amazing Video Sir , Appreciated your Efforts 🙏🙏
It's my pleasure
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?
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
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
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
Great Teaching Sir, Thank u
I like so much. I have no words what i am writing Further
Thank you so much for your comment!
like the way you remind things softly
very very helpfull video please sir recomend video for complete ms learning as a bigginer
I liked your video very much, its too good and motivating as well.
Thanks a lot
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 KPI's kaise nikale uske bare ma bhi video banaye.. Huge data ko short list kaise kare??..
Sure, will make a video in future.
Sir! You are a great mentor!
Thank you so much.
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
Sir m student hun ho .. or self depend banan chata hun apna kharcha khud uthna chata hun exel seekh ke .😊
Glad to hear it.
Well-explained but needs to tell some more functions ,that are still hidden
Your are great guy to provide best knowledge, thanks you
Please make on videos that completely methalogy of fivrr online market place
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!
God tussi great ho awesome 👍👍 Jai hind sir Deepak Lucknow
SIR KINDLY MADE A VIDEO ON HOW TO CREATE A "KPIS " THAT USED IN THIS VIDEO
Sir from where do we get similar kinds of logos for other projects ?
Sir Apna kPI create kaisa kari video banaho please
❤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)
Data ka working kaise karnge ispe ek full video bnaeye kpi's kaise banana hai...?
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!
Nice sir ... Kya ap school ke result ke liye dashboard bana sakte ho please??
guru ji love from saudi arabia
Thank you so much for your comment.
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 ❤❤❤❤
very informative video sir thanks
Thanks for liking
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
This is the video I like to see from your side thank u very much for this nice video...
More coming keep sharing !
Hlo sir@@learnwithlokeshlalwani
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
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...how do we make final working from data .... I don't have any knowledge about it...can you please make video on it...please ❤
Hello Sir, I am from Pakistan and a big fan of your, can i join your webinar please?
Sir, can you please a video on how to make the working page by using the data?
Sure, will make a video in future.
Which version of excel are you using Sir
My Logos are not getting selected on pressing ctrl+A
And alsopage layout me groupingnahi aa raha.
What to do?
Great! Very simple way to make it
Thanks
Thank you so much for your comment.
Sir excel ka kaun sa version use karna hei because muje charts ke liye options nahi mil raha.. im using ms excel 2010
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!
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 🙏
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
PowerBi is Best Ever than Excel...now nobody talks of excel dashboard, by the way good for beginners 😊
Sir firstly aapne UA-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...
We are waiting for this video 📷
👍
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.
your video is very good sir. But how to get work from fiverr
Great work sir. It is very helpful.
Thank you so much.
Dear Sir i'm Abdullah From Pakistan I like Your Videos.....? Dear Sir Ap na Working kaise ki or data kaise nikala haa
Dear Sir aik video or bna du pls k data kaise nikalana haaa working kr k
Sure, will make a video in future.
@@learnwithlokeshlalwani thank you sir
@@learnwithlokeshlalwani dear sir ma na apko whatsapp pa kuch pucha thaa sms kia tha ap na reply he nii kia dear sir
I'll enroll for courses prepared by you Sir
Sir final working sheet ksa ready kiya aapn ne please ek baar usko bhi bata do 🙏
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
THANK YOU SIR..... BUT SIR I HAVE A DOUBT- SIR Kpi's kaise find krte h?
Love From Bangladesh ❤️🇧🇩
Thanks sir very informative ❤
How to apply
Sir practice to kat liya bina cheating new dashboard bhi bana leya . Problem to suru ab ho gaya sir ab save kis me karlu ? Client ko kese bhej sakte he kis format me save karna hota he
navy pro,github
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
Hello sir
I'm Amiya from odisha
i explor your excel course
how to acces this course please tell me
please create a excel course for everyone with downloadable practise file.
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
how to make the workings ....in what basis
Dear Sir, please advise how to make kpis
Sir mera map ma world ka map show ho raha hai, India ka nahi...
How to fix it?
And also make a video where the company has only send the sales data, and we have to make the final workings..
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
Most useful one 👍
Glad to hear that
awesome,,,,,, these contents are free,, hats off
Thank you so much for your comment!
Sir power BI se bhi bna sakte hai na ❤
Hum bhi family ko hi denge sir
Indeed a very helpful video ❤
Thank you so much for your comment.
Map not available in my excel. How to import the more charts? (create own template)
Thank you so much,
Is tarah ke or video laiye sir 🙏🙏👆👆
Sure. Thank you so much for your comment.