आपके स्कूल फीस के दोनों videos almost perfect हैं इतना complete और बढ़िया concept और किसी video में मुझे नहीं मिल पाया है लेकिन somehow मैं कोशिश करने के बावजूद इसे तैयार नहीं कर पाया। date to month function में error, और दूसरी शीट में भी फॉर्मूले नही लग पा रहे। कोई solution हो तो बताइयेगा।
आप महान है। मेरे सकूल को आप बहुत सहयोग करते है , गुरुजी निवेदन है अगर इसकी लिंक भेज दे तो बहुत कृपा होगी हिंदी अंगेजी अलग अलग सेक्शन में अलग अलग फीस लेते हैं, किसी की कुछ माफ भी करना पड़ती है, कैसे करें।
Sir, Nice Video,app ka videos nice sir, doubt be clear Karay tho aches rahayga.Muje individual school fee details show karnay Ka formula chayi sir. For example Hostel fee, Vechile fee, Admission fee. Please give reply sir.
sir ap ki dono videos bht pasand ai hain bht kuch seeka lekin kuch chezain aisi hain samaj nahi ain yahan to peche month likha gya hai agr aisa ho k 3 columns cels ko merge kya ho us main month likha ho us ki neche wali row main tution fee phir admition fee ore phir prev dues likhain hon ab ise reciept main month change kerne se data kaise change ho ga is pr koi vedio b bnain
fees sheet me balance collom me agar koi extra fees as advance bharde to +...... dhekhayega. aur next time wo fees bharne laga to pahawala + .... amount substract ho ke aana chaheye. make a seprete vdo on that please.
Dear sir ap ki help chahy mujy . ma monthly fee student card bna raha hon jis my studant ka total fee ho our pid fee hon awr remaining fee ho bas .... ma intizar karongi ap ka...?
fee reciept main id badalne se us k matalka record to a jata hai is k sath month b agr badla jae to us ki admition fee tution fee and prev fee badal jai ye kaise ho ga age month uper column merge kr k likha ho to
Guruji. Appake ya vdo me (18.25 time) pe student name add karna dekhaya. to atomatic Student ID add hota hai. Aur fees pay sheet me (22.23 time) pe name add karte hi Student Id atomatic aata hai. Par problem, fees pay karte samai hota hai. Agar same name wale student ho to, fees pay karte samai old wala Student Id No. hi letahai. Dropdown list me doo same name dekhata hai, par old wala Student Id No. hi letahai. Higher Id number nahi leta. . ya problem kaise solve karta hai. please bataye.
sahi pakde ho bro, waise bro maine pahle hi kai video me bataya hai mera office main highway par hai isliye trafic ke vajah se distrub hota hun kayi kayi baar to ek video record karne me pura din lag jata hai, itna bhi bhul jata hun ki kahan tak samjha diya tha or ab kahan se suru karna hai, or jahan same name ki problem hoti hain wahan aap id number ka use kar sakte hain ya name 1, name 2 ka bhi. thanks
@@ComputerGyanGuruji Sirji. Name 1, name 2, select karne par bhi old id hi le raha hai. To kya student details sheet me hi rename as 1, ya 2 karna padega.? Aur 1 baat. Mai ye sare formula lagaye wale colloms lock kar raha hu. To is wajase id number bhi manul dal nahi sakte.
Hallo, No doubt have accurate knowledge but your explanation made me completely a mess. You did not show step by step procedure i.e. first what sheet (out of 3 'FeePay', 'Students', and 'Fee Receipt' sheets as you mentioned) we have to complete with formulas and what next etc. That is why I wish to contact you personally to get a clear picture. So, plz let me know how to contact you. Hope you will respond tge soonest. Thank you.
BRO ek column or insert kijiye jisme aapne likhna hai (A. B. C.) jo bhi aapka code hai ir is formula me index se pahle (cell address &) add karna hai for example. Old formula =IFERROR(INDEX(ID,MATCH('Fees Pay'!D2,NAME,0)),"") New formula =IFERROR(Cell address&INDEX(ID,MATCH('Fees Pay'!D2,NAME,0)),"")
Explanation is not clear and confusing. He does not explain step by step i.e. first what sheet has to be prepared and what next etc. He does also not clearly show which sheet he is explaining and which sheet he is going into for which formula creation etc. No doubt he has knowledge but step by step clear explanation he is lacking. Better remake a full and complete one though it makes an hour or more.
section ki fees to utni hi rahegi bro fir bhi next video mein aapki dono problem solve ho jayengi file download ke liye description me link hai click karke download kar lijiye
हमारे यहां 60 से 100 लोगों का समिति चलता है जिसमें हमलोग 100रु, जमा करते हैं और उसे आपस में ब्याज पर लेते हैं अगला महीना पुनः जमा करके कर्ज पर ले लेते हैं जो सदस्य मासिक नहीं जमा करते हैं उन्हें अतिरिक्त शुल्क के साथ जमा करना पड़ता है इसि तरह जो सदस्य मासिक नहीं जमा करते हैं उन्हें अतिरिक्त शुल्क के साथ जमा करना पड़ता हैं आप हमें ऐसा सोफ्टवेयर बताओ कि हमें अतिरिक्त शुल्क के साथ पिछला मासिक+ब्याज पता चले साथ ही टोटल रुपया तथा प्रति सदस्य का सेयर पता चले धन्यवाद मैं आपक आभारी रहूंगा
Auto Student ID - 20-3-001 how can I solve? 20 means session, 3 means class, 001 no, if i select class 3 then code willbe 20-3-001,if 2 then 20-2- 001. plz solve me, i will be grateful
jahan tak aapki baat se mujhe samajh aaya hai, yadi ye format aapke paas date me dikhata hai to isko general kar le or yadi auto generat id leha chahte hain to aap 3 hidden column lene honge or fir unko ek column me jointext ki madad se join karna hoga
@@ComputerGyanGuruji sir yea auto id, jab maine dropdown me se class me click karenge tab auto id generate hoga, 20 matlab session middle ka num class baki unique id
आपके स्कूल फीस के दोनों videos almost perfect हैं इतना complete और बढ़िया concept और किसी video में मुझे नहीं मिल पाया है लेकिन somehow मैं कोशिश करने के बावजूद इसे तैयार नहीं कर पाया। date to month function में error, और दूसरी शीट में भी फॉर्मूले नही लग पा रहे। कोई solution हो तो बताइयेगा।
Nice video, bahut achha dekhne ke liye mila, thank you sir
ruclips.net/video/_3PUA1lEdn0/видео.html
मुझे डोनेशन सिलिप निकालने के लिए बताए यह वीडियो भी काफी जानकारी वाली है। धन्यवाद👍🏻
डोनेशन स्लिप के लिए भी बताए
Excellent narration with detailed practical work. Many many thanks.
Best video I Usually watch your videos Thanks I am Sri Lankan
Very nice formula sir
Kindly sir make a video to calculate fee refund for colleges and universities according to ugc guidelines, as soon as possible
Very Good and Help for me Thanks
आप महान है। मेरे सकूल को आप बहुत सहयोग करते है , गुरुजी निवेदन है अगर इसकी लिंक भेज दे तो बहुत कृपा होगी हिंदी अंगेजी अलग अलग सेक्शन में अलग अलग फीस लेते हैं, किसी की कुछ माफ भी करना पड़ती है, कैसे करें।
Bahut sunder hai
Thanks sir
Very good sir
Too good sir .. I am going to try it.... But क्या यह classwise भी हो सकता है?
Thanks modern teacher ...hop you make Excel video for accounts also
Sooooo nice ,kindly do one in English
Sir, Nice Video,app ka videos nice sir, doubt be clear Karay tho aches rahayga.Muje individual school fee details show karnay Ka formula chayi sir. For example Hostel fee, Vechile fee, Admission fee. Please give reply sir.
sir my name is naga srinivas sir your videos on excel sheet are interesting sir please do excel sheet for auto generate collage teacher time table
sir ap ki dono videos bht pasand ai hain bht kuch seeka lekin kuch chezain aisi hain samaj nahi ain yahan to peche month likha gya hai agr aisa ho k 3 columns cels ko merge kya ho us main month likha ho us ki neche wali row main tution fee phir admition fee ore phir prev dues likhain hon ab ise reciept main month change kerne se data kaise change ho ga is pr koi vedio b bnain
super sir ji
fees sheet me balance collom me agar koi extra fees as advance bharde to +...... dhekhayega.
aur next time wo fees bharne laga to pahawala + .... amount substract ho ke aana chaheye.
make a seprete vdo on that please.
Great job sir, Thank you for this great formula teaching.
Sir i have a question plz reply me as soon as possible ... ager ek class ka bachon ki mukhtalif fees hai to us ka liye kya karin ga ?
Nice sir 👍
nice video. good learners guide.
ruclips.net/video/_3PUA1lEdn0/видео.html
Very Good Sir..
Sir kya ap hmri requirement k according sheet bnakr k sakte hai apka jo payment hoga wo kra denge
best your formula
Good job
Dear sir ap ki help chahy mujy .
ma monthly fee student card bna raha hon jis my studant ka total fee ho our pid fee hon awr remaining fee ho bas .... ma intizar karongi ap ka...?
Good
R/Sir good Evening , fee receipt के सामने वाले search Box main I'd dalne se st.ditail automaticallyकैसे changeहोती है , इसके बारे में जरूर बताएं 🙏🙏
इसके साथ डेली कलेक्शन रजिस्टर ( DCR ) बनाने का भी विवरण दें
Dear,
Ek to jo sheet ha usk bnaya lro video men bhi,, dusra Jitne students hen sb k challan kese print krenge by one click,
fee reciept main id badalne se us k matalka record to a jata hai is k sath month b agr badla jae to us ki admition fee tution fee and prev fee badal jai ye kaise ho ga age month uper column merge kr k likha ho to
Running month ke hisaab se due kitna hai? Ea kaise nikala ja sakta hai?
Class 1 to 10 different sheet pe ho to kaise karege sirji
What should i do i have students who are siblings.
But sir start pr working kaise krni means fee receipt kaise bnani
Showing circular reference error in the fee deposite column when using the ,if, formula to extract month.
muje ek sath receipt ki print leni he to kese leni hogi
Sir plz buss fee add Karo es excelsheet ma or mara students details ma monthly fee add nahi ho raha hy
Bhai new video upload karay is may sound clear nahi hay or pleas formulay clear dikhay
Guruji. Appake ya vdo me (18.25 time) pe student name add karna dekhaya. to atomatic Student ID add hota hai. Aur fees pay sheet me (22.23 time) pe name add karte hi Student Id atomatic aata hai.
Par problem, fees pay karte samai hota hai.
Agar same name wale student ho to, fees pay karte samai old wala Student Id No. hi letahai.
Dropdown list me doo same name dekhata hai, par old wala Student Id No. hi letahai.
Higher Id number nahi leta.
.
ya problem kaise solve karta hai.
please bataye.
sahi pakde ho bro, waise bro maine pahle hi kai video me bataya hai mera office main highway par hai isliye trafic ke vajah se distrub hota hun kayi kayi baar to ek video record karne me pura din lag jata hai, itna bhi bhul jata hun ki kahan tak samjha diya tha or ab kahan se suru karna hai, or jahan same name ki problem hoti hain wahan aap id number ka use kar sakte hain ya name 1, name 2 ka bhi. thanks
@@ComputerGyanGuruji
Sirji. Name 1, name 2, select karne par bhi old id hi le raha hai.
To kya student details sheet me hi rename as 1, ya 2 karna padega.?
Aur 1 baat. Mai ye sare formula lagaye wale colloms lock kar raha hu. To is wajase id number bhi manul dal nahi sakte.
How can we promote students to new class after completion of academic session? Sir help me please
Sir fee receipt wlaa aur pay fee ka kaise banana haiii
Hallo, No doubt have accurate knowledge but your explanation made me completely a mess. You did not show step by step procedure i.e. first what sheet (out of 3 'FeePay', 'Students', and 'Fee Receipt' sheets as you mentioned) we have to complete with formulas and what next etc. That is why I wish to contact you personally to get a clear picture. So, plz let me know how to contact you. Hope you will respond tge soonest. Thank you.
online fees lene k liye btaiye
PLEASE CREATE ACCOUNTING SOFTWARE WITH THE HELP OF EXCEL OR VBA
सर अगर ट्रांसपोर्ट फी डालनी होगी या फिर होस्टल फी डालनी होगी तो उसका कैसे होगा
ruclips.net/video/_3PUA1lEdn0/видео.html
If fees collecting is not monthly , how can change it change into 3 installment.
sir, admission no. A.001 se start hoga. ye kease input kore? Kindly tell me.
BRO ek column or insert kijiye jisme aapne likhna hai (A. B. C.) jo bhi aapka code hai ir is formula me index se pahle (cell address &) add karna hai for example.
Old formula =IFERROR(INDEX(ID,MATCH('Fees Pay'!D2,NAME,0)),"")
New formula =IFERROR(Cell address&INDEX(ID,MATCH('Fees Pay'!D2,NAME,0)),"")
@@ComputerGyanGuruji thank you sir
Sir,
In place of student id in your xl sheet
I want to generate Enrolment No in 'student details'
Pl guide me to do that
Fees pay me student ka name same ho to father name rorng so kerta h
sir fees receipt software kaise milega.
Explanation is not clear and confusing. He does not explain step by step i.e. first what sheet has to be prepared and what next etc. He does also not clearly show which sheet he is explaining and which sheet he is going into for which formula creation etc. No doubt he has knowledge but step by step clear explanation he is lacking. Better remake a full and complete one though it makes an hour or more.
Fees wali jo sheet hai usme aapne already formula lga rkha hai usko toh aapne bataya hi nhi bcz same process se mera ho hi nhi raha hai
Guru ji..jub v main admission Fees aur dep.amount main formula dal rha hu usmain #value dikh rha hai...0 nahi..
ye value error hai jahan se aap value le rahe hain usme check kare value sahi se nahi dali hai ya formula me galti kar rahe ho
Next video upload kariye plz sir
ruclips.net/video/vIvkaSdqjCc/видео.html
स्कूल में 3 सेक्शन है तो कैसे करें
section ki fees to utni hi rahegi bro fir bhi next video mein aapki dono problem solve ho jayengi file download ke liye description me link hai click karke download kar lijiye
Sir
start se bataiye
Bhai ye sheets send kro
1st sep. ko is video ke description se download kar lena
हमारे यहां 60 से 100 लोगों का समिति चलता है जिसमें हमलोग 100रु, जमा करते हैं और उसे आपस में ब्याज पर लेते हैं अगला महीना पुनः जमा करके कर्ज पर ले लेते हैं जो सदस्य मासिक नहीं जमा करते हैं उन्हें अतिरिक्त शुल्क के साथ जमा करना पड़ता है इसि तरह जो सदस्य मासिक नहीं जमा करते हैं उन्हें अतिरिक्त शुल्क के साथ जमा करना पड़ता हैं आप हमें ऐसा सोफ्टवेयर बताओ कि हमें अतिरिक्त शुल्क के साथ पिछला मासिक+ब्याज पता चले साथ ही टोटल रुपया तथा प्रति सदस्य का सेयर पता चले धन्यवाद मैं आपक आभारी रहूंगा
Auto Student ID - 20-3-001 how can I solve? 20 means session, 3 means class, 001 no, if i select class 3 then code willbe 20-3-001,if 2 then 20-2- 001. plz solve me, i will be grateful
jahan tak aapki baat se mujhe samajh aaya hai, yadi ye format aapke paas date me dikhata hai to isko general kar le or yadi auto generat id leha chahte hain to aap 3 hidden column lene honge or fir unko ek column me jointext ki madad se join karna hoga
@@ComputerGyanGuruji sir yea auto id, jab maine dropdown me se class me click karenge tab auto id generate hoga, 20 matlab session middle ka num class baki unique id
Sir apka email me format ka pic dia
Next part ka link kaha h
part - 2
ruclips.net/video/vIvkaSdqjCc/видео.html
Brother can u give this file on this email your co-operation is highly appreciated
Part -1 - drive.google.com/open?id=1U-rb1orxv9N1e_sUf9-bU54nj19A3uX5
Part - 2 - drive.google.com/open?id=1lLpetPnKufKxSW-uMC9g3xsNcOgmVJ8F
Sir apka nu chahiye bat karne ko mujhe aapse school software banwana hai
Hello
Sir File Save
Sir send kr na ye sheets
Hello
Send kro na sir
Hello
Send
Please
Sir send kro
Na
sir please my E-mail mukesh.kumar14@gmail.com per isko send kar dijiye
😭😭😭
Good
Sir
Please