Build a Clinic Attendance and Leave Tracker in Excel

<p>Kavya Nair runs Arogya Family Clinic in Pune: sixteen staff, a paper muster roll and a hand-typed leave register. Every month the payroll consultant needs each person's paid days and loss-of-pay days, and every month something doesn't add up. Across five lessons you build her attendance and leave tracker from zero in your own personal workbook: counting attendance codes with COUNTIF and mixed references, handling half days and paid weekly offs, counting leave in working days with NETWORKDAYS.INTL, totalling approved leave with SUMIFS, looking people up with XLOOKUP and flagging anyone over their leave limit. Along the way you learn to make numbers prove themselves: every day accounted for, the roll and the register agreeing. Every lesson then hands the same job to your AI (Copilot, ChatGPT, Claude or Gemini) and shows you how to catch its mistakes. In the capstone your agent builds August end to end, and you prove it right.</p>

Tools: COUNTIF and COUNTIFS, Mixed References, NETWORKDAYS.INTL, SUMIFS, XLOOKUP, Data Validation, Conditional Formatting, AI Assistants for Excel