SAP User Human Resources Management (HCM) with Excel

The course teaches you the central application areas of SAP® Human Capital Management in a practical way. Theory, examples and exercises will enable you to make your HR tasks more efficient - supplemented by topics such as reports and queries. You will also learn the basics of spreadsheets with Excel and how artificial intelligence (AI) is used in your professional environment.
  • Certificates: Microsoft Excel" certificate
    SAP Training Partner Certificate
  • Examination: Praxisbezogene Projektarbeiten mit Abschlusspräsentationen
    Modulprüfung Microsoft Excel
  • Teaching Times: Full-time
    Monday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
  • Language of Instruction: German
  • Duration: 6 Weeks

Spreadsheet calculation with Microsoft Excel

Spreadsheet calculation with Excel (full-time 10 days/part-time 20 days)

Basics of table editing

Working with formulas and functions

Formatting cells, editing and printing tables

Filling, moving and copying

Sorting and filtering data

Calculating with date and time

Creating and editing charts

Using chart templates and chart layouts

Manage workbooks

Use individual print settings

Using Excel templates

SAP User Human Resources Management (HCM)

Introduction, technical briefing and registration SAP Learning Hub (approx. 1 day)


S4H00 - SAP S/4HANA Overview (approx. 4 days)

Overview of SAP S/4HANA

Navigation, SAP Fiori, SAP Business Client, SAP Logon

System-wide concepts with organizational units, master data and transactions

Overview of financial accounting and logistics modules, mapping of the respective processes in SAP

Reporting, system structure and migration

SAP service offerings


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies and possible applications in the professional environment


S4HR05 - Business processes in SAP ERP HCM on S/4HANA (approx. 7 days)

Start SAP Human Capital Management for SAP S/4HANA

Maintaining personnel master data

Use of structures in HCM

Executing processes in personnel administration

Applying time management

Introduction to payroll accounting

Carrying out personnel development activities

Understanding shared services and Fiori

Using the analysis functions of SAP HCM

Using additional HCM components

Getting to know SAP SuccessFactors


S4HR11 - Business processes in HCM Payroll for S/4HANA (approx. 4 days)

Describe the basics of payroll accounting

Working with employee master data for payroll and personnel actions

Explore the payroll process

Get to know payroll scenarios

Troubleshooting and resolving typical errors in payroll accounting

Describing follow-up activities

Finding additional resources


Project work/case study (approx. 4 days)



Changes are possible. The course content is updated regularly.

You understand the concept of spreadsheets and master the use of Excel quickly and confidently in order to achieve optimal and accurate work results.

The course also offers you a systematic introduction to the basic methods and applications of human resources management in the SAP system. You will round off your professional profile with SAP user certification.

The course is aimed at people with training, professional experience or good basic knowledge in the commercial or administrative field as well as specialists in the field of human resources management. The course is also suitable for specialists from the fields of economics and business administration who wish to acquire user knowledge of SAP software.

HR specialists with SAP skills are in demand from both large and medium-sized companies in industry, trade and the service sector.

Your meaningful certificate provides a detailed insight into the qualifications you have acquired and improves your career prospects.

Training partner of SAP® Germany

In cooperation with the SAP training partner alfatraining Bildungszentrum GmbH, we will qualify you for a job in industry and business.

You are directly connected to the SAP® Germany servers and learn on the original SAP® training system (IDES) in the latest version. This gives you the necessary practical experience during the course.

All SAP user courses also conclude with the original SAP certification. Our SAP instructors are qualified SAP consultants who will provide you with intensive support and prepare you optimally for the certification exam.

 

Didactic concept

Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).

You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.

 

Virtual classroom alfaview®

Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face teaching via video technology.

The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).

We will gladly advise you free of charge.

0800 3456-500 Mon. - Fri. from 8 am to 5 pm
free of charge from all German networks.

Contact

We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm free of charge from all German networks.