HomeОбразованиеRelated VideosMore From: Deepak EduWorld

How To Maintain STOCK [Inventory] in Excel Hindi | Sale Purchase Stock Register With PROFIT and LOSS

3301 ratings | 200159 views
How To Maintain Stock OR Inventory in Excel Hindi- create sale purchase stock register with profit and loss in excel step by step. purchase sales balance sheet with profit and loss. easily make an inventory in ms excel 2007 2010 2013 2016 in hindi Excel में Stock Maintain करना सीखें, Stock Maintain In Excel Hindi,Stock Maintain,how to maintain stock in excel in hindi,create stock ledger in excel,maintain your stock in excel,Excell Based Stock Register,inventory ledger format in excel,how to create Excel sheet for stock Maintain,maintain your stock in excel Step By Step,Inventory solution Excel,stock record format in excel,Stock Maintain In Excel Hindi, How to Create Stock Maintain Sheet in Excel. DOWNLOAD TRAINING FILE : https://drive.google.com/open?id=1mZ15UyiRgIu31w6yh60qqyJwuC5OgzNX Equipment Used In This Video [You Can Buy] AMAZON OFFERS: 1.TO BUY - Marantz Professional MPM-1000 Large Diaphragm Condenser Microphone click https://goo.gl/NdjSQK 2.TO BUY - Generic 57000928MG Silica Gel Professional Condenser Microphone Sound Studio Recording Dynamic (Works With Phantom Power Supply Or Sound Card Only) https://goo.gl/sRd7RX 3.TO BUY - Blue Yeti USB Microphone, Satin Red Full HD Recording https://goo.gl/1zSaJ8 Hope you will like the video. Thanks for watching. ------------------------------------------------------------------- ------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- like my facebook page: https://www.facebook.com/deepakeduworld ------------------------------------------------------------------- ------------------------------------------------------------------- follow on linkedin: https://www.linkedin.com/in/deepakeduworld Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ MS WORD के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3lZyL-Kj823ODQg1KCipzZ _____________________________________________________________ ADVANCED MS EXCEL के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J1kCWdOZof-htD4CbFRjvrT _____________________________________________________________ ADVANCED MS EXCEL FORMULAS के videos के लिए देखे ये playlists https://www.youtube.com/playlist?list=PLVevUWkXP6J2jsiIpCRjtOQvcMecQ49kw _____________________________________________________________ HTML5 & CSS3 के videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J31sl4Crvx-RUiJcIMw7p3C _____________________________________________________________ COMPUTER के TECHNICAL videos के लिए ये playlist देखे https://www.youtube.com/playlist?list=PLVevUWkXP6J3qcZy11BxbUNRVTMBvzdwe _____________________________________________________________ Thanks for Watching Happy Learning DEEPAK NEHRA ____________________________________________________________
Html code for embedding videos on your blog
Text Comments (492)
AHMAD yousufzai (17 hours ago)
Hello bro how are u? Kindly bro I'm from Pakistan nowdays our relationship is not good but that time I'm your student please must response me i make sale purchase sheet but i lock the formula I put my name now i can't find BCz there i need more insert but i can't even i can't change the colour
mas mask (5 days ago)
Nice
SHABBIR JAMALI (9 days ago)
Daily expenses ki koi video bana ke do
Deepak EduWorld (9 days ago)
G
Biswajit De (12 days ago)
pesticides packing mantain
masroor baloch (13 days ago)
sir agr koi stock market se return hota h ya Damags ya claim hota h to usko kese mentain kiya jaega plz??
Deepak EduWorld (11 days ago)
Okay dear.. I ll publish another video on this topic as soon as possible
SANJEET KUMAR (13 days ago)
namaskar sir sir aap ek aisa vdo banaye jisme stock maintain se ho , jisme ham purchase ek hi baar karege lekin sale 4-5 karenge
Raj Garg (16 days ago)
Closing stock mein rate ka colum bhi add karke dikhao bro....plzz
It's Me (18 days ago)
But what if you have more than 500 product... You can't easily find those items and create entry
Mohammad Javed (20 days ago)
How you will control or decide sale unit rate if you have purchased same item in two different price for example Ist i purchased 100 kgs pipe in 150 rupees per kgs and i am selling in 155 rupees per kgs 2nd i purchased more 100 kgs pipe in 151 rupees while i have in my stock 50 kgs pipe which i had purchased before in 150 Now in which unit rate i will sale it
Qi webtotorail (20 days ago)
Thanks sir
Sk Kh (20 days ago)
What if we sell mouse second time then how this sheet will calculate
Bishal Chakraborty (20 days ago)
Sir is method se kisika koi v firm me job kar sakte hai ??
Deepak EduWorld (11 days ago)
G
Haji Online (22 days ago)
Plz upload a toturial about square feet calculation
Haji Online (11 days ago)
+Deepak EduWorld bhai meri job ma mujhe sqft k hisab se billing or stock maintain karna parta ha jo by hand kafi ziada time consuming hota ha is plz koi solution do
Deepak EduWorld (11 days ago)
G
Mansoor Alam (26 days ago)
Dear Deepak!, Hum ne "Inventory Management" naam ka ek vedio dekha hai. Channel ka naam "Excel for Freelances" hai. Aap wo vedio dekhen aur usko apne andaaz men humsab ko dikhayen. Us vedio men wo angraiz na to zoom krke dikhata hai aur angrezi ka lecturer samajh se baher hai. Bari ummed se likh rha hoon.
Deepak EduWorld (23 days ago)
G
Avtar Singh (26 days ago)
very very useful trick bro Thanks
Dipak Raj Poudel (28 days ago)
धन्यबाद दोष्त बढियॉ टिप्स दिया आपने💐💐💐
Zoom Tech (28 days ago)
Kia excl me barcode scanner se stock ko automaticly in out kia jasakta hy? Agr hosakta hy to plzz is per ak video banayen.
Md Iqbal Raza Khan (1 month ago)
Best explain 👌👌👌👌👌👌👌
Sujoy Sarkar (1 month ago)
U r genius sir
Fareed Shaikh (1 month ago)
Entry repet hongy alg alg date pr to stock m kese jayegi
Nitish Kumar Yadav (1 month ago)
mere qus ka reply dijiye sir please mujhe iska bohot jarurat hai
Nitish Kumar Yadav (1 month ago)
mere qus ka reply dijiye sir please mujhe iska bohot jarurat hai
Nitish Kumar Yadav (1 month ago)
mere qus ka reply dijiye sir please mujhe iska bohot jarurat hai
Nitish Kumar Yadav (1 month ago)
mere qus ka reply dijiye sir please mujhe iska bohot jarurat hai
Nitish Kumar Yadav (1 month ago)
sir ye bataeye agar ham 10 pics koi item purchase karte hai aur unmese 7 bech dete hai .uske bad closing stock me 3 pics bachega use kaise bechenge taki mera closing balance 0 dikhe. ok
Deepak EduWorld (28 days ago)
Dear.. You have typed wrong formula.. Please watch video steps.. Again... Plz
Zoom Tech (1 month ago)
plzz ap barcode scanner pr video banye ki us ka zariye stock kaise maintain hoga
Deepak EduWorld (28 days ago)
G
sevan sid (1 month ago)
Owe thanks sir ji apka video bahut achcha hai .....
bablu ranjan (1 month ago)
Thank you so much sir Very very nice video sir
Govind kumar (1 month ago)
Thanks sir jee
BEGAl SHAH FARMAN (1 month ago)
Sir formulas locked krna smj ma aya aab unlocked kaise karum? Rply plz..
Deepak EduWorld (1 month ago)
Press f4 again
BEGAl SHAH FARMAN (1 month ago)
Nice presentation sir...
BEGAl SHAH FARMAN (1 month ago)
Sir excell ma jo smj ma nhe aya ga yaha pouch sakta hm kia?
Ashok Paramahamsa (1 month ago)
Bro...can you pls tell me ... how to closing stock is auto update opening stock from next date or next invoice... in Excel
Muzafar Ali Jeho Abro (1 month ago)
Sir Plzz add Daily sale and parches video with custmer acounts and how to add autometiclly Dr amount in every customers Grand total plzzz its argent im very worried about it
Sandip Dasarwar (1 month ago)
Ok hai Lekin jab Excel file close kar ke firse open karne ke baat formulae sab unlock ho rahai hai. Kay problem ho sagta ahe.
Jibran Qureshi (1 month ago)
Closing stock me se sale Karna Hoga to agli entry kaha karenge ??
Deepak EduWorld (1 month ago)
Please wait. I m publishing another video shortly
Mukesh kumar sharma (1 month ago)
Sir last me kitnaa profit huwa ya loss wo kaise pataa chalegaa 100 data hoga to kaise search karenge koi yesa formulas bataeye ki loss ko minus kar ke profit dikhaa de Please sir reply me
Deepak EduWorld (1 month ago)
Ok g.. I ll publish another video on this topic shortly
Zoom Tech (1 month ago)
excellent bro kia baat hy aapki
Aamir Hamza (1 month ago)
bohat achha sir ye kam ki chij hai wakai
KAMREZZAMAN ARU (1 month ago)
Nice bro
A K RAWAT (1 month ago)
Formet pura samajh aa gya thank you sir
Alok Chandra Asthana (1 month ago)
sir ji thankes itni achi information dene ke liye sir ji muje plywood ka fully stock maintain ,or stock kese less krte he excel me btaye muje bhout jldi ye shop pr krna he .
K P (2 months ago)
thank you deepak jee I am your new subscriber I hope I ll see more needful information about advanced excel through you
ASHOK GIRI (2 months ago)
o.k very good explain this mathod
virendra pandit (2 months ago)
God bless you sir, tax related video create
patel gulab (2 months ago)
sir aap ek stock inventory banaye jisme date waise purchase and sale aur usme ek opcation banayo ek item serch karne me uski balace qty and supplyers detail purchase dedail plese reoly soon
Deepak EduWorld (2 months ago)
G.. Please wait.. I ll publish shortly
Sandip Dasarwar (2 months ago)
Sir top pe jo total closing amount profit & loss include kar ke tekha Raha hai. Kay problem hai.
mohm meraj (2 months ago)
Thank sir main bhi aishia video dekhana chata tha
Bindas Parinda (2 months ago)
Very nyc video frends
pratiksha ugale (2 months ago)
or sales retun kese calculated kare
Deepak EduWorld (2 months ago)
Please wait.. I ll publish another video shortly
pratiksha ugale (2 months ago)
Sir agr discount dena ho to
Kishor Ambildhage (2 months ago)
Silender Ka stock maintain video banai sir please sir please
Deepak EduWorld (2 months ago)
G
n Singh (2 months ago)
chaque book kaun sa chalega image batao SBI bank
Deepak EduWorld (2 months ago)
?
Abhijitpurkait (2 months ago)
Open office 3.4.1
Salman Raza (2 months ago)
Brilliant
Surajit santra (2 months ago)
महोदय ..... खरीद और बिक्री वापसी की गणना ... यदि यह वीडियो है तो मैं बहुत फायदेमंद होगा ... मैं पश्चिम बंगाल में हूं .... मैं एक विकलांग व्यक्ति हूं ... नौकरी के लिए यह वीडियो बहुत जरूरी है ...please please sir.....
Deepak EduWorld (2 months ago)
G.. Please wait i ll publish video as soon as possible on this topic
Surajit santra (2 months ago)
How to do purchase & sales return calculation..... Please help me.... Video... Please please sir...
raju bhai (2 months ago)
nice video sir ismen purchase ke baad sale karte hain to sahi batata hai lekin bina purchase kie sirf sale karte hain to - men ajata hai isko kaise thik karenge please batayen
Surma Samriya (2 months ago)
Sir please exal ke home, insert, page layout, formulas, data, review, view. Sbi pure vistar se btao please.
JAKIR HOSSAIN (2 months ago)
Awesome Deepak Da...
Md Ansar Uddin (2 months ago)
nice
Imran Sameer (3 months ago)
Nice
all is well govind (3 months ago)
Dipak sir stock mauntan me data invoice sit se kese lae sakte hai tally ke jese stock sit kese mantan kare
all is well govind (3 months ago)
Kya vba file se stock mantan kiya ja sakta hai
FAIZAN MALIK (3 months ago)
thanks you so much invoicing or inventry dono ka ek workbook mein vedio bana do bhai plzz
Deepak EduWorld (3 months ago)
G
Rock Star (3 months ago)
Sir kya ye kam hm tally par kar sakte hai?
Deepak EduWorld (3 months ago)
Ys
Matin Farookhi (3 months ago)
Agar sir opening stock ho to kese karenge
My email [email protected] please connect me
I want to talk about ur tutorial . I suggest u to develop this template
5ves star videos (3 months ago)
Deepak bhai me in salesman noon mein 1 cheez mutlab apple hi karlo yeah mein mukhtlif dukan daroon no difrient price mein hoon uska profit kaise nikalna hai
mrinmoy das original (3 months ago)
sir me bohot try kar raha hu...but nehi ho raha he...plz apka whats app digiyeee
Sandeep Ekilwale (3 months ago)
KHUB BADIYA SIR JI BAHUT HU SIDHE AUR ACHE TARIKE SE AAPNE SAMJAYA HAI DHANYAVAD SIRJI
Indian Monster (4 months ago)
Deepak Sir ji.........namaskar ....... Muje ek query he : " muje esa stock register banana he jis me bill vice jo IN hota he vo kitna OUT hota he muje pata nahi chalta kyo ki vo diffrent date me out hote he is liye me perfect stock mantain nahi kerpa raha, muje summery Show kervani he me kese karu ????? " i Need your Help............pleased make it..... ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
Deepak EduWorld (3 months ago)
Okay g.. I will publish video as soon as possible on this topic
sarojkumar sahu (4 months ago)
Sir ek order software banaye
baloch shahrukhkhan (4 months ago)
Sir ak hi product bar bar bechna he to stock mainten kese kare jese ke aap ne mouse 10 beche fir 5 beche wo kese mainten kare
Bhola Bhatt (4 months ago)
SIR this for monthly inventory how can use for daily inventory
M Ayub Niazi (4 months ago)
Sir, aik itme ager 2nd and 3rd time purchase karna hy to Kia Kareen gye ?
Deepak EduWorld (4 months ago)
I m publishing another video on stock management.. Very shortly
Rg Tiwari (4 months ago)
MOSTLY YOUR VIDEOS ARE FRUITFUL TO LEARNERS.
Rg Tiwari (4 months ago)
when goods sold from the remaining stock not explained in this video. you know stock is maintained either 'LIFO OR FIFO' system.
Deepak EduWorld (4 months ago)
Ys.. I m publishing another stock video shortly
Shahryar Ahmed (4 months ago)
Bhai ye bata dain k is format me 15 item add ho sakti hai agr item zyada hun tu phir kia karen gay???
Deepak EduWorld (4 months ago)
Ys we can add many items.. Just add more rows in description
Shahryar Ahmed (4 months ago)
Bhai bht zabrdust keep it up
Shahryar Ahmed (4 months ago)
Bhai ye bata dain k is format me 15 item add ho sakti hai agr item zyada hun tu phir kia karen gay???
Satyaban Tada (4 months ago)
good method sir thanks sir very easy method.pl ease sir your mobile no . contact me 9078634831. I am see your all excell vedio
Riya Kumari (4 months ago)
Thanks sir..
raju bhai (4 months ago)
vedio bahut achha laga ismen udhar becha ua nagad ye bhi add karna sikha den to aur behtar ho jayega
Deepak EduWorld (4 months ago)
G
PRAVESH DWIVEDI (4 months ago)
ये तो देख लिया अगर हमारे पास 500 आइटम है और प्रत्येक आइटम अलग अलग तारीख को खरीदते औऱ बेचते है तब क्या ये फॉर्मूला काम करेगा, अगर हम देखना चाहे कि किस तारीख को कोंन सा सामान कितना खरीदा या बेचा इस बारे में कोई अच्छा वीडियो बनाइये, जिसमे तारीख के साथ सब हो।
Manni Pandit (4 months ago)
Gud job sir..
Urmal Hadiyal (4 months ago)
Sir apka explanation super hai.... Sir agar koi manufacturering ho aur uske liye stock maintain karna ho to..??? Ex. Raw material ->mfg. Product->sale redy product
Subho Senapati (4 months ago)
In excel .
Subho Senapati (4 months ago)
Sale data record & purchese data record .
Subho Senapati (4 months ago)
Customer & suppliers ledger .
Subho Senapati (4 months ago)
Bill book , profit & loss
Subho Senapati (4 months ago)
Gst billing , inventry,sale invoice,sales report,payment & receipt ,
Ashish Gupta (4 months ago)
Thank you so much
Ankesh Vaje (4 months ago)
Sir mujhe gold(gram wt) and diamond(ct wt/5=gram wt) ke stock (opening & closing) k bare me aapse help chaiye
ismail khan (4 months ago)
Deepak ji aap gajab ka samjatay hai. Very nice sir ji. Best of luck
Aamir Hayat (4 months ago)
Mainay ap sy bhot khuch sekha hy.good
Aamir Hayat (4 months ago)
Is me Percentage % ka bhi Formula ad karo
Aamir Hayat (4 months ago)
sir g is me Invoice The system bhi shamil karo
DILIP Yadav (4 months ago)
very nyc sir
Arti Rao (4 months ago)
Thank u sir
vinay Kumar (4 months ago)
Sir mujhe aap se ek bill former banvana Hai please sir ek bar mere pass call kar dijiye bill former banane jo bhi paisha hoga o mai aap ko account me bhej dunga ye mera number hai 9506316602 please please please sir call kariye
Naresh Rathod (4 months ago)
Very helpful Brother thanks

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.