Recruitment Process and Talent Acquisition. (Advance Excel Free)
- Methods and Technique of Recruitment.
- End-to-End Recruitment Process
- How to Use Different kind of recourses of Recruitment
- How to screen & shortlisting right candidate as per company requirement.
- How to Preparing Job Description and Job specification, Job Analysis & Job Advertisement.
- How to conduct Preliminary Round of Interview & Telephonic conversation.
- How to Use Job Portals like Naukr, Timesjob, Shine & Monster Jobs, LinkedIn.
- How to use Search right Candidate in Job portals with Boolean Search, Keyword Search.
- How to use different filters in Job portals.
- How to post a Job in different Job portals.
- How to use different social media platform for recruit right candidate.
- How to use HR Recruitment Tracker and MIS, Monthly and Daily basis reports.
- How to calculate Turnover/Attrition rate of Organization.
- Interview Handling, Mock Interview & Interview Technique
Advance Excel
V-Lookup , H-Lookup WITH (Array + Match + Choose), Freeze Panes,
Pivot Table/ Pivot Charts o Data Validation, Match & Index, Condition Formatting ,Text To Column Wizard, Remove Duplicates o Logical Formulas (IF,And,OR, IFError, Nested IF+And+OR), Protecting Sheet o Text Formulas (Contatnate ,Upper,Lower,Proper,Trim, Left, Right,Mid,Find, Replace,Substitute,Text) o Statistical Formulas (Sumif, Countif, Averageif, Sumifs, Averageifs, Countblank, Counta) o Date & Time Formulas (Datevalue, Timevalue, Today, Now, Edate, Emonth, Networkdays, Workday, Day360) o Recording & Assign Macros, Goal Seek & Hyperlink (Linking Sheets,Website, Objectives)