Curriculum

4 Chapters · 22 Lessons

  1. 1

    UVOD

    1. (Included in full purchase)

      Dinamičke karakteristike & Spill

    2. (Included in full purchase)

      Kviz: Uvod

  2. 2

    DINAMIČKE ARRAY FUNKCIJE

    1. (Included in full purchase)

      Filter

    2. (Included in full purchase)

      Sort i Sortby

    3. (Included in full purchase)

      Unique

    4. (Included in full purchase)

      Kombinacija funkcija: Filter, Sort, Unique

    5. (Included in full purchase)

      Sequence

    6. (Included in full purchase)

      Randarray

    7. (Included in full purchase)

      Xlookup

    8. (Included in full purchase)

      Kviz: Dinamičke array funkcije

  3. 3

    UNAPREĐIVANJE KLASIČNIH FUNKCIJA UZ POMOĆ DINAMIČKIH ARRAYS

    1. (Included in full purchase)

      Kompatibilnost dinamičkih i običnih arrays

    2. (Included in full purchase)

      Fiksiranje ćelija

    3. (Included in full purchase)

      Sumifs & Countifs

    4. (Included in full purchase)

      Vlookup

    5. (Included in full purchase)

      If

    6. (Included in full purchase)

      Referenciranje array-a u drugom sheet-u

    7. (Included in full purchase)

      Transpose & Frequency

    8. (Included in full purchase)

      Kviz: Unapređivanje klasičnih funkcija uz pomoć dinamičkih arrays

  4. 4

    DODATNE FUNKCIONALNOSTI DINAMIČKIH ARRAYS

    1. (Included in full purchase)

      Data validation

    2. (Included in full purchase)

      Filter - više kriterijuma

    3. (Included in full purchase)

      Array u formuli

    4. (Included in full purchase)

      Kviz: Dodatne funkcionalnosti dinamičkih arrays