Great Sir Lokesh, I have Excel 2016 where I don't have to option but recently i learned Power BI and i did this process there. Thank you so much for providing us the opportunity to learn. ❤from Pakistan
Without power bi also it is possible we can use nested function isblank and in the final result print the heading, although it can be done here because the data has only 4 columns
thankyou sir my answer got came but i done this with alternative by using if and ifblank at the same time and then concernate formula and my answer got came
Sir, How you can convence anyone? Now I have no laptop but within 20 days.I purchased laptop. So I request you to that please teach me. Thanks Sir. Hopping for your positive response.
Sir i am new in this channel.. And i want to start this work.. I saw your video to approach in linkedin... Will you please make a elaborate video how to approach in linkedin
Hi Lokesh , I appreciate your work that you are doing and yes please cover these topics How to create profile on fiverr, upwork..that looks impressive to clients and we can get project over there then it would be really helpful ! Thankyou
Sir aap batate hai bahut aacha..Mujhe excel me expert hu par aaisa kaam karne ka kabhi socha hi nahi...Sahi kahe to pata hi nahi tha ki aaisa bhi hota hai...Ab kr sakta hu..Par kaam kaise milega wo link de do
Sir , you are so great Aap ka teach krne outclass. But mera issue net ka hi leg reha. Isi liye form nahin ho reha liken mujy aap ki master. class leni hai.😢
Sir i want to learn convert pdf to word,i am trying to learn but still facing problem,sir please can you help me ,can you make a full knowledgeable video,from that i can understand everything and can learn .one important thing is that i dont know about different documents ,that client can give us for formating , official documents kis tarha ke hote hai jisme client hume kis prakar ka kaam karne ko bolte hai,kahi aisa na ho k client ne koi document hume diya hai,aur humne use kuch alag form me matlab uska proper look presentation ,placing of matter,humne kharab kar diya,hume official documents ki koi knowledge nahi hai,vo kaise hote hai, please sir aap ek video bana sakte ho jisme har tarha ka official documents dikha sako ,to muj samaj aye aur vo dekh kar me practice bhi kar saku.🙏🙏 please help sir Sir please reply aap bahot accha samjhate ho aur practice work bhi bahot kaam ata hai, please reply i am waiting 🙏
I love this sir❤❤.Sir i am currently fresher in college and i want to earn second salary .So please tell how i can learn Excel and it's tips and tricks that can help in freelancing 🙏🙏
Hii, Mera flash fill work nhi kr rha. 4 example Dene ke bad flash fill krte hai to popup me aata hai ki couple of sample dene. Tin din se preshan hun. Please help me 🙏
Hi Lokesh Sir very informative video & thanks for the same, currently i am using excel 2016 version, but in this version get & transform data is not highlighting, in this case what i can do. Please confirm Thanks & Regds, Amit Jain
Sir, I kindly request you to provide guidance. Which specific skills/certifications should I go on learning for securing a higher pay n position in my next job? My profile : Operations , Total work ex - 6 years. Present ctc - 14 lpa Industries worked - Banking operations, Retail supermarket & e-commerce supply chain operations , Strategic consultant operations(present) . Present skill - Excel. Please bataye mai kon kon see certifications/skills sikhu for laddering up in my operations career.
@@ashishpatidar805 bhai mai 3 months se job switch krne ko try ker rha but not successful till date. Mere current CTC k upar bracket k jha b jobs hain ..data analysis/power bi/ sales/inventory forecasting/ crm /s4 Hana ye sab maang rhe companies. . Please suggest now
Hello sir mai bhi online work karke ek achhi income creat karna chahta hu but उसके liye abhi mere pass laptop nahi hai toh kya mai phone se work karke mai online paisa kama सकता hu jishke baad mai apni jarurat ki chezo ko le suku......
Join my free webinar. Here all your doubts will be cleared and your questions will be answered. Here is the link: event.webinarjam.com/register/13/m4851s2
Sir mane ap ka course purchase keya hai pura course English ma hai ap ap ka course Karna ka leya phle mujhe English ka koe course Karn pdhg jab ap youtube par hindi ma padh rahe ho to course English ma ku please reply
FREE Live Masterclass. Register Now. 🔥🔥
event.webinarjam.com/register/13/m4851s2
I'm really sorry that's my mistake in mail ID so now I got the solution so thank you very much
Sir mere kobii start kar na h ye work
Dawnload lik dijiye sir please
I am Musharraf from Pakistan, it is a big opportunity for everyone from your end and highly appreciated to you.
Great Sir Lokesh,
I have Excel 2016 where I don't have to option but recently i learned Power BI and i did this process there. Thank you so much for providing us the opportunity to learn.
❤from Pakistan
Can you provide me
@@Aalahazratch_08 yes sure brother.
What you have to do
Open that file in power BI and the rest all the process is same as Sir Lokesh explained.
Without power bi also it is possible we can use nested function isblank and in the final result print the heading, although it can be done here because the data has only 4 columns
Sir no one have knowledge like you. You are No.1
YOU HELPED ME ALOT , LOVE FROM POK
Sir Power BI ka course lao Hindi me last powerbi course dekha wo bhi aacha hai aap ke excel ke videos dekh leye bhot sikhne ko mila hai aap se ❤❤❤❤❤
You are a Greatest Teacher 👍👍👍
Thank you!
thankyou sir my answer got came but i done this with alternative by using if and ifblank at the same time and then concernate formula and my answer got came
sir tnq so much this is very esy tresk
Sir, How you can convence anyone? Now I have no laptop but within 20 days.I purchased laptop. So I request you to that please teach me. Thanks Sir. Hopping for your positive response.
I have laptop . You can give me work and charge commission
Send me your address i will send you my damaged laptop 😂😂
Yeah bro... I do have a laptop please find a project and be a middle man.
@@aartisaini2204 hi can i found work with you
@@theminimalist3368 hi can i found work for you
Sir i am new in this channel..
And i want to start this work..
I saw your video to approach in linkedin...
Will you please make a elaborate video how to approach in linkedin
Sir jinko excel ke bare me basic knowledge he vo ye work kr skte he kya?
Hi Lokesh , I appreciate your work that you are doing and yes please cover these topics
How to create profile on fiverr, upwork..that looks impressive to clients and we can get project over there then it would be really helpful !
Thankyou
Love your video sir long fan ❤️❤️❤️
Thank you so much for your comment.
Sir agr ap full excel course bnate hai to dekhne m mja aa jaye ga❤
Join my free webinar. Here all your doubts will be cleared. Here is the link to join: event.webinarjam.com/register/13/m4851s2
Sir aap batate hai bahut aacha..Mujhe excel me expert hu par aaisa kaam karne ka kabhi socha hi nahi...Sahi kahe to pata hi nahi tha ki aaisa bhi hota hai...Ab kr sakta hu..Par kaam kaise milega wo link de do
Really amazing video sir👌👌👌👌
Thank you so much for your comment.
Respected sir Thanks for sharing this trick with us 👌👌.
Most welcome
Sir , you are so great
Aap ka teach krne outclass. But mera issue net ka hi leg reha. Isi liye form nahin ho reha liken mujy aap ki master. class leni hai.😢
Thank you very much, Sir, for learning one more new topic
Thank you so much for your comment.
Hope next time you turn on the subtitles, your topic is very good, but unfortunately there are no subtitles so I can't absorb it.
Thank you very much
Love you teacher
We can use pivot and vlookup too , can be easy for anyone who has older versions of excel where advance features weren't available m
Sir please Ek video Upwork profile par banayye, Ki kaisi profile honi chahiye and proposal and project gigs n all. Please guide us
Sir please make a video on how to reach connection on LinkedIn and got projects
Please help me on this
❤badhia
Sir i want to learn convert pdf to word,i am trying to learn but still facing problem,sir please can you help me ,can you make a full knowledgeable video,from that i can understand everything and can learn .one important thing is that i dont know about different documents ,that client can give us for formating , official documents kis tarha ke hote hai jisme client hume kis prakar ka kaam karne ko bolte hai,kahi aisa na ho k client ne koi document hume diya hai,aur humne use kuch alag form me matlab uska proper look presentation ,placing of matter,humne kharab kar diya,hume official documents ki koi knowledge nahi hai,vo kaise hote hai, please sir aap ek video bana sakte ho jisme har tarha ka official documents dikha sako ,to muj samaj aye aur vo dekh kar me practice bhi kar saku.🙏🙏 please help sir
Sir please reply aap bahot accha samjhate ho aur practice work bhi bahot kaam ata hai, please reply i am waiting 🙏
I'm from Hyderabad I'm really interested in learning
Join my free webinar. Here all your doubts will be cleared. Here is the link to join: event.webinarjam.com/register/13/m4851s2
Great Sir
Sir, please give full detail about your Excel book.
Well working 😃
Thank you.
Love from Pakistan 🇵🇰❤
Sir ehe masterclass keliye kya money lagti hai
Kon kon h jise video dekhne ke bad work mila ho
Sir, actually I haven't any pc or laptop so can I do this on my smartphone?
I am waiting for feedback...
You need to have a Laptop or a PC
I love this sir❤❤.Sir i am currently fresher in college and i want to earn second salary .So please tell how i can learn Excel and it's tips and tricks that can help in freelancing 🙏🙏
Join my free webinar. Here all your doubts will be cleared. Here is the link: event.webinarjam.com/register/13/m4851s2
Okay sir
@@hemantkumarnirmalkar2868 hii broo, I have already joined in this course are you?
@@theminimalist3368 after joining this course are u able to make money online ?????
@@dineshkumarsaini6418 not yet
Sir aap ne step by step btaya nahi kaise fiverr pe project milega ?....
thanks a lot
sir
Please tell me the website where i can find job opportunity......
Thank you Sir,
Most welcome
Provide systematic course for begginners
sir unstrectured data ko edit foam me kaise lay ha
Hii, Mera flash fill work nhi kr rha.
4 example Dene ke bad flash fill krte hai to popup me aata hai ki couple of sample dene. Tin din se preshan hun.
Please help me 🙏
Plz make a videos of data engineer in 15 days same like analytics
Sir mere pass windows 7 hain,
Usme Heavy xcel file chala sakte hain kya ,plz batayi ye
Hi Lokesh Sir
very informative video & thanks for the same, currently i am using excel 2016 version, but in this version get & transform data is not highlighting, in this case what i can do. Please confirm
Thanks & Regds,
Amit Jain
Watch from Karachi Pakistan
Sir, I kindly request you to provide guidance. Which specific skills/certifications should I go on learning for securing a higher pay n position in my next job? My profile : Operations , Total work ex - 6 years. Present ctc - 14 lpa Industries worked - Banking operations, Retail supermarket & e-commerce supply chain operations , Strategic consultant operations(present) . Present skill - Excel. Please bataye mai kon kon see certifications/skills sikhu for laddering up in my operations career.
Sir apko koi certificate ki jarurat nhi he abhi 👍
@@ashishpatidar805 bhai mai 3 months se job switch krne ko try ker rha but not successful till date. Mere current CTC k upar bracket k jha b jobs hain ..data analysis/power bi/ sales/inventory forecasting/ crm /s4 Hana ye sab maang rhe companies. . Please suggest now
sir esi or practice file chahiye to kya kare??
Sir apna power Bi ka project Hr ko kese dikhaye apne laptop ma hi ya Mobile ma picture ke Through ?
Sir data entry ki video bnao please 🙏
how should make a profile as freelancer ,please make video on them
Sir Excel ki file ko bhejna kaise hai save karke
Sir in my excel, the get and transform data have only "data from picture" option. Is there any other way to access "from table/range" option?
Hello sir
Please bta do
Ka latest excel version kha sa dawnload kra free main
Thanks sir 🙏
Excel kya he ??? Excel bigginer ke liye video banau pls pls
sir how to do the same work if there is that option is not available in excel 2013?
plz answer
Sir. Really Amazing. You are really a legend of Excel
Thank you so much
Hello sir mai bhi online work karke ek achhi income creat karna chahta hu but उसके liye abhi mere pass laptop nahi hai toh kya mai phone se work karke mai online paisa kama सकता hu jishke baad mai apni jarurat ki chezo ko le suku......
Please tell me
How to earn second salary from Excel
Join my free webinar. Here all your doubts will be cleared and your questions will be answered. Here is the link: event.webinarjam.com/register/13/m4851s2
Hai sir your tricks and tips are very useful but how to get leades
Sir is 1 trik sy 866rs pr hour hy ya aapka pura course krne k baad hy yh 866rs pr hour
Ap se ksi or trah rabta hoskta hai? Manger ya ksi or I'd py?
Ap se fiverr se related kuch guide lines chaye.
Ye bhi bta dijiye k fiverr pr account kaise bnaye.
Mobile Se kar sakte he ?
Sir kya ye kaam h mobile se kar sakte hai
Sir what's a use Excel version
you can provide free e book for us. today i joined ur masterclass sir
Please email at ask@nurturetechacademy.in
I used If function to clean it is that wrong I achieved accurate result
Bhai kaam kaise milega ye bataao
Mujhe bhi krna h par aap step by step kar ke btao aur kaha se km lena h air excel me kaha se aayega sari chije achhe se samjhao sir
Sir muje freelancing karni hai please muje guidelines dijiye mere pas laptop, computer nahi hai sif smartphone hai.
Which excel version have you used ?
Is saare procedure ko kya kahte Han sir
Sir teach us to Create profile for excel work
Use filters on classes then use copy paste
Only 10 min.
Sir also possible in computer/ laptop not phone
where is bio that excel file is available
Hlo sir eis file ko mobile se laptop me kasy dalye
sir muje tora problem horaha hain payment mood per .ager upki tim kitarafse kuch help hota to acha hota
Hello sir
Nepal wale vi kr sakte hai ye sab kaam
File ka option kidhar hai download ke liye
sir fiver, Upwork, freelancer, one-hour, in sbko chod ke koi or web btaiye
How to buy your excel book
Sir excel trick to bahote he lekin project Nehi mil raha he. Please help🙏
Sir Please HElp Me Sir Apki koi bhi file acssible nhi hai please sir check it
How to send that excel sheets to clients
Can you please tell how to start with this?
Do you want the course brother?
Cause I do have a course on Excel
Mobile main hoga ?
You need to have a Laptop or a PC
Sir please show you had received payment proof
Sir is ko start kase kare
Mobile se karne ka batavo na
Par sir, mere pass computer nahi hain... 😢
Sir mane ap ka course purchase keya hai pura course English ma hai ap ap ka course Karna ka leya phle mujhe English ka koe course Karn pdhg jab ap youtube par hindi ma padh rahe ho to course English ma ku please reply
Hm sath m kre ap k course m smja du gi
hello sir ,I have entered wrong mail ID how can i find master class link
You can re-enter your details with correct email id. Registration link already shared in the descripton.
Link Tu Sahi batayen mobile pay open husakta Google pay kia
Hi, dear Sir I'm form Bangladesh. I want to do freelancing. But I have no ideas for it.
Join my free webinar. Here all your doubts will be cleared. Here is the link to join: event.webinarjam.com/register/13/m4851s2
Project konsi site s milege
can somebody tell me how can i earn from these projects that are available from the gigs