Excel Training for HR:
(Duration: 1 Full Days)
- Excel Essentials
- Sorting on the basis of customized list
- Setting the context for Formulas
– Basics about Formula’s
– Absolute, Relative and Mixed Reference.
- Excel Formula’s
– Text Formulas (Left, Right, Len, Upper, Lower, Proper etc.)
– Lookup Formulas (Vlookup, Hlookup, Transpose etc.)
– Date and Time (Date, Datevalue, EOMonth, Workday, etc)
– Math and Trig (if, sumif, sumproduct etc)
– Nested Formulas
– Edit and Understand the formula
- Conditional Formatting
- Goal Seek
- Pivot Tables
- Working with Date and Time- How to work on holiday list, working day list etc.
- Payroll Analysis
- Filter and Advanced Filter to extract data with multiple conditions.
- Performance Appraisal
- HR Dashboard
- Manpower Planning
- Mail Merger
- Case Study
We can customize all our MS Excel Training Programs as per the Company’s need and requirement. Customization can be there in terms of Contents, Duration of Training Program etc.
You may also consider our other training Programs, in case you are looking for different level of Training Programs.