Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training
Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training helps Procurement Officers and Supply Chain Managers build practical strategic procurement, logistics, and supply chain excellence capability through role-relevant activities, instructor-led 5 days delivery, and a clear certificate pathway.
Training provider: EduCore Global Skills
Category: Strategic Procurement, Logistics, and Supply Chain Excellence
Duration: 5 Days
Delivery: Instructor-led classroom, Live online, In-house corporate training
Certificate: Certificate of Completion
Course fees: KES 85,000 / USD 850
Course Overview
Professional strategic procurement, logistics, and supply chain excellence course for capacity building, professional development, executive training, corporate training, workshops, Kenya, Africa, and global training teams.
Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training is an instructor-led professional training course offered by EduCore Global Skills for individuals, teams, and organizations seeking practical capability in Strategic Procurement, Logistics, and Supply Chain Excellence.
EduCore Global Skills offers Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training as Strategic Procurement, Logistics, and Supply Chain Excellence training for Procurement Officers, Supply Chain Managers, Logistics Officers, Contract Managers and related professionals. Delivery supports classroom, live online, and corporate cohorts in Nairobi, Kenya or by arrangement.
Who Should Attend
- Procurement Officers
- Supply Chain Managers
- Logistics Officers
- Contract Managers
- Stores Officers
- Professionals
- Managers
- Technical staff
Prerequisites
No mandatory prerequisite is required unless stated in the course outline. Participants should bring relevant workplace examples where possible.
Course Modules
Excel Data Analysis Foundations
- Workbook structure, data tables, named ranges, and analysis-ready spreadsheet design
- Data types, data quality checks, validation rules, and common spreadsheet risks
- Sorting, filtering, subtotaling, structured references, and reusable analysis layouts
- Professional spreadsheet documentation, version control, and audit-friendly workbook habits
- Exercise: convert a raw worksheet into a clean analysis-ready Excel table
Formulas, Functions, and Analytical Logic
- Logical, lookup, text, date, statistical, and dynamic array functions for analysis
- XLOOKUP, INDEX MATCH, FILTER, SORT, UNIQUE, SUMIFS, COUNTIFS, and nested formulas
- Error handling with IFERROR, formula auditing, dependency tracing, and calculation checks
- Building reusable calculation blocks for KPIs, ratios, trends, and variance analysis
- Exercise: build an analytical formula model for a management reporting dataset
Data Cleaning and Transformation in Excel
- Cleaning duplicates, blanks, inconsistent labels, extra spaces, data types, and imported text
- Text to Columns, Flash Fill, Remove Duplicates, data validation, and conditional cleanup checks
- Using Power Query in Excel to import, merge, append, reshape, and refresh datasets
- Documenting transformation steps and preparing reliable data refresh workflows
- Exercise: clean and transform multiple Excel files into a consolidated analysis table
PivotTables, PivotCharts, and Interactive Analysis
- Creating PivotTables for grouping, summarizing, filtering, ranking, and cross-tab analysis
- Calculated fields, value field settings, slicers, timelines, grouping, and drill-down review
- Building PivotCharts and interactive reporting views for managers and operational teams
- Refreshing, changing data sources, preserving formatting, and troubleshooting pivot errors
- Exercise: create an interactive Excel analysis pack using PivotTables and slicers
Advanced Visualization and Dashboard Design in Excel
- Chart selection for trends, comparisons, distributions, variance, composition, and KPI monitoring
- Conditional formatting, sparklines, icon sets, dynamic labels, and dashboard controls
- Designing compact executive dashboards with clear hierarchy, layout discipline, and print readiness
- Avoiding visual clutter, misleading scales, weak chart choices, and inconsistent formatting
- Exercise: design an Excel dashboard from a business performance dataset
What-If Analysis, Forecasting, and Decision Models
- Goal Seek, Scenario Manager, Data Tables, Solver concepts, and sensitivity analysis
- Forecast sheets, trendlines, moving averages, seasonality, and simple predictive analysis
- Decision models for budgets, pricing, staffing, inventory, and operational planning
- Validating assumptions, documenting inputs, and presenting model limitations
- Exercise: build a what-if decision model and summarize the recommended scenario
Automation, Protection, and Reporting Productivity
- Using templates, data validation, worksheet protection, comments, notes, and controlled inputs
- Introduction to macros, recorded automation, Office Scripts concepts, and repeatable workflows
- Reducing manual reporting effort through refreshable queries, formulas, pivots, and dashboard links
- Quality assurance checklists for recurring Excel reports and shared workbooks
- Exercise: automate a recurring Excel reporting workflow and prepare a QA checklist
Capstone Excel Data Analysis Project
- Defining a business question, data requirements, analytical approach, and report audience
- Cleaning data, building formulas, creating pivots, designing dashboards, and validating outputs
- Interpreting insights, writing commentary, recommending actions, and handling review questions
- Packaging the workbook with documentation, assumptions, controls, and improvement notes
- Exercise: deliver a complete Excel analysis workbook and management insight brief
Training Focus
Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training helps Procurement Officers and Supply Chain Managers build practical strategic procurement, logistics, and supply chain excellence capability through role-relevant activities, instructor-led 5 days delivery, and a clear certificate pathway.
Related Course Discovery Links
Frequently Asked Questions
How is Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training delivered?
Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training is delivered through instructor-led classroom, live online, private in-house corporate training depending on the selected cohort or organizational arrangement.
What are the fees for Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training?
The published course investment is KES 85,000 and USD 850. Location-specific fees are shown where configured.
How long is Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training?
Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training runs for 5 Days unless a customized corporate schedule is agreed.
Do participants receive a certificate for Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training?
Participants who complete the course receive a Certificate of Completion from EduCore Global Skills.
Register for Strategic Procurement, Logistics, and Supply Chain Excellence: Analytics for Technical Officers Training or contact EduCore Global Skills.