😮 Create Fantastic Fully Automated 👌Attendance Sheet in Excel | Hindi

Подписаться 1,2 млн

Просмотров 874 тыс.

50% 1

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,

Опубликовано:

18 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 1,9 тыс.

@prachandrakayastha4556 5 лет назад

Thank you very much, sir, for the most important tutorial you teach us. "Respect from Nepal"

@sunilkumar-cm2iw 5 лет назад

Thank you sir apke smjhane ka tarika bahut achha hai so agin than thank you

@DeepakEduWorld 5 лет назад

😊😊

@mmrameshkumar2279 3 года назад

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!

@mmrameshkumar2279 2 года назад

@Gauri Dhame No Sir

@dipakbhowmik2339 2 года назад

Same here. Did you find the solution

@Learn_With_Fun..... 2 года назад

I am also want know how to solve it please Deepak sir give us solution

@masterjitoo Год назад

Learn payroll from us

@harisp338 Год назад

Yes sir .even I have the same issue

@akansha123.4 2 года назад

U r so intelligent.... thank you for sharing the video

@rajendrakumarsinwar6719 3 года назад

Sir ak asi excel sheet banao jisme time In time out fir outomatic over time calculate hojaye.

@darkwarrior1879 Год назад

Mila kya

@Pihus123 5 лет назад

Nice bahut hi achhi jankari mili

@DeepakEduWorld 5 лет назад

😊

@DeepakEduWorld 5 лет назад

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

@AzharUddin-vg5ee 5 лет назад

Sir ap ni jo attendance sheet bena he ose m ek month ki results he next month ki results kese deki vo bate sir

@bikashrajak9480 5 лет назад

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

@rishabhjain9160 5 лет назад

And sir is there any way....which can inform us if we wrongly type any other word in the sheet except "P" and "A" ???

@NatureAnimallover-786 5 лет назад

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..

@anwarhossain9648 5 лет назад

sir, my keyboard f4 buttom if i clic dont lock my cell .how can i lock my cell plz im watting for your replay.

@ferozmd7942 4 года назад

Very nice sir, very very useful to us, thank u very much

@infomipw9633 5 лет назад

Friend, Excellent way to transfer knowledge. learnt a lot, thanks

@Akshayluvsu 4 года назад

Thank you brother wish you all the best

@Sachinchauhan021 4 года назад

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 🙄

@dharmendrarawat2524 3 года назад

Even I am also facing the same issue..do you know how to fix it?

@manishrahulninejun 3 года назад

Hi Sir, I am also facing the same issue... Could you please provide the solution.. I want to use this file itself

@Munadas93 3 года назад

Yes i am also facing same issue pls guide us asap .it will help me alot

@Shivaniverma24317 4 года назад

Very nice video.... very useful thank you

@DeepakEduWorld 4 года назад

😃

@fitnesstools123 6 лет назад

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

@chandankumar-jk5fg 6 лет назад

KARAN SINGH .. it is most important question which needs to be answered. Hope Deepak ji will answer it

@DeepakEduWorld 6 лет назад

Nice question.. Please wait. I will publish another video shortly on this topic.. Regarding your very nic query...

@jikcomputers4889 6 лет назад

sir make a video early about this problem . We are waiting.........

@suvendupradhan5458 6 лет назад

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.

@RailLoVeRSaHaNi 6 лет назад

Deepak EduWorld when u publish new video on this

@muhammadtalal4085 5 лет назад

Bhai ap jab month change kar rahay hy tou sunday walay column may bhi Absent likha a raha hy is ka solution batai

@DeepakEduWorld 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAwc.html

@SURYAPRAKASH-cm6xi 5 лет назад

VERY GOOD AND USEFUL VIDEO

@DeepakEduWorld 5 лет назад

😊

@pritam4you 5 лет назад

how to create April 2019 to march 2020

@DeepakEduWorld 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAwc.html

@sureshparmar1855 5 лет назад

LOWER SHEET FOR INDICATING "P" "A" NOT CHANGING MONTHWISE, ONLY SAT & SUN COLUMN IS HIGHLIGHED WITH COLOUR

@DeepakEduWorld 5 лет назад

I ll publish next part of this sheet as soon as possible

@shashikantbhide9185 5 лет назад

@@DeepakEduWorld YOU ARE PUBLISH THIS PROBLEM?

@DeepakEduWorld 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAwc.html

@manishrahulninejun 3 года назад

Hi Sir I am also facing same issue... I wanted to fix the problem in same file... Can that be done

@NaveenKumar-kd4ce 3 года назад

@@DeepakEduWorld सर इस प्रॉब्लम का सोल्यूशन बताओ plz

@abhishekchauhan2130 3 года назад

bhai thank u itna deep mein samjhane k liye

@mathewsenan8167 5 лет назад

how to extract only leave dates from this excel sheet using with formula.

@RajaThakur-ws1nh 4 года назад

Very useful video

@sandipkhanapure455 5 лет назад

सर, हमने आपका अटेंडन्स शीट वाला व्हिडीओ देखा व्हिडिओ काफी अच्छा था । लेकिन हमे कुछ समस्या थी । अगर कर्मचारीयो की विकली ऑफ अलग अलग है तो उसको कैसे हायले किया जा सकता है ।

@shubhamwani3190 5 лет назад

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.

@smaranamatrakeshava3762 5 лет назад

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

@sunitawelekar4416 4 года назад

Sir namaste, आप बहुत अच्छे से बताते है, आसानी से समझ मे आ जाता है. एक प्रॉब्लम हो रही है, मैने Aug ki attendance शीट बनाई, जब इसमे month चेंज करते है तो aug का फिल किया हुआ डाटा sep मे भी आ जाता है. इसको कैसे ओके करें.pls बताये...🙏

@DeepakEduWorld 4 года назад

New attendance sheet for 12 months... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAw.html 👍👍👍

@VedPrakash-cb9te 5 лет назад

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...

@DeepakEduWorld 5 лет назад

Next part of this sheet is coming shortly

@lokesh686 5 лет назад

@@DeepakEduWorld i am facing same problem..

@rishabhjain9160 5 лет назад

Yes same problem

@vikaskatiyar007 5 лет назад

I have resolve this issue

@poojachettri2200 5 лет назад

@@vikaskatiyar007 will provide us on the same

@MaheshMahi-iy9rf 4 года назад

Super thanks u r for update this video

@setuanubhav8971 6 лет назад

सर, हम जो अटेंडेंस शीट में डिटेल्स फील करते हैं अपने absent present वही.डिटेल हमें अगले महीने में दिखाई देती है

@DeepakEduWorld 6 лет назад

Please wait.. I will publish video as soon as possible on this topic

@neerajchaudhary9860 6 лет назад

Sir plz give solution as soon as b. coz its very need full

@neerajchaudhary9860 6 лет назад

Sir plz solve the query as soon as

@40keshav 6 лет назад

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.

@ashwini_makeup_artist_07 6 лет назад

@@DeepakEduWorld ak hi month ka data fill krte hai to sabhi me vahi fill hota sir solution to batao hame

@excelclassesmobileexcel893 5 лет назад

dipak ji aapke knowledge ka kmal hai

@Panther09Playz 5 лет назад

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

@DeepakEduWorld 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAwc.html

@riteshsrivastav6335 5 лет назад

Very nice videos sir

@Ravikumar-rd7cv 4 года назад

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

@DeepakEduWorld 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAwc.html

@AhsanKhan-sm8vn 3 года назад

mindblowing attendence sheet sir thank u so mauch

@bidyadharrabha4033 5 лет назад

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

@sahilarya2306 5 лет назад

true

@sonalithanekar7227 5 лет назад

Yes k koi solution nhi h kya. Baki sab achha h

@nandanrana2676 5 лет назад

Sahi me bhai

@masti_time5013 5 лет назад

@@sonalithanekar7227 vba use kar sakte hai

@niveditapandey9023 5 лет назад

TRUE

@poojakarn2771 2 года назад

Thank you so much Sir , how much effort you do to teach us

@zemtechnology4474 5 лет назад

very nice style of teaching thank you great information

@DeepakEduWorld 4 года назад

*New Video of Fully Advanced Attendance Sheet for 12 months* 👉 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAwc.html Must Watch it 👌 दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰 *My New Channel :* bit.ly/3qFrbl5 *Complete Microsoft Word Tutorial :* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Xkq0-xXAj48.html *Complete Powerpoint Tutorial :* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OekrBhNybP0.html *Xlookup Complete Tutorial :* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0LjfRVD7srU.html *Vlookup Complete Tutorial* : bit.ly/2K0C1Sb *Excel All Formulas :* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C9y53fedo04.html *Office Work in Excel :* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PT8D1qQwe1k.html

@---tz2ug 4 года назад

@sushilyadav5805 4 года назад

Sir g vba coading se related vdo bno koi jisme alg alg month ka data save ho

@jyotimishra5796 4 года назад

Sir 2007 me work nahi horha

@arabindaghose2058 4 года назад

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.

@rubyshah3382 4 года назад

Hello sir meri salary list me month by month present and absent change nhi ho rha h to kya krna pdega

@MuhammadTahir-dm7mr 5 лет назад

best teacher

@DeepakEduWorld 5 лет назад

😊♥️♥️

@nextstepsknowledge2438 4 года назад

I have made from wacth your video. Working.

@studentstoteachers2396 5 лет назад

Thank your so much sir First time kisi ki video really like krne Ka mn kr rha hai

@srivatsavas1325 Год назад

Thank you so much. It helped me a lot

@savitripal873 5 лет назад

Thaknyou deepak sir i just downloaded your vedio and completed too I learnt much about excel with this one vedio thanks alot

@fazalmaula4001 2 года назад

ماشااللہ سر آپ بہت اچھی ویڈیوز بنا رہے ہیں سر پلیز آپ اس طرح کریں کہ VBA میں بھی اس طرح کی ویڈیوز بنائیں تو ہمیں VBA بھی سمجھ آ جائے گا Thanks a lot

@ghurahuprasadyadav3798 4 года назад

मेरी बहुत बडी समस्या का हल बताया है ।आपने सर जी इसके लिये दिल से आभार करते है ।

@DeepakEduWorld 4 года назад

❤️

@nmjkumbla4579 5 лет назад

Very good and easy method of using excel formulas. Thank you Mr. Deepak.

@DeepakEduWorld 5 лет назад

👍😊😊

@newmovie5125 4 года назад

Very good video

@poojaVerma-hi3hh 5 лет назад

This video for me most useful thanks sir

@sarojanandpathak1033 4 года назад

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.

@rheapeter9709 Год назад

Thank you sir!!

@sudarmadimadi7826 3 года назад

Thanks alot for education share for the worlds, GOD BLESS YOU

@ravijadhav5933 5 лет назад

Useful video,Nice

@DeepakEduWorld 5 лет назад

😊

@AnilKumar-go7hj 4 года назад

Waw very nice video sir ji very good

@Mahadev_Priest_ 4 года назад

Thankyou sir very helpful video 👌👌👌👌♥️

@divyasri5910 5 лет назад

Superb

@dinabandhugouda9720 5 лет назад

You are great yeaar

@DeepakEduWorld 5 лет назад

🤗😊

@jaisingh9829515091 4 года назад

hello sir nice and important secession thanks

@happy___boy___7860 5 лет назад

वाह दीपक जी वाह

@bibinazia9444 3 года назад

Assalam u Alaikum sir. I created cash book, Day book and now I am working on attendance sheet. thank u sir from Pakistan

@DeepakEduWorld 3 года назад

New attendance sheet for 12 months... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAw.html 👍 Here is one More NEW Interesting video on ATTENDANCE SHEET ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l6ORdfIENDY.html

@bibinazia9444 3 года назад

@@DeepakEduWorld inshaa Allah I will watch it.

@ganpatihardware5619 3 года назад

your work looking awesome sir

@newsandvlogs9130 3 года назад

Bahut Dhanyavad, Jai Siyaram.

@muhammadkamran8555 2 года назад

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

@rajeshchoudhary2520 5 лет назад

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

@siddhkumar5580 5 лет назад

Sir humane aapaka attdence walk Vedio dekha baht achchha laga lekin kisi company ki salary sheet kaise banaye samjhane ka tarika achchha hai.

@greeneyes4496 5 лет назад

Really you Are very professional Thank you

@chandrabhanu7626 5 лет назад

Thank you, Very good teaching.

@DeepakEduWorld 5 лет назад

👍😊

@nagendrab.4368 5 лет назад

Super bro awesome

@DeepakEduWorld 5 лет назад

😊😊

@tanveerahmad533 4 года назад

very well done

@DeepakEduWorld 4 года назад

@mansuribhai9918 5 лет назад

Super guru

@DeepakEduWorld 5 лет назад

🤗😊😊

@brijmohan8594 5 лет назад

nice video antligents

@DeepakEduWorld 5 лет назад

🤗😊😊

@vinay0991 5 лет назад

Thanks bhaiiii

@koushikmandal8311 4 месяца назад

Bahat acha deepak sir❤❤

@arshiyasiddiqui8086 5 лет назад

bht bht bht bht bht achi knowledge really helpful

@newmovie5125 4 года назад

Thanks sir....

@leenaflower3709 4 года назад

Thank u Deepak for sharing the excellent knowledge.it was very useful for my career.

@ghanshyammeena3629 4 года назад

Very nice 👌👍👍👍

@ramachandrannatarajan4234 5 лет назад

Useful

@manpreetbhamra2180 5 лет назад

Excellent Easy to teach

@Tum_Aur_Hum 3 года назад

Thank you so much sir🤗👍👍👍👍

@raghulamani1347 5 лет назад

Useful video sir

@moodkn 5 лет назад

Lot of Thanks Mr.Deepak very helpful Excel attendance sheet!

@bidyadharrabha4033 5 лет назад

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

@RafiqKhan-xp2ic 4 года назад

Mere dost deepak thanks

@learngrow6556 4 года назад

Good work👌👌👌

@moinkhan4155 4 года назад

Thank you bro its helpful

@drjaykumarsingh815 5 лет назад

Really good work

@arvindkumarmishra5574 5 лет назад

very nice vedio

@noormohammed8976 4 года назад

Thanks Deepak Bhai, Very knowledgeable video provided.. I learnt lot of things from this very video.

@watisthis 4 года назад

I looked for many videos, This one is the best

@DeepakEduWorld 4 года назад

New attendance sheet for 12 months... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0Bdc1XftAw.html 👍👍👍

@shahidrehmat7636 5 лет назад

Awesome Work

@chaitratoravi8805 5 лет назад

Very useful Sir, thank you.

@DeepakEduWorld 5 лет назад

😊😊😊

@surajverma5346 5 лет назад

Good evening sir

@DeepakEduWorld 5 лет назад

😊 good morning

@ARIFKHAN-lg4pb 5 лет назад

Superb thank you sir.

@DeepakEduWorld 5 лет назад

👍

@ambarnayak4029 5 лет назад

For your valuable teaching

@murtuzaali3856 6 лет назад

Execellent sir i love your talent

@muhammadiftikhar5856 5 лет назад

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)

@DeepakEduWorld 5 лет назад

😊