Sir aap jo batate hain samajh toh aa jata hain achhe se lkin jo ek dam fresher hain ya beginner hain jais eki main toh mujhe yeh dikkat aati hain ki samajhne ke bad exactly kam kaise lu kahi online platform se aur koi mujhe kaam dega hi q kyunki waha toh already bahut log hain.
Sir please make a video for zero to Advance, how to make client, how to make profile and after completing work how can send file to client please make it ❤
I have questions sir and also request to make a video about that asking I am asking you. So in this video you explained about clean Excel spreadsheet, Excel data cleaning and data cleaning up so in this video you used only Vlookup . If we put same gig on fivver or any other platform so which kind other required we got from customers like you use here only Vlookup So I would asking you about which more formula i should know and what kind of other formulas we should do in spreadsheet, Excel data cleaning in data cleaning of which more formulas we would use ?
Sir hume ye sab ata h bas aap ek video aisi banaiye ki hum logo se kase baat kare or kis tarh baat kare ki client hume apna choise kare pleace sir ek video bana dijiye ma apki sari video dekhta hun....🥺🥺
Your all vidoes are very informative and learned lot of new excel tricks. I want to start earn second salary Could you please help to get the projects.
Sir I have one question you might no noticed that source 2 is completely replaced by #N/A. So if our client ask whete the source 2 is gone. What will we say??
Maine aapka hi bataya formula use kiya hai sir exactly same formula but shuru ki kuch hi rows ka result aaya hai baki sari rows ke andar error aa rha hai .mujhe samjh nahi aa raha ki galti aakhir ho kaha rahi hai . please explain kijiye sir .🙏🙏🙏
Formula mein table select aur 1 likhne ke bad jab comma dekar 0 type karoge then 2 options aayenge False select karne hai down arrow key se and then follow as shown in video your problem will be solved
I have created multiple videos in in my channel related to optimizing and reaching clients in LinkedIn. Reaching out to clients in a specific domain on LinkedIn involves strategic steps. Firstly, optimize your profile to reflect expertise in the domain. Next, utilize advanced search to target ideal clients based on industry, job title, or location. Personalize connection requests by highlighting mutual interests or mentioning shared connections. Engage meaningfully by sharing valuable content relevant to the domain, initiating discussions, and commenting thoughtfully on others' posts. Utilize LinkedIn messaging to offer insights or solutions that align with their needs. Building rapport through genuine interaction is key. Lastly, consider joining and contributing to relevant groups or forums where your target clients are active. Consistency, value, and authenticity in your approach will help foster meaningful connections.
Absolutely, pursuing a career as a data analyst after completing your intermediate studies is indeed achievable and worthwhile. While a specific degree in data analysis can be advantageous, it's not always a strict requirement. Numerous successful data analysts come from diverse educational backgrounds. Your dedication, eagerness to learn, and practical application of analytical tools will significantly contribute to your success in this field. Start by familiarizing yourself with essential software while also exploring data visualization tools. Remember, becoming a data analyst is more about your skills, dedication, and continuous learning than solely relying on a specific educational qualification. Keep your passion ignited and pursue opportunities that enhance your analytical abilities. Wishing you the best in your journey towards becoming a successful data analyst!
@@learnwithlokeshlalwani hello sir, I have join your master class and after it completed, I created a profile on fivver but my profile is not approved.. so please guide me how did I create my account in fivver?.....
I think the formula is wrong.. coz i tried this in vlookup u selected only A2 on source 2 then you selected full column in source 1 you should select full column in source 2 also right..
just you need to select "FALSE - exact match" option while typing 0 part( i.e. range_lookup) and then after following the steps in video your problem will be solved
Starting freelancing without experience can seem daunting, but it's entirely possible. Begin by identifying your skills and passions. Next, build an online presence through platforms like Upwork, Freelancer, or Fiverr. Create a compelling profile highlighting your strengths. Start small with projects, even if they're unpaid or low-paying, to gain experience and build your portfolio. Network, reach out to potential clients, and don't hesitate to showcase your willingness to learn and adapt. Continuous learning and perseverance are key to success in freelancing!
I will suggest that you join my free webinar. Here all your doubts will be cleared. Here is the link to register: event.webinarjam.com/register/13/m4851s2
Getting clients in freelancing involves several steps. Firstly, focus on building a strong portfolio showcasing your skills and past work. Utilize freelancing platforms like Upwork, Freelancer, or Fiverr to create a profile highlighting your expertise. Networking is key-reach out to potential clients through social media, attend industry events, and engage in online communities. Providing high-quality service and asking for referrals from satisfied clients can also help expand your client base. Lastly, consider creating a professional website to establish credibility and attract clients organically. Consistency, professionalism, and effective communication are vital for acquiring clients in freelancing.
Some popular platforms include Upwork, Freelancer, Fiverr, and Guru. Each of these sites offers a diverse range of freelance opportunities across various skill sets and industries. On Upwork, you can find projects ranging from writing and programming to design and marketing. Freelancer also offers a wide array of job categories, allowing you to showcase your skills and expertise. Fiverr is known for its gig-based services, where you can offer specific services at different price points. Additionally, Guru provides a platform for freelancers in fields like programming, writing, administrative support, and more. Signing up on these platforms is relatively straightforward. You'll need to create a profile highlighting your skills, experience, and portfolio (if applicable). It's essential to craft a compelling profile that stands out and clearly showcases your abilities to attract potential clients. Remember, success on these platforms often requires dedication, professionalism, and consistent effort in bidding or promoting your services. Good luck in establishing your profile, and I hope these platforms help you kickstart your freelance journey!
Fiverr is a reputable online platform that prioritizes user security and privacy. Providing your PAN (Permanent Account Number) to Fiverr is generally safe, especially when it's required for tax purposes or verifying your identity.
I will suggest that you join my free webinar. Here all your doubts will be cleared. Here is the link to register: event.webinarjam.com/register/13/m4851s2
Getting a certificate after learning a skill depends on various factors. Certificates can validate your proficiency, yet their necessity differs. Some fields prioritize certifications for formal recognition or job requirements. However, not all skills mandate certificates. Practical expertise often speaks louder than certificates in numerous settings. Consider your goals: if it's for personal growth or specific job requirements. Research your industry-some value experience over certificates. Certifications may enhance credibility but aren't always essential. Networking, portfolios, and real-world application often matter more. Evaluate whether a certificate aligns with your goals; sometimes, practical application suffices. Ultimately, focus on skill mastery and relevance to your aspirations rather than solely chasing certificates.
*🎄🌹꧁!! जीवन का सत्य !!꧂🌹🎄* *किसी की सहायता करते समय यह मत सोचिये कि वह भविष्य में वह आपके काम आएगा..!* *बस सहायता करके भूल जाइए क्योंकि यह आशा का भाव ही भविष्य में आपके दुख का कारण बनता है।* *आप जो भी कर रहे हैं। वह परमात्मा देख रहा है, उससे छिपा नहीं है। दूसरे जो कर रहे है। उसे भी वह देख रहा है। ना किसी को जताईए, ना ही बताइये।* *बस इतना विश्वास रखिये कि जब ईश्वर ने उसकी सहायता के लिए आपको भेजा तो निश्चित है। कि जब आपको आवश्यकता होगी वह किसी ना किसी को भेजेगा।।* 🌹🙏🏻🌹✨🌹🙏🏻🌹✨🌹🙏🏻🌹
FREE Live Masterclass. Register Now. 🔥🔥 event.webinarjam.com/register/13/m4851s2
Bhai ye work milega kha
sir aap jitni bhi tricks btate ho usme se 90% tricks mujhe already aati he , it means i am pro 😁😎
😂
Sir aap jo batate hain samajh toh aa jata hain achhe se lkin jo ek dam fresher hain ya beginner hain jais eki main toh mujhe yeh dikkat aati hain ki samajhne ke bad exactly kam kaise lu kahi online platform se aur koi mujhe kaam dega hi q kyunki waha toh already bahut log hain.
Gd question 😮
Bache ke jaise study karwate ho aap ungli pakad pakad kar ♥️ dhanyawad.
I am watching ur programs several times
Sir please make a video for zero to Advance, how to make client, how to make profile and after completing work how can send file to client please make it ❤
Sure, will make a video in future.
@@learnwithlokeshlalwaniyes sir please
Yes we need
@@learnwithlokeshlalwaniplease sir make video on it 🙏🏻
@@learnwithlokeshlalwani yes sir it would be helpful for us
Sir very great thank you for sharing excellent work am from Pakistan
Thank you so much for your comment.
I have questions sir and also request to make a video about that asking I am asking you.
So in this video you explained about clean Excel spreadsheet, Excel data cleaning and data cleaning up so in this video you used only Vlookup .
If we put same gig on fivver or any other platform so which kind other required we got from customers like you use here only Vlookup
So I would asking you about which more formula i should know and what kind of other formulas we should do in spreadsheet, Excel data cleaning in data cleaning of which more formulas we would use ?
Sir, love from Bangladesh ❤
Sir hume ye sab ata h bas aap ek video aisi banaiye ki hum logo se kase baat kare or kis tarh baat kare ki client hume apna choise kare pleace sir ek video bana dijiye ma apki sari video dekhta hun....🥺🥺
Sure, will make a video in future.
9:46 Homework answer - #N/A(5001) ? CORRECT OR WRONG
Vloopup laga k 1300 😂 ... Kuch zayada sapna dikha diye sir
Video dekhte dekhte mene practice v karliya...
Glad to hear it.
Very vibrant and illustrative video
Thank you so much for your comment.
Sir apki videos. Sessions bohut informative r encouraging ha but jab freelance pe kam hi na milay to ham skill ka kia kri
Sir kam karna ka baad client ko apna Jo kam kiya hai vo submit kisa kara gayor phir Pisa kasa le gay sir Please baata do
BHAI AADAB AAP KI SHEET PRACTISE KI INSHAA ALLAH UMEED HAI CORRECT HOGI KAISE AAP CHECK KAR SAKTE HAI
Your all vidoes are very informative and learned lot of new excel tricks. I want to start earn second salary Could you please help to get the projects.
Join my free webinar. Here all your doubts will be cleared. Here is the link to register: event.webinarjam.com/register/13/m4851s2
Sir , earning to bata di aap na par , es platform pa apna account ya profile kasa banaya.
Excellent sir 🙏
Keep watching
why $ symbol is require? How to use $ in formula means short cut
Sir gig to bana liya lekin order kese laye ye batao 😢😢 order nhi mil Raha hai 😢😢
Sir, good job, additionally duplicate Values k zarye bhi ye data clean kia ja skta ha, gig ko promote krne k method bhi bata den please.
Sir I have one question you might no noticed that source 2 is completely replaced by #N/A. So if our client ask whete the source 2 is gone. What will we say??
Sir how to reach out the cliant what to write in the email pls make the video for newly enter in this filde
wow sir this is amezing
Sir payment upi ke through higa ya PayPal kr
But its showing 41,666 freelancers who are already doing this work. How to get work with such hefty competition???
So brother any scope u got from it...does any client come for beginners?
If data in five sheets then how can find common data from five sheets?
Corporate work Excel me kaise krte hai please explain
how to write a cover letter to the client for making client's project. That client should give us project. pls make a video
Sir please sath hi sath ye bata diye karen ki aap excel ka kaun sa version use karte hain
Its MS Office 365
Mobile se kaise money earn kr skte h es pr plz video bnaye sir 🙏huge request sir plz🙏🙏
Maine aapka hi bataya formula use kiya hai sir exactly same formula but shuru ki kuch hi rows ka result aaya hai baki sari rows ke andar error aa rha hai .mujhe samjh nahi aa raha ki galti aakhir ho kaha rahi hai . please explain kijiye sir .🙏🙏🙏
Formula mein table select aur 1 likhne ke bad jab comma dekar 0 type karoge then 2 options aayenge False select karne hai down arrow key se and then follow as shown in video your problem will be solved
Sir ap knsa excel version use krty hai ? Ya knsa excel version you recommend
MS Office 365
sir client jaldi kase milenge or konsa kam deta ha live experience video banado ❤
Why not use Xlookup in this situation? Why not power query ?
sir apne clean & filter karke bheja data🥲
Sir, apke webinar mein login nehi kar pa raha huun,
Aur fiverr pe account bhi nehi ban raha please help
Sir , How to reach out to clients Via Linked in a Particular Domain ?? Please a detail video on that . & Gratitude to your Efforts .
I have created multiple videos in in my channel related to optimizing and reaching clients in LinkedIn.
Reaching out to clients in a specific domain on LinkedIn involves strategic steps. Firstly, optimize your profile to reflect expertise in the domain. Next, utilize advanced search to target ideal clients based on industry, job title, or location. Personalize connection requests by highlighting mutual interests or mentioning shared connections. Engage meaningfully by sharing valuable content relevant to the domain, initiating discussions, and commenting thoughtfully on others' posts. Utilize LinkedIn messaging to offer insights or solutions that align with their needs. Building rapport through genuine interaction is key. Lastly, consider joining and contributing to relevant groups or forums where your target clients are active. Consistency, value, and authenticity in your approach will help foster meaningful connections.
@@learnwithlokeshlalwani Again thank you sir for Guiding
Sir intermediate kay baad data analyst bann sakthey hai pls replay sir
Absolutely, pursuing a career as a data analyst after completing your intermediate studies is indeed achievable and worthwhile. While a specific degree in data analysis can be advantageous, it's not always a strict requirement. Numerous successful data analysts come from diverse educational backgrounds. Your dedication, eagerness to learn, and practical application of analytical tools will significantly contribute to your success in this field. Start by familiarizing yourself with essential software while also exploring data visualization tools. Remember, becoming a data analyst is more about your skills, dedication, and continuous learning than solely relying on a specific educational qualification. Keep your passion ignited and pursue opportunities that enhance your analytical abilities. Wishing you the best in your journey towards becoming a successful data analyst!
Thank uu sir
❤ Diwali ki shubh kaamanaaye.
Thank you and same to you.
Sir agar yah flipkart ka data hota to order id same kai baar aati
Gurudev 🙏 excel me drop down kaise banaen uske upar video banaiye with a excercise file 🙏
Sure, will make a video in future.
@@learnwithlokeshlalwani ok gurudev 🙏 mein uss video ke intezaar me hoon bohut kuchh sikhne ko milta hai apse
How should I earn second salary sir
Sir please make a video on profile creation on fivver for excel for bigginers/freshers in details.....
Sure, will make a video in future.
@@learnwithlokeshlalwani hello sir, I have join your master class and after it completed, I created a profile on fivver but my profile is not approved.. so please guide me how did I create my account in fivver?.....
Sir, i m lovin it
Keep watching
this excel sheet downloaded but with some error every time. not only this many others from your link. why ?
Please give me guide i am beginner in freelancing i have not project to work.
Good afternoon Sir 🙏, I need job please send link
what is the answer of given sheet? did anyone completed?
Brother i cant complete my fiverr profile as a seller i made my profile on fiverr but cant complete seller profile how to make done pls help
I think the formula is wrong.. coz i tried this in vlookup u selected only A2 on source 2 then you selected full column in source 1 you should select full column in source 2 also right..
just you need to select "FALSE - exact match" option while typing 0 part( i.e. range_lookup) and then after following the steps in video your problem will be solved
Sir please guide how to start freelancing work without experience
Starting freelancing without experience can seem daunting, but it's entirely possible. Begin by identifying your skills and passions. Next, build an online presence through platforms like Upwork, Freelancer, or Fiverr. Create a compelling profile highlighting your strengths. Start small with projects, even if they're unpaid or low-paying, to gain experience and build your portfolio. Network, reach out to potential clients, and don't hesitate to showcase your willingness to learn and adapt. Continuous learning and perseverance are key to success in freelancing!
Sir kuch under 16 ke students ku kuch batado😢😢
Hello sir
Biggner kaise start kare zero leblel se date cleaning
I will suggest that you join my free webinar. Here all your doubts will be cleared. Here is the link to register: event.webinarjam.com/register/13/m4851s2
HOW to start for biggner excel zero to hero please full video and creat fiver account
Sir how to create a account
Sir sare seller a rhe hai clients kaise milege
Roj to sikh rahe hain sir magar payment nehi milta hai
Dear Sir, please upload a video on Power BI from 0 to hero. Thank you.
If interested I can teach you Power BI
You are best
Thank you so much for your comment.
Sir, I want to do this, but I don't have a laptop or PC
Sir hum kaise clintko pakdna hai bathaiye
Getting clients in freelancing involves several steps. Firstly, focus on building a strong portfolio showcasing your skills and past work. Utilize freelancing platforms like Upwork, Freelancer, or Fiverr to create a profile highlighting your expertise. Networking is key-reach out to potential clients through social media, attend industry events, and engage in online communities. Providing high-quality service and asking for referrals from satisfied clients can also help expand your client base. Lastly, consider creating a professional website to establish credibility and attract clients organically. Consistency, professionalism, and effective communication are vital for acquiring clients in freelancing.
Order kaise laye
sir data import nahio horaha hai
Sir please mention here freelance website name so I can make profile there .
Thanks !!
Some popular platforms include Upwork, Freelancer, Fiverr, and Guru. Each of these sites offers a diverse range of freelance opportunities across various skill sets and industries.
On Upwork, you can find projects ranging from writing and programming to design and marketing. Freelancer also offers a wide array of job categories, allowing you to showcase your skills and expertise. Fiverr is known for its gig-based services, where you can offer specific services at different price points. Additionally, Guru provides a platform for freelancers in fields like programming, writing, administrative support, and more.
Signing up on these platforms is relatively straightforward. You'll need to create a profile highlighting your skills, experience, and portfolio (if applicable). It's essential to craft a compelling profile that stands out and clearly showcases your abilities to attract potential clients.
Remember, success on these platforms often requires dedication, professionalism, and consistent effort in bidding or promoting your services. Good luck in establishing your profile, and I hope these platforms help you kickstart your freelance journey!
Sir I need ur book... How can I get ur excel book
You can purchase this book from Amazon. Here is the link: amzn.eu/d/hBb27Gt
sir which excel version you use?
MS Office 365
how to use it free for long time sir plese make a video on it @@learnwithlokeshlalwani
is it save to give pan no. to fiverr..??
Fiverr is a reputable online platform that prioritizes user security and privacy. Providing your PAN (Permanent Account Number) to Fiverr is generally safe, especially when it's required for tax purposes or verifying your identity.
@@learnwithlokeshlalwani😊
Sir excel kese free me download kre
Sir ye work phone mai kar sakta huuu
Laptop or a Desktop is required.
I use Microsoft office 2021
Thanks sir❤
Most welcome
Good video
Thank you for your comment.
🎉How get work sir
I will suggest that you join my free webinar. Here all your doubts will be cleared. Here is the link to register: event.webinarjam.com/register/13/m4851s2
میں وی لوک آپ استمعال کر چکا ہوں، لیکن پھر بھی یہ تیکنیک میرے لیے نئی ہے۔
Is it true ?
I have a question, if I will learn any skill do you need the same certificate after learning any skill.... Please reply 🙏
Getting a certificate after learning a skill depends on various factors. Certificates can validate your proficiency, yet their necessity differs. Some fields prioritize certifications for formal recognition or job requirements. However, not all skills mandate certificates. Practical expertise often speaks louder than certificates in numerous settings. Consider your goals: if it's for personal growth or specific job requirements. Research your industry-some value experience over certificates. Certifications may enhance credibility but aren't always essential. Networking, portfolios, and real-world application often matter more. Evaluate whether a certificate aligns with your goals; sometimes, practical application suffices. Ultimately, focus on skill mastery and relevance to your aspirations rather than solely chasing certificates.
Sir aap se contact kaise ho skta h?
Please email at ask@nurturetechacademy.in
*🎄🌹꧁!! जीवन का सत्य !!꧂🌹🎄*
*किसी की सहायता करते समय यह मत सोचिये कि वह भविष्य में वह आपके काम आएगा..!*
*बस सहायता करके भूल जाइए क्योंकि यह आशा का भाव ही भविष्य में आपके दुख का कारण बनता है।*
*आप जो भी कर रहे हैं। वह परमात्मा देख रहा है, उससे छिपा नहीं है। दूसरे जो कर रहे है। उसे भी वह देख रहा है। ना किसी को जताईए, ना ही बताइये।*
*बस इतना विश्वास रखिये कि जब ईश्वर ने उसकी सहायता के लिए आपको भेजा तो निश्चित है। कि जब आपको आवश्यकता होगी वह किसी ना किसी को भेजेगा।।*
🌹🙏🏻🌹✨🌹🙏🏻🌹✨🌹🙏🏻🌹
Lekin ap aise job sod ke UA-cam video Q bana raha ho bhai 😅
Kama tho rahe hai par kaha ye bhi tho batao😂
Hello Sir
Hlo sir
Hii sir
sab bakwas .only likes and comment game to earn your 🤑💰🤑
Bhut hi bakwas video
To tum achi bna k dal do.
🤬