Excel Stock Plus Minus Formula auto counts

saleem khan

Is video mein aap seekhenge ke Excel mein stock ko auto update kaise kiya jata hai Yani jab bhi stock add ya minus ho to Excel usay khud calculate karle Is tutorial mein hum simple formulas ka istemal kar rahe hain jisme basic plus minus system auto stock count aur inventory update ka pura tariqa shamil hai Ye video un logon ke liye bohat mufeed hai jo apni daily stock entry ko asan banana chahte hain Chahe aap shop chalate hon warehouse manage karte hon ya kisi company mein inventory handle karte hon ye Excel tutorial aap ki zindagi bohat asan kar dega Is video mein aapko step by step guide milaygi jisme aap seekhenge ke stock in stock out aur remaining stock ka auto calculation system kaise banaya jata hai Aap Excel ke through apna stock register professional level par maintain kar sakte hain Bila kisi mushkil formula ke ye method bilkul easy aur beginners friendly hai Agar aap Excel mein stock ka record rakhna chahte hain to ye video aap ke liye complete solution hai Is video mein aap ko Excel ke andar stock plus minus formula ka poora practical tariqa sikhaya gaya hai yahan aap jaanenge ke kis tarah ek simple sheet ko professional stock management system mein badla ja sakta hai Yeh video un tamam logon ke liye hai jo apni dukaan warehouse office ya business inventory ko asani se handle karna chahte hain Aksar log stock likhne mein ghaltiyan kar dete hain lekin Excel ka auto count system aap ki sari mushkilaat door kardega Is tutorial mein hum shuru se sheet tayar karte hain jisme product ka naam initial stock stock in stock out aur remaining stock sab kuch auto calculate hota hai Is method ko follow karke aap kisi bhi product ki entry karain Excel khud hi total count ko update kardega jis se aap ka record 100 accurate rahega Is video mein hum formulas ka istemal bilkul asaan zubaan mein samjhate hain taake beginners bhi isay asani se samajh saken Aap seekhenge ke kis formula se plus hoga kis formula se minus hoga aur kis formula se remaining stock auto update hoga Aap ko conditional formatting aur basic formatting bhi samjhayi gayi hai jisme aap sheet ko professional style de sakte hain Is tutorial ko follow karne ke baad aap kisi bhi business ke liye ek complete stock register tayar kar sakte hain Jo log retail business chalate hain un ke liye ye video bohat useful hai jo log online store manage karte hain wo bhi apne products ka record is method se bohat asan tareeke se rakh sakte hain Is video ka maqsad aap ko ek aisa Excel stock system banana sikhana hai jo fast ho error free ho aur puri tarah automatic kaam kare Jis me aap sirf stock in aur stock out likhen aur Excel seedha aap ko updated total bata de Ye system daily weekly ya monthly stock checking ke liye bohat behtareen hai Agar aap ek beginner hain to ye video aap ke liye complete training course hai aur agar aap Excel ko use karna pehle se jante hain to bhi ye tutorial aap ko professional level ke features sikha dega Aap chahe choti shop chalate hon ya bada business Excel stock plu

Transcript

00:00In the name of the

00:05video, I will tell you that if you are in company or in a company or in a company or in a company,

00:14or if you use Excel, then you will be very important to this video. If you are watching this video,

00:21you will be very important to see if you are going to start with a very important issue.

00:25If you have stock or you are going to start with, then you can count it.

00:31If you have stock or minus, then you can start with a click, then you can use it.

00:41If you are going to start with your stock, then you can make it minus.

00:48You can see my screen here.

00:51I have a quantity here.

00:54And you can see it.

00:56I can see it.

00:57Plus or minus.

01:01So you can see if you have a plus or minus quantity.

01:06Then you can see it easily.

01:09So, let's start.

01:11Let's start.

01:12If you have a request for a while,

01:13if you have a channel subscribe,

01:15if you have a video,

01:17then you can subscribe.

01:19If you have a channel,

01:21I will upload my videos.

01:24You can see my videos.

01:29So, here I have an Excel open.

01:31I have a quantity.

01:33I have a minus.

01:35I have a plus.

01:37If you have a quantity,

01:39I have a quantity.

01:41I have a stock.

01:43If you have a stock,

01:44like 200 stock,

01:45we can see it.

01:47So, how do we do it?

01:49So, here we go.

01:51Equal.

01:53You can see it.

01:55Here I have a look.

01:57So, you can see it.

01:59You can see it.

02:01Equal.

02:03Click the button.

02:05Click the button.

02:07Click the button.

02:09Click it.

02:11Lickرنگی تو یہاں پہ ایک فارمولا لگ جاتا ہے

02:13اس کے بعد یہاں پہ آپ کو

02:15کیا کرنا ہے آپ کو

02:16Minus کرنا ہے یہاں پہ

02:18Minus پہ Click کرتے ہیں جیسا ہی

02:21Minus پہ Click کریں گے اس کے بعد

02:22جو ہے آپ اس سے کتنا

02:24Minus کرنا چاہتے ہیں اس Pentateet

02:26سے تو چلے میں اس سے جو ہے

02:29تقریبا 6000

02:30Minus کرنا چاہتا ہوں

02:32میں 6000 یہاں پہ Likرنگیتا ہوں

02:33اور 6000 میں نے

02:36لکھ دیا اب یہاں میں Enter پہ

02:37Click کرنا ہے یہاں پہ Enter ہے

02:39so we have enter click here, you can see here, enter, enter,

02:44so we can click here, so now you can see that I have count minus here,

02:52here we have 94000,000, very simple and easy way, now we have 2000,000,

02:59so we have here click here, equal click here, equal click here,

03:07so we have here click here, so you can see here automatically formula,

03:14now we have here plus, so we have control shift,

03:20and then we click here, so we have plus, here we have plus,

03:27now we have how much quantity we have, 2000, 3000,

03:31so we have 3000 we have here,

03:353000 में ने लिख दिया, अब यहां में क्या करना है,

03:41यहां पे enter पे क्लिक करते हैं, बस इतना सकाम आपको करना है,

03:45यहां पे आप देख सकते हैं, 5000 quantity आगिया,

03:49तो दोस्तों यह बोट बिलकुल एक शार्ट कार्कुलेटर है,

03:53आप असानी के साथ जो है, इसको आप counter और plus और minus कर सकते हैं,

03:59उमेद है कि वीडियो आप लोगों को समझ आया होगा, अगर वीडियो आपको फसंद आए,

04:03तो वीडियो को एक लेक जरूर देने, चैनल को सब्सक्राइब करना ना भूलें,

04:06झाल को समझ आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको आपको �

Category

Transcript

Be the first to comment

Recommended