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

#excel #earnmoneyonline
FREE Live Masterclass. Register Now. 🔥🔥🔥
event.webinarjam.com/register...
Download the practice file from here 👇👇👇:
docs.google.com/spreadsheets/...
IMPORTANT ----- Steps to download the file.
Step 1 - Click on the link above.
Step 2 - Click on "File" from top left corner
Step 3 - Click on Download and then on Microsoft Excel to save the file on your system...

[@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 🙏

[@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....

[@laibasiddiqui9711]

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

[@abdulusman7045]

Bahot badiya explanation sir...

[@Amit.648]

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

[@learnwithlokeshlalwani]

Thanks and welcome

[@mayankmaurya2001]

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

[@Shawrav_Abdullah]

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

[@learnwithlokeshlalwani]

Many many thanks

[@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?

[@satyal8907]

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

[@Azhar_Khan383]

Thanks Sir for providing such information, instead of applying filter manually we can use filter function with Vstack function to exclude the blank rows.

[@raidriar68]

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

[@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

[@SajidKhan-un8vz]

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

[@learnwithlokeshlalwani]

Keep watching

[@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

[@kamalHossen0583]

Real Mentor! Thanks from Bangladesh.

[@learnwithlokeshlalwani]

Most welcome!

[@sujat_9762]

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

[@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.

[@balakrishna981]

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

[@learnwithlokeshlalwani]

Sure I will

[@hajarakk602]

Superb bhai ❤

[@austindean9274]

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

[@learnwithlokeshlalwani]

Glad to hear that!

[@anuradhasingh3259]

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

[@rahulgraphicsmalda]

allah aap ko accha rakhe hamesa abad rakhe

[@skillshub1648]

Many many thanks dear sir

[@alimehmood7105]

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

[@learnwithlokeshlalwani]

Thank you so much

[@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

[@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 .

[@Basicinfoansari9211]

I like you sir You 😎 awasome

[@aishlayvlog]

Real motivation ❤

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@tanmaychoudhary9599]

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

[@jooning877]

How to pull the data from random cells of another sheet into a new sheet.? Example if i want to view all the editing histories of multiple sheets done in a day into a new sheet how do i do that?? Urgent help

[@chandraprakashmeghwal380]

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

[@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

[@m-7767]

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

[@MuhammadWaqas-sq2rv]

Hi sir please guide me Excercise file not open in excel 365, when i open they says this excel version not supported

[@sanjayg3316]

TRUSTED CHANNEL 👍👍👍👌

[@learnwithlokeshlalwani]

Thank you for your comment.

[@nehazahra5800]

Your video illustration is super different 👍

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@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.

[@Dhirajsinghrajput-fl8bd]

SUPER SIR

[@funcityg]

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

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@sarastudio7410]

love from Bangladesh

[@mohdaadil9852]

Thanks sir but how to make profile on this website & what should be keywords and profile

[@lathamudaliyar5644]

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

[@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.

[@user-yn4xh2hg4h]

dear sir your all video help full for all freelancers

[@learnwithlokeshlalwani]

Glad to hear that

[@roshanmazhar1955]

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

[@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...

[@Respect_DNS]

#1st_viwe❤.

[@LiaqatAli-qk8yp]

Amzing❤

[@fuzailharoon7689]

Sir I am unable to select an array 1 when I am clicking the Andhra.

[@jiminlover1764]

Mujhe Excel m expert hona h sir achhe se 😊

[@learnwithlokeshlalwani]

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

[@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?

[@vlogbyamanxd]

Sir can I delete strike through word in row ? If yes please advise me! thanks

[@user-hg9jh6bz3p]

How to select Andhra and others by pressing shift? I am failed in doing so. I tried many times. please guide. Is their any special trick to select them?

[@euphrasiagomes4271]

Excellent trick. I like this.

[@learnwithlokeshlalwani]

Thanks for liking

[@gopabandumallick5158]

#Lokesh Lalwani Sir, " How long do you think this project will take" This msg show when apply for job in upwork. But the all time period show above 1 month for complete the task. How can i edit. There is no option for change it.

[@Eagleworld652]

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

[@learnwithlokeshlalwani]

Thank you so much for your comment and subscribing.

[@technicalgyan4913]

This work we can using power query easily

[@sadikhuddar1705]

sir i am using excel 2021 but formula vstack is not there do we need to enable or something if you know please help me

[@Dream-tc4zp]

Sir G,Multiple workbooks ho to kaise combine karenge?

[@user-uv3fd3bm4v]

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

[@mdmahfuzurrahman9792]

In this case, if client's data increase or new sheet add then it work or not!?

[@Hassantariq034]

Everything is great but there's only one minor thing missed, when the data is merged after using the formula, the dates are changed

[@fuzailharoon7689]

Array 1 is not selecting when I am clicking on Andhra sheet.

[@Hassantariq034]

which office version are you using?@@fuzailharoon7689

[@mohammedzubairuddin146]

But you can change in Home tab just change from General to Date format.

[@abhishekgoyal2615]

Sir Plzz u can tell me how to update excel latest version i have 2016 excel version

[@sumansoni3223]

good evening sir, i have window 11 in my dell laptop, and vstack ka formula meri suggestion list me show hi nhi ho rha h

[@dhakafady774]

Thanks a lot , sir

[@learnwithlokeshlalwani]

Most welcome

[@user-sj9ii3vd3g]

if i have data in pdf form than how can transform into excel

[@Annya530Qariya]

I am really impressed of your vedios your method of teaching in very good thanks.

[@learnwithlokeshlalwani]

It's my pleasure

[@nothinghappened6007]

17 no comment and 891 no viewer. Love from Bangladesh. Note: When I went to preview I saw that the date format had changed. Which happened in your video as well. I have seen it and fixed it myself but many people don't understand these things. It would be nice to see a video showing what to do to fix it. I'm already a fan of you. Hope to be continued.

[@fact2fied]

Bro can you tell me how you fixed the date format...Plz

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@user-hg9jh6bz3p]

bhya after Vertical staking dates are changed. how to correct them.

[@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

[@ashishranjan7901]

Sir aap Consolidate Option Se kr sakta tha ye isse bhi jaildi Data option mein hota 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

[@krishnanandagiri]

Good ❤😊

[@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.

[@The____One]

Thank you

[@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

[@SandeepKumar-cp4mz]

sir value error aa rha he same aapke process ko follow kiya fir bhi. why? Please help!

[@pragatisawant1724]

how to download vstack library from if we do not have vstack function in excel 2016

[@Asif30523]

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

[@mohdaadil9852]

sir jo apne practice sheet di he usme to + ka sign nhi show kar rha he 😰

[@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 😀

[@NAGESH_789]

Mobile par paise kaise kamae iss par video banae please

[@bhikhabhaipatel6209]

Dear Sir I try to practice this data on Microsoft office 365 but not openning file on its pl help

[@asif.29619]

Sir I’m agree with you love from pakistan❤

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@user-xm7tc7pd8t]

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

[@Motivationalq3]

Sir i don't know anything about online or exel ma kasa karu kya samaj nahi aa raha

[@theriadid7566]

Please put video for Fiverr account registration for Excel work

[@pesawang.912]

Sir im a 12th student... And my family is struggling through some financial problem and i don't want to be a load on my family.... Sooo.... Sir as a student i have 1,2 hour a free time.... So i want to do something that make my 1,2 hour to earn even if it is just 200 a day please help me... SIR

[@aarushgautam-ci4zc]

SIR SHIFT PRESS KARKE SHEETS SELECT NAHI HO RAHI HAI PLEASE TELL OTHER SHORTCUT TO DO THIS

[@gayatrichoudhary8882]

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

[@rajkiratkaur1449]

Hello Sir Thank you for uploading such videos, these are very helpful to us. However, I am not able to add a new sheet in the data u have provided. If someone has tried it kindly let me know.

[@debiprasaddutta2506]

Dear Sir, while MERGING the sheet, I faces an error (#NAME?, when I move my cursor on the error, it shows " The Formula Contains Unrecognize Text". I also give you the formula I used as per your video "=VSTACK(Andhra:Punjab!A2:J200)". kindly help me in the issue. So that I can do the rest. Warm Regards, Debi Prasad Dutta.

[@ilyasawan7837]

Sir this trick also use on Google sheets?

[@pushpapushparaj8082]

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

[@user-jo1yw3pn7q]

Sir standard and premium packages ka kia matlab hai

[@rohitgusain8810]

Sir,, I want to do this excel work but I have not a laptop for to do so😔😔

[@anshulsinghal8788]

Also tell us the how xlook up works

[@samirdeshmukh9886]

Thank you sir..

[@learnwithlokeshlalwani]

Most welcome

[@lakshay8711]

Kaam milna is hard pass me koi dukkan vagera nahi just dail kaa bhi ni pta but fiver vagera try kr skte but client mushkil

[@nehaprasad6665]

Zero containing rows bs hide hui h delete nhi to wo to phir se data mai dikhengi ... Koi btayega is case me kya krna h