Curriculum

8 Chapters · 56 Lessons

  1. 1

    FUNKCIJE

    1. (Included in full purchase)

      Plan otplate kredita

    2. (Included in full purchase)

      Numeričke funkcije

    3. (Included in full purchase)

      Funkcije u VBA

    4. (Included in full purchase)

      Vlookup sa više kriterijuma

    5. (Included in full purchase)

      Funkcije VLOOKUP i MATCH

    6. (Included in full purchase)

      Funkcije INDEX i MATCH

    7. (Included in full purchase)

      Logičke funkcije(IF_AND i OR)_ Goal Seek i Data Validation

    8. (Included in full purchase)

      Automatizacija funkcije SUMIFS

    9. (Included in full purchase)

      Funkcije logičke (IF, AND i IFNA) i numeričke (SUM(S), COUNTIF)

    10. (Included in full purchase)

      Plan završetka projekta (Datumske funkcije)

    11. (Included in full purchase)

      Radni staž

    12. (Included in full purchase)

      Pravljenje kalendara u Excel-u

    13. (Included in full purchase)

      Sređivanje baze zaposlenih

    14. (Included in full purchase)

      Izvlačenje potrebnih podataka iz baze

    15. (Included in full purchase)

      Analiza povišica plata

    16. (Included in full purchase)

      Analiza radnog iskustva

    17. (Included in full purchase)

      Analiza prodaje komercijalista

    18. (Included in full purchase)

      Funkcije

    19. (Included in full purchase)

      Kviz: Funkcije

  2. 2

    PIVOT

    1. (Included in full purchase)

      Funkcija GETPIVOTDATA

    2. (Included in full purchase)

      Change Data Source

    3. (Included in full purchase)

      Slicer i Show Report Filter Pages za pivot

    4. (Included in full purchase)

      Grupisanje u Pivotu

    5. (Included in full purchase)

      Grupisanje u Pivotu

    6. (Included in full purchase)

      Filteri u Pivotu

    7. (Included in full purchase)

      Grafikoni sa zelenom maksimalnom vrednošću

    8. (Included in full purchase)

      Dizajniranje Pivot tabele

    9. (Included in full purchase)

      Pivot

    10. (Included in full purchase)

      Kviz: Pivot

  3. 3

    SOLVER

    1. (Included in full purchase)

      Maksimizacija profita i solver

    2. (Included in full purchase)

      Minimizacija troskova i solver

    3. (Included in full purchase)

      Kviz: Solver

  4. 4

    WHAT IF

    1. (Included in full purchase)

      Vrednovanje kompanije

    2. (Included in full purchase)

      Procena rasta prodaje

    3. (Included in full purchase)

      What IF

    4. (Included in full purchase)

      Kviz: What If

  5. 5

    GRAFIKONI

    1. (Included in full purchase)

      Grafikoni sa crvenim i zelenim varijansama

    2. (Included in full purchase)

      Multiplikovanje grafikona

    3. (Included in full purchase)

      Skaliranje grafikona

    4. (Included in full purchase)

      Kviz: Grafikoni

  6. 6

    FORMULA AUDITING

    1. (Included in full purchase)

      Trace Precedents i Trace Dependents

    2. (Included in full purchase)

      Watch Window i Show Formulas

    3. (Included in full purchase)

      Formula Auditing

    4. (Included in full purchase)

      Kviz: Formula Auditing

  7. 7

    BAZA PODATAKA

    1. (Included in full purchase)

      Brži rad sa bazom podataka

    2. (Included in full purchase)

      Sređivanje baze podataka

    3. (Included in full purchase)

      Rad sa velikim bazama podataka

    4. (Included in full purchase)

      Uvoz podataka iz različitih izvora

    5. (Included in full purchase)

      Više nivoa zaštite podataka

    6. (Included in full purchase)

      Baze Podataka

    7. (Included in full purchase)

      Kviz: Baza podataka

  8. 8

    VIŠE OPCIJA

    1. (Included in full purchase)

      Custom Number Formats

    2. (Included in full purchase)

      Složeni kreditni kalkulator

    3. (Included in full purchase)

      Holding kompanija Izvestavanje

    4. (Included in full purchase)

      Planiranje treninga sa kalendarom

    5. (Included in full purchase)

      Kviz: Više opcija