Excel Supply Chain Analysis: Solving Transportation Problems Course

Preview certificate

What will I learn?

Get lekker good at using Excel for efficient supply chain management with our in-depth course designed for finance professionals in Namibia. We'll start with the basics of Excel, teach you how to build transportation models, and use Solver for optimization. You'll learn advanced functions like VLOOKUP and INDEX, and become a master of data analysis with pivot tables and charts. Learn how to visualise and report data properly, and use cost minimisation strategies in real-world situations. Level up your skills and solve complex transportation problems with accuracy and confidence.

Apoia's Unique Features

Online course with lifetime access
Certificate aligned with educational standards
Printable PDF summaries
Online support always available
Select and arrange the chapters you wish to study
Customize your course workload
Instant feedback on practical activities
Study anytime, no internet connection required

Develop skills

Enhance the growth of the practical skills listed below

Master Excel formulas: Work smarter with essential functions and formulas.

Optimise transport models: Solve complex logistics challenges using Excel Solver.

Visualise data insights: Create powerful charts and summary reports.

Analyse supply chains: Balance supply and demand effectively.

Implement cost strategies: Reduce expenses with smart planning.

Suggested summary

Workload: between 4 and 360 hours

Before starting, you can modify the chapters and the workload.

  • Select which chapter to commence with
  • Add or remove chapters
  • Increase or decrease the course workload

Examples of chapters you can include

You’ll be able to generate additional chapters similar to the examples below

This is a free course focused on personal and professional growth. It does not equate to a technical, undergraduate, or postgraduate qualification, but offers practical and relevant knowledge for your professional journey.