Industry acceptable HR certification for HR Training learners which help fresher/Experienced to up-skill at corporate.
4-5 Industry Expert Sr. HR Manager Having 15+ Years provide HR practical training to learner’s
After completion of 70% HR training our dedicated placement team arrange interview till placement.
Practical HR Training help to gain exposure like corporate level with technical test series
Real time projects and best case study makes SLA workshop very unique and lively for learners.
For Learner’s, Our admin team fresh batch schedule/re-scheduling classes/arrange doubt classes.
Advanced HR Generalist and Analytics Training Course With Advanced Excel and SAP HCM
Course Duration: 90-100 Hours Expert HR Trainers for 6 Modules
Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advanced Excel so that user can Make Advanced Analysis with the help of Those Tools
Lookup & Reference Functions:-VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’sSum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct.
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.
Logical Functions:-And, Or, If, Iferror, Not, Nested If, Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min
Data Management:- Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
Analysis:- Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table,
Advanced Chart, Graph & Dashboard:- Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table
Advanced Filter, Validation & Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data Split. Pivot Table and Charts, Import and Export Data, Protect/Unprotect Sheets/Workbooks, Worksheet Formatting and Print Display.
Contributions of HR from Business Perspective?
Review and Analyze Business Unit Data
Employee Budgeting and Man Power Planning
Workforce Planning, Succession Planning, Career Architecture Program and Skills Assessment
Attrition Issues and Control