BAS4SC - EXCEL SRB

Topic outline

• 

  General

  • Intro URL

    
    

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

  1. UVOD U ANALIZU PRORAČUNSKIH TABELA

  • Poglavlje 1 File
  • Prezentacija 1 File
• 

  2. METODE VIZUALIZACIJE PODATAKA

  • Poglavlje 2 File
  • Prezentacija 2 File
• 

  3. OPTIMIZACIJA U UPRAVLJANJU LANCEM SNABDEVANJA

  • Poglavlje 3 File
  • Prezentacija 3 File
• 

  4. KONTROLING U UPRAVLJANJU LANCEM SNABDEVANJA

  • Poglavlje 4 File
  • Prezentacija 4 File
• 

  5. ANALITIKA U PODRUČJU NABAVKE I KUPOVINE

  • Poglavlje 5 File
  • Prezentacija 5 File
• 

  6. OUTSOURCING

  • Poglavlje 6 File
  • Prezentacija 6 File
  • Vežba 1 Assignment
• 

  7. OPTIMIZACIJA DISTRIBUTIVNE MREŽE POMOĆU GRAVITACIONOG MODELA

  • Poglavlje 7 File
  • Prezentacija 7 File
  • Vežba 2 Assignment
  • Case Study 1 Assignment
• 

  8. PREDVIĐANJE POTRAŽNJE

  • Poglavlje 8 File
  • Prezentacija 8 File
  • Vežba 3 Assignment
• 

  9. UPRAVLJANJE ZALIHAMA

  • Poglavlje 9 File
  • Prezentacija 9 File
• 

  10. OPTIMIZACIJA TRANSPORTA

  • Poglavlje 10 File
  • Prezentacija 10 File
  • Vežba 4 Assignment
  • Case study 2 Assignment
• 

  Post-test

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

  VEŠTAČKA INTELIGENCIJA

  • Korišćenje veštačke inteligencije u tabelama File
• 

  DODATNI VIDEO SNIMCI

  • ---

    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
• 

  DODATNI KURSEVI otvorenog pristupa

  • 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