Excel Labs AI: Sinthani maspredishithi anu ndi luntha lochita kupanga

Kodi mungayerekeze kuti mutha kugwiritsa ntchito mphamvu zanzeru zopangira zopangira mwachindunji kuchokera pamasamba anu a Excel? Lero izi ndizotheka kale chifukwa cha ntchito za AI za Excel Labs, pulogalamu yowonjezera yoyesera kuti Tengani kuthekera kwa Excel kupita pamlingo wina. Ndipo popanda kusiya pulogalamuyo kapena kudalira zida zakunja.

M'nkhaniyi tikubweretserani kalozera wathunthu ndi Zonse zomwe muyenera kudziwa za Excel Labs. Timawunikiranso ntchito zake za nyenyezi, zofunikira pakuyika ndikuphatikiza kwake mumayendedwe wamba ndi Excel.

Kodi Excel Labs AI ndi chiyani ndipo imachokera kuti?

Excel Labs ndi a zowonjezera zoyeserera zopangidwa ndi Microsoft Garage. Kwa iwo omwe sakudziwa, ili ndi gawo la Microsoft lokha lodzipereka popanga ndikuyesa mapulojekiti omwe (kapena ayi) amatha kuphatikizidwa pazogulitsa zomaliza zakampani. Cholinga chake chachikulu ndikukhala ngati malo oyesera zinthu zatsopano, kusonkhanitsa ndemanga zenizeni za ogwiritsa ntchito.

Excel Labs AI imaphatikiza mawonekedwe apamwamba kwambiri omwe amadziwika kuti Advanced Formula Environment ndi mwambo wochita upainiya wotchedwa LABS.GENERATIVEAI. Chotsatiracho chimakupatsani mwayi wolankhulana mwachindunji ndi mitundu yopangira yanzeru yopangira kuchokera mkati mwa Excel, ndikupereka gawo latsopano lazinthu zokha komanso thandizo kudzera pa AI.

Kodi LABS.GENERATIVEAI imagwira ntchito bwanji ndipo mungakwaniritse chiyani nayo?

Ntchito ya nyenyezi ya Excel Labs ndi LABS.GENERATIVEAI. M'malo mwake, ndi ntchito yomwe imachita ngati fomula ina iliyonse ya Excel, koma imakupatsani mwayi wolumikizana ndi zilankhulo zapamwamba.

Zimagwira ntchito mophweka: mumalowetsa ntchitoyi mu selo, kuwonjezera zomwe mwalemba, ndipo pakapita nthawi, Excel Labs' AI imabwezera yankho ku spreadsheet yanu. Nazi zina zomwe zingatheke:

• Unikani zambiri zapagulu kapena zachinsinsi: amapempha chidule, mafotokozedwe, kapena kusanthula deta yovuta.
• Lowetsani ndi kupanga data: Funsani AI kuti ichotse, isinthe, ndikupereka zidziwitso m'mawonekedwe enieni (mndandanda, matebulo, ndi zina).
• Yankhani mafunso aluso kapena luso: kuyambira polemba zolemba mpaka kupanga zitsanzo ndi mayankho achikhalidwe.
• Sinthani zambiri ndi zolozera ku ma cell ena: Mutha kupanga zidziwitso zamphamvu polumikizana ndi magawo ena a spreadsheet, kulola AI kuti isinthe mayankho ake potengera zomwe zili muzolemba.
• Sinthani zotsatira ndi magawo apamwamba: Sinthani mwanzeru, kutalika, ndi kalembedwe ka mayankho anu ndi zochunira monga kutentha, ma frequency, ndi malire a ma tokeni.

Zofunikira pakugwiritsa ntchito Excel Labs AI

Kuti muyambe ndi Excel Labs AI muyenera kukumana ndi ochepa zofunika zosavuta. Choyamba, muyenera kukhala ndi a akaunti pa OpenAI (mutha kupanga imodzi kwaulere) ndikupanga kiyi ya API yanu, yomwe ingakuthandizeni kulumikiza Excel ku mtundu wa AI. Kenako, tsitsani zowonjezera za Excel Labs kuchokera ku Office Add-ins Store molunjika kuchokera ku Excel.

Mukayika, gawo lodzipatulira lidzawonekera mkati mwa tabu ya Excel Add-ins. Kuchokera apa mudzakhala ndi mwayi wopeza ntchito zonse za LABS.GENERATIVEAI komanso malo apamwamba a formula.

Excel Labs ndi Imagwirizana ndi Windows ndi Mac, komanso mtundu wa intaneti wa Excel. Komabe, kuti mugwiritse ntchito Python code editor yomwe ikuphatikizidwa muzowonjezera, mudzafunika akaunti yokhala ndi Python ku Excel.

Nkhani yowonjezera:

Momwe mungawerengere ma cell okhala ndi mawu mu Excel: kalozera wagawo ndi sitepe

Chilengedwe Chapamwamba cha Formula: Chida Chachinsinsi cha Excel Labs

The zapamwamba formula chilengedwe kapena Advanced Formula Environment zikuyimira Kusintha kwenikweni pakupanga, kusintha, ndi kugwiritsanso ntchito mafomula mu Excel.. Ngati munavutikapo ndi ma formula omwe simungawatsatire, zolakwika zosadziwika bwino, kapena kufunika kokopera ndikumata mobwerezabwereza, izi zidapangidwira inu.

Izi ndi zina mwazinthu zake zodziwika bwino:

• Mkonzi wa ma code okhala ndi kuwunikira kwa mawu, zolakwika zapaintaneti, ndikusintha zokha, kupangitsa kuti zikhale zosavuta kulemba ndi kukonza zolakwika zamitundu yayitali.
• Ndemanga, indentation, ndi chithandizo cha mafomu otchulidwa ndi ntchito za LAMBDA, kukwezera kumveka kwa ma code ndikugwiritsanso ntchito.
• Kutha kuitanitsa, kusintha, ndi kulunzanitsa ntchito kuchokera kumabuku ena ogwira ntchito kapena kuchokera ku GitHub, kukulitsa modabwitsa mwayi wosintha mwamakonda ndi mgwirizano.
• Mawonekedwe opangidwa amitundu yonse yotchulidwa, kukulolani kuti muzitha kuyang'anira ma module athunthu mwaukadaulo.

Lowetsani kuchokera ku gululi komanso kupanga ma LAMBDA

Chinthu china chothandiza kwambiri cha Excel Labs AI ndi kuthekera kolowetsa logic yowerengera mwachindunji kuchokera pagululi. Njirayi imakupatsani mwayi wosankha ma cell angapo, kuchotsa malingaliro awo, ndikusinthiratu kukhala ntchito ya LAMBDA, kuphatikiza kapangidwe ka LET kuti mukonzekere bwino zosintha zamkati. Njirayi ndiyosavuta:

1. Sankhani mitundu yosiyanasiyana ya ma cell omwe ali ndi mawerengedwe oti asungidwe.
2. Onetsani zolowetsa ndi zotulutsa.
3. Dinani "Preview" ndipo Excel Labs' AI ipanga ntchito ya LAMBDA kutengera mitu ndi mawerengedwe omwe mwasankha.

Mutha kusinthanso mayina osinthika ndikugwiritsanso ntchito LAMBDA mwanjira ina iliyonse. Izi ndi zopulumutsa moyo kwa iwo omwe akufuna kuwongolera momwe amagwirira ntchito ndikuwongolera kuwonekera kwa mafomula m'mabuku ogawana nawo.

Ubwino ndi Zovuta za Excel Labs: Zomwe Muyenera Kuzikumbukira

Zina mwa mphamvu zazikulu za Excel Labs AI ndi: Kusavuta kugwiritsa ntchito, kuphatikizika kwawo ndi Excel, komanso kuthekera kwake kufewetsa njira zovuta zachikhalidwe. Kuphatikiza apo, ndi yaulere kwathunthu ndipo imagwirizana ndi mitundu yaposachedwa kwambiri ya pulogalamuyi.

Zina zofunika kuziganizira:

• Gawo loyamba la maphunziro- Ngakhale pulogalamu yowonjezerayo idapangidwa kuti ikhale yowoneka bwino, kugwiritsa ntchito bwino mawonekedwe ake onse kungafunike kusintha ngati simunazolowere kugwira ntchito ndi makonda kapena malo osungira.
• Kudalira makiyi a API ndi intaneti: Kuti mugwiritse ntchito generative AI, mufunika kiyi ya OpenAI API ndi kulumikizana kogwira ntchito, komwe kumatha kukhala malire m'malo otsekedwa kwambiri kapena osalumikizidwa.
• Sizinthu zonse zoyeserera zomwe zidzaphatikizidwe mu Excel yokhazikika.: : Kutengera ndi mayankho, zina zitha kuchotsedwa kapena kusinthidwa mtsogolo.

Chimodzi mwazabwino za Excel Labs AI ndikuti imagwirizana konsekonse: Imagwira ntchito m'mitundu yonse yamakono ya Excel, kuphatikiza Windows, Mac, ndi mtundu wapaintaneti. Pulagiyi imapezeka m'zilankhulo zingapo, kuphatikiza Chisipanishi, zomwe zimathandizira kukhazikitsidwa kwake padziko lonse lapansi.

Kwa iwo omwe akufuna kuphunzira zambiri, pali zida ndi zolemba zambiri zomwe zikupezeka patsamba la Excel Labs komanso kudzera mumayendedwe apadera komanso madera ogwiritsa ntchito. Kuphatikiza apo, Microsoft imalimbikitsa malingaliro achindunji kuti athandizire kukonza projekiti.

Daniel Terrasa

Mkonzi wokhazikika pazaukadaulo komanso nkhani zapaintaneti yemwe ali ndi zaka zopitilira khumi pazama media osiyanasiyana. Ndagwira ntchito ngati mkonzi komanso wopanga zinthu pa e-commerce, kulumikizana, kutsatsa pa intaneti ndi makampani otsatsa. Ndalembanso pamawebusayiti azachuma, azachuma ndi magawo ena. Ntchito yanga ndi chidwi changanso. Tsopano, kudzera mu zolemba zanga mu Tecnobits, Ndimayesetsa kufufuza nkhani zonse ndi mwayi watsopano umene dziko laukadaulo limatipatsa tsiku lililonse kuti tisinthe miyoyo yathu.