🔥 Fully Automated Attendance Sheet in Excel | Attendance Sheet in Excel | MS Excel
ฝัง
- เผยแพร่เมื่อ 23 ก.ย. 2022
- 🔥 Fully Automated Attendance Sheet in Excel | Attendance Sheet in Excel | MS Excel
Welcome to Computer Gyan,
#msexcel #data_entry_in_excel #attendancesheet #attendance_sheet_in_excel
WPS Office for Windows
Best Office Suite for Docs, Sheets, Slides, and PDFs.
All Microsoft Word, Excel, and Powerpoint Formats are Compatible.
Available for Windows 11, Windows 10, Windows 8, and Windows 7.
bit.ly/3s7es05
Welcome to Computer Gyan,
in this video,
we will learn to create professional attendance sheet in excel. Attendance sheet is one of the important practical of excel, which is very important for all excel user.
watch this video and learn it easily to create attendance sheet.
Thank You.
App link- play.google.com/store/apps/de...
Related Searches:
data entry in excel,
ms excel,
attendance sheet,
attendance sheet in excel,
excel me attendance sheet kaise banaye,
attendance sheet in excel in hindi,
Fully Automated Attendance Sheet in Excel,
How to Maintain Attendance Sheet in MS excel in Hindi,
Excel में Attendance Sheet,
excel attendance sheet,
create attendance sheet in excel in hindi,
#attendance_sheet
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
Bht badhiya kya bat hai sir mind blowing
Baht kuchh sikha diya cool
God bless 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.
बहुत ही बढ़िया एज्युकेशनल व्हिडिओ है। सिखने में और बनाने में मजा आ गया।
भाईसाहब
धन्यवाद धन्यवाद धन्यवाद
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 ❣️
धन्यवाद सर आपकी इस वीडियो से मुझे बहुत कुछ सीखने को मिला आपके पढ़ाने का तरीका बहुत ही आसान और सरल है। आपकी इस वीडियो से मुझे बहुत help हुई है। धन्यवाद सर 🙏🙏
Kya rabshik chiz hai Excel, maja aa gya complete krke thnxxx boss 😎😎
Excellent format
Respected sir,
Can I do used your format only for one year or used by for any year
Superbbb
You had gr8 knowledge of excel
And know well how to distribute it
Wau sir aap bahut achhe se samjhate h
superb sir aapka samjhane ka tarika kisi ke paas nahi hai or aapki voice ka to koi jwab nhi.
Sir excel 2007 version me ye option nahi a raha hai aur mai data validation par click karte hi sheet lock bhi ho jati hai is problem ke bare me koi vedio banaye plZ sir
Thank You Sir ,सर आपने एक एक स्टेप को इतने अच्छे से समझाया.
Waooo..you know I am not sharing my feeling with you....
Kya amazing video share kiye h app ..Thanks3
bhai sahab jaisa aap kehte gaye mai karta gaya... video k saath saath maine bhi ye template bna liya. gajab ho bhai aap thankyou.
Sir apko video bahut acha laga sir apke jaisa kohi bhi nahi bolta
Very nice sir g aapne bahut achha se bataye hai
Thank you very much... Main video ke ssath sath hi attendance sheet banaya... Maja aagaya thanks again
Aap ki sare vedio very useful.
sir, bohat khoob ap bohat acchi tarha samjah rahey ho apki is best viedo ka shukria
Thanks a lot Sir,Super Very Nice sir 👍 Pure sal ka course Complete.
बहुत सुन्दर जानकारी धन्यवाद के पात्र हों जी
Good job..
Thanks for Good knowledge
Thanku sir your teaching method is very nice.
This is really helpful video thanks bhaiya ❤️❤️
Sir your teaching skill is very easy and you teaches everybody student very easily method
I love 💕 you sir
🙏🙏🙏🙏🙏🙏🙏
All videos super sir ji , thanks 👍 again
The way of explanation is very good.. anybody can understand. Thank You for Share your knowledge
Awesome Its new format for Lakhs of Hr professional ❤ Thank you soooooo much.May your channel got 10 millions of subscribers
Sir apka video dekhar bahut kuchh sikhne ko mila.
Mere taraf se thanks
सर, महीना चेंज करने पर तारीख , दिन चेंज हो रहे लेकिन डाटा महीने के साथ चेंज नही हो रहा है। डाटा सभी महीने मे वही रहता है, प्लीज मुझे समझाए कि इसको कैसे करे 🙏🏻
Well explained 👍
Very unique style teaching.amazig
Very nice 🎉Sir
Bohot simple and acha smjhaya sir ap nay
is there any way to write only roll number of present students with comma separation?
Useful video sir Thanks sir
i love you guru ji. bahut sikha hai maine aapke channel se love you .......
Thankyou so much sir for creating such video
Amazing to learn....❤❤❤
Thanks for valuable knowledge
Sir,बहुत अच्छी जानकारी मिली , आप का धन्यवाद ।
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.
Outstanding sir
Sir all videos u re very use full..sir i want please make..how to mange employees leave mange maneger
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
Thank you sooooooo much bhot acha ap nae Samjhya h plz aur Bhi chezen humko sekha dein .
If Saturday & Sunday, both days are weekend, then how I will validate in both cells? Please response. Thanks.
sir your teaching method isvvery nice😊😊😊😊
Very nice sir
Amezing video
very goog broo Teaching method is very very nice.
Very helpful loved it ❤
Are you very good teacher for TH-cam learning
great video in ever watch till now about excel related all information and i would to say one things is that can i learn excel from home does it need to go to institute or not and other things is that i have chromebook not a laptop so it is ok for the excel use anyways very useful video
Lots of love from Pakistan❤❤❤great work sir
Thanku sir very use full video
Good Job bro...Love from Bangladesh ❤️
I love india
It's so helpful
Sir your teaching technique is best
Thank you so much sir for your wonderful session,but at last I am not able to apply Sunday inter colour
Very impressive ❤
very nice brother your teaching method so good
Nice video sir ♥️🥰♥️ thanks sir
Thank you bhaiya 🎉❤
Excellent format
Thank you sir!!
Thank you sir❤
Excellent
Very nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
Sir but next month pr click krte hi same data ara aise tho sare hi save as krne pdege
Excellent sir ji 🙏🙏🙏
Thank you for making this useful video,but sir sab months me same name ajate hai use kaise seperate kar sakte hai uske baare me bhi ek video banaye.
Dear sir thanks
My question is ,in my sheet there are 2 shift in a day but formula is working in one shift if I merge both shift and drag then all days merge but I want only Sunday should be merge
very amozing video
@computerGyan1apki video bhht kaam ki thi .
Mera ek sawal ha ma jab month filter ma sa change krta hn to jo last month ma adding hwe thi attendence ki woi agay ajati ha usko kese lock krun
Sir ji 1 number smjyaa😊
Bahut jada kaam aane or sikhne wala video
Most useful technic bro
Very unique approach. But one thing I want know that how create month wise summary of every employee. Please guide me.
What about 2023? Is that automatically adjust date with week names? Like this year in this month Sunday on 25th September but in 25th September 2023 it's Monday not Sunday
th-cam.com/video/0ogS7xQw6rY/w-d-xo.html
Please check this Video. You can make Attendance Sheet of coming years with just 1 click. Even your query regarding 2023 will be solved
Data validation pr jake 2nd sheet open nhi ho rhii
Thank you so much sir
Great Effort, Plz guide, How we can change YEAR
When I entered Present in Jan Month... Its automaticaticy Fetch for Feb to Dec, which is very difficult to edit. @computer gyan
Asome vedio sir i relly respect ❤
Tally ki GST wali video bnao bhai
Sir aapse request hai ki aap excel ke logical function ke all formule ke uppar ek depply video bnao
Best teaching technique sir
Great sir 🙏🙏
Sir apka padhane ka tech bhoot achha hai
Apka coaching centre kha hai sir
Sir, mere mein jo formula sunday ke liye use kiya toh sabmein sahi hai but sep., and dec. mein All colunm red ho jaa rha hai.
In the date formula, i want to know what us the value of 1 and "" this .
Date value wale function mein bhai ne concatenate Kiya hai month ki phli tarikh aur year ko (&) iske dwara. Aur eom function mein 0 ka mtlb hai usi month ki last date. Eom function basically mahine ki last date ko show krta hai.
Thank You for the good informative video👌👌👌👍👍
We have employees working in different projects in the same month. So during cost allocation, how can we segregate employee in the time sheet. Please provide any such excel. Mostly these different projects in one single month are requires in contracting sector
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 👉
Thanks sir ❤❤❤
Bahut sundar.
Buhut Achi video
Thanks you sir