-
Certificates: Microsoft Excel" certificate
Certificate "Forwarding and warehouse logistics specialist" -
Additional Certificates: Certificate "Freight forwarding expertise"
Certificate "Logistics expertise"
Certificate "Foreign trade and customs clearance" -
Examination: Practical project work with final presentations
Module examination Microsoft Excel -
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: 14 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
Freight forwarding expertise
Freight forwarding (approx. 3 days)
Freight forwarder and warehouse logistics specialist in the freight transport industry
Performance characteristics of the modes of transport
Selection criteria for means of transport
The capacity of individual means of transport
Areas of work and legal status
Rights and obligations as a freight forwarder according to HGB
Supply Chain Duty of Care Act (LkSG)
Forwarding, freight and storage contracts
National and international road haulage (approx. 2 days)
Freight orders in national road haulage
National authorization for commercial road haulage
Vehicle types - dimensions and vehicle weights
Freight orders in international road haulage
CMR law, CMR consignment note
Accompanying documents in international road haulage
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Profitability calculations (approx. 1 day)
Calculating transportation costs in road haulage
Differentiation between fixed and variable costs
Make-or-buy decision for own or external transport
Transportation of dangerous goods (approx. 1 day)
Transportation of dangerous goods by road
Legal basis according to GGVSEB
Dangerous goods classes and packaging groups
Rail freight transport (approx. 1 day)
Legal bases and freight contract
Types of freight wagons
Combined transport (approx. 1 day)
Types of combined transport
National and international transport network
Liability and insurance (approx. 2 days)
German Freight Forwarders' Standard Terms and Conditions
Legal character of the ADSp
Liability as a freight forwarder and carrier
Handling claims
Insuring goods
Premium calculation and level of liability
Transportation types and cost calculations (approx. 1 day)
Groupage and system transport
Transportation cost calculation
CEP services
Sea freight and inland waterway transport (approx. 3 days)
Legal bases and contract of carriage
Ship types
Transport price calculation in sea freight traffic
Dimension and weight rates
Surcharges and discounts of shipping companies
Inland waterway transport
Federal waterway network
Air freight transport (approx. 2 days)
Legal bases in air freight transport
Freight contract and air waybill
Calculation of air freight costs
The TACT tariff
Groupage cargo in air freight traffic
Project work (approx. 3 days)
To consolidate the content learned
Presentation of the project results
Logistics expertise
Logistics services (approx. 4 days)
Providing logistics services
Target relationships in the magic square of logistics
Logistics systems
Hub-and-spoke, gateway and cross-docking networks
Individual logistics services/value-added services
Legal provisions and contractual bases of logistics
Supply Chain Duty of Care Act (LkSG)
Standards in logistics
Digitalization and Logistics 4.0
Quality management in logistics companies
Key figures for logistics controlling
Efficient consumer response
Contract logistics (approx. 1 day)
Green Logistics
Portfolio of logistics services
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Procurement logistics (approx. 2 days)
Push and pull principle
Sourcing concepts
ABC and XYZ analysis
Determination of requirements
Optimal order quantity
Warehouse logistics (approx. 2 days)
Warehouse technology
Legal basis for warehouse services
Warehouse cost calculation
Calculation methods
Calculation principles
Intralogistics (approx. 1 day)
The organization of internal transports
IT-supported accompanying information
Distribution logistics (approx. 1 day)
Direct and indirect distribution
Own and third-party transportation
Disposal logistics (approx. 1 day)
Legal framework conditions
Recycling tasks
Marketing in logistics (approx. 1 day)
Marketing concepts
marketing instruments
Accounting (approx. 2 days)
Accounting basics
Inventory, stocktaking and balance sheet
Chart of accounts and chart of accounts
Turnover tax
Forwarding expenses and forwarding income
Dealing with hazards (approx. 1 day)
Tasks of the employers' liability insurance associations
Accident prevention regulations
Storage of hazardous goods
Information and communication technology (approx. 1 day)
IT systems in logistics
document management
Project work (approx. 3 days)
To consolidate the content learned
Presentation of the project results
Foreign trade and customs clearance
Foreign trade (approx. 1 day)
Trade in Europe and world trade
Importance of sea freight transportation in foreign trade (approx. 1 day)
Advantages and disadvantages of sea freight transportation
Ship types and freight areas
Importance of air freight transport in foreign trade (approx. 1 day)
Known consignor and regulated agent
Advantages of groupage shipments in air freight
Incoterms® 2020 (approx. 1 day)
One-point and two-point clauses
Criteria for a suitable Incoterms® 2020 clause
Risk hedging (approx. 1 day)
Payment and delivery risks in foreign trade
Documentary collection
Documentary letter of credit
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Customs procedure (approx. 5 days)
Import procedure
Customs certificate and release
Import duties
Customs duties and customs value
Electronic customs tariff (EZT)
Export procedure
The Automated Tariff and Local Customs Clearance System ATLAS
Export licenses
EU customs law
The Union Customs Code
Preferences and certificates of origin
Security provisions in the international movement of goods
EU customs security initiative
Customs warehouse
Processing ATLAS customs procedures with Dakosy ZODIAK GE (approx. 5 days)
Create and edit customer data
Create and edit article data
Create import customs declaration
Processing input requests
Processing errors
Creating export declarations
Creating transit procedures in the NCTS system
Creating an import and export customs declaration
Creating a transit declaration
Possible prompts and errors
International Trade (approx. 1 day)
The International Chamber of Commerce ICC
EU legal bases
Supply Chain Due Diligence Act (LkSG)
Forwarder documents for foreign trade (approx. 1 day)
FIATA-FCR and FIATA-FCT
FIATA-Multimodal Transport
Bill of Lading
Project work (approx. 3 days)
To consolidate the content learned
Presentation of the project results
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 able to handle work processes for national and international shipping with legal certainty and acquire the specialist knowledge to be able to work in related specialist areas.
Knowledge in the use of various MS Office programs is a prerequisite for successful and efficient work in professional life.
Specialists in the field of freight forwarding and logistics are in demand at companies of all sizes in the areas of goods and freight transportation, sea, air and land trade, import and export, as well as customs clearance and warehousing. According to estimates by the Federal Ministry of Transport, Building and Urban Development, increasing foreign trade links in goods and freight transport will lead to a long-term increase in the volume and performance of freight transport by 2050. The relevant knowledge will therefore open up career opportunities in a wide range of areas.
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).