Program kursa

5 Chapters · 28 Lessons

  1. 1

    OSNOVE

    1. (Included in full purchase)

      Uvod u trening Osnovni Excel

    2. (Included in full purchase)

      Uvod i pokretanje Excel-a

    3. (Included in full purchase)

      Regionalna podešavanja

    4. (Included in full purchase)

      Osnovni delovi Excel-a

    5. (Included in full purchase)

      Kviz: Osnove rada u Excel-u

  2. 2

    UNOS PODATAKA

    1. (Included in full purchase)

      Unos numeričkih i tekstualnih vrednosti

    2. (Included in full purchase)

      Unos datumskih vrednosti

    3. (Included in full purchase)

      Kalkulacije (Apsolutne vs Relativne reference)

    4. (Included in full purchase)

      Kviz: Unos podataka

  3. 3

    FUNKCIJE

    1. (Included in full purchase)

      Numeričke funkcije (SUM, AVERAGE, COUNT)

    2. (Included in full purchase)

      Numeričke funkcije (MIN, MAX, LARGE, SMALL)

    3. (Included in full purchase)

      Automatizacija (Opcija AutoSUM)

    4. (Included in full purchase)

      Tekstualne funkcije (TRIM, PROPER, UPPER, LOWER)

    5. (Included in full purchase)

      Tekstualne funkcije (LEFT, MID, RIGHT, LEN)

    6. (Included in full purchase)

      Datumske funkcije (DATE, DAY, MONTH, YEAR)

    7. (Included in full purchase)

      Funkcija IF i ISBLANK

    8. (Included in full purchase)

      Kviz: Funkcije

  4. 4

    MODIFIKACIJE

    1. (Included in full purchase)

      Premeštanje i kopiranje podataka

    2. (Included in full purchase)

      Sređivanje redova i kolona

    3. (Included in full purchase)

      Formatiranje ćelija i teksta

    4. (Included in full purchase)

      Formatiranje brojeva

    5. (Included in full purchase)

      Kviz: Modifikacije

  5. 5

    DODATNE OPCIJE

    1. (Included in full purchase)

      Format painter

    2. (Included in full purchase)

      Conditional fomratting

    3. (Included in full purchase)

      Rad sa shape-ovima

    4. (Included in full purchase)

      Freeze panes

    5. (Included in full purchase)

      Štampanje

    6. (Included in full purchase)

      Kviz: Dodatne opcije