Curriculum

7 Chapters · 35 Lessons

  1. 1

    BAZA PODATAKA

    1. (Included in full purchase)

      Prečice i rad sa sheet-ovima

    2. (Included in full purchase)

      Fiksiranje i Named Ranges

    3. (Included in full purchase)

      Formula auditing

    4. (Included in full purchase)

      Pravljenje baze podataka

    5. (Included in full purchase)

      Sređivanje i priprema baze za Pivot

    6. (Included in full purchase)

      Kviz: Baza podataka

  2. 2

    NAREDBA

    1. (Included in full purchase)

      Freeze Panes

    2. (Included in full purchase)

      Sortiranje i filtriranje

    3. (Included in full purchase)

      Remove Duplicates

    4. (Included in full purchase)

      Grupisanje

    5. (Included in full purchase)

      Subtotal

    6. (Included in full purchase)

      Data Table

    7. (Included in full purchase)

      Kviz: Naredba

  3. 3

    FUNKCIJE

    1. (Included in full purchase)

      Vlookup

    2. (Included in full purchase)

      Numeričke funkcije

    3. (Included in full purchase)

      GETPIVOTDATA

  4. 4

    PIVOT TABELA

    1. (Included in full purchase)

      Osnovne komande u Pivotu

    2. (Included in full purchase)

      Grupisanje u Pivotu

    3. (Included in full purchase)

      Filteri u Pivotu

    4. (Included in full purchase)

      Kalkulacije u Pivotu

    5. (Included in full purchase)

      Kviz: Pivot tabela

  5. 5

    POWER PIVOT

    1. (Included in full purchase)

      Power Pivot - Rad sa više baza i relationships

    2. (Included in full purchase)

      Power Pivot - Kreiranje kalkulacija

    3. (Included in full purchase)

      Power Pivot - Dashboards

    4. (Included in full purchase)

      Kviz: Power pivot

  6. 6

    POWER QUERY

    1. (Included in full purchase)

      Uvoz podataka

    2. (Included in full purchase)

      Komande za sređivanje podataka

    3. (Included in full purchase)

      Power Query - Append i Merge Queries

    4. (Included in full purchase)

      Power Query - Priprema podataka za analizu

    5. (Included in full purchase)

      Power Query - Uvoz podataka za analizu

    6. (Included in full purchase)

      Kviz: Power Query

  7. 7

    POWER BI

    1. (Included in full purchase)

      Power BI - Uvoz podataka

    2. (Included in full purchase)

      Power BI - Relationships

    3. (Included in full purchase)

      Power BI - Reporting i Dashboards

    4. (Included in full purchase)

      Kviz: Power BI