Practical Session
Practical Session
Practical Session
Practical 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
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.
Performance Management System (Advanced Topic Added)
Contributions of HR from Business Perspective?
Review & Analyze Business Unit Data
Employee Budgeting and Man Power Planning
Workforce Planning, Succession Planning, Career Architecture Program and Skills Assessment
Attrition Issues & Control
Design SOP.
Practical Session
Practical Session
Practical Session
Practical 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
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.
US Payroll
INDIAN PAYROLL
INDIA- Statutory Configuration On TAX, PF, ESI, Professional TAX.
Use of assigning Appraisal Model to PSA/ESG Multiple Appraisal system Perform Employee Appraisal
Reports
Documents & Project Process:
Factory pictures.
Audit methodology.
They actually do what they commit, I took classes for HR Generalist training & I am really satisfied with trainers as he explained every topic in a very efficient way. Now I am utilizing his guidance and also SLA committed me that they will provide me the good placement opportunities and they did as they said. So, I am really satisfied with the classes and their efforts for SLA students.
Great Institute with great teaching faculty. It has good placement team & process. Satisfied after studying from this institute. It is the best HR training institute.
I wanted to make my career in HR but could not afford to do an MBA course. SLA Consultants provided me with theoretical as well as practical training in HR and I am working as HR Executive with a reputed company now even without an MBA. Thanks SLA. You made my life easier.
People say that the job of an HR Generalist is very tough as the person has to take on multiple roles. Thanks to SLA Consultants, I did not feel that I cannot take on multiple roles. The trainers made me a superstar and I can deal with any HR issue right now, as the trainers have shared extensive knowledge with me.
SLA Consultants is a great place for young students who want a job without spending a lot of money. I have learnt a lot there and they helped me get a stable job in a company of my choice. I will forever be thankful to them for guiding me towards a great career path and helping me make a good life for myself.
I wanted to make my career in HR but could not afford to do an MBA course. SLA Consultants provided me with theoretical as well as practical training in HR and I am working as HR Executive with a reputed company now even without an MBA. Thanks SLA. You made my life easier.
I had read a lot of SLA Consultants consumer complaints before signing up for a training program in HR. Thankfully, all the doubts I had were fake and the Institute helped me to get a job in a dream company. Thank you, team SLA!!
I dreamed of making a career in HR but I did not want to go into a core recruitment job role. This is where SLA helped me. The trained made me a multitasker by teaching me all aspects of HR from payroll to labor law. This training helped me make my dream of working as a HR professional come true.
SLA Consultants made me a better HR professional in just a few weeks. I am proudly working as an HR Manager now and have a team under me. I am really thankful to them for their constant support before and after the completion of the course.
SLA Consultants made me a better HR professional in just a few weeks. I am proudly working as an HR Manager now and have a team under me. I am really thankful to them for their constant support before and after the completion of the course.
I dreamed of making a career in HR but I did not want to go into a core recruitment job role. This is where SLA helped me. The trained made me a multitasker by teaching me all aspects of HR from payroll to labor law. This training helped me make my dream of working as a HR professional come true.
SLA Consultants made me a better HR professional in just a few weeks. I am proudly working as an HR Payroll Executive now and have a team under me. I am really thankful to them for their constant support before and after the completion of the course.
People say that the job of an HR Executive is very tough as the person has to take on multiple roles. Thanks to SLA Consultants, I did not feel that I cannot take on multiple roles. The trainers made me a superstar and I can deal with any HR issue right now as the trainers have shared extensive knowledge with me.
SLA Consultants made me a better HR professional in just a few weeks. I am proudly working as an Sr.HR Executive now and have a team under me. I am really thankful to them for their constant support before and after the completion of the course.
I wanted to make a career in HR and I had a knack for understanding laws and regulations. SLA Consultants helped me to become a HR law expert within a few weeks. Every rupee I spent on the course is worth it as I have gained knowledge for life.