Excel for Supply Chain Management
Excel for Supply Chain Management
What is Excel for Supply Chain Management?
Excel for Supply Chain Management seeking to calculate payments for significant purchases, create a budget, or maintain organisation with checklists and other tools.
Excel makes it simple to track financial performance, including business profit or loss. The most frequently utilized spreadsheet program is Microsoft Excel.
Excel proficiency is a worthwhile investment for both your personal and professional lives.
The majority of jobs use Excel, thus as an employee, learning how to use it well has value. More options for employment and career progress result from this.
Why this course?
Understanding how to utilize Excel increases a worker’s productivity at work. Employees who are proficient in producing intricate worksheets, bills, charts, and complex formulae produce professional outcomes in a shorter amount of time.
Excel for Supply Chain Management demonstrates the fundamentals of more complex spreadsheet working methods and allows learners to study the structure of the Excel file.
Formulas & formatting
- Creating formulas
- formulas in cells
- Using the Formula Bar
- Excel basic functions & Automatic calculation
- Paste Function tool
- Previewing and printing
- Page Setup & Page Break Preview
- Headers and footers
- Repeating column/row headings
- Formatting numbers & text
- Coloring data and cells
- Wrapping and shrinking text
- Merging cells
- Conditional formatting
Data Management
- Full-Screen view
- Splitting the window
- Freeze Panes
- Using range names in formulas
- Re-defining and deleting range names
- Creating & using the Chart
- Editing and Formatting Charts
- Naming a group of cells and navigating to a named group
Advanced functions
- Using IF functions
- Creating and editing scenarios
- creating a Scenario Report
- Using Goal Seek
- Creating a pivot table & chart
- Defining the source range
- Formatting a pivot table
- Refreshing a pivot table
Supply chain functions by using Excel:
Forecasting
- Forecasting Functions
- Forecast accuracy tracking
- Forecast graphs & Plotting
Planning
- Cascading business plan
- Demand planning management
- Distribution plan
Procurement Management
- Supplier selection tools
- Supplier evaluation tools
- Procurement processes
- Karlajic matrix
Inventory Management
- Categorize item lists
- Sub-lists
- In-Out lists
- Stock inventory levels
- Stock control
- Inventory Levels
- Safety stock calculations & maintaining
- Reorder point calculations
- Lot size & breakeven calculations
- Economic order quantities (EOQ)
- Bill of material (BOM)
- inventory counting
- Inventory tracking
- budgeting,
- Mean absolute deviation calculation (MAD)
After completing the Excel or Supply Chain Management, individuals will be able to:
- Manage all supply chain operations swiftly and effectively.
- Achieve results for the supply chain with great precision.
- Examine all data and outcomes from supply chain operations.
- Easily manage the execution process and vendors.
- Supply chain management professionals, including managers and executives.
- Experts looking for comprehensive knowledge and comprehension of the Excel Supply Chain functions.
Course Features
- Lectures 0
- Quizzes 0
- Duration 24 hours
- Language ENG/AR
- Students 0
- Assessments Yes
![PD 02: SCM Supply Chain Management Course [ CILT International Diploma]](https://hpaconsultant.com/wp-content/uploads/2023/08/PD-02-SCM-Supply-Chain-Management-Course-CILT-International-Diploma--450x450.png "PD 02 SCM Supply Chain Management Course [ CILT International Diploma ]")