😮 Create Fantastic Fully Automated 👌Attendance Sheet in Excel | Hindi
Вставка
- Опубліковано 25 сер 2024
- Easily create/make Fully Automated Attendance Sheet in Excel hindi - Learn How to Make a fully automatic Attendance Sheet / salary sheet in MS excel in Hindi. and how to use excel formulas to make a attendance | #salarysheet | #payrollsheet. this #attendancesheet is fully automated with some new features.
automatically fill months date.
automatically fill weekdays date.
automatic highlight saturdays & sundays for month.
automatic highlight absense and presense.
how to calculate leave charges
Payroll calculation
Video link for 12 months automatic attendance sheet with salary • How To Make Attendance...
New Date to Date Attendance Sheet video : • How To Maintain Attend...
Plz Also Subscribe My New Channel DEEPAK TECHWORLD : / @deepaktechworld
Download Training File drive.google.c...
1. Attendance sheet previous video : How to Maintain Attendance Sheet in MS excel in Hindi | How to Make Attendance Sheet In Excel. Microsoft Excel मैं Attendance sheet कैसे बनाते हैं Attendance sheet / salary sheet बनाने के लिए कौन कौन से formulas उपयोग मैं आते हैं और उनका उपयोग कैसे करते हैं इस Attendance sheet मैं हम calculate करेंगे Monthly attendance, Total Absence, Total Presence, PF, DA, HRA, Per Day Amount, Total Salary, In Hand Salary आदि
• How to Maintain Attend...
2. Excel - कुछ नया सीखो 😮 - Automatically Generate Month Dates 👌 Based On DropDown List HINDI. Automatically Generate Month Dates Based On Drop Down List in Excel Hindi. Its very easy to fill date of a months automatically on month selection from dropdown list. by using datevalue, if and eomonth functions. and this automatic date series is most usefull while creating monthly records. Automatically Generate Month Dates Based On DropDown List in excel 2007 2010 2013 2016 by deepak nehra [ deepak eduworld ]
• Excel - कुछ नया सीखो 😮...
3. HOW TO MAKE PAYROLL sheet IN EXCEL [ salary sheet / Payslip ] 2007/2010/2013/2016. Do you want to make salary sheet/ payroll sheet /pay slip /employee payroll report in Excel, do you want to prepare all salary data in excel but do not know how to make a salary sheet in excel then look no further. In this video you will learn to create a salary sheet in excel which has allowances, deductions, attendance, advance, pf, taxes ,etc.
Calculating - City Compensatory Allowance, Dearness Allowance, House Rent allowance, PF, Taxable salary, TDS, salery after TDS,
Excel मे payroll / salary sheet कैसे बनाए
• How to Create Salary S...
Hope you will like the video. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
________________________________________________
ADVANCED MS EXCEL ► goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS ► goo.gl/bbHYu2
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER Tips & Tricks ► goo.gl/paZmpn
---------------------------------------------------------------------------
---------------------------------------------------------------------------
Subscribe to my channel ► / deepakeduworld
Like my Facebook page ► / deepakeduworld
Follow on LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
**********************************************
Thanks for Watching
Happy Learning
ER DEEPAK NEHRA [ M.Tech. ]
**********************************************
Deepak eduworld, deepak eduworld excel, computer user, excel user, billing software, deepak eduworld hindi, hindi technology, excel tutorial,
Hi Deepak, Seems there is a flaw with the automatic sheet. Pls assist with the query below,
1) If data is updated in the sheet (say P or L) of any month initially, the same would reflect in other months as well when we list down the months/change months.
2) How can we show empty columns for the coming month's when changed, so that attendance can be tracked accordingly.
Hope to see your response soon. Thank You!
@Gauri Dhame No Sir
Same here. Did you find the solution
I am also want know how to solve it please Deepak sir give us solution
Learn payroll from us
Yes sir .even I have the same issue
Execellent Deepak sir..u r very talented..love u sir
Thank you sir apke smjhane ka tarika bahut achha hai so agin than thank you
😊😊
U r so intelligent.... thank you for sharing the video
Thank you very much, sir, for the most important tutorial you teach us. "Respect from Nepal"
Friend, Excellent way to transfer knowledge. learnt a lot, thanks
Nice bahut hi achhi jankari mili
😊
ماشااللہ سر آپ بہت اچھی ویڈیوز بنا رہے ہیں
سر پلیز آپ اس طرح کریں کہ VBA میں بھی اس طرح کی ویڈیوز بنائیں تو ہمیں VBA بھی سمجھ آ جائے گا Thanks a lot
Sir ak asi excel sheet banao jisme time In time out fir outomatic over time calculate hojaye.
Mila kya
NICE BRO I have one Query ki agar hum month change krte hai kya pichla data jo ki hmne pichle month attendance bhari this vo save rhega isme. ki har baar hme new sheet banaani padedi. matlab ye hai ki hmne is sheet ko bna liya hia attendance har mahina ki lagaani hoti hai agar baad me hame maan lo may ki attendance dekhni hai aur hum isi sheet se may month ko select krte hai kya hum may ki attendance jo fill ki this dekh payenge isme ki nahi
KARAN SINGH .. it is most important question which needs to be answered. Hope Deepak ji will answer it
Nice question.. Please wait. I will publish another video shortly on this topic.. Regarding your very nic query...
sir make a video early about this problem . We are waiting.........
KARAN SINGH deepak sir same problem . The data which i prepared for may that is also coming on the month June. Pls tell us how to solve this.
Deepak EduWorld when u publish new video on this
Thank you brother wish you all the best
मेरी बहुत बडी समस्या का हल बताया है ।आपने सर जी इसके लिये दिल से आभार करते है ।
❤️
Sir this is nice but when i change month then presence and absence data will not change if you can give trick so it will work otherwise this sheet is totally waste and i also waste my time 🙄
Even I am also facing the same issue..do you know how to fix it?
Hi Sir, I am also facing the same issue... Could you please provide the solution..
I want to use this file itself
Yes i am also facing same issue pls guide us asap .it will help me alot
Bhai ap jab month change kar rahay hy tou sunday walay column may bhi Absent likha a raha hy is ka solution batai
ua-cam.com/video/0Bdc1XftAwc/v-deo.html
Very nice sir, very very useful to us, thank u very much
Sir namaste,
आप बहुत अच्छे से बताते है, आसानी से समझ मे आ जाता है.
एक प्रॉब्लम हो रही है, मैने Aug ki attendance शीट बनाई, जब इसमे month चेंज करते है तो aug का फिल किया हुआ डाटा sep मे भी आ जाता है. इसको कैसे ओके करें.pls बताये...🙏
New attendance sheet for 12 months... ua-cam.com/video/0Bdc1XftAw/v-deo.html 👍👍👍
सर, हमने आपका अटेंडन्स शीट वाला व्हिडीओ देखा व्हिडिओ काफी अच्छा था । लेकिन हमे कुछ समस्या थी । अगर कर्मचारीयो की विकली ऑफ अलग अलग है तो उसको कैसे हायले किया जा सकता है ।
play.google.com/store/apps/details?id=comm.example.takemyroll_teacher.takemyroll_ssw
Sir, please try this app
It will help you do all this with just few clicks.
Please mention WK off with a new colour as they assigned a separate colour for leave & absent , then search as WK off in table you will find your results
LOWER SHEET FOR INDICATING "P" "A" NOT CHANGING MONTHWISE, ONLY SAT & SUN COLUMN IS HIGHLIGHED WITH COLOUR
I ll publish next part of this sheet as soon as possible
@@DeepakEduWorld YOU ARE PUBLISH THIS PROBLEM?
ua-cam.com/video/0Bdc1XftAwc/v-deo.html
Hi Sir I am also facing same issue... I wanted to fix the problem in same file... Can that be done
@@DeepakEduWorld सर इस प्रॉब्लम का सोल्यूशन बताओ plz
bhai thank u itna deep mein samjhane k liye
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Sir ap ni jo attendance sheet bena he ose m ek month ki results he next month ki results kese deki vo bate sir
Hi Deepak, I am also facing the same issue, I have prepared the attendance sheet and I understand the procedure. But when I have filled the attendance for January, some of the data from January will get reflect to the other month. When I will change the month from January to other.
Please help us
And sir is there any way....which can inform us if we wrongly type any other word in the sheet except "P" and "A" ???
Im just loving yur videos, what if I need to highlight only Sunday ,then how can I do that., because you highlight sat,Sunday for weekly holidays but I need only sunday.can u help me please how to drive this formula..
sir, my keyboard f4 buttom if i clic dont lock my cell .how can i lock my cell plz im watting for your replay.
how to extract only leave dates from this excel sheet using with formula.
Very nice video.... very useful thank you
😃
Rajesh, Deepak sir ji aapne video me attendance sheet banaanaa sikhaaye vo bahut badhiya bataaye, aur aage me ye kahna chaha raha hu ki mujhe ase hi data entry excel ki job bataiye kahi bhi, aaj me excel me full expected hu lekin kahi job mil hi nahi pa rahi hai, to aap jaroor-2 data entry ki job bataiye, aur video achha hai
how to create April 2019 to march 2020
ua-cam.com/video/0Bdc1XftAwc/v-deo.html
Sir...when you change the month, the days and day is changing, but the details of absent and present is not changing .....what ever we enter in one month the same is being displayed for all the months?? Ravi kumar
ua-cam.com/video/0Bdc1XftAwc/v-deo.html
Thank your so much sir
First time kisi ki video really like krne Ka mn kr rha hai
सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में दिखाई देती है
Please wait.. I will publish video as soon as possible on this topic
Sir plz give solution as soon as b. coz its very need full
Sir plz solve the query as soon as
Deepakji Namaste, I am facing the same problem. will be greatful if you can solve this major issue. I am also waiting for this query.
@@DeepakEduWorld ak hi month ka data fill krte hai to sabhi me vahi fill hota sir solution to batao hame
Thanks sir but isme hamne January k month m presents fill ki to bahi presents next month m bhi fill rahati h. Aisa kyo kuchh upay sir...
Next part of this sheet is coming shortly
@@DeepakEduWorld i am facing same problem..
Yes same problem
I have resolve this issue
@@vikaskatiyar007 will provide us on the same
dipak ji aapke knowledge ka kmal hai
Thaknyou deepak sir i just downloaded your vedio and completed too I learnt much about excel with this one vedio thanks alot
Video toh pura banao yaar absent and present toh vaise hi reh jate hain fuddu wali harkatein mat karo yaar part 2 abhi tqk banaya ni
ua-cam.com/video/0Bdc1XftAwc/v-deo.html
Isko bananeka koi value hi nahi he kyuki date change karnese jo likha vo change hi nahi hota he to itna mehenat karne ka kya faida
true
Yes k koi solution nhi h kya. Baki sab achha h
Sahi me bhai
@@sonalithanekar7227 vba use kar sakte hai
TRUE
Very good and easy method of using excel formulas. Thank you Mr. Deepak.
👍😊😊
Your style to teach on line is fantastic. you describes each line very smartly that students want. Thanks a lot.Marvelous jobs. Keep it up.
*New Video of Fully Advanced Attendance Sheet for 12 months* 👉 ua-cam.com/video/0Bdc1XftAwc/v-deo.html Must Watch it 👌
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* ua-cam.com/video/Xkq0-xXAj48/v-deo.html
*Complete Powerpoint Tutorial :* ua-cam.com/video/OekrBhNybP0/v-deo.html
*Xlookup Complete Tutorial :* ua-cam.com/video/0LjfRVD7srU/v-deo.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* ua-cam.com/video/C9y53fedo04/v-deo.html
*Office Work in Excel :* ua-cam.com/video/PT8D1qQwe1k/v-deo.html
Hi
Sir g vba coading se related vdo bno koi jisme alg alg month ka data save ho
Sir 2007 me work nahi horha
Mr Deepak I am facing serious problem in setting the day and date and I am unable to go ahead in this video plz look to this and give me quick solution.
Hello sir meri salary list me month by month present and absent change nhi ho rha h to kya krna pdega
I have made from wacth your video. Working.
very nice style of teaching thank you great information
VERY GOOD AND USEFUL VIDEO
😊
Sir humane aapaka attdence walk
Vedio dekha baht achchha laga lekin kisi company ki salary sheet kaise banaye samjhane ka tarika achchha hai.
Assalam u Alaikum sir. I created cash book, Day book and now I am working on attendance sheet. thank u sir from Pakistan
New attendance sheet for 12 months... ua-cam.com/video/0Bdc1XftAw/v-deo.html 👍 Here is one More NEW Interesting video on ATTENDANCE SHEET ua-cam.com/video/l6ORdfIENDY/v-deo.html
@@DeepakEduWorld inshaa Allah I will watch it.
great bro, great bro,.... bro ap aik attandence sheet bna kr dikhao k jb staff apni attandence khud lagay to us ka arrival time khud ba khud lag jay k ya staff mamber is time pr offuce pohancha ha. thanks bro
Excellent Deepak sahib you have very well knowledge about Excel I have seen yours more video about excel my child says that uncle Deepak has fully command in formulas of Excel.
( Kamal ha bie)
😊
Bahat acha deepak sir❤❤
Thank you so much Sir , how much effort you do to teach us
mindblowing attendence sheet sir thank u so mauch
Super thanks u r for update this video
Thankyou sir very helpful video 👌👌👌👌♥️
वाह दीपक जी वाह
Thanks alot for education share for the worlds, GOD BLESS YOU
Very useful video
your work looking awesome sir
This video for me most useful thanks sir
Thanks Deepak Bhai, Very knowledgeable video provided.. I learnt lot of things from this very video.
Thank u Broo Nice Teaching Style with Knowledge. Excellent Keep it up.
😊😊😊
Very nice videos sir
Deepak ji.. It's very gud
Ab tk video me sbse best h ye
So dear sir keep it up
Thanku
WHEN WE CHANGE MONTH , ATTENDANCE NOT CHANGING , KINDLY LET US HOW CHANGE ATTENDANCE TOO . VERY GOOD VIDEO BEST PLACE TO LEARN EXCEL
I also need help with this
ua-cam.com/video/0Bdc1XftAwc/v-deo.html
Thank you so much. It helped me a lot
Thank u Deepak for sharing the excellent knowledge.it was very useful for my career.
Sir video bahut acha hai.
Likin sir next year ka kise karege. Next year ka kise banayege
Next video on attendance sheet is coming shortly
Bahut Dhanyavad, Jai Siyaram.
Good job..
Can I use this for student attendance also... Or need to change some format
Thank you sir!!
Lot of Thanks Mr.Deepak very helpful Excel attendance sheet!
Not helpful man its seems smart but actualy there is nothing valueable this is just waste of time you just try tum khud ko gali dene lagoge ek bar try karke dheko
Waw very nice video sir ji very good
best teacher
😊♥️♥️
hello sir
nice and important secession
thanks
आपकी vedio काफी बेहतरीन है और इसके अनुसार मैंने भी एक अटेंडेंस शीट बनाया लेकिन इसमें एक बहुत बड़ी प्रॉब्लम है और प्रॉब्लम ये है कि मैंने 2019 के लिए बनाया है किंतु 2019 के बाद 2020 भी आएगा तो 2020 को कैसे मेंशन करे कि 20 की अटेंडेंस शीट के लिए फिर उतनी मेहनत करनी पड़ेगी अगर इसका कोई सलूशन हो तो जरूर बताएं और अपने ही vedio पे ही बताए कि किस फॉर्मूले में एडिट करे कि 2019 2020 हो जाये
जैसे कि फर्स्ट डेट या लास्ट डेट में भी कुछ एडिट करने का ऑप्शन नही आ रहा है या
D 6 सेल में भी एडिट करने का कोई ऑप्शन नही है कि उसे 2020 कर सके
Nice job man. Learn alot from your videos. es format me jab aik month ki entries kar lyty hain phir jb next month ko select karty hain tu wohi entries dobara ajati hain. agar entries ko delete kar dain tu previous month sy be khatam ho jati hain. es ka koi hal bataye plz.
I ll publish next part of this video shortly
@@DeepakEduWorld Thanks and will be waiting for the new video.
Mere dost deepak thanks
Thank you, Very good teaching.
👍😊
thank you sir .... nice video next month ke liye new sheet create karni padti he kaya
Noooo.. I m publishing another video shortly on this topic
I looked for many videos, This one is the best
New attendance sheet for 12 months... ua-cam.com/video/0Bdc1XftAw/v-deo.html 👍👍👍
Very good video
this is very bioinformatic Love from Pakistan bro
😊
Great job Deepak.....👍🏻
😊
Dipak Ji Ur Brilliant Thanks a Lot for Ur help u saved my lot of money God Bless U n Ur Loved 1s
i am from Pakistan my name is Ali very nice it,s very Good video thank you
Very nice
Really you Are very professional Thank you
Thank you so much sir🤗👍👍👍👍
Useful video,Nice
😊
Your video is really valuable.
Please further guide me how to automatically post the journal entry to relevant ledger accounts just like accounting softwares. I am managing my accounts in excel i have to post the entry indually which take a lot of time
Excellent Deepak the way you explained the Attendance Sheet preparation was very nice and easy to understand. Thanks alot.
Dear Sir, it is excellence lesson. Thank you. Looking forward to learn more from you.
Deepkji, Very nice हम आपका हर वीडियो देखते हैं एवं कई लोगों को देखने के लिए भी कहते हैं मैं अटेंडेंस वाली इस वीडियो का ऑफिस में उपयोग करूँगा I will use in my office but I have one problem हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में भी दिखाई देती है जबकि होना यह चाहिए की जब हमने current महीने की अटेंडेंस fill कर दी तो ये अगले महीने नहीं दिखना चाहिए अगले महीने ब्लेंक होना चाहिए एवं हम जब लीव काउंट करें तो monthwise count होना चाहिए उसके बाद पुरे वर्ष की काउंट हो जाये कृपा इसका वीडियो अपलोड कीजिये तो अच्छा होगा |
G blkul.. Please wait.. I ll publish another video on this topic... Shortly
Superb, Wonderful, excellent and marvellous. Suppose I want to mark second saturday &third saturday instead of all Saturdays how to proceed?
Thanks bhaiiii
Great work Deepak. ! I learnt many things 😀
🤗🤗🤗
@@DeepakEduWorld Thank you sir
bht bht bht bht bht achi knowledge really helpful
Very nice 👌👍👍👍
Good evening sir
😊 good morning
Thank you bro its helpful
Excellent
Easy to teach
You are great yeaar
🤗😊
Execellent sir i love your talent
like your video what a great work for human beings
bundle of thanks for Deepak Educationworld
It's really very helpful Brother
Superb
really appreciated video.....good brother keep it up
😊
Good work👌👌👌