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)