Autoplay
Autocomplete
Previous Lesson
Complete and Continue
HR ANALYTICS ON EXCEL
LECTURES
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
Combine and Separate Text using Flash Fill
Complete and Continue