Sir, I have two queries regarding the online course as I have attend your master class and I have enrolled in your course but I didn't understand this is live course or recording class and second thing is if this is a recordings course so how can I get the certificate after complete it. Please resolve my query.
Hey 👋 Sir My name is Shivam Thakur. I am a graphic designer. sir, I want to do thumbnail design for you. sir, can you give me a job? I will do the best of the best design for you. Thank you 😊🙏
I just wanted to drop a quick comment to say THANK YOU! Your videos have been a game-changer for me. Thanks to your detailed tutorials and insights, I've grown so much in my career. Keep up the amazing work - you're making a huge difference!"
Sir my total transactions are 1789. It took me only 5 minutes. The harder part is to get this sort of work from client. Please keep posting this type of information. Much needed most appreciated.
Sir thank you so much I have done this task with so many efforts, i am beginner in this skill and finally i got it done. So thank you so much and the answer is 1790 total rows
Great sir....I have understood the formulae but i have two query sir first of all iam using excel 2021 and during consolidate (Sales Rep and Region) is not coming in new sheet due to duplicacy. 2. If iam working in 365 online version then vstack is showing but problem is coming in selection all sheets together with shift key. please provide solution sir...🙏
Power query use kr lnge turnt ek bar me ho jyega issse bhi jldi ho jyega connection build krke de dnge to clint dubra km bhi nhi dega automatic ho jyega fir add krna hoga to🤣 VBA code se bhi kr dnge
Sir, actually the VSTACK formula isn't in my Excel system. And I am trying the Consolidate option but it's showing error and not taking in the data as you've shown in the video. Can you please explain how to work with the consolidate option? Thank You Sir.
sir my total transaction are 1789 and that formula VSTACK didn't work on my laptop so i created it with power query editor and upload my homework file with new source and then place them with the help of append queries and upload them in table is this good way to do it ??? I try to do it with data consolidation but i don't know how to do it......😅
I'm a student and preparing for govt exam but financial issues bht hai hum kese kr skte bhaiya 🙏🏻🙏🏻mene aapke sari vdo dekhna suru kiya hai abhi abhi kuch time hi hua like10-15 days jabse follow kr rha vdo idea dijiye sir hum bhi aage badh ske thoda sa
hello sir, can you teach how to use consolidate formula for this project, 'cause in my excel version i don't have a vstack formula & i try my best to use consolidate formula but don't get result yet.
And one more thing i want to add, last time you have posted a video related to dashboard, please make one new video especially dedicated for dashboard with new funnels used for dashboard.
Sie total number of transactions is = 1790. sir it is hard to do consolidation but i have saw in you tube and added consolidation. i am having 2019 version of Excel.
1791 rows including the headers?......Also, sir i don't know why but 3D referencing for selecting multiple sheets is not working for me...naa hi excel 365 mei...naa to google sheets mei....mujhe manually sheets select krni pdi.....help would be appreciated ...ty
Total No of transactions 1789 Sir vstack work nhi kiya consolidate se karrhe the to data idhar udhar hogya tha consolidate pe video bnayiye please if possible.❤❤❤
Sir ek doubt when clìent see our profile which was newly made he thinks this is a fresher y should i approch him i need this solution one reply can me make my day
Sir mere pass laptop nahin hai kya main yah kam phone se kar sakta hun aur yah kam phone se kaise kiya jata hai kya aap iska per ek video banaa sakte hain
![NLE Choppa - Or What ft. 41 (Orchestra Mix) [Official Music Video]](http://i.ytimg.com/vi/biOFASEgSOM/mqdefault.jpg)
FREE Live Masterclass. Register Now. 🔥🔥
event.webinarjam.com/register/13/m4851s2
Excuse me sir can you give me this book ❤
@@npmiyagaming7390 You can purchase the ebook from Amazon. Here is the link: amzn.eu/d/hBb27Gt
Sir, I have two queries regarding the online course as I have attend your master class and I have enrolled in your course but I didn't understand this is live course or recording class and second thing is if this is a recordings course so how can I get the certificate after complete it. Please resolve my query.
@@learnwithlokeshlalwaniPlease sir aapka book ham sab students Ko PDF ke roop mein dijiye ❤
Hey 👋
Sir
My name is Shivam Thakur. I am a graphic designer. sir, I want to do thumbnail design for you. sir, can you give me a job? I will do the best of the best design for you.
Thank you 😊🙏
I’m sure this will be filled with useful tips and tricks. Thanks for sharing your knowledge!
Hello sir I am from Pakistan and you are my excel teacher you do really good work for us keep it up 👍❤
Thank you for this practice file, I got 1790 rows including the header row, and it took me 30 mins to clear concepts including the homework file
The answer is correct!
I just wanted to drop a quick comment to say THANK YOU! Your videos have been a game-changer for me. Thanks to your detailed tutorials and insights, I've grown so much in my career. Keep up the amazing work - you're making a huge difference!"
Ur evey video knowledge able and motivated every one
I'm Mir taimur from Karachi Pakistan
I always look forward to your videos. They are so practical and useful for freelancers.
Did you get any work after watching this video
Your videos are always so helpful. I’m sure this one will be too!
Sir aap freelance se work lo 1365 per hour ke rate se or wo work aap hamse karwa lo 500 per hour ke rate se dono ka benefit rahe ga 😊😊
Sir my total transactions are 1789. It took me only 5 minutes. The harder part is to get this sort of work from client. Please keep posting this type of information. Much needed most appreciated.
The answer is correct. Sure, thank you so much for your comment.
Bro kse job mila hum log ka clients hi nhi milta
Sure. The answer is also correct.
I know this will be another great video. Your content never disappoints!
Answer - 1790
Thanku sir
Sir thank you so much
I have done this task with so many efforts, i am beginner in this skill and finally i got it done. So thank you so much and the answer is
1790 total rows
i have never see a video like this about a excel
98% is channel par Ms Excel Se Pese kmaane ke uper ha Amazing ❤
Koi kama paya hai kya
@@rahul-xo3cj pta nhi shala koi Kam paya ha ki nhi
Thanks for always providing such valuable insights. Can’t wait for this one!
Sir, I ordered your book on amazon and got it delivered today, very excited to go thru it
Glad to hear it.
Total rows is 1789.....its very knowledgeable video. Thank you so much for helping us
Correct answer!
Total rows is 1789.....its very good video. Good knowledge video
Thank you so much for your comment. Correct answer!
Total Transactions are 1789. Useful video. Thanks!
Great work. Correct answer!
Kaise Kiya explain
I have done it through power query.
Total transactions are 1789. And there are 301 First Class ship modes done.
Correct answer!
Total Transactions are 1789. Used Power Query, thanks for awesome video❤❤sirji
Correct answer!
Useful video ❤
Kya ye work phone ke through ho skta h ya computer ka use krna hoga???
Very Professional
Sir plz make a video on how to create an account on Fiverr as a excel expert
Total rows is 1789
Right answer!
we can do copy paste of that data instead of doing vstack formula ?
sir please, create some advanced Excel video playlists.
Lokesh bhai aap excel ka konsa version use korta hai, please let me know, thanks
sir power point par bhi ek reel kar dijiye. And also power Bi and Ai kaise use Kiya jata hai vo bhi bata dijiye.
Great sir....I have understood the formulae but i have two query sir first of all iam using excel 2021 and during consolidate (Sales Rep and Region) is not coming in new sheet due to duplicacy. 2. If iam working in 365 online version then vstack is showing but problem is coming in selection all sheets together with shift key. please provide solution sir...🙏
I did this homework using data query(append) and the total number of transaction is 1967
Please check your answer again. Correct answer will be - 1789
I attended your masterclass today but at the time of asking the queries you just got vanished. Just because of your webinar, wasted my 1 hour
So u have to enroll their course which they have sended to ur email
total transaction - 1790
Please check your answer again!
Homework workbook total number of transactions 1790
3:50 start
Hii Lokesh Sir,
Thank You Sir For teaching for Microsoft Excel and I am practicing in this video. So my answer is 1000 rows. am I correct or not?
Please check your answer again.
Great fully for video sir !
Sir i want to learn Excel basic to advanced is there any paid course ? Plz suggest if you know
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
Sir in office 365 how to select multiple sheets altogether. With shift key and click on last sheet is not working here. please provide solution...
Power query use kr lnge turnt ek bar me ho jyega issse bhi jldi ho jyega connection build krke de dnge to clint dubra km bhi nhi dega automatic ho jyega fir add krna hoga to🤣
VBA code se bhi kr dnge
Total transaction 1789, merging can be done by Power query since vstack is available only in 365.
Right answer!
Correct answer!
Thank you sir❤
Please sir aapka book ham sab students Ko PDF ke roop mein dijiye ❤
Sir ham power query bhi use kar sakte hai na marge karne ke liye?
Bhai kya ye sirf laptop/pc walo ke liye h
sir can you tell me how to create a fresher excel expert cv
can you creat a video for this topics
and thanks for sharing your knowledge
which version of excel are you using? I have 2016. I didn't find the same.
Hi Sir! I have a doubt! Why are you selecting extra rows at 6.27th minute (Can you explain in English) what is the logic behind it?
What pitch do you have to keep for the clients?
Which version of excel are you using?
Sir maine appki free class join Kiya tha 25 ko, kya mai July me aapki masterclass join Karu to mujhe kya enroll me abhi wala offar milega?
Please email at ask@nurturetechacademy.in
total row - 1790
Please check your answer again!
Sir, actually the VSTACK formula isn't in my Excel system. And I am trying the Consolidate option but it's showing error and not taking in the data as you've shown in the video. Can you please explain how to work with the consolidate option? Thank You Sir.
Sir can you do please in series 😊😊😊
sir my total transaction are 1789 and that formula VSTACK didn't work on my laptop so i created it with power query editor and upload my homework file with new source and then place them with the help of append queries and upload them in table is this good way to do it ??? I try to do it with data consolidation but i don't know how to do it......😅
I'm a student and preparing for govt exam but financial issues bht hai hum kese kr skte bhaiya 🙏🏻🙏🏻mene aapke sari vdo dekhna suru kiya hai abhi abhi kuch time hi hua like10-15 days jabse follow kr rha vdo idea dijiye sir hum bhi aage badh ske thoda sa
Income ho raha heh kya bro?
excluding header total transaction 1789
hello sir, can you teach how to use consolidate formula for this project, 'cause in my excel version i don't have a vstack formula & i try my best to use consolidate formula but don't get result yet.
sir vstack ka alternative bhi bata dete, sabke pass latest MS Excel nahi hota
Hi Lokesh Sir
very detailed information & thanks for the same. The total number of transactions are 3230 is my answer.
Please confirm.
And one more thing i want to add, last time you have posted a video related to dashboard, please make one new video especially dedicated for dashboard with new funnels used for dashboard.
Sorry, the correct answer will be 1789.
Okay, i will see video again and will check
Pls let me know how to proceed. Hope theres no investment right. Hows the payment process?.
Sie total number of transactions is = 1790. sir it is hard to do consolidation but i have saw in you tube and added consolidation.
i am having 2019 version of Excel.
Hi sir i used vistekh and the final result is merged with 1789 columns
Correct Answer!
Dear sir, ye batao ye same formats mai hai sari sheets agr format same na ho to kese Marge kare ge
Total number of Transactions : 1789.
Correct answer!
1791 rows including the headers?......Also, sir i don't know why but 3D referencing for selecting multiple sheets is not working for me...naa hi excel 365 mei...naa to google sheets mei....mujhe manually sheets select krni pdi.....help would be appreciated ...ty
While using the consolidation which function should I need to use
Total No of transactions 1789
Sir vstack work nhi kiya consolidate se karrhe the to data idhar udhar hogya tha consolidate pe video bnayiye please if possible.❤❤❤
Sure, will make a video in future!
@@learnwithlokeshlalwani thank you so much ❤️
Sir ji Fiverr pr account create nahi ho pa Raha.aap koi tutorial suggest kar skte ho
Sir, aap ji excel ka kaam dedo mujhe to, apke bataye website se to ek bhi kaam nahi aa raha
Sir main under matric Hon Kia main upwork pay Kam Kar sakti hon aur Agar Kar skti hon to us pay file kiasay banao no experience sir please help me
Sir kya ham phone se free lancing kar sakte hai
Amazing video
Thank you.
Sir kindly AP consolidate function sa merge krna wla tutorial lain please
Sir ek doubt when clìent see our profile which was newly made he thinks this is a fresher y should i approch him i need this solution one reply can me make my day
Sir please make a video for making freelancer websites profile 🙏
Sure, will make a video in future.
Sir Please Gig ke bareme video banado please bhot confusion hai sir please bana do
Sir, I have ms 365 but I didn't find VSTACK function please tell me how I find
Sir total transaction is 1789......❤
Correct answer!
please show me data consuleted option in your excel version..
I don't in my this option..
TOTAL NUMBER OF TRANSACTIONS = 1789
Correct answer!
Phone ae ho jayega sir
freelance par full course video Banao
bhai copy past bhi karsakty hen
thankyou sir😊
Keep watching
sir can show that consolidate option and how it works if vstack is not available
Bhai mobile me nhi kr skte??
Laptop or a Desktop is required.
Sir ap kon sa version use kar ry hien Microsoft excel k
Office 365.
Sir, please tell us how we can earn from mobile also.
Hi sir mere excel me VSTACK function nhi hai. Consolidate se work nhi horaha. Plz consalidate pe video banao
VSTACK is available in Excel in Microsoft 365 version 2208
the total number of transactions 1789
Correct answer!
How to start I mean how create account in any freelancer website
Answer is 1790
Total transactions are 1789
Correct Answer!
Sir mere pass laptop nahin hai kya main yah kam phone se kar sakta hun aur yah kam phone se kaise kiya jata hai kya aap iska per ek video banaa sakte hain
Sir data merge / data analysis / data clened 3 ek sath kaise kare
1789
Harshvardhan Srivastava
Correct answer!
Sir how to create account in f..
Sir I have MS Office LTSC 2021 but when I am typing =vstack no such formula is showing. Please guide me it would be really helpful for me.
VSTACK is available in Excel in Microsoft 365 version 2208
@@learnwithlokeshlalwani sir mine is showing version 18.2405.1221.0 here I guess 2405 is version but still no vstack.