AI COALITION LEARNPrijava

KORISTNA VEŠČINA, KORAK ZA KORAKOM

Naučite se Excela.
Uporabite umetno inteligenco za svoje podjetje.

Sestavljajte pozive, ki opravijo koristne naloge v Excelu. Preglejte predlagane spremembe, jih uporabite in preverite rezultate.

Začni se učiti brezplačno →Poglavji 1 in 2 sta brezplačni · plačilo ni potrebno · začnite brez računa

Kako se učite: najprej opazujete, kako vodnik sešteje januarsko prodajo v celici B5 s formulo =SUM(B2:B4), ki pokaže 260. Nato napišete svoj poziv, na primer »Seštej februarsko prodajo v C5«. Kartica za pregled predlaga C5 = SUM(C2:C4), ki izračuna 315, označeno kot predlagano in ne shranjeno, dokler ga ne uporabite. Ko ga uporabite, C5 pokaže 315 in lekcija je preverjena kot dokončana, vaš napredek pa se premika po dvanajstpoglavni poti od formul in grafikonov do poslovnih pozivov, čiščenja, oblikovanja cen, denarnega toka, iskanj, vrtilnih tabel in nadzornih plošč.

Vaša prva zmaga: s pozivom ustvarite delujoč seštevek prodajeIlustracija · tako deluje vaša prva lekcija

PRAZNIČNA UVODNA PONUDBA

Celoten tečaj Excela · enkratno 19 $ USD

Enkraten nakup. Vključenih je vseh 12 poglavij, trenutne vaje tečaja, preverjanja znanja in pouk ob lekcijah. Brez obvezne naročnine. Poglavji 1–2 ostaneta brezplačni.

Prijavite se za nakup celotnega tečaja · enkratno 19 $ USD →

Najprej se prijavite z računom AI Coalition Network, da bo dostop do tečaja vezan nanj, nato se vrnite sem in zaključite nakup.

Načrtovana dodatna vadba z umetno inteligenco je neobvezna po ceni 19 $/mesec, zahteva ločen izrecen nakup in tu ni na voljo. Nakup tečaja vas vanjo nikoli ne vpiše.

Kako se učite

  1. Poglej, kako vodnik spreminja prave celice in pojasnjuje zakaj.
  2. Poziv za naslednji koristen rezultat sami.
  3. Pregled, uporaba in preverjanje predlagani rezultat v Excelu.

Ponovno predvajajte pojasnila, razveljavite spremembo ali ponastavite lekcijo, kadar koli potrebujete nov poskus.

Oglejte si celoten tečaj

Dvanajst poglavij. Poglavji 1–2 sta brezplačni. Tukaj je, kaj boste po vsakem poglavju zmogli narediti za svoje podjetje.

  1. Poglavje 1: Spreadsheet foundations Brezplačno

    Po tem poglavju zmorete: Turn a sales list into totals and a chart that update themselves when the numbers change.

  2. Poglavje 2: AI prompts for business spreadsheets Brezplačno

    Po tem poglavju zmorete: Prompt a sales tracker, an expense budget and a regional chart, checking each proposal before you apply it.

  3. Poglavje 3: Prepare reliable business data Celoten tečaj

    Po tem poglavju zmorete: Clean imported data (stray spaces, text numbers, duplicate IDs) into a table you can trust for reports.

    Clean an imported table · Sort and filter complete records · Independent data-quality check

  4. Poglavje 4: References and connected models Celoten tečaj

    Po tem poglavju zmorete: Build a pricing model with locked assumptions, so one changed input reprices every product correctly.

    Copy formulas with locked assumptions · Test a pricing scenario · Independent pricing model

  5. Poglavje 5: Cash-flow planning Celoten tečaj

    Po tem poglavju zmorete: Build a rolling cash forecast and stress-test a shortfall before it happens.

    Build a rolling cash forecast · Stress-test a cash shortfall · Independent cash-flow plan

  6. Poglavje 6: Sales and inventory decisions Celoten tečaj

    Po tem poglavju zmorete: Calculate stock positions and exceptions, and track down a stock discrepancy to its cause.

    Calculate stock and exceptions · Investigate a stock discrepancy · Independent inventory review

  7. Poglavje 7: Charts that support decisions Celoten tečaj

    Po tem poglavju zmorete: Chart actual results against targets and over time, and state the finding the chart supports.

    Compare actual results with targets · Show change over time · Independent chart and finding

  8. Poglavje 8: Lookups and reconciliation Celoten tečaj

    Po tem poglavju zmorete: Match invoices to payments with lookups that flag the exceptions instead of guessing.

    Reconcile invoices to payments · Guard ambiguous lookup matches · Independent exception review

  9. Poglavje 9: Native Excel PivotTables Celoten tečaj

    Po tem poglavju zmorete: Summarize sales by region with a real PivotTable in desktop Excel and refresh it when the data changes.

    Create a native regional PivotTable · Refresh after source changes · Independent PivotTable verification

  10. Poglavje 10: Dashboards and business KPIs Celoten tečaj

    Po tem poglavju zmorete: Build a one-page dashboard of revenue, profit, margin and top region that reconciles to the detail.

    Build a reconciled dashboard · Connect monthly and regional views · Independent management dashboard

  11. Poglavje 11: Repeatable reporting workflows Celoten tečaj

    Po tem poglavju zmorete: Add a new month to a report without duplicating records, so month-end is a rerun, not a rebuild.

    Append a new period safely · Rerun without duplicating records · Independent reporting refresh

  12. Poglavje 12: Independent business capstone Celoten tečaj

    Po tem poglavju zmorete: Produce a defensible management report from raw data on your own, sources preserved and every number checked.

    Prepare a defensible management report · Extend the report to a new period · Independent Excel capstone

Začni se učiti brezplačno → Raziščite poglavja 3–12 →

Poln dostop do tečaja stane 19 $ USD enkratno, vključno s trenutnimi vajami, preverjanji znanja in poukom ob lekcijah. Brez obvezne naročnine. Dodatna stalna vadba z umetno inteligenco zahteva ločen neobvezen nakup. Razpoložljivost blagajne si oglejte v zgornji ponudbi.