-
Certificates: Microsoft Excel" certificate
DATEV certificate "DATEV user wage and salary"
DATEV training partner certificate of attendance -
Examination: Practical project work with final presentation
Module examination Microsoft Excel
DATEV user wage and salary -
Teaching Times: Full-time / Part-timeFull-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.). Part-time: Monday to Friday from 8:30 a.m. to 11:45 a.m. (in weeks with public holidays from 8:30 a.m. to 12:35 p.m.).
-
Language of Instruction: German
-
Duration: 6 Weeks full-time / 12 Weeks part-time
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
Calculating with date and time
Creating and editing diagrams
Using individual print settings
Manage workbooks
Using chart templates and chart layouts
Using Excel templates
Sorting and filtering data
Wages and salaries with DATEV
Legal framework for payroll accounting (full-time approx. 3 days/part-time approx. 6 days)
Introduction to labor law
Social security law: obligation to pay social security contributions, pay-as-you-go obligation, reporting system, obligation to keep records
Wage tax law: tax deduction features, tax recording and reporting obligations
Meaning of wage types
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Creation of employees and clients in DATEV (full-time approx. 5 days/part-time approx. 10 days)
Client creation in DATEV
Save and import clients
Recording social security and tax law specifics, other client master data
Creation of different employee types
Dealing with the digital personnel file
Special features (e.g. trainees, part-time employees, managing directors, etc.)
Social security key
Leavers
Payments and deductions in DATEV (full-time approx. 4 days/part-time approx. 8 days)
Salary and time wage
Special wage types: piecework and premium wages
Surcharges
Staff discounts
One-off payments (e.g. Christmas and vacation bonuses)
Travel allowances
Continued payment of wages in the event of illness
Payment of wages (payment of wages on public holidays)
Garnishment
Benefits in kind and non-cash benefits
Company car
Travel expenses and expense reimbursements Movement data
Maternity protection and maternity pay
Company pension scheme
Payroll accounting and monthly closing with DATEV (full-time approx. 3 days/part-time approx. 6 days)
Calendar entry
Entry and exit management
Payroll accounting and monthly closing
Reporting and certification
Payroll tax registration
Sending data
Repeat and recalculations
Transfer of payroll postings to financial accounting
Year-end closing work
Digital cooperation between tax consultants and companies (full-time approx. 2 days/part-time approx. 4 days)
Project work, certification preparation (via the DATEV Students online platform) and certification exam "DATEV User Wages and Salaries" (full-time approx. 3 days/part-time approx. 6 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.
You will also be familiar with basic payroll accounting processes, carry out payroll accounting and acquire practical knowledge of the DATEV software.
The course is aimed at all persons with commercial or legal training, persons from financial accounting and bookkeeping, tax consultants, auditors, entrepreneurs and law firm employees.
Your knowledge of the DATEV payroll software will open up many new opportunities in the job market: according to the manufacturer, more than 9.5 million payrolls are created with DATEV every month.
Your meaningful certificate provides a detailed insight into the qualifications you have acquired and improves your career prospects.
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 lessons 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).