😮 Create Fantastic Fully Automated 👌Attendance Sheet in Excel | Hindi
Vložit
- čas přidán 3. 06. 2018
- 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.com/file/d/1UP7x...
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,
*New Video of Fully Advanced Attendance Sheet for 12 months* 👉 czcams.com/video/0Bdc1XftAwc/video.html Must Watch it 👌
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* czcams.com/video/Xkq0-xXAj48/video.html
*Complete Powerpoint Tutorial :* czcams.com/video/OekrBhNybP0/video.html
*Xlookup Complete Tutorial :* czcams.com/video/0LjfRVD7srU/video.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* czcams.com/video/C9y53fedo04/video.html
*Office Work in Excel :* czcams.com/video/PT8D1qQwe1k/video.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
Thank you very much, sir, for the most important tutorial you teach us. "Respect from Nepal"
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.
Thank your so much sir
First time kisi ki video really like krne Ka mn kr rha hai
Execellent Deepak sir..u r very talented..love u sir
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*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.
like your video what a great work for human beings
bundle of thanks for Deepak Educationworld
Dear Sir, it is excellence lesson. Thank you. Looking forward to learn more from you.
Friend, Excellent way to transfer knowledge. learnt a lot, thanks
how to extract only leave dates from this excel sheet using with formula.
Thanks very much.. Awesome lecture
Thank you so much sir : great job
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
how to create April 2019 to march 2020
czcams.com/video/0Bdc1XftAwc/video.html
Really you Are very professional Thank you
Yes we are waiting for this
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
Dipak Ji Ur Brilliant Thanks a Lot for Ur help u saved my lot of money God Bless U n Ur Loved 1s
this is awesome man, great, thanks a million
Bhai ap jab month change kar rahay hy tou sunday walay column may bhi Absent likha a raha hy is ka solution batai
czcams.com/video/0Bdc1XftAwc/video.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
Thaknyou deepak sir i just downloaded your vedio and completed too I learnt much about excel with this one vedio thanks alot
Wonderful explanation and so much helpful, thanks for tutor
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
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?
czcams.com/video/0Bdc1XftAwc/video.html
Hi Sir I am also facing same issue... I wanted to fix the problem in same file... Can that be done
@@DeepakEduWorld सर इस प्रॉब्लम का सोल्यूशन बताओ plz
Thank you sir👏👏👏
Great Job Bro...very useful video
सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने 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
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
czcams.com/video/0Bdc1XftAwc/video.html
Excellent Deepak the way you explained the Attendance Sheet preparation was very nice and easy to understand. Thanks alot.
Lovely vedio ...thanks for giving us that type of knowledge its so helpful.....and all the best for your future vedios.
SHIVAM SACHAN augb370
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
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
czcams.com/video/0Bdc1XftAwc/video.html
wonderful lesson!
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
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
Thanks foe this video....
thanks Sir....most important vadio for me. from pakistan
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
Bro. Tusi great ho
Sir, thank you for excellent lesson and teaching method.
Deepak sir ek doubt clear kr do agr hum month change krte h to Sunday har month me ku nhi off dikhata
Aisa kuch btao jese hum month change kre to Sunday automatically off ho har month ke
very nice style of teaching thank you great information
bhai thank u itna deep mein samjhane k liye
Thanks So helpful
Thanku sirr...
Thanks bro problem solve ❤️
Thank you sir apke smjhane ka tarika bahut achha hai so agin than thank you
😊😊
Thnkew very much it gives me a wonderful experience
🤗
U r so intelligent.... thank you for sharing the video
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)
😊
Thank you for sharing the knowledge...you earned a subscriber...I really love the way you taught ...please can you share from basics to MACRO and /VBA... Please
😊😊😊
Excellent
Easy to teach
Very good and easy method of using excel formulas. Thank you Mr. Deepak.
👍😊😊
Very nice video.... very useful thank you
😃
Very helpful 😊
Nice bahut hi achhi jankari mili
😊
Very useful Sir, thank you.
😊😊😊
Thank u sirji for the video
Thank you brother wish you all the best
thank you sir for this video.
Very nice sir, very very useful to us, thank u very much
Thanks alot for education share for the worlds, GOD BLESS 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
I have made from wacth your video. Working.
Thanks Deepak Bhai, Very knowledgeable video provided.. I learnt lot of things from this very video.
Thank you, Very good teaching.
👍😊
वाह दीपक जी वाह
this video is awesome but i am looking some different
Thankyou sir very helpful video 👌👌👌👌♥️
bht bht bht bht bht achi knowledge really helpful
Thank you bro its helpful
Thank u Deepak for sharing the excellent knowledge.it was very useful for my career.
Bahat acha deepak sir❤❤
Great !!
Out standing sir ji I am waiting for new video
your work looking awesome sir
Super thanks u r for update this video
Superb thank you sir.
👍
dipak ji aapke knowledge ka kmal hai
Great work Deepak. ! I learnt many things 😀
🤗🤗🤗
@@DeepakEduWorld Thank you sir
I looked for many videos, This one is the best
New attendance sheet for 12 months... czcams.com/video/0Bdc1XftAw/video.html 👍👍👍
Thanks bhaiii
For your valuable teaching
Useful video sir
Hi Deepak, thanks for ur guidelines. i have a concern. what is d use drop down in month format if same date is auto fill in attendance data if i change the month. i hope it should be convert into blank sheet if no data fill in the particular month. kindly help me out ASAP
Nice...very useful
mindblowing attendence sheet sir thank u so mauch
Amazing Bro thanks
Fantastic bro
VERY GOOD AND USEFUL VIDEO
😊
Thank you.
Zabardast!, great work
😊
Thank u Broo Nice Teaching Style with Knowledge. Excellent Keep it up.
😊😊😊
It's really very helpful Brother
really appreciated video.....good brother keep it up
😊
Thank you so much sir🤗👍👍👍👍
THANKS YOU SIR
Hi Deepak Thank you so much its so usefulness.
i was trying to make this type of roster but i unable to put months. i did copy in 2nd sheet but i couldnt paste in dialog box. i dont know its my laptop problem or what? please advice me. thank you
This video for me most useful thanks sir