BAS4SC - EXCEL CRO

Topic outline

• 

  General

  • Forum
  • Handbook File
• 

  INTRODUCTION TO SPREADSHEET ANALYSIS

  • Chapter 1 File
  • Presentation 1 File
• 

  DATA VISUALIZATION METHODS

  • Chapter 2 File
  • Presentation 2 File
• 

  OPTIMIZATION IN SUPPLY CHAIN MANAGEMENT

  • Chapter 3 File
  • Presentation 3 File
• 

  CONTROLLING IN SUPPLY CHAIN MANAGEMENT

  • Chapter 4 File
  • Presentation 4 File
• 

  ANALYTICS IN THE AREA OF SUPPLY AND PURCHASING

  • Chapter 5 File
  • Presentation 5 File
• 

  OUTSOURCING

  • Chapter 6 File
  • Presentation 6 File
  • Cost Analysis - teaching materials for exercises + excel file Assignment
• 

  DISTRIBUTION NETWORK OPTIMIZATION USING GRAVITY POINT

  • Chapter 7 File
  • Presentation 7 File
  • Distribution Network Optimization - teaching materials for exercises + excel file Assignment
  • Case1. Logistics operator locations + excel file Assignment
• 

  DEMAND FORECASTING

  • Chapter 8 File
  • Presentation 8 File
  • Forecasting - teaching materials for exercises + excel file Assignment
• 

  INVENTORY MANAGEMENT

  • Chapter 9 File
  • Presentation 9 File
• 

  TRANSPORT OPTIMIZATION

  • Chapter 10 File
  • Presentation 10 File
  • Transport Optimization - teaching materials for exercises + excel file Assignment
  • Case 2. Selection of logistics operator + excel file Assignment
• 

  ADDITIONAL VIDEOS

  • ---

    INTRODUCTION

  • Video 1 - introduction (16m) URL
  • Video 2 - introduction (2h) URL
  • ---

    FORMULAS AND FUNCTIONS

  • Video 1 - formulas and functions (13m) URL
  • Video 2 - formulas and functions (11m) URL
  • Video 3 - formulas and functions (53m) URL
  • ---

    CHARTS

  • Video 1 - charts (17m) URL
  • Video 2 - charts (7m) URL
  • Video 3 - charts (8m) URL
  • ---

    PIVOT TABLES

  • Video 1 - pivot tables (14m) URL
  • Video 2 - pivot tables (8m) URL
  • ---

    SOLVER

  • Video 1 - solver (24m) URL
  • Video 2 - solver (8m) URL
  • ---

    TIPS AND TRICKS

  • Video 1 - tips and tricks (26m) URL
  • Video 2 - tips and tricks (53m) URL
  • Video 3 - tips and tricks (40m) URL
  • ---

    FULL COURSE

  • Video 1 - basic level (1h) URL
  • Video 2 - intermediate level (1,5h) URL
  • Video 3 - intermediate level (2,5h) URL
  • Video 4 - advanced level (4h) URL
• 

  ADDITIONAL COURSES open access

  • Introduction to MS Excel (7h) URL
  • 50 Excel Formulas to Get Smarter than Your Colleagues (1,5h) URL
  • Excel for Beginners (7h) URL
  • Excel Certification Course Online (15h) URL
  • Online Excel Training (12h) URL
  • List of Excel Courses URL