Request Call Back000-000-0000
Monday - Friday8AM - 9PM
Addressiraq

• Using range names in formulas

Course Content
Formulas & formatting
0/14
• 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
0/8
• 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
0/8
• 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
0/29
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)
Excel for Supply Chain Executives
About Lesson


Previous
Next