store management and record keeping in excel
Вставка
- Опубліковано 26 сер 2024
- stores department maintains a record in which a separate folio is maintained for each item.
_/LINKS\
► Facebook:➜ / shahabislam123
► Twitter:➜ / shahabislam123
► Instagram:➜ / shahabislam6
► Website:➜ advanceexcelon...
================================================
#Storereocrd #Bookkeeping
How To Make Salary Sheet in MS Excel # 43
• How To Make Salary She...
Microsoft Word - Create Form (Office 2019)
• Microsoft Word - Creat...
How to Calculate gross Profit From Income Statement
• how to calculate gross...
Inventory Management excel formulas
• inventory management e...
How To Make Sale Report in Excel # 26
• HOW TO MAKE SALES REPO...
how to maintain store inventory in excel
• how to maintain store ...
#159 How To Make Food Cost Profit Sheet in Excel Hindi
• #159 How To Make Food ...
advance Excel Training For Job | Data Entry | functions for data analysis
• advance Excel Training...
hide excel sheet with password
• hide excel sheet with ...
#107 How To Make a Stock Management in MS Excel
• #107 How To Make a Sto...
How To Make Experience Certificate and Latter on MS word Hindi
• How To Make Experience...
How To Make Automatic student fee Collection and status system in Excel
• How To Make Automatic ...
How To Make General Ledger Trial Balance Sheet in Excel
• How To Make General Le...
#219 How To Make Daily Production Report in Excel Hindi
• #219 How To Make Daily...
How To Make Salary Pay Slip In MS Excel # 37
• How To Make Salary Pay...
how to Maintain petrol pump accounts in excel Hindi
• how to maintain petrol...
How To Make ID Card Design In Ms Word Urdu Tutorial
• How To Make ID Card De...
#283 How To Make Stock Sale/purchase or Profit and Loss Sheet in Excel Hindi
• #283 How To Make Stock...
How To Make Resume / CV with Microsoft Word
• How To Make Resume / C...
How To Make Daily Production Report For Garment industry on Excel Hindi
• How To Make Daily Prod...
how to Create Notifications or Reminders Automatically in Excel
• how to Create Notifica...
#132 How To Make Monthly Interest amount Calculate Sheet in Excel Hindi
• #132 How To Make Month...
Click to see all our videos||
/ @shahabislam4912
subcribe to our Channel ||
/ @shahabislam4912
How To Make Bill / cash Book On MS word Hindi
• How To Make Bill / cas...
How To Make Sale Price Sheet IN MS Excel Tutorial In Hindi # 51
• How To Make Sale Price...
#88 How To Make Debit Credit sheet in Excel Hindi
• #88 How To Make Debit ...
#91 How To Make Balance Sheet in Excel Hindi
• #91 How To Make Balanc...
how to calculate retirement date in Excel
• how to calculate retir...
Top 50 Excel Shortcut in Hindi
• Top 50 Excel Shortcut ...
#269 How TO Maintain Cash Book ans Petty Cash Record in Excel 2019 Hindi
• #269 How TO Maintain C...
MS Excel Complete Course Hindi ||
• #231 How To Make Reven...
File Download Link Click Link goto Website
advanceexcelon...
Assalamualaikum...sir apka smjany ka tareqa bht acha hai thanks in Sha Allah bht Kuch learn kr skty hain hum 👍 thanks
Appka vdo dekhkar bohot hi asanise bohot sare gyan Arjit kartahu. Dhannyabad apko❤️❤️🙏🏻
Thanks a Lot Sir ....
You solve my Inventory Problem.....
God Bless You....
1) Monthly stock in out and balance
2) purchase record sheet
Sir we want one more sheet 3) sales return sheet how to add ??
AOA SIR
Ma Sha Allah bht acha smjhaya ap ny main bhi store keeper hu mery liy bht achi vedio hy yh
i am a fresher for storekeeper job this video is very helpful to me
Kya bat Hai sir tq so much Apne Meri Puri problem solve kre di Dil se tq
Bro zbrdst bhot achy sy smjhaya apny, bs aik video oor bna den jo Store handle krty hain in UAE construction ka uski aik mukamal tfseel sy video bna den mujhy mention krky mera 4din bd interview hai or mujhy excel ka kuch b ni ata tha abi jo ye apki video dekhi hai srf y abi tk aya bd
اسلام علیکم ، آداب ۔سر ماشاءاللہ بہت ہی اچھی طریقے سے سمجھایا سر جی اگر ایک چیز ہم نے کم ہونے کی صورت میں منگوانا مالک نے کہا ہے کہ جب بیس 20 ٪۔ رہ جائے تو مجھے بتانا ہے تو ہم کس طرح معلوم کرنگے کہ 20 ٪ رہ گیا ہے اگر اسی طرح اسی شیٹ میں سمجھائے تو بہت مہربانی ہوگی۔۔
بندہ محمد زیاد ثانی بن سید بادشاہ ۔۔ پاکستان
Muhammad zayad saani from Pakistan
Very good sir jee
Love from India...Bahot badhiya
Or price vala topic kasy fixed karnii please tell me please send me link
Assalamualaikum baya g so much thanks to Sir you have shown such good way of keeping records in Ms Excel once again thanks sir
Aslam o aleikum
Bundle of thanks sir
Most welcome
Sir I am chef biraj started working as Executive in Saudi Arabia it’s my first time and want to increase my knowledge about Daily order. And keep stock and sale
Please how can I keep touch with you please tell me
teaching so fast sir and plz narriate every click
thnk u
Thanks a lot sir it is very help full for my electronics component inventory.... Ap ka dil se shukriya sir.. 🙏
helpful video ...
sir
plz make video on store keeper hierarchy his post from downward to upper level ...
n how can a beginner can starr his career his field plz make video on this ...
in beginning for which job post his can apply n which job designation ...how can anyone make his career in this make long video on career of store n warehouse keeper.....
hope we get to see soon......
Thankyou sir aap ne bahut achha bataya
very nice sir this is basic or we can use this anywhere
Out class Masha Allah 😘
V good example...
How to carry stock for next month
Assalamoalaykum Awesome
very nice video sir
MashaAllah, Very helpfull. ❤️
Thanks for liking
very useful video bhaijaan god bless
It's video very helpful for us. And in this vedio I had Learnt only how would we out put the material but you didn't teach how would be input. And sir in all company one time checking in one year of inventory.
So please make one video as one year with summery relative inventory.
Sir Next month k liye alag se same sheet banani hogi ya kya ?
Thank you,it helped me
You're welcome!
Sir,
A video bahut achchi lagi hai.
Please thora slow motion say sikhayeingay to bahut achcha hota. Speed honay ki wajah say sikh paana thora muskil ho jaata hai.
Very helpful
Glad it helped
Jai shree Ram ❣️...nice video bro
Jazak Allah ❤
Jazakallah khair Bhai
AoA
Next month k liye kesy maintain karain gy. Start sy table banana pary ga ya isi ko copy paste kr k ho jai ga uski detail kindly send kr dain
Are chacha next time video ko thoda zoom karke banayega okk😢
Sir Very Nice Video,,
Thanks for training sir God bless you
It's my pleasure
ua-cam.com/channels/5hJqXR5trR4CcwlWSJJJWw.html
Inward ki sheet alag chahiye or outward ki sheet alag chahiye matlab
S1-Balance stock, S2- inward, S3- Outward (S1,S2,S3-SHEET)
awesome and informative video!
well organized video thanks your support
Sir,ek cheez ap se share krna he k Purchase sheet ka link Opening Stock waly column se nhe dein blkay Ending Stock waly Column se dein.
Wo is lye k agr kisi ko maloo. krna ho k is Month k opening stock kya tha to wo purchase ki quantity add kr k btay ga.
thank u for making this video...
sir store keeper ko konsa computer knowledge hone chahiye ms officle local purchase order
You taught most important thing for store keeper job
Thanks for good tutorial
You are welcome
So helpful ....
Thanku so much
Most welcome 😊
Very informative
Thank you sir.your understand very nice
Thanks and welcome
Very use ful vedeo❤👍🤝
Thanks sir..is this the final work for store keeper ?or they have more work to do
thank you so much sir for this video
its helps me alot sir
Most welcome
Excellent video ... simple and clear
Mashallah 👍💐👍
Big thanks full sir
Sir I have question.....pls give me solid answer ............. How the storekeeper handles the work of the storeroom?
Very nice video sir tbank you
Superb logic boss
Sir i also making just like your but purchase record donot impact on stock in out sheet automatically.
walaikum assalam Wow thank you so much
Most welcome
Nice very useful♥️🙏
very nice video and explanation Sir. Can you upload a video on B2B customer database (Companies List) and followup management for Prospects, Leads, Quotes and Deals for SALES profile
This will be of great help Sir!!
Will upload soon
Sar
@@shahabislam4912 kiya is me har mahine isi tarah new sheet bana ni pade gi ya
Sir agar koi Naya stock add karna ho sheet mey wo kis Tarah add karengey ?
Just add an extra tab with each day which calculates amount rec in sales and tally the sales amount as per record with Cash till to ensure cash completeness.
Masha allah
Nice video Bhai....
Hello bhai
hi
Thank you Bro
you are just awesome
thanks
Very helpful video
Glad it was helpful!
sir make video for biggner
🤩🤩🤩
Jazakallah Khair sir thank you
this information is very helpful thanks your work very well
You are welcome
GREAT JOB
Sir har month ki closing alag alag karni hogi
Amazing ❤
Thanks 😄
1 lenght 50 inch ki h ic mai 5 inch cut ho jaye to baki kitni rah jaye gi..asa fourmula bata skty h.just lenght counteing k liye
Very useful information
We can keep stock record in one sheet itself even if we get more items in between from suppliers. Just put one more column in the sheet and put formula
But you will miss purchasing date.
Am i right ?
Aoa sir
Good video
But sir ap sa ma na kha tha ka 4,5 brand or barcode ka hisab sa
Purchase, sale,returend,or stock ko kisa maintains kar sakta han plz sir tel me
Can you make for one video plz sir
Thanks sir very informative
Welcome
Wao ❤️
Isi sheet main month wise poore year ka formulas laga sakate hai to pls usse bhi batyen
Sir very good but I want one sheet in out and extra add inventory
Thank you sir
Very useful video 👍 for me...
Thank you
How do I line the second Sheet with first sheet ..!
Sabase best
A.o.a Shukriyah ❤
Nice sir may data entry ki job kerta hun artistic garment may oricle softwear par
Thanks 👍
Welcome 👍
Thanks brother
Thanks sir ❤ Allah hafiz
Thanks
Welcome
Sir agar aap keyboard se key press kar rahe ho to kaise pata chalega. Aapne date and month me kitane din hai wo to bataya but waha Aya kaise wo to aapne keyboard se press Kiya
Sir good training session God bless you 🙏
Thanks and welcome
@@shahabislam4912
*VERY NICE*
Please make one where......
1) We have both Purchase & Sale on same Sheet, so we can just scroll down to see & have 12 Tabs for 1 YEAR & IMPORTANT FOR STOCK TO KEEP AUTO UPDATING ON TO NEXT MONTH (Hope you understand)
2) Freeze the ITEM List so when we scroll the dates & Item Name is always is visible
3) Most Important, in Dates coloum when I put 5pc sold, for Computers I need to add the Inv #
For Eg: If I sold 5p. COMP on 10th want it to show in next Coloum
2pc Comp sold to Inv# 1,
1pc Comp sold to Inv# 2
2pc Comp sold to Inv# 3 & so on ....
How would we be able to add coloum for that
Next month keliye ke bar bar asob kuch karna pare ga ke
Thanks❤
Thank you
You're welcome
Very nice
excel me
inventory tracking
data entry
invoice creation
attendence sheet creation
chart creation
stock maintain
mailing list can u say ..
in word
business letter/ document
proposal
contract creation
plan report