Excel for Procurement and Supply Chain Officers
Five days of Excel built around procurement workflows: organising supplier databases, building bid evaluation scorecards, tracking purchase orders and deliveries, analysing spend by category and supplier, and creating dashboards that procurement managers and audit committees can act on.
- Duration
- 5 days
- Level
- Intermediate
- Delivery
- In Pretoria, at your offices, or live online
- Group size
- Individuals or whole teams
- Build bid evaluation scorecards with weighted criteria
- Track purchase orders, deliveries and supplier performance
- Analyse procurement spend by category, supplier and period
- Create inventory models and reorder point calculators
- Build procurement dashboards for management reporting
- 1Supplier databases and registers. Building and maintaining supplier lists with data validation, dropdowns and lookup formulas.
- 2Bid evaluation and scoring. Weighted scoring models, automated scorecards and comparison matrices.
- 3Purchase order and delivery tracking. Order registers, status tracking, overdue alerts with conditional formatting.
- 4Spend analysis. Pivot tables and charts for spend by category, supplier, department and period.
- 5Procurement dashboards and reporting. Executive dashboards, KPIs and automated management reports.
Need a different date? Tell us when suits you — we schedule courses on demand for teams and individuals.
Procurement officers, supply chain managers, tender administrators and contract managers in government and the private sector.
Basic Excel use. No procurement system experience needed.
- In person in Pretoria, South Africa; at your offices anywhere; or live online on Microsoft Teams or Google Meet.
- International delegates are welcome in Pretoria — we arrange invitation letters for visa applications and recommend hotels near the venue.
- Run for your team only, on dates that suit you, with examples from your own work; or join an open course.
- Hands-on throughout: learners practise each step on their own device, not just watch.
- A certificate of completion that can be verified online.
Where is the training held?
At your offices anywhere in South Africa or at our training centre in Pretoria. For international delegates, we arrange training in Pretoria with joining instructions and hotel recommendations. Live online delivery on Microsoft Teams or Google Meet is also available.
Do you train organisations outside South Africa?
Yes. We work with organisations across Africa and beyond. International delegates can attend in person in Pretoria, South Africa, or join live online. We arrange invitation letters for visa applications and handle all logistics.
Can the course be run for our team only?
Yes. Most courses are run in-house for one organisation, on dates that suit you, with examples from your own work. Larger teams are split into groups.
What do learners receive?
A Beplugged Tech certificate of completion that anyone can verify online. Where a course prepares for a certification exam (Certiport, Microsoft, Oracle, Google), the exam can be arranged at our testing centre or through the certification body.
How do we book, and what does it cost?
Send the enquiry form on this page with the number of people and your preferred dates. We reply within one working day with dates, the full outline and a quote.
