😮 Create Fantastic Fully Automated 👌Attendance Sheet in Excel | Hindi
HTML-код
- Опубликовано: 3 июн 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* 👉 ruclips.net/video/0Bdc1XftAwc/видео.html Must Watch it 👌
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* ruclips.net/video/Xkq0-xXAj48/видео.html
*Complete Powerpoint Tutorial :* ruclips.net/video/OekrBhNybP0/видео.html
*Xlookup Complete Tutorial :* ruclips.net/video/0LjfRVD7srU/видео.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* ruclips.net/video/C9y53fedo04/видео.html
*Office Work in Excel :* ruclips.net/video/PT8D1qQwe1k/видео.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
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*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.
Thank you very much, sir, for the most important tutorial you teach us. "Respect from Nepal"
Dear Sir, it is excellence lesson. Thank you. Looking forward to learn more from you.
Execellent Deepak sir..u r very talented..love u sir
Friend, Excellent way to transfer knowledge. learnt a lot, thanks
Thank your so much sir
First time kisi ki video really like krne Ka mn kr rha hai
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.
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 extract only leave dates from this excel sheet using with formula.
like your video what a great work for human beings
bundle of thanks for Deepak Educationworld
Excellent Deepak the way you explained the Attendance Sheet preparation was very nice and easy to understand. Thanks alot.
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
Really you Are very professional Thank you
सर, हमने आपका अटेंडन्स शीट वाला व्हिडीओ देखा व्हिडिओ काफी अच्छा था । लेकिन हमे कुछ समस्या थी । अगर कर्मचारीयो की विकली ऑफ अलग अलग है तो उसको कैसे हायले किया जा सकता है ।
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?
ruclips.net/video/0Bdc1XftAwc/видео.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 apke smjhane ka tarika bahut achha hai so agin than thank you
😊😊
Wonderful explanation and so much helpful, thanks for tutor
how to create April 2019 to march 2020
ruclips.net/video/0Bdc1XftAwc/видео.html
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
Thaknyou deepak sir i just downloaded your vedio and completed too I learnt much about excel with this one vedio thanks alot
Nice bahut hi achhi jankari mili
😊
Bhai ap jab month change kar rahay hy tou sunday walay column may bhi Absent likha a raha hy is ka solution batai
ruclips.net/video/0Bdc1XftAwc/видео.html
सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने 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
this is awesome man, great, thanks a million
very nice style of teaching thank you great information
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
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
ruclips.net/video/0Bdc1XftAwc/видео.html
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 very much.. Awesome lecture
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
ruclips.net/video/0Bdc1XftAwc/видео.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
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
Very good and easy method of using excel formulas. Thank you Mr. Deepak.
👍😊😊
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
Thank you so much sir : great job
Great Job Bro...very useful video
Excellent
Easy to teach
Yes we are waiting for this
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)
😊
Thanks alot for education share for the worlds, GOD BLESS YOU
wonderful lesson!
U r so intelligent.... thank you for sharing the video
thanks Sir....most important vadio for me. from pakistan
bhai thank u itna deep mein samjhane k liye
Thank you sir👏👏👏
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
Thanks Deepak Bhai, Very knowledgeable video provided.. I learnt lot of things from this very video.
bht bht bht bht bht achi knowledge really helpful
Thanks foe this video....
Thank u Deepak for sharing the excellent knowledge.it was very useful for my career.
dipak ji aapke knowledge ka kmal hai
Thank you brother wish you all the best
Very nice sir, very very useful to us, thank u very much
Thanku sirr...
Thanks So helpful
Very helpful 😊
Thanks bro problem solve ❤️
mindblowing attendence sheet sir thank u so mauch
Thnkew very much it gives me a wonderful experience
🤗
Very nice video.... very useful thank you
😃
I looked for many videos, This one is the best
New attendance sheet for 12 months... ruclips.net/video/0Bdc1XftAw/видео.html 👍👍👍
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
Bro. Tusi great ho
Bahat acha deepak sir❤❤
वाह दीपक जी वाह
I have made from wacth your video. Working.
Very useful Sir, thank you.
😊😊😊
thank you sir for this video.
Out standing sir ji I am waiting for new video
Sir humane aapaka attdence walk
Vedio dekha baht achchha laga lekin kisi company ki salary sheet kaise banaye samjhane ka tarika achchha hai.
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
😊😊😊
It's really very helpful Brother
Thank you, Very good teaching.
👍😊
Thank u sirji for the video
your work looking awesome sir
really most most most informative video really you have professional thinking, your work very easy, but if we want that do every thing.
really
really
really
really
really
really
u r nice teacher
Nice...very useful
For your valuable teaching
This video for me most useful thanks sir
Thankyou sir very helpful video 👌👌👌👌♥️
Useful video sir
Sir namaste,
आप बहुत अच्छे से बताते है, आसानी से समझ मे आ जाता है.
एक प्रॉब्लम हो रही है, मैने Aug ki attendance शीट बनाई, जब इसमे month चेंज करते है तो aug का फिल किया हुआ डाटा sep मे भी आ जाता है. इसको कैसे ओके करें.pls बताये...🙏
New attendance sheet for 12 months... ruclips.net/video/0Bdc1XftAw/видео.html 👍👍👍
Execellent sir i love your talent
Zabardast!, great work
😊
Waw very nice video sir ji very good
Awesome Work
really appreciated video.....good brother keep it up
😊
VERY GOOD AND USEFUL VIDEO
😊
Super thanks u r for update this video
Thank u Broo Nice Teaching Style with Knowledge. Excellent Keep it up.
😊😊😊
Thank you bro its helpful
Fantastic bro
मेरी बहुत बडी समस्या का हल बताया है ।आपने सर जी इसके लिये दिल से आभार करते है ।
❤️
Superb thank you sir.
👍
It's too good sir jiii
Great work Deepak. ! I learnt many things 😀
🤗🤗🤗
@@DeepakEduWorld Thank you sir
Really good work