Certification Expiry Tracker Spreadsheet

I need an Excel workbook that lets me track employee certifications and, most importantly, the expiration dates tied to each one. The sheet should give me a quick, color-coded view of who is current and who is slipping out of compliance.

Scope and key features
• Master table for every employee’s name/ID, certification type, issue date, and expiration date.
• Automatic “Compliance” status that turns green when a certification is current, yellow when it is within a set reminder window, and red once it has expired.
• Simple drop-downs so I can add new certification types without breaking formulas.
• Dynamic filters and basic pivot summaries so I can pull lists by department, location, or approaching-expiration window.
• A clean dashboard page that highlights total certified staff, upcoming renewals, and past-due items in real time.
• Brief instructions built into a hidden tab so any future administrator knows how to maintain the file.

Please build the spreadsheet entirely in Microsoft Excel, using formulas, conditional formatting, and built-in tables—no macros are required. I’d like a functional, polished workbook that I can start using right away and tweak as our training program grows.