CFC8003: Transport, Logistics, Fleet Management, and Advanced Excel Applications

Module 1: Introduction to Transport and Logistics Management

• Overview of Transport and Logistics
• Transport and Logistics Strategy

Module 2: Advanced Transportation Management

• Transportation Planning and Optimization
• Technology in Transportation Management

Module 3: Logistics Operations and Supply Chain Integration

• Logistics Operations Management
• Supply Chain Integration

Module 4: Fleet Management Essentials

• Fleet Management Fundamentals
• Fleet Performance Measurement
  • Key Performance Indicators (KPIs) for Fleet Management
  • Data-Driven Decision Making in Fleet Operations
  • Safety and Compliance in Fleet Management
  • Group Exercise: Developing a Fleet Performance Dashboard

Module 5: Advanced Excel for Transport and Logistics Analysis

• Excel Data Management Techniques
  • Data Cleaning and Preparation in Excel
  • Advanced Excel Functions for Logistics Analysis
  • Pivot Tables and Pivot Charts for Transportation Data
  • Practical Exercise: Analyzing Transport and Logistics Data
• Data Visualization and Reporting in Excel
  • Creating Dashboards for Transport and Fleet Management
  • Advanced Data Visualization Techniques
  • Automating Reports and Macros in Excel
  • Practical Exercise: Building a Fleet Management Dashboard

Module 6: Strategic Fleet Management and Optimization

• Strategic Fleet Management
• Fleet Optimization Techniques
  • Route Optimization and Vehicle Utilization
  • Reducing Fleet Operating Costs
  • Implementing Green Fleet Initiatives
  • Group Exercise: Fleet Optimization Simulation

Module 7: Logistics and Supply Chain Risk Management

• Identifying Risks in Logistics and Supply Chain
• Sustainability and Resilience in Logistics
  • Sustainable Logistics Practices
  • Building Resilience in the Supply Chain
  • Future Trends in Sustainable Transportation
  • Group Exercise: Developing a Sustainable Logistics Plan

Module 8: Financial Management in Transport and Logistics

• Cost Management in Transportation
  • Cost Control Techniques in Logistics
  • Financial Planning and Budgeting for Fleet Management
  • Analyzing Financial Performance in Transport Operations
  • Case Study: Financial Optimization in Logistics
• Using Excel for Financial Analysis
  • Financial Modeling in Excel for Logistics
  • Cash Flow and Profitability Analysis
  • Scenario Planning and Sensitivity Analysis
  • Practical Exercise: Building a Financial Model for Fleet Management

Module 9: Leadership and Communication in Logistics

• Leadership Skills for Transport and Logistics Managers
• Stakeholder Management in Transport and Logistics

Module 10: Emerging Trends and Technologies in Transport and Logistics

• Digital Transformation in Transport and Logistics
  • The Impact of AI, Blockchain, and IoT
  • Autonomous Vehicles and Drones in Logistics
  • The Future of Smart Logistics and Supply Chains
  • Group Discussion: Preparing for the Future of Transport and Logistics

GENERAL NOTES
i.   The clients have many options on where they would wish to have the training
ii. The client should communicate their preferred training venue at least seven days before the training date failure to which the training shall take place in Nairobi.
iii. This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
iii. Training manuals and additional reference materials are provided to the participants.
iv. Upon successful completion of this course, participants will be issued with a Chania finance consultancy certificate.
v.   The onsite training fee covers tuition fees, training materials, tea at 10am, lunch, tea at 4pm, training venue and a certificate on completion. Accommodation and travel may be arranged for our participants upon request.
vi.   The online training fee covers tuition fees, training materials, and a certificate on completion.