Auto update Purchase and Sales price in Profit and loss account in excel | automated stock maintain

  Рет қаралды 23,532

Computer Gyan Guruji

Computer Gyan Guruji

Күн бұрын

Пікірлер: 39
@asifmulla3079
@asifmulla3079 3 жыл бұрын
Very helpful video...upload the next part of this video.
@mumairasghar8313
@mumairasghar8313 Жыл бұрын
Lots of Respect for you from Pakistan as you have solved my problem please upload the 2nd part of the video of net profit calculation please please please
@tarikulislamtanvir5904
@tarikulislamtanvir5904 3 жыл бұрын
Sir please upload the video for calculation P&L with different purchase and sales price of a specific product as u mentioned in ths last portion of the video.
@charanpoojari3650
@charanpoojari3650 4 жыл бұрын
Sir really very good teaching techniques... Am really proud of you..... God bless you sir... Please one video about ledger, receive, sale, loan, stock, defi, surplus, and store balance, lastly summary sheet ya vouchers automatically please sir.....
@zulfiqarali-zb1zn
@zulfiqarali-zb1zn 4 жыл бұрын
Salam bro main micro sheet ke andar user name or password lagia hai par jab woh google excel main matlb jab ose Cloud pe kholte hain to woh sari without username id or password on ho jati hai iska koi hal hai
@JituKumar-yp9ge
@JituKumar-yp9ge 3 ай бұрын
Profit and loss ka video banaya sir ji
@kumarakashchand9433
@kumarakashchand9433 3 жыл бұрын
Sir plz short stock banake samjhaiye mujhe ek stock banana h jisme mera product aya aur wo maine sell kiya to jo stock bach jata h wo automatic change ho jaye waisa formula btaiye
@saurabh17sharma68
@saurabh17sharma68 4 жыл бұрын
Iska part2 bhai hai kya sirji Nice video sirji
@romeoravi7650
@romeoravi7650 2 жыл бұрын
Sir aap ka video sab thik hai but ek chiz baki hai ek yai sa format sow kijiyai jo sales purchase or stock v aata hai par es mai hum kis kis sai purchase kiyai hai or kis kis ko sale ki yai hai oo data sahit wala video banayai or detail k sath ho jo bill number bill date k sath ho
@romeoravi7650
@romeoravi7650 2 жыл бұрын
Hello sir 🙏🙏
@akbarlatif288
@akbarlatif288 Жыл бұрын
Sir Baki row aur large tak ok hai per jab vlookup lagty han #N/A Error a jata i
@bhavneshparikh8283
@bhavneshparikh8283 2 жыл бұрын
Can be possible client wise auto update loan amotozation table? Also if loan interest change so can be auto update in excel table?
@dewtech4906
@dewtech4906 3 жыл бұрын
Thanks if download link files
@nvonline2484
@nvonline2484 3 жыл бұрын
Profit kaise niikaale video banaye sir ji
@JituKumar-yp9ge
@JituKumar-yp9ge 2 ай бұрын
Agar hmm large value formula dal kar array banate hai to purane price sab auto update ho jata hai, Jo ki profit loss nikal ne mein dikat hota hai..
@jayeshgajjar7313
@jayeshgajjar7313 3 жыл бұрын
Excel me stock inventory different product ka profit los fifo = first in first out our lifo = last in first out formulas kese lagaye
@sahilsitai
@sahilsitai 2 жыл бұрын
sir net profit and loss kese nikalna hoga agr rate increase ya decrease hote hen please 🙏?
@Ravikumar-xd4qd
@Ravikumar-xd4qd Жыл бұрын
Sir net profit ka video upload kr dijiye pls..
@mshahidkhan8359
@mshahidkhan8359 3 жыл бұрын
sir next video ka link send krdy profit loss wali jo end ma ap ny smjhaya ha uski vido ka link send kr dy
@tarikulislamtanvir5904
@tarikulislamtanvir5904 3 жыл бұрын
Sir, will u please explain how to calculate p&l of same product with different Purchase and selling price according to stock
@russiaangom7614
@russiaangom7614 3 жыл бұрын
Sirji i tried but fail to get row no. N autoupdate purchase price. Sorry...can we use other formula than if formula
@abhijitbiswal2640
@abhijitbiswal2640 Жыл бұрын
Next video please upload
@saleembukhsh7682
@saleembukhsh7682 4 жыл бұрын
Nice
@ravisolanki1797
@ravisolanki1797 3 жыл бұрын
Ageing inventory pr video bnao sir
@RahulYadav-nc4gm
@RahulYadav-nc4gm 4 жыл бұрын
Sir Mera ek issue Search box or find ka copy paste ka Please help me Sir
@abhijitbiswal2640
@abhijitbiswal2640 3 жыл бұрын
Please upload new video on this matter
@jitendurga8421
@jitendurga8421 2 жыл бұрын
Ammount kese update ho raha he pata nahi chal raha he
@abhijitbiswal2640
@abhijitbiswal2640 3 жыл бұрын
I try with averageif It’s not working properly Example Pen Purchase 1 time 10 pen 10 rupees 100 2 time 10 pend 9.25 rupees 92.5 3 time 20 pen 15 rupees 300 At that moment When I sales 16 pcs 11 rupees 176 Same time I want to know my profit Sale average 11 but purchase average 12.31 Problem ho raha Hai profit main Please give a new video
@kantharaju2931
@kantharaju2931 4 жыл бұрын
How to School & college fee receipt generate in Excel Sir
@HITESHPATEL-ln7ze
@HITESHPATEL-ln7ze 7 ай бұрын
ITEM ADD KARNA HAI TO KYAKARE
@rehanprince3834
@rehanprince3834 2 жыл бұрын
Sir Is Video Ka New Part
@ashvinraval3178
@ashvinraval3178 Жыл бұрын
સર મેં ડેઇલી સ્ટોપ સેલ ઓર પર્ચેઝ કરતા હું મેન્ટેન કે લિયે સોફ્ટવેર ચાહિયે
@RahulYadav-nc4gm
@RahulYadav-nc4gm 4 жыл бұрын
Hello Sir
@herocrazygaming
@herocrazygaming 3 жыл бұрын
where is part 2
@javaidiqbal51214
@javaidiqbal51214 4 жыл бұрын
Plz petrol pump ka software bana do excel ma
@mishfaq9038
@mishfaq9038 Жыл бұрын
برائے مہربانی نیٹ پرافٹ کی شیٹ سینڈ کریں شکریہ
@abhijitbiswal2640
@abhijitbiswal2640 2 жыл бұрын
Please sir give any reply
@asifmulla3079
@asifmulla3079 3 жыл бұрын
Iska part 2 shayad aap ko bhi nahi pata
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
Каха и дочка
00:28
К-Media
Рет қаралды 3,4 МЛН
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
Stock Management in Excel (Hindi) | Without Macro
20:14
PowerEx by Jitendra
Рет қаралды 123 М.