Program kursa

9 Chapters · 46 Lessons

  1. 1

    OSNOVE

    1. (Included in full purchase)

      Uvod u trening Napredni Excel

    2. (Included in full purchase)

      Ribbon, Quick Access Toolbar

    3. (Included in full purchase)

      Regionalna podešavanja

    4. (Included in full purchase)

      Sortiranje, filtriranje

    5. (Included in full purchase)

      Conditional formatting

    6. (Included in full purchase)

      Reference i imenovanje ćelija

    7. (Included in full purchase)

      Prečice

    8. (Included in full purchase)

      Prečice - rekapitulacija

    9. (Included in full purchase)

      Freeze panes

    10. (Included in full purchase)

      Štampanje

    11. (Included in full purchase)

      Zaštita podataka

    12. (Included in full purchase)

      Kviz: Osnove rada u Excel-u

  2. 2

    VLOOKUP

    1. (Included in full purchase)

      VLOOKUP

    2. (Included in full purchase)

      VLOOKUP - četvrti argument (TRUE/FALSE)

    3. (Included in full purchase)

      Kviz: VLOOKUP

  3. 3

    NUMERIČKE FUNKCIJE

    1. (Included in full purchase)

      SUM, AVERAGE, COUNT, COUNTA

    2. (Included in full purchase)

      MIN, MAX, LARGE, SMALL

    3. (Included in full purchase)

      SUMIF, AVERAGEIF, COUNTIF

    4. (Included in full purchase)

      SUMIFS, AVERAGEIFS, COUNTIFS

    5. (Included in full purchase)

      Kviz: Numeričke funkcije

  4. 4

    TEKSTUALNE FUNKCIJE

    1. (Included in full purchase)

      TRIM, PROPER, UPPER, LOWER

    2. (Included in full purchase)

      LEFT, MID, RIGHT, LEN

    3. (Included in full purchase)

      Text to columns

    4. (Included in full purchase)

      Flash Fill

    5. (Included in full purchase)

      CONCAT

    6. (Included in full purchase)

      Kviz: Tekstualne funkcije

  5. 5

    DATUMSKE FUNKCIJE

    1. (Included in full purchase)

      DATE, DAY, MONTH, YEAR

    2. (Included in full purchase)

      DATEDIF

    3. (Included in full purchase)

      Kviz: Datumske funkcije

  6. 6

    LOGIČKE FUNKCIJE

    1. (Included in full purchase)

      IF, ISBLANK

    2. (Included in full purchase)

      AND, OR

    3. (Included in full purchase)

      Kviz: Logičke funkcije

  7. 7

    FINANSIJSKE FUNKCIJE

    1. (Included in full purchase)

      PMT, IPMT, PPMT

    2. (Included in full purchase)

      Kviz: Finansijske funkcije

  8. 8

    PIVOT TABELE

    1. (Included in full purchase)

      Priprema baze za Pivot

    2. (Included in full purchase)

      Osnovne komande u Pivotu

    3. (Included in full purchase)

      Napredne komande u Pivotu

    4. (Included in full purchase)

      Pivot - zadatak za vežbu

    5. (Included in full purchase)

      Pivot - rešenje

    6. (Included in full purchase)

      Kviz: Pivot

  9. 9

    WHAT IF ANALIZA

    1. (Included in full purchase)

      Goal seek

    2. (Included in full purchase)

      Data table

    3. (Included in full purchase)

      Scenario Manager

    4. (Included in full purchase)

      Formula auditing

    5. (Included in full purchase)

      Data validation

    6. (Included in full purchase)

      Kviz: What if analiza