1. Open the Excel file containing the "Automated Attendance Sheet with Check boxes."
2. Ensure the "PK's Utility Tool V3.0" add-in is active in the Excel ribbon.
3. Navigate to the "PK's Utility Tool V3.0" tab in the ribbon.
4. Click on the "Tutorials and Downloads" option to access any relevant tools or templates.
5. Look for a tool or function within the add-in that allows for the automation of attendance tracking, such as a "Check Box Manager" or "Attendance Automation" feature.
6. Use the tool to select the range of cells containing the check boxes for the month of January 2024.
7. Configure the tool to count the number of checked boxes (present days) and calculate the attendance percentage based on the total number of days in January (31 days).
8. Ensure the "Present," "Total Days," and "Attendance%" columns are updated automatically with the correct values.
9. Verify that the attendance percentages are calculated correctly by comparing a few entries manually.
10. Save the updated attendance sheet to preserve the changes.
Parent Tip: Review the logic above to help your child master the concept of free excel worksheet.
