The way of presentation is to be appreciated, and it's very helpful video. There's a mistake in this video though. When i mark the attendence for September month the same is being updated to every month automatically.(in the same column despite of holidays) And when i tried to change the attendence for other months it's effecting the whole data. How can it be resolved? Is there ny additional formula to be applied for that? Plzz respond as soon as possible
Sir ji maine 1 year ka course complete kiya but aapke 1 video ne mujhko sab kuch sikha diya jitna main 1 year mein na seekh paya so thanks a lot dear sir
धन्यवाद सर आपकी इस वीडियो से मुझे बहुत कुछ सीखने को मिला आपके पढ़ाने का तरीका बहुत ही आसान और सरल है। आपकी इस वीडियो से मुझे बहुत help हुई है। धन्यवाद सर 🙏🙏
VERY IMPRESSIVE .I HAVE BEEN LEARNING EXCEL BY YOU FOR FEW MOUNTH AND I AM ALSO TEACHING MY STUDENTS . WHATEVER I HAVE ISSUES RELATED TO EXCEL IS CLEARED . I AM FOND OF YOUR TEACHING STYLE IT HELPED ME A LOTS MILLIONS THANKS TO YOU ❣️
How to apply data validation 1st from the 2nd sheet :- • Open a new sheet (1st sheet) •then selected the work data (column wise/ row wise) •then go to the formula tabe •then click on the defined name option ( Be side of Function Library) •then write a specific name •then click the ok button •then enter 2nd Sheet •then click on the Data tab •then go to the Data Validation Option •then click on any value to list option •then see the source list •then write the = a specific name ( written on 1st sheet Formula tab defined name option) •then click on the ok button •then you will see the drop down list shown of the selected cell on the 2nd sheet. *** Its method is applicable of the 2007 version Excel.
Thanks for info its really helpful. I wanted to create a daily dashboard from the data .. if that would have been added in this template, it would have been more helpful
i m from pakistan....excellent superp..fabulous teaching style...keep it up...ek ek farmula ek ek method boht zbrsst ar achay andaz m breafly sikharhy hn...dost app...shabsh
WPS Office - Best Alternative to Microsoft office, download for Windows 11, Windows 10, Windows 8, and Windows 7.
bit.ly/3s7es05
The way of presentation is to be appreciated, and it's very helpful video. There's a mistake in this video though. When i mark the attendence for September month the same is being updated to every month automatically.(in the same column despite of holidays) And when i tried to change the attendence for other months it's effecting the whole data. How can it be resolved? Is there ny additional formula to be applied for that? Plzz respond as soon as possible
Eirirh
Yyrgrgeheh😅😮🎉🎉ygxhdhdñdñdmd,d deyueyehdhdhddhfrkfkkdordóeoir
❤ very nice thanku sir
Hii sir please reply🙏🙏🙏 month change kr rhe h to month ka data change nhi ho rha
Sir ji maine 1 year ka course complete kiya but aapke 1 video ne mujhko sab kuch sikha diya jitna main 1 year mein na seekh paya so thanks a lot dear sir
Certificate mila apko
Ek Sal me Excel hi nhi sikha hoga na
Yeh fake comment hai auto hai ...Maine kitne hi video pe yeh comment dekha
@@faizankazi9512 nhi ye shi baat h maine bhi ek saal ka diploma kiya h mujhe bhi nhi dikhai gyi thi ye
Bht badhiya kya bat hai sir mind blowing
Baht kuchh sikha diya cool
God bless you sir
i love you guru ji. bahut sikha hai maine aapke channel se love you .......
Kya rabshik chiz hai Excel, maja aa gya complete krke thnxxx boss 😎😎
बहुत ही बढ़िया एज्युकेशनल व्हिडिओ है। सिखने में और बनाने में मजा आ गया।
भाईसाहब
धन्यवाद धन्यवाद धन्यवाद
Sir ji 1 number smjyaa😊
धन्यवाद सर आपकी इस वीडियो से मुझे बहुत कुछ सीखने को मिला आपके पढ़ाने का तरीका बहुत ही आसान और सरल है। आपकी इस वीडियो से मुझे बहुत help हुई है। धन्यवाद सर 🙏🙏
sir your teaching method isvvery nice😊😊😊😊
bhai sahab jaisa aap kehte gaye mai karta gaya... video k saath saath maine bhi ye template bna liya. gajab ho bhai aap thankyou.
Very nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
kamaal explaine karte ho SIR
Thanks 😊
@@ComputerGyan1 use ful video sir
@@ComputerGyan1 but sir mere window me koi sa month to pura hi red fill ho raha hai plz sir solution 🙏
Keep going ❤
Aap ki sare vedio very useful.
Thanks a lot Sir,Super Very Nice sir 👍 Pure sal ka course Complete.
Thank you very much... Main video ke ssath sath hi attendance sheet banaya... Maja aagaya thanks again
Really appreciated ❤
Amazing to learn....❤❤❤
Lots of love from Pakistan❤❤❤great work sir
Wau sir aap bahut achhe se samjhate h
All videos super sir ji , thanks 👍 again
Sir apko video bahut acha laga sir apke jaisa kohi bhi nahi bolta
बहुत सुन्दर जानकारी धन्यवाद के पात्र हों जी
Very good an informative video.
THIS IS VERY VERY EASY AND UNDERSTANDING METHOD SIR THANK YOU SO MUCH FOR YOUR EFFORT
superb sir aapka samjhane ka tarika kisi ke paas nahi hai or aapki voice ka to koi jwab nhi.
Sir apka video dekhar bahut kuchh sikhne ko mila.
Mere taraf se thanks
Good Job bro...Love from Bangladesh ❤️
I love india
Sir your teaching skill is very easy and you teaches everybody student very easily method
I love 💕 you sir
🙏🙏🙏🙏🙏🙏🙏
Superb👍👍👍👍 U r Teaching method is very very nice. Full understanding. U r explain each formulas how to make. That is very important for understanding.
Waooo..you know I am not sharing my feeling with you....
Kya amazing video share kiye h app ..Thanks3
Asome vedio sir i relly respect ❤
Are you very good teacher for RUclips learning
Best teaching technique sir
Very nice 🎉Sir
This is really helpful video thanks bhaiya ❤️❤️
Nice Sir👍👍
Sir mere bahut hi kam aaya ye formate thankyou so much
Thanku sir your teaching method is very nice.
Great sir❤❤
Amezing video
very nice brother your teaching method so good
VERY IMPRESSIVE .I HAVE BEEN LEARNING EXCEL BY YOU FOR FEW MOUNTH AND I AM ALSO TEACHING MY STUDENTS . WHATEVER I HAVE ISSUES RELATED TO EXCEL IS CLEARED . I AM FOND OF YOUR TEACHING STYLE IT HELPED ME A LOTS
MILLIONS THANKS TO YOU ❣️
Love you bro❣️❣️❣️
Sir your teaching technique is best
sir, bohat khoob ap bohat acchi tarha samjah rahey ho apki is best viedo ka shukria
Very nice sir g aapne bahut achha se bataye hai
Thanks for valuable knowledge
Bohot simple and acha smjhaya sir ap nay
Excellent sir ji 🙏🙏🙏
very goog broo Teaching method is very very nice.
Very nice sir
Informative video..
Very helpful loved it ❤
Superb sir very nice
Good job keep it up 👍
Superbbb
You had gr8 knowledge of excel
And know well how to distribute it
Thank you very so much sir vidio bahut hi helpful hai .mai ak compani accountant ka kaam karti hu mujhe aisi aur vidio ki jarurat hai
It's so helpful
Nice class sir ji super
بہت ہی اچھا ماشاء اللّٰہ
Good job..
Thanks for Good knowledge
Awesome Its new format for Lakhs of Hr professional ❤ Thank you soooooo much.May your channel got 10 millions of subscribers
Thankyou so much sir for creating such video
Thank you bhaiya 🎉❤
Bahut sundar.
Nice explanation
Zbr10 lecture
Thank you sooooooo much bhot acha ap nae Samjhya h plz aur Bhi chezen humko sekha dein .
Outstanding sir
Thanks sir ❤❤❤
👍Good
Good topic sir .
Than you so much sir ❤
Thank You Sir ,सर आपने एक एक स्टेप को इतने अच्छे से समझाया.
Most useful technic bro
Very unique style teaching.amazig
Thanku sir very use full video
Very impressive ❤
Buhut Achi video
Thanks you sir
Nice video sir ♥️🥰♥️ thanks sir
very helpful video
Good job sir
Great sir 🙏🙏
Thanks sir ji ❤
Bohot aacha h sir
Thank you🙏
Great method
Excellent format
Sir very nice beautiful
How to apply data validation 1st from the 2nd sheet :-
• Open a new sheet (1st sheet)
•then selected the work data (column wise/ row wise)
•then go to the formula tabe
•then click on the defined name option ( Be side of Function Library)
•then write a specific name
•then click the ok button
•then enter 2nd Sheet
•then click on the Data tab
•then go to the Data Validation Option
•then click on any value to list option
•then see the source list
•then write the = a specific name ( written on 1st sheet Formula tab defined name option)
•then click on the ok button
•then you will see the drop down list shown of the selected cell on the 2nd sheet.
*** Its method is applicable of the 2007 version Excel.
Thanks for info its really helpful. I wanted to create a daily dashboard from the data .. if that would have been added in this template, it would have been more helpful
Useful video sir Thanks sir
Excellent
Thank you so much sir
i m from pakistan....excellent superp..fabulous teaching style...keep it up...ek ek farmula ek ek method boht zbrsst ar achay andaz m breafly sikharhy hn...dost app...shabsh
Sir ji apki teaching to bahut achi hai,or apki avaj to or bhi jyada mast h...❤️🙏☺️
fix kaise kiya o skip kr diya
@@PraveshKumar-ou1qb f4key
Right 👉
Good lesson.
Manmohan Kumar Vishwakarma 🙏🙏🙏👏🙏👏👏
most beautiful sir ji