Stylish Attendance Tracker with Symbols in Excel

preview_player
Показать описание
#AttendanceSheet #ExcelTemplates
Hello Friends,

In this video, You will learn how to create a Stylish Attendance Tracker with Symbols in Excel. It is an innovative and attractive Attendance Template because we have used Symbols in place of attendance codes (e.g Present, Absent, etc.)

Download the practice files from below given link:

Download the Free Project Management Dashboard

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

Visit our Amazon Store
Рекомендации по теме
Комментарии
Автор

You are genius sir thank you for teaching us . Make us god of excel.❤️❤️

azimuddin
Автор

excellent explanation. Any lay man can understand. Once again very very great.

srinivasvayuvegula
Автор

Thank you for making out time to put together this clip. I have tried to do the conditional formating for the webbing text but it keeps showing the wrong symbol. What can i do??

ransomchidi
Автор

how do i add half days in this sheet please explain

flightofdreams-sf
Автор

Awesome work, i have one question for you. How can I have the marked days with symbols moves along when we change the month period. in other word, if I changed the month period the attendance sheet in the schedule also follow it the change period. for example, if X person attended on 1st. Jan but did not attend on 1st Feb then when i change the month above I want to have the attendance also be changed with the change of month so I can meet my exact match of the attendance.

صقر_الجزيرة
Автор

That was some heavy formatting. Thank you PK. I'm glad I went through that lesson. I feel like I learned conditional formatting a lot better. Thank you.

nsanch
Автор

If u change any month the previous month data is not saved.. it ll display for every month same..say if i mark March 1st as present..nd change April month ...data for March 1st is still appears.. were it supposed to be new sheet for april

SD-bquk
Автор

Thank you PK, have learned a lot by watching your videos

MrSoy
Автор

Hi Bro .Thank you for incridible video . I am from Uzbekistan . I am having problem with formula it cant type (=text ) this formula doesnt work what can I do ?

coding
Автор

conditional formating custom rule not working, it shows only 'a' instead of symbol. please tell me anything else to do

sureshkumarpantla
Автор

Sir
Assume, we have columns emp code, name, date and attendance from 1 to 31. How to clear cells as per the date updated in column number 3. If i put date as 4th march 2021, I need the cells as blank from columns 5th March to 31st March. If it is possible, pls help..

nullhas
Автор

Can you make a video on 3 × 8 hour weekly Shift planner for 30 days with alternating week shifts with changing week off after every week to preceding day??

bhalchandragodse
Автор

Thank you! Just got my new monitoring sheet.

johnfebrero
Автор

Dear PK, IF ATTENDANCE MENTIONED 21st TO 20th of month then...if make a vedio if possible 😊

innerpeacefindings
Автор

Plz make one video for software office administrator work in Excel. All in one vid 🙏🙏plz

azimuddin
Автор

Can you check if the practice file format is correct ?
It's downloading as txt file.

mirrorreflection
Автор

Hi sir please explain how to rotate each shift as 10 to 17 staff roster approximate 3 shift

ashannavemula
Автор

How to do background color .. that blue color

Danisdx
Автор

Sir 24 hour attendance for Petrol Pump shift

munawarnazir
Автор

Hindi me banoa sir apke subscriber aur jyada badh jayenge

johndas