Excel for Supply Chain Executives

Overview:

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists and etc…
As an employee, learning how to use Excel efficiently provides value, since most jobs utilize this application. This opens up more opportunities for employment and career advancement.
When employees know how to use Excel, it improves their efficiency in the workplace. Employees who know how to create detailed worksheets, invoices, charts, and complex formulas achieve professional results in a fraction of the time.
This course is designed to let participants explore the structure of the Excel workbook and demonstrates basic to advanced techniques required for working with spreadsheets.

Content:

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 range of cells & Jumping to a named range

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)

Key Benefits:

At program completion, participants will be able to:

• Manage all supply chain processes effectively & quickly
• Achieve high accuracy for supply chain results.
• Analyze all data and results of supply chain processes
• Manage the suppliers and execution process easily

Audience:

• Managers, Executives and Professionals who are involved in supply chain management.
• Professionals seeking in- depth knowledge and understanding of the Excel Supply Chain functions.