-
Certificates: Microsoft Excel" certificate
DATEV certificate "DATEV user wage and salary"
DATEV training partner certificate of attendance -
Examination: Praxisbezogene Projektarbeit mit Abschlusspräsentation
Modulprüfung Microsoft Excel
DATEV-Anwender Lohn und Gehalt (Eine Anmeldung über das Lernportal „DATEV Students online“ ist für die Zertifizierungsvorbereitung obligatorisch.) -
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 (auto-fill, flash preview)
Sorting and filtering data
Calculating with date and time
Creating and editing charts
Chart templates and chart layouts
Manage workbooks (sheet protection, workbook protection)
Use individual print settings
Using Excel templates
Formula help and troubleshooting with AI
Wages and salaries with DATEV
Legal framework for payroll accounting (full-time approx. 3 days/part-time approx. 6 days)
Fundamentals of labor law with reference to payroll accounting
Social security law: compulsory insurance, contribution groups, levies, reporting, obligation to keep records
Wage tax law: tax deduction features, obligation to call up, payroll account
Wage types and their significance for payroll accounting
Data protection and limits of AI for payroll and personal data
Create and maintain client and employee master data in DATEV (full-time approx. 5 days/part-time approx. 10 days)
Client creation in DATEV
Backing up and importing client data
Recording social security and tax law specifics, other client master data
Creation of different employee types
Employee group (trainees, mini-job, midi-job, managing directors)
Entries and exits
Payments and deductions in DATEV (full-time approx. 4 days/part-time approx. 8 days)
Salary and time rate
Supplements and variable remuneration components
One-off payments (e.g. Christmas and vacation bonuses)
Travel allowances
Payment of wages in the event of illness, vacation, public holidays
Garnishment
Benefits in kind and non-cash benefits (e.g. company car, staff discounts)
Company pension scheme
Travel expenses and reimbursement of expenses
Maternity protection pay and maternity benefit
Payroll accounting and monthly closing with DATEV (full-time approx. 3 days/part-time approx. 6 days)
Transaction data entry
AI as an accounting tool for complex payroll transactions
Payroll accounting and monthly closing
Proof of contributions and estimation, certificates
Payroll tax registration
Repeat and recalculations
Transfer of payroll postings to the
Financial accounting, accounting voucher
Year-end closing work
Digital collaboration in DATEV (full-time approx. 2 days/part-time approx. 4 days)
DATEV Unternehmen online and DATEV Arbeitnehmer online at a glance
Preliminary wage recording and digital recording of monthly data
Digitally exchange and manage personnel documents
Digital mapping of attendances and absences
Use evaluations and wage evaluations in the DATEV applications
Insight into digital personnel processes with DATEV Personal
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 prepare payroll accounting with DATEV in a professional and practical manner. You will deepen your knowledge of the legal principles, process typical and complex payroll cases confidently in the software and be able to use digital processes efficiently in the collaboration between law firms, clients and employees.
The course is aimed at people with commercial or legal training, people 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).