Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel for Strategic HR
Time Saving HR Case Studies
3 hour per month task reduce to less than 1 minutes
Top 50 Excel Function for HR Guide (worth 10X of the price)
Pivot Table - Analyze HR Payroll Data
How to Find the Total Salary and Headcount for each department faster with Pivot Table (5:33)
Analyze Payroll by Month (9:59)
How many absences for each employee had using Pivot Table (7:02)
Salary Guide 2021
Malaysia Salary Simulator Tool (5:43)
Turn your Nightmare into Sweetdream
Transforming your Monthly Payroll Report into Pivot Table readable format X10 Time faster (10:39)
dashboard - Data Cleasing Process - remove unwanted row in HR Payroll Monthly Data (7:33)
Strategic HR Tool
Identify Top performer, Average performer, Low performer at a glance (5:51)
Strategic HR - Calculate Employee Turnover Rate (5:11)
How to Retain your talents for 10 years with amazing Excel Function and strategy
Excel Macro skill for Strategic HR
Macro to Insert New Month Faster for over 100 Stores (4:25)
Macro to Insert New Month Faster for over 100 Stores Part 2 Coding like a Terminator (6:58)
EA Form Automation Tool YA2022 (16:16)
Payroll Reporting Critical Skill
Mapping Process Map Summary Column Label to Monthly Payroll List Label (5:05)
Powerquery Essential
Convert PDF to Excel (14:01)
Visual Reporting Advanced Skill
Bullet Graph (7:57)
Strategic HR Metrics
% of Team Leave Taken (6:23)
How to calculate Staff Turnover Rate (6:30)
How to Highlight Staff Turnover Rate at a glance (4:48)
How to Calculate Retention Rate (5:56)
How to calcuate Turnover Rate Monthly or Quarterly (7:27)
How to SUM conditionally using SUMIF and SUMIFS (4:31)
How to Create Turnover vs Retention Analysis with Combo Chart (8:42)
HR Practitioner Puan Zolida talk about Why Employee Leave (6:32)
How to calculate Attrition Rate Part 1 (14:10)
Time to Fill (6:46)
First step - Know where you are now
Training Need Analysis - the SpeedExcel way (6:29)
Awareness of Time is COST
Total Meeting Cost with 3 C Level (12:43)
Hidden Cost to let C-Level Googling or Youtube (5:11)
How to calculate Overtime over days (2:56)
Retaining Talents
How to PREDICT your team will leave using Excel NPS (6:23)
Employee Satisfaction Survey automation (9:12)
Employee Satisfaction Index ESI. (7:09)
How to calculate Prorated Salary Faster
How to calculate Pro Rated Leave faster Part 1 (5:29)
How to calculate Pro Rated Leave faster Part 2 (6:14)
How to calculate Pro Rated Leave faster Part 3 (16:47)
How to calculate the adjusted total salary with the new Minimum Wage increase to 1500 (3:08)
1500 Minimum Wage IMPACT (5:03)
RM 1500 Minimum Wage IMPACT on Overtime (9:01)
How to calculate Annual bonus faster (5:28)
Consolidating monthly data faster
Combining 6 months commission data fast with latest Excel tool (3:22)
9 Boxes - Talent Management Automation using Excel Advanced Function
Lesson 1 - Array Formula Basic (3:18)
Lesson 2 - Array Formula - Intermediate Level (3:37)
Lesson 3 - Array Formula Advanced Level (6:24)
Lesson 4 - Divide and ... (11:24)
FOMEMA
When to send Foreign Worker for Fomema Checkup (16:10)
mployee Voucher Tracker - track faster (6:59)
Reporting Automation
Understanding the current challenge in creating KPI report (4:51)
Automating Reporting for Employee KPI Report Actual vs Target (7:23)
Stories of HRBP over challenges with Power tool
How Power BI Powerquery helps a HR to overcome challenge in HR data analytic 2 (2:54)
All about Annual Leave
Calculate Annual Leave for New Joiner using DATE TODAY Excel function (12:30)
Monitoring Employee Health
How to deal with outpatient medical expense Part 1 (4:28)
Medical Fee for Each Cost Center - Beyond Unmerge, use Fill Down PowerQuery (5:24)
TRAINING PLANNING
How to plan for a Excel Training for 500 Employees in Malaysia (9:18)
Hiring Strategies
How to advertise job strategically (6:43)
HR Productive Tool
SOCSO Calculator
Teach online with
How many absences for each employee had using Pivot Table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock