Curriculum

6 Chapters · 37 Lessons

  1. 1

    UVOD U EXCEL

    1. (Included in full purchase)

      Napredne Pivot Tabele

    2. (Included in full purchase)

      Konvertovanje, Ribbon i Quick Access Toolbar

    3. (Included in full purchase)

      Prečice i rad sa sheet-ovima

    4. (Included in full purchase)

      Uvod u Excel PDF

    5. (Included in full purchase)

      Kviz: Uvod

  2. 2

    FUNKCIJE

    1. (Included in full purchase)

      Funkcije za povezivanje tabela

    2. (Included in full purchase)

      VLOOKUP

    3. (Included in full purchase)

      VLOOKUP i MATCH

    4. (Included in full purchase)

      INDEX i MATCH

    5. (Included in full purchase)

      Funkcije za povezivanje tabela (rešenja)

    6. (Included in full purchase)

      Kviz: Funkcije

  3. 3

    BAZA PODATAKA

    1. (Included in full purchase)

      Baza podataka i Pivot tabela

    2. (Included in full purchase)

      Sređivanje i priprema baze podataka za Pivot

    3. (Included in full purchase)

      Change Data Source u Pivotu

    4. (Included in full purchase)

      Osnovni delovi Pivot tabele

    5. (Included in full purchase)

      Baza podataka i Pivot tabele (rešenja)

    6. (Included in full purchase)

      Baza podataka PDF

    7. (Included in full purchase)

      Kviz: Baza podataka

  4. 4

    PIVOT TABELA

    1. (Included in full purchase)

      Baza podataka i Pivot tabela

    2. (Included in full purchase)

      Osnovne komande u Pivotu

    3. (Included in full purchase)

      Grupisanje u Pivotu

    4. (Included in full purchase)

      Filteri u Pivotu

    5. (Included in full purchase)

      Kalkulacije u Pivotu

    6. (Included in full purchase)

      GETPIVOTDATA

    7. (Included in full purchase)

      Pivot tabela PDF

    8. (Included in full purchase)

      Kviz: Pivot tabela

  5. 5

    GRAFIKONI

    1. (Included in full purchase)

      Grafikoni u Pivotu

    2. (Included in full purchase)

      Rad sa grafikonima u Pivotu

    3. (Included in full purchase)

      Grafikoni u Pivotu (rešenja)

    4. (Included in full purchase)

      Grafikoni PDF

    5. (Included in full purchase)

      Kviz: Grafikoni

  6. 6

    POWER PIVOT

    1. (Included in full purchase)

      Power Pivot

    2. (Included in full purchase)

      Priprema baze i aktivacija Power Pivota

    3. (Included in full purchase)

      Kreiranje Data Modela

    4. (Included in full purchase)

      Kreiranje kalkulacija i Pivot tabele

    5. (Included in full purchase)

      Power Pivot

    6. (Included in full purchase)

      Kviz: Power pivot