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 ❣️
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
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
Very useful tutorial explained in a simple and convincing manner. Thank you so much. Sir, I just want to ask you one question. After inserting data validation and conditional formatting in ' SUNDAY" COLUMNS, if i wish to include 'H' for holiday in there , how to do it, without disturbing the conditional formatting and data validation. Kindly explain.
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 😎😎
धन्यवाद सर आपकी इस वीडियो से मुझे बहुत कुछ सीखने को मिला आपके पढ़ाने का तरीका बहुत ही आसान और सरल है। आपकी इस वीडियो से मुझे बहुत help हुई है। धन्यवाद सर 🙏🙏
bhai sahab jaisa aap kehte gaye mai karta gaya... video k saath saath maine bhi ye template bna liya. gajab ho bhai aap thankyou.
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
Sir apko video bahut acha laga sir apke jaisa kohi bhi nahi bolta
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 ❣️
Sir apka video dekhar bahut kuchh sikhne ko mila.
Mere taraf se thanks
Aap ki sare vedio very useful.
Sir ji 1 number smjyaa😊
Sir mere bahut hi kam aaya ye formate thankyou so much
sir your teaching method isvvery nice😊😊😊😊
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.
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 🙏
Wau sir aap bahut achhe se samjhate h
Lots of love from Pakistan❤❤❤great work sir
بہت ہی اچھا ماشاء اللّٰہ
Sir your teaching skill is very easy and you teaches everybody student very easily method
I love 💕 you sir
🙏🙏🙏🙏🙏🙏🙏
Thanku sir your teaching method is very nice.
Are you very good teacher for RUclips learning
All videos super sir ji , thanks 👍 again
Bohot simple and acha smjhaya sir ap nay
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
Sir your teaching technique is best
Waooo..you know I am not sharing my feeling with you....
Kya amazing video share kiye h app ..Thanks3
sir, bohat khoob ap bohat acchi tarha samjah rahey ho apki is best viedo ka shukria
Very nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
बहुत सुन्दर जानकारी धन्यवाद के पात्र हों जी
very nice brother your teaching method so good
Good Job bro...Love from Bangladesh ❤️
I love india
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
very goog broo Teaching method is very very nice.
Thanks for valuable knowledge
Thankyou so much sir for creating such video
Very nice sir g aapne bahut achha se bataye hai
Asome vedio sir i relly respect ❤
Really appreciated ❤
Best teaching technique sir
Amazing to learn....❤❤❤
This is really helpful video thanks bhaiya ❤️❤️
Superbbb
You had gr8 knowledge of excel
And know well how to distribute it
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.
Very good an informative video.
Awesome Its new format for Lakhs of Hr professional ❤ Thank you soooooo much.May your channel got 10 millions of subscribers
Thank You Sir ,सर आपने एक एक स्टेप को इतने अच्छे से समझाया.
Thank you sooooooo much bhot acha ap nae Samjhya h plz aur Bhi chezen humko sekha dein .
Good job..
Thanks for Good knowledge
Thank you bhaiya 🎉❤
Buhut Achi video
Thanks you sir
It's so helpful
Very helpful loved it ❤
Love you bro❣️❣️❣️
Amezing video
Very nice 🎉Sir
Keep going ❤
Excellent sir ji 🙏🙏🙏
Manmohan Kumar Vishwakarma 🙏🙏🙏👏🙏👏👏
Good job keep it up 👍
Very unique style teaching.amazig
Bahut sundar.
Thanku sir very use full video
Very nice sir
Great sir❤❤
Than you so much sir ❤
Nice class sir ji super
Dear brother 🙏 If I have thousands like so i will give you thousands like on your video 😊🙏thanku soo much 🙏
Most useful technic bro
Thanks sir ❤❤❤
Superb sir very nice
Informative video..
Nice Sir👍👍
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.
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 👉
Thank you🙏
Bohot aacha h sir
Nice video sir ♥️🥰♥️ thanks sir
Good topic sir .
Thanks sir ji ❤
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
Outstanding sir
Nice explanation
Great method
Zbr10 lecture
Thanks 😊😊
Very useful tutorial explained in a simple and convincing manner. Thank you so much. Sir, I just want to ask you one question. After inserting data validation and conditional formatting in ' SUNDAY" COLUMNS, if i wish to include 'H' for holiday in there , how to do it, without disturbing the conditional formatting and data validation. Kindly explain.
most beautiful sir ji
Thank you so much sir
very helpful video
Thank you so much sir
Thank you so much sir
Sir very nice beautiful
Great sir 🙏🙏
The way of explanation is very good.. anybody can understand. Thank You for Share your knowledge
👍Good