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čunaKako 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šč.
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
- Poglej, kako vodnik spreminja prave celice in pojasnjuje zakaj.
- Poziv za naslednji koristen rezultat sami.
- 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.
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.
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.
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
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
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
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
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
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
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
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
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
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.