People Data in Practice: Managing HR Data with Excel
Spreadsheet Proficiency & Experiential Learning Lab (SPELL)
Course Overview
Human Resources professionals regularly manage large amounts of employee information, from personnel records and recruitment trackers to attendance reports, performance results, compensation data, and workforce summaries. However, many HR teams still rely on separate spreadsheets, inconsistent formats, manual updates, and repetitive reporting processes.
As a result:
- Employee records become difficult to maintain and verify.
- Recruitment and onboarding updates require repeated manual consolidation.
- Attendance, attrition, and headcount reports take too much time to prepare.
- Performance and compensation data are stored but not easily summarized.
- HR teams spend more time fixing spreadsheets than using the information they contain.
People Data in Practice: Managing HR Data with Excel is a highly practical, hands-on Excel course designed for HR beginners who want to improve the way they organize, clean, manage, analyze, and report people data.
The course focuses primarily on essential Excel skills and data management techniques, using common HR files and scenarios as practical applications. Participants will work with employee records, recruitment data, attendance and attrition information, performance results, compensation records, and other HR datasets.
Rather than focusing heavily on HR theories or policies, the program equips participants with practical spreadsheet skills they can immediately apply to their daily work. By the end of the course, participants will be able to create cleaner HR databases, reduce manual work, summarize workforce information, and prepare more reliable reports using Excel.
Investment Rates:
Student Rate (must present ID): ₱5,600.00 (including tax)
Super Early Bird Rate (pay on or before August 13, 2026): ₱6,000.00 (including tax)
Early Bird Rate (pay from August 14 to September 10, 2026): ₱6,500.00 (including tax)
Regular Rate (pay from September 11 to September 23, 2026): ₱7,000.00 (including tax)
Learning Objectives
By the end of the program, participants will be able to:
Course Outline
Module 1: Reframing HR Data Management
Participants will explore the common challenges HR teams face when managing employee information in spreadsheets and learn the characteristics of a reliable HR data system.
Module 2: Building an Employee Master Database
Participants will learn how to organize employee records into a structured and consistent Excel database that can serve as the foundation for other HR reports.
Module 3: Cleaning and Standardizing HR Data
Participants will apply practical Excel tools and formulas to clean employee information imported from forms, systems, emails, and other files.
Module 4: Improving Data Accuracy and Control
Participants will learn how to reduce encoding errors and make HR spreadsheets easier and safer to update.
Module 5: Managing Recruitment and Onboarding Data
Participants will build and manage practical trackers for applicant movement, hiring status, and onboarding completion.
Module 6: Managing Attendance, Leave, and Attrition Data
Participants will use Excel to organize and summarize attendance-related information and workforce movement.
Module 7: Managing Performance and Compensation Data
Participants will learn how to organize sensitive HR records and prepare basic summaries for performance and compensation reporting.
Module 8: Summarizing HR Data with Formulas
Participants will apply essential Excel formulas to answer common HR questions and automate recurring calculations.
Module 9: Analyzing People Data with PivotTables
Participants will learn how to quickly summarize large HR datasets without manually creating multiple formulas.
Module 10: Creating Practical HR Reports
Participants will transform HR data into clear and useful reports that can support regular updates and management discussions.
Module 11: Building an Efficient HR Excel Workflow
Participants will combine the techniques learned throughout the course into a more organized and repeatable HR data management process.
Who Should Attend?
This course is designed for beginners and early-career HR professionals who regularly use Excel to manage employee information and prepare HR reports.
It is ideal for:
- HR assistants and HR associates
- HR administrators and coordinators
- Recruitment and talent acquisition staff
- Compensation and benefits staff
- Timekeeping, attendance, and payroll support staff
- Employee relations and engagement staff
- Performance management support staff
- Training and onboarding coordinators
- Office administrators handling employee records
- New HR professionals who want to strengthen their Excel skills
No advanced Excel knowledge is required. Participants should be familiar with basic spreadsheet navigation, data entry, and simple formulas.