Consultant Controlling with Management and Corporate Planning

Free of cost

by funding

You will be trained in accounting with the DATEV software and in basic management accounting business processes with SAP. You will gain in-depth knowledge of the Excel program as well as the basics of management and corporate planning and learn how artificial intelligence is used in the profession.
  • Certificates: Certificate "Consultant Controlling"
    Certified Business Manager" certificate
  • Additional Certificates: Certificate "Microsoft Excel for advanced users"
    Certificate "Fundamentals of Controlling"
    Certificate "Controlling practice with DATEV"
    Original SAP user certificate
  • Examination: Practical project work with final presentations
    SAP user certification UC_CO_S42023
    Certified Business Manager
  • 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: 22 Weeks

Microsoft Excel for advanced users

Spreadsheet calculation with Excel (approx. 8 days)

Using Excel as a database: Selecting (auto and special filters), sorting, evaluating lists (tables)

Using functions, performing calculations with functions, getting to know references

Matrix functions: SREFERENCE, WREFERENCE, XREFERENCE

Working with names or named ranges

Creating, editing and evaluating pivot tables

Special functionalities such as conditional formats, validity rules, user-defined formats

Calculations with cell ranges (matrices)

Creating different chart types

Macro recording


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Project work (approx. 2 days)

To consolidate the content learned

Presentation of the project results

Controlling basics

Introduction to controlling (approx. 1.5 days)

Controlling as part of the management process

Overview of the various controlling instruments and methods

Strategic and operational controlling


Cost accounting and cost management (approx. 3.5 days)

Introduction to cost and activity accounting

Cost element accounting

Cost center accounting

Cost unit accounting


Cost accounting systems (approx. 3 days)

Actual, normal and planned cost accounting

Partial and full cost accounting

Activity-based costing


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Corporate planning and budgeting (approx. 4 days)

budget planning

Liquidity planning

investment planning


Key figures and key figure systems (approx. 3 days)

Contribution margin

Balanced scorecard


Reporting (approx. 2 days)

reporting

BWA

Data protection in controlling


Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results

Controlling practice with DATEV

Cost accounting with DATEV (approx. 7 days)

Creation of basic data

Creation of the cost center plan

Setting up the evaluations

Adaptation of cost accounting to operational requirements

Account allocations

Internal activity allocations and apportionments

Entering and processing batches

Displaying and printing evaluations

Setting up evaluation packages


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Business planning with DATEV (approx. 5 days)

Overview and functionality of DATEV

Basics of planning calculation

Planning strategies - setting up a planning and control system with integrated profit and liquidity planning

General planning approaches

Detailed planning options using detailed objects

Investment planning (investment and financing)

Program links

Target/actual comparison and DATEV controlling report

Evaluations: Brief overview and standard evaluations as well as planning report


Analysis and planning in accounting (approx. 5 days)

The monthly analysis

Profit analysis: comparison with previous year, target/actual comparison, industry comparison, time series presentation for trend statements

Liquidity analysis: static liquidity, withdrawal behavior, payment habits, account management, cash flow statement with cash flow calculation

Use and origin of funds

Special solutions and occasions

Determination of debt servicing capacity

Individual BWA (adaptation of the standard BWA)


Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results

Controlling (CO) user with additional qualification in financial accounting (FI) with SAP S/4HANA

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


S4F10 Business processes in financial accounting (approx. 8 days)

Overview of financial accounting

General ledger accounting, accounts payable accounting, accounts receivable accounting, asset accounting and bank accounting

Closing operations in general ledger accounting


S4F20 Business processes in management accounting (approx. 8 days)

Differentiation from financial accounting and tasks of internal accounting

Components and tasks

Organizational units and master data

Analyses, planning and planning integration

Integration of posting logic

Postings and period-end closing


S4F22 Cost center accounting and internal order management (approx. 10 days)

Organizational units, master data, event-based postings, period-end closing

Internal orders: Overview, master data, postings and period-end closing

Planning and budgeting


S4F28 Profit Center Accounting (approx. 4 days)

Profitability management, master data, actual postings, planning and transfer prices


Project work/case study, certification preparation and SAP user certification Controlling (approx. 6 days)

Management and corporate planning

Management (approx. 1 day)

Hierarchy levels

Management methods

Planning horizons

Management functions

Management control loop

Management instruments


Objectives, methods and instruments of business plan preparation (approx. 3 days)

Basics of business plan preparation

Analysis and planning tools (SWOT analysis, scenario analysis, portfolio analysis, creativity techniques)


Contract law (approx. 1 day)

Declarations of intent

Warranty and guarantee

Types of contract and their disruptions

Law on contractual defects (subsequent performance, withdrawal, purchase price reduction, compensation)

General terms and conditions (AGB)


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Commercial and company law (approx. 1 day)

Types of merchants

company forms

Commercial practices

Special features of commercial law

Commercial register and publicity

Introduction to insolvency law


Project planning (approx. 0.5 days)

basics

Resource planning

Planning steps

Errors in project planning


Environment analysis (approx. 0.5 days)

Company analysis

Industry analysis

Location analysis

Competition analysis


Marketing (approx. 3 days)

Market analysis and market segmentation

Basics of market research

Instruments of the marketing mix

Advertising and supporting instruments


Financial planning (approx. 1 day)

Overview of

Instruments


Planning investment calculation (approx. 2 days)

Basics

Investment calculation methods

Limits and problems of capital budgeting methods

Key figures


Financial planning (approx. 1 day)

Basics

Equity and debt financing

External and internal financing

Key figures


Controlling (approx. 1 day)

Tasks and objectives of controlling

Areas of controlling

Controlling instruments


Project work, certification preparation and certification examination (approx. 5 days)



Changes are possible. The course content is updated regularly.

Microsoft Excel basic knowledge, basic commercial knowledge (balance sheet and P&L) and specialist knowledge in the field of accounting are required for this course.

After the course, you will be able to work confidently with formulas and functions as well as create, edit and evaluate large tables. You will also be able to use pivot tables and make sensible use of references. You will have the necessary specialist knowledge to strategically plan, monitor and optimize performance processes within the company. The focus of the course is on knowledge of internal accounting to ensure cost-efficient and realistic business analysis and advice. You will also be familiar with the basic management tools of controlling with SAP® and round off your professional profile with an original SAP® user certificate.

You also know how to draw up different business plans for projects and companies from an economic perspective and apply the most important economic planning and marketing tools. You have knowledge of contract law and are familiar with the content of commercial and company law as well as the basics of financial planning.

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 areas of bookkeeping and accounting with knowledge of economics and business administration.

The course is also aimed at anyone who would like to acquire basic business management and planning knowledge or deepen their knowledge.

With sound knowledge in the field of controlling, you can support management, especially in larger companies. You can work in companies in almost all sectors of the economy and in public administration.

With your meaningful certificate, you prove your business planning knowledge and provide a detailed insight into the qualifications you have acquired to improve your career entry and advancement.

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.