MINI-MBA of Specialization in Human Resources Management with the Excel tool applied to HR via online learning

The course of Human Resources aims to:

• Enable for the operational management of human resources;
• Develop capabilities for the design of integrated strategies (psychosocial, cultural, technical and economic-financial) management and human resource development, organizational and social level;
• Promote skills of analysis and definition of human resource policies at the organizational and social levels (local, regional and national);
• Optimize the decisions of managers and directors of HR to HR management level, using the full potential of Excel and Excel transforming information into effective information to support decision-making.

At the end of the course the students will be able to:

• Identify the different types of remuneration, salaries and compulsory deductions;
• Differentiate certain forward contracts, uncertain and indeterminate;
• Knowing the renewal terms, effects of expiry of complaints and legal prior notice of the same types of contracts;
• Know how to calculate the payroll, with the respective allowances and deductions, applying the limits laid down in the Labour Code;
• Know how to calculate the indemnity rights of dependent employees, differentiated by the type of employment;
• Know how to calculate the annual wage bill and interpret it as Head of Human Resources, in order to have valid options and benefits in possible recruitment;
• Identify processes of internal and external recruitment - advantages and disadvantages. Frame the selection of personnel in the organization;
• Recognize the importance of ethics in recruitment and selection processes;
• Identify the steps of the curriculum analysis, as well as the various tests that are part of the selection of employees;
• Know generally the components of a performance management system and the importance of defining individual goals;
• Identify various forms of education and existing solutions within the personal development;
• Prepare and structure Excel templates adapted to different needs and HR processes;
• Optimize the calculations related to training by creating training dossiers and reports and organizing information through Excel;
• Structuring and organizing a framework of HR indicators, facilitating periodic review and achieved goals viewing;
• Plan, design and implement a performance evaluation by applying the Excel capabilities.

 

CONTENTS

Module 0 – Opening

• Presentation of trainers and trainees;
• Presentation of the objectives and training program operating methodologies.

Module I – Human resource management projects

• Enquadramento – a Gestão de Projetos aplicado aos Recursos Humanos;
• As ferramentas de gestão de projetos;
• Gestão e Registo;
• Exercício de aplicação prática.

Module II – Social Security

• Basic Law and Legal Binding System;
• Family benefits;
• Calculation System and Reform:
• Old age;
• Anticipated.
• Compensation maps;
• Mandatory contributions;
• Analysis of case studies, applying local laws. 

Module III – Taxation

• IRT;
• Allowances;
• Subsidies;
• Exemptions and benefits;
• Tax rules Calculation of Compensation;
• Analysis of case studies, applying local laws.

Module IV – Personal registration systems and payroll

• The Single Register of Labor;
• Examples of organizations;
• Exercises Payroll Processing Practical;
• Map of Overtime;
• Support payroll software;
• Preparation and Implementation of Performance Evaluation Systems;
• Objectives and Performance Evaluation of Strategies;
• Methods and performance assessment instruments;
• The Performance Assessment Interview;
• Attendance control – methods and techniques;
• Management of absenteeism;
• Analysis of case studies and practical exercises.

Module V – Legal factors at work – Legal Regime Applicable

• Elaboration of rules / code of conduct / ethics / Corporate Responsibility;
• Minutes of work contracts;
• Disciplinary proceedings:
• Deadlines;
• Reports.
• Fulfillment of legal obligations:
• Mandatory reporting;
• Deadlines.
• Rules and preventive measures in place of general inspection work;
• The Qualifier:
• Career Management.
• Case studies and practical exercises, applying local laws.

Module VI – Excel applied to Human Resources

• Planning, Design and Performance Evaluation of Implementation in Excel:
• Worksheet definition according to the data, parameters and performance evaluation of variables;
• Application of Excel tools in Performance Assessment context;
• As detailed analyzes based on the results of typology:
• Statistical analysis, graphical analysis and content analysis;
• Dashboards as indicators of evaluation;
• Forced distributions;
• Organized presentation of the resulting information.
• Excel as a tool for Revision Holding Salary
• Create pivot tables to synthesize information;
• Tables of a Single Input, a Multiple Input and tables Two Inputs with Filter Criteria Range;
• Make decisions based on graphical analysis and automatic calculations;
• The importance of information protection: Methodologies.
• Administrative management - Automation calculations in Excel
• Automating repetitive administrative procedures;
• Creation of simulators for automatic performing calculations;
• Macro creation for performing repetitive processes;
• Creating simulators to avoid redundancies:
• Social Security calculation;
• Change in net earnings;
• Compensation in the event of leaving the company.
• Monitoring indicators of human resources based on Excel
• Creating an Indicator Monitoring Framework:
• Periodic review and Immediate View of the State of achievement of objectives : Deviations identification;
• Identification of Strategic Objectives based on the Balanced Scorecard methodology;
• Operationalization of Deployment Goals in Excel;
• Planning Registration of collected data;
• Types of indicators and their operationalization in Excel;
• Alarm introduction through the Conditional Formatting.

Module VII – Optional – Preparation and Exam

• Assess and evaluate the knowledge acquired.

Module VIII – Closing

• Evaluation of the Specialization Mini-MBA: trainers and trainees.

Prerequisites
The necessary prerequisites to attend this course are:
Have access to a computer or tablet with an Internet connection and a browser (program for surfing the web), such as Chrome, Safari, Firefox or Internet Explorer.
You can access the course from any computer (for example, at home and at the office), tablet or smartphone.

Methodology
This course is always with the trainer, who will even give a face-to-face training through the platform.
The trainee can intervene together with the trainer or with the other trainees as he does in the classroom.
Practices and exercises will always be made available by the non-final trainer of each training session.
At the end of the course, you will receive a Professional Training Certificate if you attend at least 90% of the classes, carry out the proposed work and tests, participate in the online exercise and have a positive final assessment.
This training is certified and recognized.