Vaad Training Academy

ADDMUK TRAINING MATRIX

📊 System Overview

Total Courses

Training Bundles

Organizations

Staff Members

📈 Training Status Summary

🚀 Getting Started

📋 Quick Start Guide:

Step 1: Download Bundle Template

Click " 📥 Download Bundle Template" button above to get a blank Excel template. Fill it in with your bundle names and the courses in each bundle. (Column-based format: each column = one bundle)

Step 2: Upload Bundle Definitions

Click " 📦 Upload Bundles" button and select your filled-in bundle template. This defines which courses belong to each training bundle.

Step 3: Upload Staff Training Data

Click " 📤 Upload Staff Data" button and select your staff training records Excel file.
Required columns: Department, Staff Name, Bundle, Training Date, Expiry Date, Booked Date
Format: Each sheet = one organization

💡 Tip: The system is completely empty until you upload data. Start with Step 1!

📈 Detailed Analytics

Filter Analytics:

📋 Training Matrix View

Organization (Required):

Department (Required):

📚 Manage Courses

➕ Add New Course

Course Name:

📦 Manage Training Bundles

➕ Add New Bundle

Bundle Name:

Default Expiry Duration (days): ℹ️ This sets how long training is valid. When uploading staff data without expiry dates, the system will calculate: Training Date + these days = Expiry Date

Select Courses (hold Ctrl/Cmd for multiple):

🏢 Manage Organizations

➕ Add New Organization

Organization Name:

Departments (comma-separated):

📄 Training Records

📋 Step-by-Step Filter

Select in order: Organization → Department → Staff Member

1️⃣ Organization:

2️⃣ Department:

3️⃣ Staff Member:

Additional Filter:

👥 Staff Management

Add Staff to Bundle

Organization:

Department:

Training Bundle:

Staff Name:

Training Date:

🖨️ Bulk Reports Generator

📋 Generate Multiple Training Reports

Select filters to generate PDF reports for multiple staff members at once

🔍 Filter Selection