Checklist in Excel

Kenji Explains • 10 days ago

Original source

What This Video Is About

This video tutorial demonstrates how to create a dynamic checklist in Excel to track attendance and calculate attendance percentage. The tutorial provides step-by-step instructions on how to insert checkboxes, customize their appearance, and use formulas to count the number of days present and calculate the attendance percentage.

Major Ideas Discussed

  • Creating a dynamic checklist in Excel by inserting checkboxes into relevant cells.
  • Customizing the appearance of checkboxes by changing their colors.
  • Using the spacebar or mouse to check or uncheck the boxes.
  • Counting the number of days present using a COUNTIF formula that counts true values behind each checkbox.
  • Calculating the attendance percentage by dividing the number of days present by the total number of days.

What to Watch Next

Viewers can apply these skills to track attendance in various settings, such as work or school, and explore more advanced Excel formulas to analyze and visualize their data.