Online HR Course

2.1 – MS Excel- Lab Session

Objective:

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

Topics Covered:

Advanced Excel

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.

9. APPRENTICESHIP Act, 1961 (New Topic Added)

• Objective
• Contract of Apprenticeship
• Termination of Apprenticeship Contract
• Obligation of Employers Toward an Apprentices
• Obligation of Apprentices
• Payment to Apprentices
• Health, Safety and Welfare of Apprentices
• Rules and Guideline

Module 5.1 – HR -Business Partner (Advanced Topic Added)

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

Design SOP.

• End-to-End Recruitment Process and Head Hunting.
• Hands on Experience on Job Portals i.e., Naukri / Monster with Sourcing Methodologies.
• Boolean Search, Industry Mapping
• Screening, Short-Listing of Resume.
• Interview Checklist (Primary and Secondary)