Excel Labs AI: Shandura maspredishiti ako nehungwaru hwekugadzira

Kugadziridza kwekupedzisira: 24/04/2025
munyori: Daniel Terrasa

  • Excel Labs inobatanidza generative AI uye yepamusoro fomula masisitimu muExcel.
  • Inokutendera kuti ugadzire, kugadzirisa, uye kushandisa zvakare mafomula akaomarara zviri nyore.
  • LABS.GENERATIVEAI inogadzirisa kuongororwa kwedata, kupfupisa, uye shanduko.

Excel Labs AIUnogona kufungidzira uchikwanisa kushandisa simba rekugadzira njere dzekugadzira zvakananga kubva kune yako Excel spreadsheets? Nhasi izvi zvatove zvinogoneka nekuda kweAI mabasa e Excel Labs, yekuedza plugin iyo Tora mikana yeExcel kune inotevera nhanho. Uye pasina kusiya chirongwa kana kuvimba nezvishandiso zvekunze.

Muchikamu chino tinokuunzira gwara rakakwana ne Zvese zvaunoda kuti uzive nezveExcel Labs. Isu tinoongorora mabasa ayo enyeredzi, kuisirwa zvinodiwa uye kubatanidzwa kwayo mune yakajairwa kufambiswa kwebasa ne Excel.

Chii chinonzi Excel Labs AI uye inobva kupi?

Excel Labs ndeye yekuwedzera-yekuwedzera yakagadzirwa neMicrosoft Garage. Kune avo vasingazive, iyi kupatsanurwa kweMicrosoft pachayo yakatsaurirwa kuvandudza uye kuyedza mapurojekiti ekuvandudza anogona (kana kusagona) kupedzisira abatanidzwa mune zvekupedzisira zvigadzirwa zvekambani. Chinangwa chayo chikuru ndechekushanda senzvimbo yekuyedza yezvinhu zvitsva, kuunganidza mhinduro chaiyo yemushandisi.

Excel Labs AI inosanganisa yakanakisa yemhando yepamusoro fomula nharaunda inozivikanwa se Yepamusoro Formula Environment ine tsika yekupayona inonzi LABS.GENERATIVEAI. Iyo yekupedzisira inobvumidza iwe kutaurirana zvakananga neanogadzira enjere mamodheru kubva mukati meExcel, ichipa chidimbu chitsva che otomatiki uye rubatsiro kuburikidza neAI.

Nyaya inoenderana:
Essential Excel Formulas kuti Utange uye Dzidza Excel Formulas

Excel Labs AI

LABS.GENERATIVEAI inoshanda sei uye chii chaungaite nayo?

Basa renyeredzi reExcel Labs nderoLABS.GENERATIVEAI. Mukuita, itsika basa rinoita senge chero imwe Excel formula, asi inobvumidza iwe kupindirana nemhando yepamusoro yemitauro.

Exclusive content - Click Here  Iwo 7 akanakisa dzimwe nzira dzeExcel

Inoshanda zviri nyore: iwe unopinza basa muchitokisi, wedzera zvaunoisa, uye munguva pfupi, Excel Labs 'AI inodzosera mhinduro zvakananga kune yako spreadsheet. Hezvino zvimwe zvinhu zvinogona kuwanikwa:

  • Ongorora ruzivo rweruzhinji kana rwakavanzika: inokumbira zvipfupiso, tsananguro, kana kuongororwa kwedata rakaomarara.
  • Kupinza uye chimiro data: Bvunza AI kuti ibvise, ishandure, uye ipe ruzivo mune chaiyo mafomati (rondedzero, matafura, nezvimwewo).
  • Pindura mibvunzo yekugadzira kana yehunyanzvi: kubva pakunyora zvinyorwa kusvika pakugadzira mienzaniso netsika mhinduro.
  • Gadzirisa ruzivo nereferensi kune mamwe maseru: Unogona kuvaka kukurumidza kukurudzira nekubatanidza kune zvimwe zvikamu zvespredishiti rako, uchibvumira AI kuti igadzirise otomatiki mhinduro dzayo zvichienderana nehunhu huri mugwaro.
  • Rongedza mibairo uchishandisa advanced parameter: Dzora kusika, kureba, uye chimiro chemhinduro dzako nemasetirwo akaita setembiricha, frequency, uye chiratidzo chekugumira.

Zvinodiwa pakushandisa Excel Labs AI

Kuti utange neExcel Labs AI iwe unongoda kusangana nevashoma zviri nyore zvinodiwa. Chokutanga pane zvose, unofanira kuva a account paOpenAI (iwe unogona kugadzira imwe yemahara) uye gadzira yako API Kiyi, iyo inokutendera kuti ubatanidze Excel kune iyo AI modhi. Tevere, dhawunirodha iyo Excel Labs yekuwedzera-mukati kubva kuHofisi Yekuwedzera-ins Chitoro zvakananga kubva kuExcel.

Kana yangoiswa, yakazvipira basa pane ichaonekwa mukati meExcel Add-ins tab. Kubva pano iwe uchave nekuwana kune ese ari maviri LABS.GENERATIVEAI basa uye yepamusoro fomula nharaunda.

Excel Labs ndiyo Inoenderana neWindows uye Mac, pamwe newebhu vhezheni yeExcel. Nekudaro, kushandisa iyo Python kodhi mupepeti inosanganisirwa mune yekuwedzera-mukati, iwe unozoda account ine mukana wePython muExcel.

Maitiro ekuverenga maseru ane mavara muExcel
Nyaya inoenderana:
Maitiro ekuverenga maseru ane mavara muExcel: nhanho nhanho gwara

Excel Labs AI

Yepamberi Formula Nzvimbo: Excel Labs 'Chakavanzika Weapon

Iyo yepamusoro formula nharaunda kana Yepamusoro Formula Environment inomiririra Shanduko yechokwadi munzira yaunogadzira, kugadzirisa, uye kushandisa zvakare mafomula muExcel.. Kana iwe wakambonetseka nekutadza-ku-kutevera mafomula, zvikanganiso zvisina tsananguro, kana kutevedzera uye kunama subformulas kakawanda, chimiro ichi ndechako.

Exclusive content - Click Here  Mashandisiro eHofisi yemahara nemashambadziro: Zvese zvaunoda kuti uzive

Aya ndiwo mamwe emhando dzayo dzinonyanya kukosha:

  • Kodhi mupepeti ane syntax inosimudzira, inline zvikanganiso, uye otomatiki fomati, zvichiita kuti zvive nyore kunyora uye kugadzirisa mafomula marefu.
  • Comments, indentation, uye tsigiro yemafomula ane mazita uye LAMBDA mabasa, inosimudzira kujeka kwekodhi uye kushandiswazve.
  • Kugona kupinza, kugadzirisa, uye sync mabasa kubva kune mamwe mabhuku ebasa kana kunyange kubva kuGitHub, kuwedzera zvinoshamisa mikana yekugadzirisa uye kubatana.
  • Maonero akarongwa eese ane mazita mafomula, ichikubvumidza kuti utore yakazara basa modules nenzira yehunyanzvi.
Nyaya inoenderana:
Ndingashandisa sei kutsvaga uye referensi basa muExcel?

Ngenisa kubva kune grid uye otomatiki chizvarwa cheLAMBDAs

Chimwe chinonyanya kukosha cheExcel Labs AI ndeye kugona kupinza calculation logic zvakananga kubva kune grid. Iyi sarudzo inokutendera iwe kuti usarudze huwandu hwemasero, kubvisa logic yavo, uye otomatiki kuishandura kuita LAMBDA basa, kusanganisira iyo LET chimiro kurongedza zvakajeka mukati memukati. Iyo nzira iri nyore kwazvo:

  1. Sarudza huwandu hwemaseru ane macalculation achaiswa.
  2. Ratidza masero ekupinda nekubuda.
  3. Dzvanya "Preview" uye Excel Labs 'AI ichagadzira LAMBDA basa rinobva pane yako yakasarudzwa misoro uye kuverenga.
Exclusive content - Click Here  Iwo akanyanya kukosha eExcel mafomula ekutanga kubva mukutanga senge pro

Iwe unogona ipapo kugadzirisa mazita akasiyana uye kushandisa zvakare LAMBDA mune chero imwe mamiriro. Iyi ficha inoponesa chaiyo kune avo vari kutsvaga kukwenenzvera mafambiro ebasa ravo uye kugadzirisa pachena mafomula mumabhuku ebasa akagovaniswa.

Zvakanakira uye Zvinetso zveExcel Labs: Zvaunofanirwa Kuchengeta Mupfungwa

Pakati pemasimba makuru eExcel Labs AI ndeaya: Kureruka kwekushandisa, kubatanidzwa kwayo kwekuzvarwa neExcel, uye kugona kwayo kurerutsa maitiro akaomarara. Uyezve, ndeyemahara uye inowirirana neshanduro dzichangoburwa dzechirongwa.

Zvimwe zvekufunga nezvazvo:

  • Nzira yekutanga yekudzidza-Kunyangwe iyo plugin yakagadzirirwa kuve intuitive, kutora mukana wakazara wezvese maficha kungangoda kumwe kuchinjika kana usina kujaira kushanda netsika mabasa kana coding nharaunda.
  • Kutsamira pamakiyi eAPI uye kubatana kweinternet: Kuti ushandise generative AI, unoda kiyi yeOpenAI API uye chinongedzo chinoshanda, chinogona kunge chiri chipingamupinyi munzvimbo dzakavharwa zvakanyanya kana dzakadzimwa.
  • Haasi ese maficha ekuyedza achabatanidzwa mune yakajairwa Excel.: : Zvichienderana nemhinduro, mamwe maficha anogona kubviswa kana kushandurwa mune ramangwana.

Imwe yemabhenefiti eExcel Labs AI ndeyekuenderana kwayo kwepasirese: Inoshanda mune ese azvino mavhezheni eExcel, kusanganisira Windows, Mac, uye online vhezheni. Iyo plugin inowanikwa mumitauro yakati wandei, kusanganisira Spanish, ichifambisa kutorwa kwayo kwenyika dzese.

Kune avo vanoda kudzidza zvakawanda, kune akawanda zviwanikwa uye zvinyorwa zviripo paExcel Labs webhusaiti uye kuburikidza neakasarudzika nzira uye nharaunda dzevashandisi. Pamusoro pezvo, Microsoft inokurudzira mhinduro yakananga kubatsira mukuvandudza chirongwa.