COURSE OUTLINE:
Lesson 1: Developing “Should Cost Model” for negotiation and budgeting.
- Assessing competitiveness of supplier pricing
- How to use AUTOFIT command
- How to apply the right STYLE to a number
- How to build COMPLEX MATHEMATICAL FORMULA
Lesson 2: Developing Supplier Evaluation system
- Reference
- Absolute Reference
- Formatting text color
- Merge and center command
- Procurement Decision Support Features
Lesson 3: UTILIZING EXCEL SOPHISTICATED DECISION SUPPORT FEATURES
- SUM, MIN, IF FUNCTIONS
Lesson 4: Compare Bids, Analyze Spend and Track Supplier Performance
- Using charts; COLUMN CHARTS, PIE CHARTS AND LINE CHARTS.
Lesson 5: Organizing and Analyzing Procurement Spend Data
- SORTING, SUBTOTALS, FILL SERIES etc.
Lesson 6: Summarizing Procurement Patterns
- Developing TARGET PRICING MODELS for negotiation
- Using PIVOT TABLES, GOAL SEEK command tools.
Lesson 7: Drilling Down into Complex Procurement Spreadsheet
- Using VLOOKUP, CONDITIONAL FORMATTING AND FILTERING
Course Features
- Lectures 8
- Quizzes 0
- Duration 5 Hours
- Skill level All levels
- Language English
- Students 2
- Certificate No
- Assessments Yes