Thank you for your efforts, I am a intern in a Notebook company and they give me this stock management work, and I made this with the help of this video.
Sir 1 question hai: Agar maine 120rs ka stock MIS me ( 8rs ) ka sell kiya aur vo 20rs up directon me chala gaya aur 10-20 min baad vo down direction me aagaya jaha vo pahle tha to kya hoga. Kya mera stock apneaap exit ho gaya hoga ya abhi bhi mere pass hoga stock. Plz Sir reply.
Sir mujhe stock trasnfer karna h low performing stores se high performing stores ko.... almost 300 different products h and 40 stores h.... kaise karunga.... rate of sale ke base pe best store ko dena h... please revert back
Very Good Video and Information. Sheets me gridline data ke adhar par automatically add, less ho aisa kuchh ho sakta he kya? Har baar drag karna thoda ....
सर मेरा एक सवाल है कि क्या home tab ki तर ही excel sheet par batan रेबन बन सकती हैं क्या जिस मे मान लो exam par click kera to us मे time tebal ke sheet, results ke sheets, admit card ke sheet के batan bna पाये यानि एक batan us me sab batan 🙏🙏🙏🙏 help and video replay kerana
SIR kya aap bata sakte hai ?automatically update inventory with supplierwise while making invoices in excel. Though On any pc i make bill but inventory should be update.
Brother...... Video is Good. Requirement is on FIFO basis for one item with multiple purchase value and multiple sales value. Also with date range ie starting date and end date I wanna know what is my opening stock, Purchase, Sales and Closing stock. Can you help me out ??
Nazim ji , report system is excellent, but if you could suggest how to maintain it on weekly basis and product wise, also in our system we have to maintain stock ledger of every product too. I hope it will be a great help for me. Thanking u in advance
Thanks For This Video But Sir Muje Date Wise Different Sheet Chahiye And Auto Mode Mai Main Summary Sheet Me Stock Update chahiye. So Please Suggest Us How Can Do It?
Agar main macro se data record krta hu or main chahta hu ki same data apne aap add ho gaye agar phle se vo entry hai toh jese mano ki maine phle se entry kr rakhi hai Apple ki or kuch dino baad fir se apple ki entry hui toh vo purane wale me jake add ho jaye koi nayi entry naa ho
dear sir, mai min qty pehle likh kr reorder alert formula laga rha hu to jo item purchase and sale hi ni huwa hai us cell me reorder alert aa ja rha hai so how cal solve this error please help me.
Need your regarding formula can you pls response i want to know how to put formula when i enter parts number and all the details will come automatically pls let me know
sir ji drop down list me mere passs bhut sara itme hai(500) to drop dwon list me search kar ne me time lgta hai ! esa koe solution btaye sir jii ki time ka kuch later type kre or oh time uper me show kre lge
Mohataram Nazim, Write "Summary" in place of "Summery" Replace "e [5th letter]" by "a" in the word "Summery" In the jargon of Excel, I mean this: REPLACE("Summery",5,1,"a"). This type of carefulness is also necessary mere Aaqa! [being Tech Guru]
👉 Download Practice File: www.techguruplus.com/excel-mis-report/
👉 Buy Excel Course: TechGuruPlus.com/Excel-Course
👉 My Instagram: instagram.com/TechGuruPlus
👉 Facebook Group: facebook.com/groups/ExcelExpertGroup
सर आपका वाट्सअप नंबर दो बहुत जरूरी काम है
That so usefull for everyone
Thank you for your efforts, I am a intern in a Notebook company and they give me this stock management work, and I made this with the help of this video.
Love you sir, apki vedios daikhnqy k baad mujhay kahin or jany ki zaroorat hi nhai
great work and bundal of thnx
Thanks a lot sir, your way of teaching is really great, any one can easily understand
Sir 1 question hai:
Agar maine 120rs ka stock MIS me ( 8rs ) ka sell kiya aur vo 20rs up directon me chala gaya aur 10-20 min baad vo down direction me aagaya jaha vo pahle tha to kya hoga. Kya mera stock apneaap exit ho gaya hoga ya abhi bhi mere pass hoga stock. Plz Sir reply.
सर,
आपका समझाने का तरीका बहुत ही सरल और प्रभावशाली है 🙏
भविष्य में आपसे बहुत कुछ सीखने की आशा है |
हमें सिखाने के लिए कोटि-कोटि आभार 🙏
Sir mujhe stock trasnfer karna h low performing stores se high performing stores ko.... almost 300 different products h and 40 stores h.... kaise karunga.... rate of sale ke base pe best store ko dena h... please revert back
very informative video Bhaiya its helps me a lot to create MIS for inventory management
Es k sath bill generat karna aur uska relation es stock k sath karne ka tarika batain or ek video esp bhi banain
Wah sir bahut achchi report hai
Thankyou sir
Sir ek hi product alag alag batch no. Me hai uska stock kese maintain kre ?
Sir I would like to know that Is Macbook ok for advance excel or I have to buy windows laptop???
Wow..just a grt teacher dats all I can say...
Thanks
thank you for the nice inventory management system. learn a lot thou i dont understand Hindi
Amazing Amazing and Amazing altogether Amazing,it looks like a beauty queen and the way you have explained is marvelous
Excellent video
Great video on stock summary I never seen before like this thanq very very much sir
Good explanation.Tahir Husain.
Very Good Video and Information. Sheets me gridline data ke adhar par automatically add, less ho aisa kuchh ho sakta he kya? Har baar drag karna thoda ....
sales order excel me kese maintain kar sakte he video banaye sir
Sir, pl. Also give a program on making hsn summary as in gstr1 return for entering in gst return gstr1. Thanks
Bahut Achcha Sar fabric roll stock kaise banate he
Sir great vedios and very helpful for store persons
Please send another vedios related store and MIS
Thanks sir
Ab koi finance management software bhi upload kar dijiye to helpful hoga
Very good video sir👌👌🙏
सर जी में नया प्रोडक्ट purchase sheet में एड करता हूं तो वो stock sheet में add नही होता हैं क्या किया जाए please help
Masha Allah
bahut achha hai sir
This is a good video. Sir plz make a video on Cash book software
Bhai report to ye sahi hai mujhe ye jannna hai ki ye software monthly bnana padega ya yearly kaam krega
Excellent bhai 👌
सर मेरा एक सवाल है कि क्या home tab ki तर ही excel sheet par batan रेबन बन सकती हैं क्या
जिस मे मान लो exam par click kera to us मे time tebal ke sheet, results ke sheets, admit card ke sheet के batan bna पाये
यानि एक batan us me sab batan
🙏🙏🙏🙏 help and video replay kerana
bohot hi kamaal sir
excellent & outstanding
Sir muzhe yahi format mein opening bags opening weight inward outward closing balance or date bhi aani chahiye aisa video chahiye
SIR kya aap bata sakte hai ?automatically update inventory with supplierwise while making invoices in excel. Though On any pc i make bill but inventory should be update.
Very good explanation, most important things given in design part also.
gr stock k products ko alg alg groups se define krna ho to vo.kese hoga sir
Hi Sir can you please let me know if i have more then 10 products then how shoul i add it ?
Good software programming for the reorderable .
Thanks help out to the my doubt
Thank u so much sir for this amazing vedio.....i cant express your gratitude in words....
Pls. Ek video monthly stock management ka video bana dijiye
sir apki teachig acchi hai
21:56 Alert Me agr koi quantity zero ho gyi hai to waha NiLL show kre uske kon formula add kre mojuda formula me ???? pls tell ASAP🙏
Awesome Bro .........
Pl share manufaturing stock management video
Brother......
Video is Good.
Requirement is on FIFO basis for one item with multiple purchase value and multiple sales value.
Also with date range ie starting date and end date I wanna know what is my opening stock, Purchase, Sales and Closing stock.
Can you help me out ??
Sir excellent knowledge shared thanks a lot,
Sir do you anything related to share market to keep records please share
Vedio is very usefull
Video bahut acha hai. But ek question hai. Agar years change hoga usme kese karenge.
Agar ek hi customer ko kai product sale karne h to drop down se kaise select honge.multiple product
Very nice g I like video for tnx
Excellent way of teaching 🙏
Nazim ji , report system is excellent, but if you could suggest how to maintain it on weekly basis and product wise, also in our system we have to maintain stock ledger of every product too. I hope it will be a great help for me. Thanking u in advance
sir product maximum kitne insert kr skte hai.
It's Amazing sir and make more video on macro
Thanks For This Video But Sir Muje Date Wise Different Sheet Chahiye And Auto Mode Mai Main Summary Sheet Me Stock Update chahiye. So Please Suggest Us How Can Do It?
Good Evening
Please Delete button also how to delete records...
THANKUUU SO MUCH SIR EXCELLENT SHEET TOPPER VERY SMART SIR
sir isi video main loss & profit ka sheet bhi bnai
Most helpful video for Me ,
Thanks sir 😊🤘
sir you are great ,i understand very well this inventory
can you make something like what my closing stock today its come tomorrow date opening stock
Nice great 👌
Manufacturing k liye bhi stock format banayea
Sir data validation nahi lg pa raha.. Source k liye wo stock summary wali work book pr ja hi nahi raha.. Kya kru
Manufacturer ke liye bnaye video
Agar main macro se data record krta hu or main chahta hu ki same data apne aap add ho gaye agar phle se vo entry hai toh jese mano ki maine phle se entry kr rakhi hai Apple ki or kuch dino baad fir se apple ki entry hui toh vo purane wale me jake add ho jaye koi nayi entry naa ho
Toomuch nice and very much helpful
Thanks brother
sir isi sheet main lost & profit ka video banaye
Superb sir
Thanks, great learning today activity, I have done same as u guide.
Very helpful video sir
Bahot shaandar
Very nice sir
dear sir, mai min qty pehle likh kr reorder alert formula laga rha hu to jo item purchase and sale hi ni huwa hai us cell me reorder alert aa ja rha hai so how cal solve this error please help me.
Excellent
Need your regarding formula can you pls response i want to know how to put formula when i enter parts number and all the details will come automatically pls let me know
Thanks a lot ,...
sir ji drop down list me mere passs bhut sara itme hai(500) to drop dwon list me search kar ne me time lgta hai ! esa koe solution btaye sir jii ki time ka kuch later type kre or oh time uper me show kre lge
sir Ji agar items ki lambi list hoto search ka option bata dijiy
Sir i need to tdl group wise & user wise security control in tally. Erp9
excellence sir thank you for shared.
Sir ji Nil ITR 2021 ki kaise banaye plz share videos
Good guidelines boss
wow.........🙏🙏🙏🙏🙏👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
Amazing .thank you. I learned lot of thing sir.
Plz as share if any video for manage stock report for construction matrial.
Make a Production Report for piping fabrication like dn 100, dn 200, dn 350.....
And work in progress report also
Nice video sir. Very useful
Very Nice
Sir agar financial year change ho tb kaise kya krna hoga
Excellent features
good job bro
Sir school management system ka banaye
Very Helpful Video
Mohataram Nazim,
Write "Summary" in place of "Summery"
Replace "e [5th letter]" by "a" in the word "Summery"
In the jargon of Excel, I mean this:
REPLACE("Summery",5,1,"a").
This type of carefulness is also necessary mere Aaqa! [being Tech Guru]
Sir sach me excellent video h
excellent
Dear sir,
can we add time automatically from the system to this working spreadsheet.
Very good sir thank u 🙏🙏🙏🙏