#1 Excel trick to earn Rs. 436 in just 1 hour (Merge Data) 🚀

[@learnwithlokeshlalwani]

FREE Live Masterclass. Register Now. 🔥🔥 event.webinarjam.com/register/13/m4851s2

[@Rohit-nv4cq]

Sir kaam kar lainge per muje client se baat karna nahi ati ki unko subse pahele or bich ma na kase baat kare pleace reply...🙏🙏🙏🙏

[@mjassal]

Sir, can I do this work on mobile phone??

[@chandraprakashmeghwal380]

Use laptop please

[@yogeshkumawat7274]

2007 me chal jaye ga kya

[@Dodo96-perfect]

Sir mai debt mai hu bs Roz ke 300 ra Roz mil jaye please Mera debt utr jayega please help me 🙏

[@IsaacTorres-es3te]

MAI BOHOT PARESHAN THA BUT AAPKI TIPS I WAJE SE MERI LIFE CHANGE HOGYIUI MAI BANKRUPT SE BACH GAYA AUR DAILY KA GHR BAITHE MAI 2 SE 3 HAKJAR KA MA LATA HUN learn with lokesh lalwani m THANK YOU SO MUCH DEAR

[@laibasiddiqui9711]

I love your content. You say the exact words that needs to be said

[@austindean9274]

Your teaching method is far easier than others', making learning a breeze.

[@learnwithlokeshlalwani]

Glad to hear that!

[@natural_happiness]

Many many thanks 🙏🙏🙏 dear sir 🙏... your good important subject... I'm daily watch your all Excel knowledge video... good ... I m follow you sir one year.... dear sir... are you very excellent ms Excel knowledge teacher....i proud of you sir....

[@officialh.rscientificfact8105]

bhaiya aap explain bahut acha karte ho but mein aapko suggest kahunga ki jo aap proof batate hai vo last me bataye to jada acha hota please 😊😊

[@satyal8907]

Hum ko Kadwa lage tho bi bahuth aacha Hai,it's eyes breaking motivational

[@jiminlover1764]

Mujhe Excel m expert hona h sir achhe se 😊

[@learnwithlokeshlalwani]

Join my webinar. event.webinarjam.com/register/13/m4851s2

[@clickclickbangtan]

2:10 video starts

[@sunilsandy5244]

Aap bahut acha kaam kr rahe ho❤❤❤

[@learnwithlokeshlalwani]

you so much for your comment.

[@Biswa-hg8vk]

Mughe Excel nahi pata video dekhne ke bad mughe ye Kam karne ka man he...

[@SajidKhan-un8vz]

Awesome trick sir , always keep awaiting for new videos ...

[@learnwithlokeshlalwani]

Keep watching

[@hajarakk602]

Superb bhai ❤

[@Shawrav_Abdullah]

Hi . I am from Bangladesh. I really love your videos specially every single instructions. You are really genius.

[@learnwithlokeshlalwani]

Many many thanks

[@kamalHossen0583]

Real Mentor! Thanks from Bangladesh.

[@learnwithlokeshlalwani]

Most welcome!

[@abdulusman7045]

Bahot badiya explanation sir...

[@Amit.786-y5o]

Iam first visit to your chanel,your knowledge Sir mind-blowing.. Thanku for knowledge 🙏

[@learnwithlokeshlalwani]

Thanks and welcome

[@sanjayg3316]

TRUSTED CHANNEL 👍👍👍👌

[@learnwithlokeshlalwani]

Thank you for your comment.

[@Rizwanpatanwala-zz2yz]

Respected Lokesh sir, please mention VSTACK is available in Excel in Microsoft 365 version 2208 and later, not in older versions of Excel.

[@Basicinfoansari9211]

Yes

[@nehazahra5800]

Your video illustration is super different 👍

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@chandraprakashmeghwal380]

I am a hard worker too,so let’s try this

[@funcityg]

aapki video ka wait rahega thanks you so much...

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@PMDISHA-p6b]

dear sir your all video help full for all freelancers

[@learnwithlokeshlalwani]

Glad to hear that

[@mygamingshow2641]

sir please provide latest version of excel you are using because some features are unavailable like VSTACK and Analze Data etc. so that it is easy to practice excel same like you sir .

[@ajmohanty5791]

thank you so much sir u are the best teacher in my life and you are the biggest idol for me. mein apka chennel subscribe kia hoon apka har ek video dekhraha hoon like bhi karta hoon apka har video aur trick apply karn ke liye mein Microsoft 365 ka ek mahine ka subscription lia hoon aur excercise file download karke pracctice karraha hoon

[@learnwithlokeshlalwani]

I am truly humbled by your kind words! It means the world to me to have such dedicated and enthusiastic students like you. Your commitment to learning and applying what you've learned is truly commendable. Keep up the fantastic work, and I look forward to seeing your progress.

[@ajmohanty5791]

@@learnwithlokeshlalwani apka har ek trick video with excercise file mei apne laptop mein save karke ek ek folder 📁 banake rakha hoon aur din me 1 ya 2 ghante nikalke practice karraha hoon

[@Respect_DNS]

#1st_viwe❤.

[@rasheed256]

Hi sir i am new in your channel and i am so appreciate from ur video

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@sujat_9762]

Apka video bahat achcha lagta hai but pura details denga to or vhi achcha ho ta hai

[@Basicinfoansari9211]

I like you sir You 😎 awasome

[@AsifAshfaq-z3v]

Sir I’m agree with you love from pakistan❤

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@mayankmaurya2001]

Please sir make a playlist for data entry and step by make account on online platform?

[@NasirKhan-z6l9d]

I like your teaching method because it is way better than others but I have a question the dates are not correct. love from Pakistan

[@anuradhasingh3259]

Sir please create a video that how can we make a good attractive profile on freelancing platforms.

[@alimehmood7105]

Sir I am big fan of you....sir you're too much motivator..

[@learnwithlokeshlalwani]

Thank you so much

[@samarkundu9497]

Ap excel ka konsa version use kar rahe ho ?

[@neverstoplearning1747]

Thank You again for the amazing video. Please make video on taxes for freelancer.

[@learnwithlokeshlalwani]

Sure I will

[@extraabubakar2879]

@@learnwithlokeshlalwaniThanks Alot again for amazing video ❤ Please make video how to create fiver Gig 😢please

[@ShahidAbbas-w7l]

LOKESH bhai i like your videos.

[@learnwithlokeshlalwani]

Thank you so much!

[@Motivationtamil10]

More clients so not easy to get order.. More competition

[@Ravi_00786]

Ye mobile se नही होगा क्या sir

[@MD.SHAFINALAM]

Some changes can be noticed in the case of "Order Date" and "Ship Date". Those data do not remain the same after doing this trick. In those cases, some values show instead of the dates. This is a problem for this type of trick I think. Do you have any solution for that?

[@NAGESH_789]

Mobile par paise kaise kamae iss par video banae please

[@Saurav_singh005]

I had previously watched your videos but never started working on it and this is the regret i am carrying now..

[@learnwithlokeshlalwani]

I understand how that might feel. Regrets can be tough to bear, but it's never too late to pick things up again. Your interest in my videos means a lot.

[@rahulgraphicsmalda]

allah aap ko accha rakhe hamesa abad rakhe

[@ArjunThapa-mu3si]

Sir ji kya apne ads mo nitize nhi kiye kya ek bhi ads nhi ata aapke videos pe

[@Earthtu]

Kya hum ek profile mei Alag alg *Gig* bana sakte hai Jaise - data excel merger, web developer, web data warp

[@learnwithlokeshlalwani]

Haan, aap ek profile mein alag-alag gigs bana sakte hain! Aapke skills ke hisab se alag services offer karke apni profile ko diverse aur appealing bana sakte hain. Isse aapko aur jyada opportunities mil sakti hain aur clients ko bhi aapki versatility dikhne lagegi.

[@roshanmazhar1955]

Applied thx a lot for this video plz provide link for power Bi tutotial

[@Eagleworld652]

I am new subscriber 😊😊😊😊 your video very yousfull

[@learnwithlokeshlalwani]

Thank you so much for your comment and subscribing.

[@kushrana1237]

Order date or ship date mistake 😞 ho ga raha ha

[@ripucamdyfun710]

Sir fever par account nhi ha kaisa kara ak full video banao plz sir

[@Krishna-nm5yr90]

How to create Fiverr account

[@amitx7128]

Ispr video banao pls

[@SurajKushwaha-s8o]

Yes sir please create a fiverr account

[@extraabubakar2879]

Hello sir please is per Fiver ki Gig banana bata da 😢

[@shreeanu9196]

Yes

[@arpanuc]

I will create your fiver acc.

[@wasimahmed6918]

My dear Lokesh Sir, Your video is very helpful & inspiring, I am going to join you masterclass very soon, I faced problems while merging the data of several sheets because the VSTACK formula is not working properly, please some tips is required, I am working MS-Office professional plus 2013 (Wasim Ahmed from Pakistan) thanks

[@learnwithlokeshlalwani]

VSTACK is available in Excel in Microsoft 365 version 2208 (Build 15601) and later, not in older versions of Excel.

[@iaminsane7684]

sir maine bhi same formula use kiya tha lekin mera #NAME? dikha rha hai . PLZ help

[@org_anicmeme]

as content writter ...or data entry ,copy writer job nahi mil... rahi hai sir 😔

[@euphrasiagomes4271]

Excellent trick. I like this.

[@learnwithlokeshlalwani]

Thanks for liking

[@Sukhendra_kewat]

This work we can using power query easily

[@raidriar68]

Please update Excel Masterclass - Beginner to Advanced according to new update of integration python programming language in excel!!!!!!

[@sujalpandey-xc1do]

Sir I don't have a feature of VSTACK in my laptop so do you have any other option which I can use to combine these sheets

[@Qadeer-s7k]

Sir standard and premium packages ka kia matlab hai

[@skillshub1648]

Many many thanks dear sir

[@creatormode77]

Sir asa kuch platform batayiye jo fiverr jese platform chod ke online work from home work kar excel ke upar karke earning kar sake

[@balakrishna981]

Awesome video sir as always. Please make a video on how to get Microsoft certified on Excel..

[@learnwithlokeshlalwani]

Sure I will

[@lathamudaliyar5644]

Sir whenever you upload such videos, pls mention it will be applicable in which excel ie 2013, 2019 or 365

[@Aziz-qb6mj]

sir Vstack ka formula nahi aa raha hai office 2016 mein

[@SreekanthCiri]

SQL server se data ko leke power BI pe report & dashboard kaise banana hai. Pl explain.

[@aishlayvlog]

Real motivation ❤

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@tanmaychoudhary9599]

Sir project kaise milenge us pr video bnaiye​@@learnwithlokeshlalwani

[@ashishranjan7901]

Sir aap Consolidate Option Se kr sakta tha ye isse bhi jaildi Data option mein hota ha ye...❤

[@HarshitDubey-z4u]

OFFICE 365 Main VSTACK ka formula show nhi ho raha mere main kya karu 2021 office 365 hai

[@AnkitSrivastav443]

In my Excel VSTACK doesn't exist, what should I do now?

[@learnwithlokeshlalwani]

Which excel version you ate using. VSTACK is available in Excel in Microsoft 365 version 2208

[@m-7767]

Hello sir Can you explain how to create account with discription and how to create gig and how to get job.

[@RakeshKumar-dt4kz]

SIR APKI BOOK KIDHAR SE BUY KAR SAKTE HA YE

[@priyankarathore14]

Aap khud consolidate se merge karke q ni dikhate h sab new version ni use krte h excel old version ho to kaise karenge ye bi bataya kariye

[@Basicinfoansari9211]

But ye wala formula mere Excel me show nhi kar rha hai

[@JUTT_Bros]

same

[@mdseditor.]

Freelance websites par work milta toh hai nahi fiverr

[@fazalbhatti457]

Love from Pakistan ❤🫂🇵🇰

[@FireX-24]

Sir Please Help Me Order Date Aur Ship Date Sahi Se Dadikate Nhi Ker Paya

[@LiaqatAli-qk8yp]

Amzing❤

[@AbuzarWali-ni1jb]

vstack wala step samjh mein nahi aaya select kar raha hun lekin ho nahi raha hai

[@zafardhansay300]

Koyi bhi client .reviews dekh kar hi hire karenga . Profile ko kaise attractive banaye .sothat we can get hired easily

[@dileshwarkurre1358]

Sir ye formula 2019 version me kam karega

[@ShahidAbbas-w7l]

kindly guide the excel version as i am trying to merge data but vstack formula is not showing on my excel which is excel 2010

[@all.car.available7165]

Sir ye kaam submit kese karna hai ❤❤

[@yaminivadigineni3929]

Thank you so much Lokesh Sir! Your videos are inspiring and have helped me to start taking this seriously. One thing, after merging the data we are not able to format the data into a table. It does not support with the formula used. Any solution to that?

[@Asif30523]

Sir wo bnane ke baad client ko dena kaise hai wo bta dete sir

[@Dhirajsinghrajput-fl8bd]

SUPER SIR

[@RekhaAkashLandge]

Koi he kya jisne iinke method real me karke dekha he jo kuch kama rahahe

[@Storiesto]

Hello sir, ye formula bahot useful to he pr mere computer me show nahi kr raha. work nahi kr raha ye. me kese update karu excel ko. please help me

[@sarastudio7410]

love from Bangladesh

[@teamxproyt9494]

SIR VSTACK FORMULA LAG HE NHI RAHA EXCEL M MERA MICROSOFT 365 HAI

[@abhishekchauhan4734]

Sir aapne data freeze nahi Kiya kisi dusri sheet par jate h to sheet ko freeze bhi to karna hota h na😊warna to data bigad bhi sakta h 😀

[@meetbollywoodeditz]

@learnwithlokeshlalwali there's an error with VSTACK formula which showing (#NAME! error) every time , what's the solution ...sir??

[@learnwithlokeshlalwani]

VSTACK is available in Excel in Microsoft 365 version 2208 (Build 15601) and later, not in older versions of Excel. Availability. Both VSTACK and HSTACK can be found within the Lookup & Reference category of the Excel Function Library. If they're not, then it means you don't have a current Microsoft 365 subscription.

[@adityagarg5544]

Sir awesome video can u also make a video through which teenager can earn a small amount of money regularly

[@adityagarg5544]

Bur really your videos are awesome 👍🏿👍🏿

[@learnwithlokeshlalwani]

Thank you so much for your comments. Sure, will make a video in future.

[@gayatrichoudhary8882]

Sir Excel cleaning kar ke Excel me 50 projects ho sakta hai kya

[@Aqsayounas-j9g]

Sir profile kesy banni h

[@anshulsinghal8788]

We type in this formula in excel 19 still not getting the formula by pressing tab button, do we have any other option or we can edit by adding the formula in excel only so that we can apply this formula by not changing or downloading new excel versions.

[@Dream-tc4zp]

Sir G,Multiple workbooks ho to kaise combine karenge?

[@muzammilgamingff.c]

How to create a account

[@rajendrasharma-qu1uz]

Good evening sir!! Need bit help - VSTACK function not available in my excel. Even that can't add from browse option from Ads-ins dialog box. Please suggest 🙏

[@learnwithlokeshlalwani]

The VSTACK and HSTACK Functions in Excel are pretty new functions. These functions can be used by Microsoft 365 users.

[@theriadid7566]

Please put video for Fiverr account registration for Excel work

[@raghavsharma-k4c]

Which version support vstack formula?

[@Myselfknowledge970]

Sir payment kaha withdraw karen bataaye🎉🎉🎉🎉

[@vijayverma1226]

Kya apne earning ki?? Bhai

[@Myselfknowledge970]

@@vijayverma1226 kaise karu withdraw ka to bataya nhi 😅😅