Supply Chain Analytics Using Excel
- Description
- Curriculum
Supply Chain Analytics Using Excel Course Overview
Supply Chain Analytics is a critical skill for professionals looking to optimize processes and make data-driven decisions. This course, “Supply Chain Analytics Using Excel,” is designed to equip participants with the essential tools and techniques needed to analyze and manage supply chain operations effectively. By leveraging the power of Excel, participants will learn how to apply analytical methods to real-world supply chain challenges, enhance efficiency, and drive profitability. This course is ideal for professionals aiming to boost their career in supply chain management, logistics, or operations.
Who Should Attend
- Supply Chain Managers and Analysts
- Logistics Coordinators and Managers
- Operations Managers
- Professionals seeking to transition into supply chain roles
- Individuals looking to enhance their Excel skills for supply chain analytics
Introduction to Supply Chain Analytics
- Overview of Supply Chain Management
- Importance of Analytics in Supply Chain
- Key Metrics and KPIs in Supply Chain
Excel Essentials for Supply Chain Analytics
- Data Organization and Management
- Introduction to Formulas and Functions
- Data Validation and Conditional Formatting
Data Analysis Techniques
- Descriptive Analytics: Summarizing Supply Chain Data
- Predictive Analytics: Forecasting Demand and Supply
- Prescriptive Analytics: Optimizing Inventory Levels
Advanced Excel Tools
- Pivot Tables and Pivot Charts for Supply Chain Analysis
- Solver and Scenario Manager for Decision Making
- Data Visualization Techniques in Excel
Introduction to Supply Chain Software
- Overview of Supply Chain Management Software
- Integrating Excel with Supply Chain Software
Johnson Fadola
My training and work experiences in the UK and Nigeria, have enhanced my high level of innovativeness and efficiency in my areas of career / specialisation. I am degree qualified and I have extensive experience in procurement, logistics, distribution, sales and marketing and supply chain management, with communication skills, negotiation skills, customer care service skills, organisational skills, problem solving and decision making skills, managerial / leadership skills, etc. I am a Certified Management Consultant (CMC) and a Fellow of the Institute of Management Consultant, Nigeria (FIMC). Also, Chartered Institute of Procurement and Supply (CIPS), UK and Nigeria, National Institute of Marketing of Nigeria (NIMN), etc.
Chigozie Paul Ndekile
Chigozie is a certified Project Manager Professional (PMP), Certified Business Analysis Professional (CBAP) and Prince 2 Practitioner with years of experience in Project Management, Banking, Auditing, Operations and Business Analysis. I have worked in different Industry and have a clear understanding on how project can be used to drive change. Over the years I have developed the right skill set to deliver to deliver the value that exceeds the customer’s expectation.
Participants enrolling for this programme will be required to have minimum of 3 years’ professional experience. Participants who meet the programme requirement should pay the course fee and complete the enrollment form 2 weeks before the programme kick off date.
Prospective applicants who do not meet the programme requirement but wants to join the programme should should follow the process detailed below.
Application Process
- Start a chat with the online course adviser or complete the application form
- Application will be reviewed by programme committee
- Application acceptance will be communicated by programme committee
- Pay the programme fee after receiving acceptance from the committee
- Check your mail for programme schedule and payment confirmation
Supply Chain Analytics Using Excel Course Fees
| Standard |
| ₦100,000 |
| Standard Plus |
| ₦120,000 |
| Professional |
| ₦160,000 |
| Professional Plus |
| ₦200,000 |
| Standard |
| ₦100,000 |
| Training Delivery Virtual |
| Duration Weekday: 5 Days Weekend: 5 Days |
| Manual & Cases (PDF) |
| Templates & Exam Guide (PDF) |
| Training Certificate (PDF) |
| Project with final grading |
| Refreshment |
| x |
| x |
| Perks |
| x |
| x |
| Additional Services |
| – |
| – |
| CV Development | LinkedIn Optimization Available at N5000 |
| Standard Plus |
| ₦120,000 |
| Training Delivery Virtual |
| Duration Weekday: 5 Days Weekend: 5 Days |
| Manual & Cases (PDF) |
| Templates & Exam Guide (PDF) |
| Training Certificate (PDF) |
| Project with final grading |
| Refreshment |
| x |
| x |
| Perks |
| x |
| x |
| Additional Services |
| Exam Application |
| Job Alerts |
| CV Development | LinkedIn Optimization 1 Package Included |
| Professional |
| ₦160,000 |
| Training Delivery Classroom |
| Duration Weekday: 5 Days Weekend: 5 Days |
| Manual & Cases Flash Drive (PDF) |
| Templates & Exam Guide Flash Drive (PDF) |
| Training Certificate Hard Copy |
| Project with final grading |
| Refreshment |
| Tea Break |
| Lite Lunch |
| Perks |
| x |
| Notepad & Pen |
| Additional Services |
| Exam Application |
| Job Alerts |
| CV Development | LinkedIn Optimization 1 Package Included |
| Professional Plus |
| ₦200,000 |
| Training Delivery Classroom |
| Duration Weekday: 5 Days Weekend: 5 Days |
| Manual & Cases Hard copy & PDF |
| Templates & Exam Guide Flash Drive (PDF) |
| Training Certificate Hard copy & PDF |
| Project Review & grading |
| Refreshment |
| Maxi Breakfast |
| Maxi Lunch |
| Perks |
| Back Pack |
| Notepad & Pen |
| Additional Services |
| Exam Application |
| Job Alerts |
| CV Development | LinkedIn Optimization Both Package Included |
Supply Chain Analytics Using Excel Course Dates for Upcoming Classroom & Virtual Online In 2024
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.
| Supply Chain Analytics Using Excel Programme | |
| Course Objective: | The Programme focus is to equip professionals with Excel-based analytics skills to optimize and enhance supply chain operations |
| Classroom | |
| Weekday Date: | Contact Us For Next Schedule |
| Weekend Date: | Contact Us For Next Schedule |
| Location: | 122a Obadina Street, Omole Phase 1 Ikeja Lagos |
| Virtual Class | |
| Weekday Date: | Contact Us For Next Schedule |
| Weekend Date: | Contact Us For Next Schedule |
| Location: | Microsoft Teams | Zoom |
Anthony Ani
“Relocating to Canada was the most challenging decision I and my family had to make, the uncertainties of a new country. I was determined that I won't risk everything to start earning minimum wage. I took my PMP training with Piston & Fusion, earned my certification at the first attempt, and to be honest it has elevated my career trajectory”
Gabriel Eluke (Human Resources/Admin) | Netcom Africa Limited
"I became a professional Human Resource personnel after my training with piston and Fusion. It brought a great turn around to my career and remains one of the best decisions I ever took. "
Okhueleigbe Usifo (Construction safety officer/ OFA) | Beedie Construction Canada
"The firm I worked with in Abuja had not paid salaries for 5 months, I decided to leave the country, and left for Dubai. I applied for a safety officer vacancy, out of 15 applicants I was the only person that was selected with HSE level 1, 2 and 3 certificate. I thought getting a job here would be difficult but my certificate helped me."
Uju Edinbus | Perform Group (Goal.com)
"I wanted to change my job, I needed something to give me the advantage to switch jobs. My friend advised I take a digital marketing course, after the training I started prospecting jobs, I got a call for my first interview, at the interview I was grilled extensively on my credentials, thanks to my digital marketing knowledge I got what I will describe as my dream job."
Mojisola Mosuro PMP | ExxonMobil
“As a fresh graduate I knew getting a good job would be a challenge. I researched online for a professional course to boost my CV, and I found P&F Project Management course. I completed the course. I have since changed jobs 3 times. Project Management. was the best Decision I made.”
Why Piston & Fusion Ranked Amongst the Best Business Institute In Nigeria?
- We have trained 6000+ professionals
- We have over 10 years industry experience
- Our facilitators are experienced and certified
- We offer post training career advice and support
People who enrolled for this course, also enrolled for the following courses
| Enterprise Risk Management | Fleet Management |
| Procurement and Contract Management | Logistics and Supply Chain Management |
All You Need to Know About Supply Chain Analytics Using Excel
What is Supply Chain Analytics?
Supply Chain Analytics involves analyzing data related to supply chain operations to improve efficiency, forecast demand, manage inventory, and make data-driven decisions. It uses various analytical methods to optimize supply chain processes and enhance overall performance.
Why Supply Chain Analytics Using Excel
The Supply Chain Analytics Using Excel course focuses on equipping professionals with the skills to analyze and optimize supply chain operations using Excel. It covers essential analytical methods, advanced Excel tools, and real-world applications to enhance efficiency and decision-making in supply chain management.
How can Supply Chain Analytics skills enhance career prospects?
Skills in Supply Chain Analytics are highly valuable as they enable professionals to make data-driven decisions, optimize operations, and contribute to overall business success. These skills can lead to roles with greater responsibility, higher salaries, and opportunities for advancement in various industries.
What industries are seeking Supply Chain Analytics professionals?
Supply Chain Analytics professionals are in demand across multiple industries, including:
Manufacturing: For optimizing production processes and managing inventory.
Retail: To forecast demand and improve supply chain efficiency.
Logistics and Transportation: For managing distribution networks and reducing costs.
Healthcare: To streamline the supply of medical products and equipment.
Technology and E-commerce: For managing complex supply chains and enhancing customer service.
How can I improve my Excel skills for Supply Chain Analytics?
Improving Excel skills can be achieved through practice, online courses, training, and hands-on projects. The Supply Chain Analytics Using Excel Course is designed to help you learn advanced functions, data analysis techniques, and visualization tools that are specifically useful for supply chain analytics.
Course details
Level
Intermediate
Popular courses
-
Logistics and Supply Chain Management
Members onlyBy piston -
Financial Modeling & Forecast...
Members onlyBy piston
-
Procurement and Contract Management
Members onlyBy piston
-
Project Management Professional (PMP)
Members onlyBy admin
-
Data Analysis – Advanced Exc...
Members onlyBy admin
-
Digital Marketing Strategy & ...
Members onlyBy admin
-
Data Analysis Using SPSS
Members onlyBy admin
-
Business Leadership for Managers &...
Members onlyBy admin
-
Tax Planning & Corporate Comp...
Members onlyBy admin