Stylish Attendance Tracker with Symbols in Excel

Sdílet
Vložit
  • čas přidán 20. 02. 2021
  • #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:
    www.pk-anexcelexpert.com/styl...
    Download the Free Project Management Dashboard
    www.pk-anexcelexpert.com/exce...
    Download our free Excel utility Tool and improve your productivity:
    www.pk-anexcelexpert.com/prod...
    See our Excel Products:
    www.pk-anexcelexpert.com/prod...
    Visit to learn more:
    Chart and Visualizations: www.pk-anexcelexpert.com/cate...
    VBA Course: www.pk-anexcelexpert.com/vba/
    Download useful Templates: www.pk-anexcelexpert.com/cate...
    Dashboards: www.pk-anexcelexpert.com/exce...
    Watch the best info-graphics and dynamic charts from below link:
    • Dynamic Graphs
    Learn and free download best excel Dashboard template:
    • Excel Dashboards
    Learn Step by Step VBA:
    • VBA Tutorial
    Website:
    WWW.PK-AnExcelExpert.com
    Facebook:
    / pkanexcelexpert
    Telegram:
    t.me/joinchat/AAAAAE2OnviiEk5...
    Pinterest:
    / pkanexcelexpert
    Visit our Amazon Store
    www.amazon.in/shop/pkanexcele...

Komentáře • 48

  • @nsanch0181
    @nsanch0181 Před 3 lety +3

    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.

  • @KhalilAhmad74036
    @KhalilAhmad74036 Před 3 lety

    Once more with an interactive video, Thanks, and appreciated your efforts!

  • @MrSoy007
    @MrSoy007 Před rokem +1

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

  • @SahilSahil-vo1yw
    @SahilSahil-vo1yw Před 3 lety

    Awesome!! It's really helpful for me as well. Thank you so much for this video. Good Job!! Much appreciated!!

  • @srinivasvayuvegula4630
    @srinivasvayuvegula4630 Před 3 lety +1

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

  • @azimuddin9936
    @azimuddin9936 Před 3 lety +1

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

  • @johnfebrero6859
    @johnfebrero6859 Před 2 lety +1

    Thank you! Just got my new monitoring sheet.

  • @mirrrvelll5164
    @mirrrvelll5164 Před 3 lety

    Amazing man! Will to do by myself and use it later =)

  • @khanhtranman1774
    @khanhtranman1774 Před 3 lety +1

    thanks very much! It is useful

  • @nnbona
    @nnbona Před 3 lety

    very useful file I do like it so much PK

  • @kishorpanara4191
    @kishorpanara4191 Před 3 lety

    You are excel magician

  • @صقر_الجزيرة
    @صقر_الجزيرة Před 2 lety +1

    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.

  • @rajkgpt.01
    @rajkgpt.01 Před 3 lety

    You are genius sir🙏

  • @mustafeosman1
    @mustafeosman1 Před 3 lety

    Thanks.

  • @ransomchidi3786
    @ransomchidi3786 Před měsícem

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

  • @Debbiexue99
    @Debbiexue99 Před 3 lety +1

    thanks alot :P

  • @mirrorreflection3479
    @mirrorreflection3479 Před 3 lety

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

  • @bhalchandragodse4514
    @bhalchandragodse4514 Před 2 lety

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

  • @azimuddin9936
    @azimuddin9936 Před 3 lety

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

  • @rash9366
    @rash9366 Před 3 lety

    Nice..

  • @zahirbabar8055
    @zahirbabar8055 Před 3 lety

    What about the public holidays in the setting sheet?

  • @ajinkyanaik6651
    @ajinkyanaik6651 Před rokem

    Dear Sir,
    Please upload such more video

  • @coding3800
    @coding3800 Před 2 lety

    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 ?

  • @ashannavemula4134
    @ashannavemula4134 Před 2 lety

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

  • @nullhas
    @nullhas Před 3 lety

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

  • @SD-bq5uk
    @SD-bq5uk Před rokem

    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

  • @Danisdx
    @Danisdx Před 3 lety

    How to do background color .. that blue color

  • @sureshkumarpantla
    @sureshkumarpantla Před 3 lety

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

  • @user-qk6rw6zt5g
    @user-qk6rw6zt5g Před 7 měsíci

    how do i add half days in this sheet please explain

  • @innerpeacefindings1046

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

  • @munawarnazir163
    @munawarnazir163 Před 3 lety

    Sir 24 hour attendance for Petrol Pump shift

  • @johndas8173
    @johndas8173 Před 3 lety

    Hindi me banoa sir apke subscriber aur jyada badh jayenge