Рет қаралды 21,655
▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
▓▓▓▒▒▒░░░ Open This Description ░░░▒▒▒▓▓▓
▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
Free Inventory and Stock Management sheet in Excel and in HINDI
this is simple Stock Management In Excel which gives you to maintain you daily in or out stock for your small or big business or shop.
*********======Click Below Link to Download the Stock Management sheet from Comtutor======*********
drive.google.c...
********************========================================================********************
This is Free Inventory Spreadsheet and you could say How to manage inventory in Excel
This Excel comes with automated applied formula and has three separate tabs, all of which you can access by clicking at the bottom of your screen, or the links you’ll see as the hyperlink on the right when you open it.
Let’s start with a quick run-through of what each tab is, and why we’ve included them.
3 Different Tabs
In the first tab, “daily stocktake”, you need to record the daily movement of stock coming in or going out of your business. In this context, “in” and “out” can mean various things. Stock coming in might be the purchase of goods or raw materials. It might also be the completion of a finished product that is ready to be sold. Stock going out of your business could be the sale of a finished product to a customer or the use of raw materials.
For the second tab, “stock inventory”, all you need to do is enter a figure for the initial amount of stock you have for the time period in question (year, month, week, etc). The tool will calculate everything else for you.
The third tab, “stock database”, is where you enter all the information about your stock. This includes a short description of each different item, as well as a unique reference code. You’ll only need to use this tab to add new items of stock.
Instructions
1. The template is filled in with some example data, just to show you where everything goes. You need to delete these before getting started.
2. Add all your stock items into the database (tab number 3). Also, make sure you give each one a unique reference, otherwise the formulas won’t work. And try to avoid deleting items from the database, as it might also affect calculations.
3. Once this is done go to tab 2, “stock inventory”, to add the initial amounts of stock. All the items you added to the stock database (in tab 3), should now automatically be showing in this tab.
4. Use the first tab, “daily stocktake”, to record the daily movements of stock in and out of the business. You can choose the right item of stock thanks to the drop-down menu (which provides options for all the items you entered in the “stock database” tab).
================More Important videos link is below================
1. 3 Method to Create a Drop Down List in Excel -HINDI
• 3 Method to Create a D...
2. How to use IF Function in Excel- HINDI
• How to use IF Function...
3. How to use the SUMIFS Function in MS-Excel
• How to use the SUMIFS ...
4. How to Use SUMIF Formula in Excel - HINDI
• How to Use SUMIF Formu...
5. Create Advance Dependent Drop Down List in Excel in HINDI
• Create Advance Depende...
LIKE | COMMENT | SHARE | SUBSCRIBE
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u