Create a dynamic Attendance Control 🕜 with Excel
👩💻 Create your own Attendance Tracker 🕜, whether for: Students, Company Staff, etc., where you can measure not only the number of absences, but also tardiness, attendance percentage, highlight those who didn't meet the minimum attendance, those with perfect attendance, etc. 👍😁
✅ 00:00 Intro
✅ 01:08 Step #1 - Obtain a List of Dates ONLY from Monday to Friday.
✅ 06:06 Step #2 - Configure the Table (Table Display).
✅ 09:02 Step #3 - Add Conditional Formatting
✅ 13:41 Reviewing the COUNTIFS Function.
✅ 16:16 Step #4 - Count Absences and Tardiness (Display Time)
✅ 19:37 Step #5 - Total Absences per Day
✅ 22:20 Step #6 - Calculate Attendance (%)
✅ 23:43 Step #7 - Highlight those who did not meet the Minimum Attendance requirement
✅ 25:59 Step #8 - Highlight those with Perfect Attendance
-----------------------------------------------------------
👀LINKS to the videos that reference Conditional Formatting:
• 6 formatos condicionales sencillos QUE TOD...
• 🟡 RESALTAR toda la fila cuando diga "X" te...
• Avance GRÁFICO del proyecto - EN EL PROPIO...
-----------------------------------------------------------
👨💻 If you want to download the video file to practice, download it at the following link:
https://smartprosoluciones.com/crea-u...
-----------------------------------------------------------
✅🚀 MY TRAINING
DO YOU WANT TO CATAPULT YOUR SKILLS WITH Want to master EXCEL and stand out from the crowd of professionals?
Excellent! Visit my academy's website for more information about my training courses:
https://www.smartprosoluciones.com/
---------------------------------------------------------------------------------------------------------
Let's stay connected! 😁:
Instagram and Facebook: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
► TikTok: / smartproacademy
---------------------------------------------------------------------------------------------------------
💡💻 Get the Microsoft 365 version of Excel (Starting at $5.99 USD):
https://click.linksynergy.com/fs-bin/...
🎥💻 I use this program to produce and edit my videos: https://techsmith.z6rjha.net/c/273772...
#excel #microsoftexcel #excelcreators #MicrosoftAmbassador