-
Certificates: Certificate "Excel Specialist"
Certificate "Purchasing Management 4.0 with TÜV Rheinland certified qualification" -
Additional Certificates: Microsoft Excel" certificate
Certificate "Microsoft Excel for advanced users" -
Examination: Practical project work with final presentations
Module examination Microsoft Excel
Purchasing management 4.0 with TÜV Rheinland-certified qualification -
Teaching Times: Full-timeMonday 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: 8 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
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
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
Purchasing management and logistics
Purchasing 4.0: What is it and where is it going? (approx. 1.5 days)
Change in procurement in the digital age
Digitalization in purchasing
Centralized vs. decentralized purchasing
Back door selling
Maverick buying
Procurement marketing
Structuring the supply chain
Analysis methods
Basics of supply (approx. 1 day)
Target triangle of modern purchasing within the value chain
Purchasing cards, bullwhip effect
Advanced/Autonomous Procurement
Supplier Management 4.0 - eProcurement (approx. 0.5 days)
Introduction of e-procurement and Procure2Pay, e-invoicing
Strategic analyses (approx. 2 days)
ABC analysis: Procedure and possible applications
XYZ analysis: selection of inventory strategies
Supply strategies: single, global or unit sourcing
Basic data for the development of supply chain and purchasing strategies
Early Involvement
Volume bundling
Supply Chain Reference Model (SCOR)
Balanced scorecard and strategy maps
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Inquiry and tender (approx. 2 days)
Inquiries for goods and services
Inquiry strategies: Price inquiries
Service description
Rules for handling inquiries and tenders
Offer analysis: composition of costs
Simple, partial or weighted multi-factor comparison
Supplier selection and supply chain management (approx. 2.5 days)
Strategic 360° supplier selection
SCOPE supplier selection process
Segmentation of the supplier portfolio
Risk assessment
Supplier certification
Supplier audits
Supplier classification and evaluation
Supplier policy
Supplier homepage
Portfolio analyses/portfolio matrices
Interface management
Supply chain management
Process optimization and design
E-procurement solutions
Electronic catalogs
Electronic order management
Product Information Management (PIM)
Electronic Data Interchange (EDI)
Basics of procurement strategies (approx. 0.5 days)
Make-or-buy analyses
Price structure analysis (approx. 1.5 days)
Composition of a price
Price calculation with the "50-25-25" formula
Cost accounting methods
Performance management
KPI
Performance evaluation
Partial cost accounting (contribution margin)
Break-even analysis
Price regression
Best practice
Price structure analysis in the supply chain
Evaluation and methodology
Value management, value engineering, value analysis (approx. 0.5 days)
Contractual agreements (approx. 2 days)
Use of price escalation clauses
Learning curve and bonus agreements
Quality management
Agreements with suppliers
Supplier rating system
Legal issues in purchasing and data protection (approx. 1 day)
Sustainability in the supply chain
Supply chain due diligence law
DSGVO
IT cybersecurity
Agile purchasing organization (approx. 0.5 days)
Strategic and operational purchasing
Lead buying in the supply chain
Purchasing controlling (approx. 1.5 days)
Objectives and tasks of purchasing controlling
Methods for developing key figures
Professional service in the supply chain
Service providers
Hard savings vs. soft savings
Success in purchasing
Design of purchasing reports
Supplier and supply chain controlling
Project work, certification preparation and certification exam "Purchasing Management 4.0 with TÜV Rheinland certified qualification" (approx. 3 days)
Changes are possible. The course content is updated regularly.
Once you have completed the course, you will understand the concept of spreadsheets and be able to use Excel quickly and confidently. You will also be able to work confidently with formulas and functions and create, edit and evaluate large tables. You will also be able to use pivot tables and make good use of references.
You also have knowledge of operational and strategic purchasing tools, digital e-procurement, as well as price analysis, calculation and negotiation. You are familiar with supply chain management and supplier selection and know methods for price analysis and calculation.
Specialists in the field of purchasing are in demand at companies in all sectors. Your new skills will open up career opportunities in a wide range of fields.
With in-depth knowledge of Microsoft Excel, you will also expand your professional expertise, which will further increase your chances on the job market.
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).