BAS4SC - EXCEL EN

Topic outline

• 

  General

  • Intro URL

    
    

  • Handbook File
  • Test 1 (pre) URL
  • Test 2 (pre) URL
  • Forum
  • File - full course to import in Moodle
• 

  1. INTRODUCTION TO SPREADSHEET ANALYSIS

  • Chapter 1 File
  • Presentation 1 File
• 

  2. DATA VISUALISATION METHODS

  • Chapter 2 File
  • Presentation 2 File
• 

  3. OPTIMISATION IN SUPPLY CHAIN MANAGEMENT

  • Chapter 3 File
  • Presentation 3 File
• 

  4. CONTROLLING IN SUPPLY CHAIN MANAGEMENT

  • Chapter 4 File
  • Presentation 4 File
• 

  5. ANALYTICS IN THE AREA OF SUPPLY AND PURCHASING

  • Chapter 5 File
  • Presentation 5 File
• 

  6. OUTSOURCING

  • Chapter 6 File
  • Presentation 6 File
  • Ex1: Cost Benefit Analysis Assignment
• 

  7. DISTRIBUTION NETWORK OPTIMISATION USING GRAVITY POINT

  • Chapter 7 File
  • Presentation 7 File
  • Ex2: Distribution Network Optimization Assignment
  • Case Study 1 Assignment
• 

  8. DEMAND FORECASTING

  • Chapter 8 File
  • Presentation 8 File
  • Ex3: Forecasting Assignment
• 

  9. INVENTORY MANAGEMENT

  • Chapter 9 File
  • Presentation 9 File
• 

  10. TRANSPORT OPTIMISATION

  • Chapter 10 File
  • Presentation 10 File
  • Ex4: Transport Optimization Assignment
  • Case study 2 Assignment
• 

  Post-test

  • Test 1 (post) URL
  • Test 2 (post) URL
• 

  ARTIFICIAL INTELIGENCE

  • Using AI in spreadsheet File
• 

  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