Description

🧑‍💼 Applicant Tracking System (ATS) in Excel

Your One-Stop Hiring Dashboard Built in Excel

🎯 Why Choose This Excel ATS?

Are you a recruiter, HR professional, or small business owner tired of clunky, overpriced applicant tracking software?
This powerful, fully customizable Excel-based ATS helps you track, manage, and analyze every stage of your hiring process — with no learning curve.

✅ Built with advanced Excel formulas, slicers, and VBA
✅ Real-time dashboards with KPIs & funnel tracking
✅ Works with Office 365 (or compatible Excel versions)
✅ One-time payment – yours to keep forever

📊 What You Get

Interactive Dashboard

• Visualize the entire recruitment funnel:
• % of candidates per stage
• Average time in stage (days)
• Days to hire
• Applications per hire
• Source effectiveness & conversion rates
  Easily filter results using slicers by:
• Department
• Recruiter
• Time period
• Job location
  Everything updates instantly.

Smart Job & Applicant Management

• With built-in VBA-powered user forms, adding and updating data is a breeze.
  Manage with 6 buttons:
• ➕ New Job
• ✏️ Update Job
• 👤 New Applicant
• 🔄 Update Applicant
• 🧹 Clear Filters
• 📂 Unhide Data Sheets
• Create, update, and close jobs and applicants while Excel handles the backend magic.

Real-Time Status Tracking

• Track who passed each stage (CV review, phone interview, manager interview, offer, etc.) and who’s currently in the pipeline.
  Failed or closed applicants are automatically filtered out to keep your view clean and focused.

Automated Source Analysis

• See where your best hires come from. The dashboard calculates:
• Number of hires per source
• Conversion % from each source
• Time to fill by source

🛠️ How It Works

✅ Step 1: Add a Job
Fill out the user-friendly form with title, location, recruiter, job type, and number of openings.

✅ Step 2: Add Applicants
Attach applicants to specific jobs, track their source, submission date, and progress.

✅ Step 3: Update Status
Move applicants through stages with just a few clicks — track results like pass/fail/scheduled.

✅ Step 4: Fill the Position
Once all positions are filled, the system automatically closes the job and removes applicants from the active view.

🧩 Fully Customizable

• Add your own job titles, locations, departments, recruiters
• Adjust dropdown lists in the “Lists” tab
• Modify forms and layout using standard Excel tools
• Easily extend the template to suit your organization’s needs

🔐 Built-In Data Protection

All backend data sheets are hidden by default to ensure a clean interface. Click a button to unhide when needed.

🎥 Watch It in Action

Get a full walkthrough of how to use the system, add jobs and applicants, and manage your pipeline.

📦 What’s Included in Your Purchase?

1. ✅ Fully Unlocked Excel File (.xlsm)
2. ✅ Lifetime Use – One-Time Payment
3. ✅ Free Updates & Email Support
4. ✅ Bonus: Shortcut to Clear All Filters

📧 Questions?

Need help customizing the file for your workflow?
Reach out and I will be happy to help!