Salary Guide 2021 | AmazingExcel

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

Salary Guide 2021

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock