HR ANALYTICS ON EXCEL
Course Curriculum
LECTURES
Available in
days
days
after you enroll
- Combine and Separate Text using Flash Fill (7:49)
- Combine and Separate Text using Formula (6:55)
- Extract First Middle and Last Name (8:08)
- Extract First Middle and Last Name - LAMBDA (15:50)
- Extract First Middle and Last Name - New Formulas (1:53)
- Find CTC Grouping (8:09)
- Overall Rating (10:21)
- Find Age (5:32)
- Extract Numbers from String (3:29)
- Calculate Headcount (5:24)
- Calculate Headcount - Pivot Table (2:04)
- Trainings Attended (3:59)
- Top Employees (6:12)
- Employees Pending Email List (3:44)
- Compa Ratio (4:04)
- Combine Excel Files (4:14)
- Create multiple documents using Mail Merge (with File Names picked from Excel) (9:44)
- Connect Excel, PowerPoint and Word (11:52)
- Power Pivot (8:11)
- Unpivot (5:36)
- Correlation (4:24)
- Salary Percentile (5:01)
- Range Penetration (3:18)
- Analyze Survey Data (Power Query) (10:41)
- Restrict and Validate Data Input using Data Validation (28:02)
- FILES
- Get Your Certificate
Please purchase from:
https://www.havishmconsulting.com/shop
Login details will be shared immediately once payment is received.