Stock Management in Excel (Hindi) | Without Macro
Вставка
- Опубліковано 16 жов 2024
- Stock Management in Excel (Hindi) | Without Macro
This video tutorial is based on stock management system. You can learn to prepare a stock management system by watching it. The special thing is that neither Excel Macro has been used nor the VBA has been used so this very simlpe and easy to learn.
Even before this, we have made fully automated videos on stock management system which have bcome very papular. Excel Macro was used to make them automatic.
Links of these videos are:-
1. Stock Management in Excel
• Stock Management in Ex...
2. Stock Management in Excel Part 2
• Stock Management in Ex...
3. Stock Management in Excel Part 3
• Stock Management in Ex...
4. Stock Management in Excel Part 4
• Stock Management in Ex...
Excel Functions used in this tutorial:
1. If Function
2. Count Function
3. Sumif Function
Related Videos:
1. If Function
• If Function in Excel i...
2. Count Function
• How to use COUNT, COUN...
3. Sumif Function
• Sumif formula in Excel...
4. Drop Down List
• How To Create Auto Upd...
---------------------------------------------------------------------------------------------
Download Our Excel File: docs.google.co...
---------------------------------------------------------------------------------------------
Most Popular Videos:
1. How to Create Day Book Report in Excel in Hindi Step by Step
• How to Create Day Book...
2.How to Create Day Book Report in Excel in Hindi Step by Step Part - 2
• How to Create Day Book...
3. How to Create GST Invoice in Excel in Hindi | Tax Invoice Template
• How to create GST Invo...
4. Credit Controlling Sheet in Excel in Hindi
• Credit Controlling She...
5. How to Calculate ROI in Excel (Hindi)
• How to Calculate ROI i...
6. How to Make Letterhead Design in Microsoft Word
• How to Make Letterhead...
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#stockmanagement
#powerxbyjitendra
#excel
Contact Us:
Instagram: ...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Sir 1 no. Ke sheet banai hai.
Bahut dino se dekhna cha raha tha aise sheet ab ja ke mile.
Thanku sir.
Thanks
Dear sir thank you for this useful video and wonderful explanation word to word. But kindly please let me know can use this all function to operate with the mobile MICROSOFT office app, is it possible ???????
Sir good evening.
I am your subscriber, and always watch your videos. Every one of your videos is informative. Can you make inventory for the department waise. I have six departments and I have to maintain their accounts. The details are as follows -
Stock in
Date ,Product Name, Received Qty, Gst, Price, T.Amount.
Stock Out.
Date ,Product Name, Department Name, Issue Qty, (Gst, Price, T.Amount.) optional
Stock Balance
Product Name, Bal. Qty, T. Amount.
Thanks so much.
Bahut accha explain kiya hai sir,
Thankyou, it very helpful for me👍👍
Dear sir agar product description or model no bar bar same entry karna hai to kya karenge
Sir alag alag date ko products buy hoga to bhi calculate hoga
sir bhot acha samjaya ap ne, agar main is sheet main, kisi toyoyta company ki dealer ka sale/purchase profit and lost sheet banaon to kia kerna hoga ?
Ji kaam karega
Sir mai uae me timekeeper ke liye apply kar rahe hu ek time keeper ko kya kya uae me aana chahiye ishper ek complete video banaiye
great sir agar search box ko purchase sale stock sheet main kerna chate hain to wo kese hoga.agar ap is sheet main search box bhi banana sekha dain to bhot acha hoga hum sub ke liye.
sir u r best teching in the world mere liye aap se jaberdast koi nahi hai really
Thanks a lot🙏
Excellent job Sir I made the same sheet with the help of your video but I'm facing a problem when the stock in date is changing in same sheet the serial number is showing some error. For example if 10 items are in one date, on another date the S. No should restart from 1 let me know how it would be possible
❤️❤️❤️❤️❤️❤️❤️🙏🙏🙏🙏🙏🙏Bahut achchhe se bataya aapne
Thank you so much 🙏❤️❤️❤️❤️❤️❤️❤️
Thanks Ravishji
I want new date on top means old date should be below , plz tel how this possible...
Excellent job Sir I made the same sheet with the help of your videos.
Thanks for watching.
Serial number का function invalid बता रहा है क्या करना चाहिए @date highlight हो रहा है
Insert formula carefully, you can watch video seperately for serial nuumber automation.
@@PowerExbyJitendra अगर हम 10 या 150 का list select करते हैं और उसके बाद अगर 11 या 151 वा प्रोडक्ट आए तो कैसे extend करेंगे
Inventory Management System in Excel | Excel Inventory Management (Without VBA) yeh wala aap banao please sir aap ka jo tarika hai woh kisi ka bhi nahi ho sakta
I didn't get new entryof product in drop-down list and date issue still with me
Sir if formula fixed karke jab date dal raha hu toh 0 q dikha rahi hai please help sir
But sir Stock agar hamare pass kaam h eg.30 and hum sale kar rahe hai 40 toh stock ka value -10 hojata toh oose kaise handle taki stock value minus me na ja paye.
agar apki pass stock 30 hi tu 40 kisy sale karogi yar just use common sense.😃😀😄
@@AbidHussain-fb1si 🤣arey bhai exception aara ho toh pucha ok 100 different stocks h mere pass 4,5 nahi
Hum daily up ka stock management dekhte hai. Formula humko for se sumjha e a pl.
Please do one video insert row, like invoice sheet which is blank we need to delete and we should insert also row should be automatic
Sir need add same more options like profite lose colam
Sir wear house ka kam kaisa hota hai storekeeper ka store keeper ko kia karna hota hai please sir boliye
Sir Debit and credit banking passbook entry macro with botton kaise kare ek video karea .
Koushik ji
Thoda bimar ho gaya tha
@@PowerExbyJitendra no problem. Avi kaisa hain sir?? aur banking debit aur credit kaise kare ek video dizia
Abhi Thoda thik hu
Ye topic maine note kar liya hai jaldi hi frame karta hu
@@PowerExbyJitendra ok sir
if coffee alag alag brand ka honga to kashe maintain karenge
Coffee ke aage brand ka naam likhna hoga
Inventory Management System in Excel | Excel Inventory Management (Without VBA);;;;;;; sir yeh viedo banao please mere liye bahout kaam ka hai yeh video himanshu agerwal ne banaya hai lekin woh mujeh samhj nahi aaraha hai please i rquest u please
Monthly basis stock reports kese banayega with material location
New purchase on same item kaise entry kare
Thanks, मैं ऐसा ही ढूँढ रहा था ताकि monthly sheet ना बनानी पडे, but अगर इसमे 15 list के बाद 2 महीने बाद नया प्रोडक्ट जोड़ना होगा तो कैसे करें??
Net stock me jake sirf product name type karna hai aur product automatically drop down list me purchase and sale section me bhi update ho jayega
@@piku8700 OK will try 😀 tomorrow
@@piku8700 thanks
Plzz Sir, अगर आप मैसेज पढ़े तो problem solve करें 🥺🙏
जब seriol no के लिए formula लगा रहा हूं तो seriol no "0" बार बार show कर रहा है 🥺😰😭
जिसके वजह से seriol no automatic सभी cells में नहीं increase हो रहा है,
जब कापी करके sales में past किया तो वहा S no शून्य दिखा रहा है 🥺😭😰😰😭😭😭
क्या करूं 🙏🙏🙏🙏
Please send your file I will resolve this issue.
Mail address is given in about section
Thanks a lot.
Welcome
Super🙏🙏
Thanks
Please explain oil changing management
Ji
Sir ye sheet download kese kare
Nice Teach❤🇳🇵🇳🇵🇳🇵
Thanks a lot
mera =if Our Date Function Nahi Aaraha hai kiya kerna hai sir first s.r no ka
Abdul ji,
If function to aa raha hai ya nahi
Nahi aaraha hai
thank u sir..
Welcome
Wow Very Good Sir
Thanks Rajinder ji
Sir ye ready sheet mil Jaye gi
Ha ji aap mail id share kar do
Thank you sir!!
Welcome
सर जी यह डेटा टेबल और एक्सेल टेबल में क्या फर्क होता है ?
Excel table data ko ek sath group karne ka ek powerful feature hai
Data Table vo hai jo aapne excel sheet mai banaya hai
Sir iss file me profit/loss bhi add kar dete ....pls
Congratulations for 10k subscribers 👍🏻😊
Thanks Raju
Superb sir 👌👌👌👌
Thanks Deepak ji
Formula error aata ha please any solution?
thanks sir
Thanks a lot
Sir, Add banded rows separate for purchase, sales and net stock
I have made video on it please watch:
ua-cam.com/video/DaBFBE9t6KI/v-deo.html
Date wala option nahi le raha hai sir
Nice
Thanks Sir
Welcome
Thanks you so much sir 🙏🙏,
Thanks Nagendra ji
Thank you ❤️
You are welcome Vishal
mera Baar baar error Araha hai kiya kerna hai sir
mai mujeh khuc samjh nahi aaraha hai please please sir khuc reply karo sir
Shit.. its works 💪 thank you sir 🙏 it will help me to maintain my stocks
Sir s.no.me 0 hi so horaha hai thada help Ker do
D cell #name? araha hai. please help...
Need your help
Bhaiya j6 kyu lia adress
Aap ki video clear hi nhi dikhti h sari video aise hi h bhai
Vinay ji ye complaint to abhi kisi ne nahi ki
Aap please net connection check karo ya fir apna device
Fir mai ye video ko mobile mai chala kar dekhta hu
❤❤❤❤❤❤❤❤❤❤❤❤
Thanks a lot
Apka no chahiye bhai
reply karo sir please i m waiting
🇳🇵🇳🇵🇳🇵🇳🇵
Thanks
Nice
Thanks ji