Umsebenzi omusha we-Copilot() we-Microsoft Excel: umhlahlandlela ophelele kanye namacala angokoqobo

  • I-Copilot isebenza ngaphakathi kwesipredishithi ukuze afinyeze, ahlele, akhe amafomula, futhi achaze imiphumela ngokukhiphayo komdabu nokubala kabusha okuzenzakalelayo.
  • =COPILOT() isetshenziswa njenganoma yimuphi umsebenzi, yamukela imiyalelo yolimi lwemvelo, futhi isebenza kububanzi, amathebula, namagama achaziwe.
  • Kukhona imikhawulo nezinyathelo zokuphepha: imikhawulo yokusetshenziswa, amaphutha angaba khona, futhi ayizilungele izimo ezinobungozi obukhulu; idinga ukubuyekezwa komuntu.
  • Ukukhishwa kancane kancane: Ukufinyelela okunelayisensi ye-Microsoft 365 Copilot esiteshini se-Beta kanye nokufika okuhleliwe kuwebhu ye-Excel ngohlelo lwe-Frontier.

Ungawusebenzisa kanjani umsebenzi we-Copilot() ku-Excel

U-Copilot ubeke unyawo oluqinile ku-Excel Futhi yenza kanjalo ngezici ezimbili ezihambisanayo: umuzwa ohlanganisiwe weribhoni onengxoxo nabasizi, nomsebenzi omusha womdabu wenjini yokubala okuvumela ukuthi ubhale imiyalelo yolimi lwemvelo ngqo kuseli. Akuwona umlingo, kodwa kuwukugxuma okusebenzayo kwalabo abahlala namathebula, ububanzi, namagama achaziwe, ngoba okukhiphayo kulahlwa kugridi njenganoma yimuphi umphumela we-Excel wakudala.

Kutuswa ukulungisa okulindelwe kusukela ekuqaleniI-Copilot ikusiza ukuthi ufingqe, uhlukanise, uhlele, ukhiqize, futhi uchaze amafomula, ngisho nokungenisa idatha ngokukuqondisa kusuka emithonjeni evamile ye-ecosystem ye-Microsoft, kodwa ayisebenzi njengomshayeli ozenzakalelayo okwazi ukuthumela iphrojekthi eyinkimbinkimbi kusukela ekuqaleni kuye ekupheleni ngokwayo. Noma kunjalo, inqubekelaphambili iyabonakala, futhi lapho isetshenziswa ngokuhlakanipha, yonga isikhathi futhi igwema ukuvinjwa lapho usuka kudatha uye ekucaceni imininingwane.

Iyini i-Copilot ku-Excel futhi isetshenziselwa ini?

Umbono omaphakathi ulula: Buza umbuzo usebenzisa ulimi lwemvelo futhi uthole impendulo esebenzisekayo ngaphakathi kwe-Excel. Leyo mpendulo ingaba ifomula, isifinyezo sombhalo, ithebula elihlongozwayo elinamakholomu, ukuhlukaniswa ngokwezigaba, ishadi, noma ithebula le-pivot, kuye ngohlobo lwesicelo nomongo otholakala kusipredishithi. Kumodi yayo ehlanganisiwe, i-Copilot iphinde ikuqondise emisebenzini ezenzakalelayo njengokungenisa ngokushesha, ukugqamisa, ukuhlunga, noma ukuhlunga idatha.

Indlela yokusebenzisa i-Copilot+ ku-Windows
I-athikili ehlobene:
Ungawathola kanjani amafayela usebenzisa i-Copilot ku-Windows

Isici esisha esigqama kakhulu ngumsebenzi othi =COPILOT()., esebenza njenganoma yimuphi omunye umsebenzi wohlelo olujwayelekile. Uthayipha uphawu olulinganayo, wengeze i-COPILOT kubakaki, futhi ucacise umyalelo futhi, uma kusebenza, ububanzi bedatha yesithenjwa. Umphumela uvela kuseli noma kububanzi bokuphumayo, ubalwa kabusha lapho idatha ishintsha, futhi ayidingi imibhalo yangaphandle noma izengezo ukuze ziqalise.

Izinzuzo ezibalulekile ngaphakathi kwe-Excel

Lona umsebenzi we-Copilot() ku-Excel nokuthi usetshenziswa kanjani.

  • Ukungeniswa kwedatha okusizwayo: I-Copilot ingakusiza ukuthi ulethe ulwazi olusuka kuwebhu, amafayela asingathwe kuwo I-OneDrive noma i-SharePoint, noma kusukela kwezokuxhumana zangaphakathi zenhlangano yakho, ukunciphisa ukushuba okujwayelekile nokushayisana kokulungiselela.
  • Ukugqamisa, ukuhlunga, kanye nezihlungi kundiza: Ngeziyalezo ezilula, u-Copilot angagqamisa amaseli ahlobene, aphakamise izihlungi zangokwezifiso, futhi asebenzise izinhlobo eziwusizo, isibonelo, ukuze abone izinombolo ezinkulu kuphela kunomkhawulo othize ngaphandle kwamafomula okwakha ngesandla.
  • Isizukulwane kanye nencazelo yamafomula- Uma udinga ikholomu ebaliwe noma uguquko oluthile, u-Copilot uphakamisa ifomula efanelekile futhi achaze nokuthi isebenza kanjani, akusize ufunde futhi uqinisekise lokho okwenzayo.
  • Ukuhlonza ulwazi: Ukucela okuthrendayo, amaphuzu aphezulu, ama-dip, ama-outliers, izifinyezo, amashadi, noma amathebula e-pivot kukuvumela ukuthi usuke kudatha uye kokutholiwe ngaphandle kokushiya isipredishithi.

Lapho ungathola khona i-Copilot ku-Excel

  • Isithonjana kuthebhu ethi Ikhaya: Kuribhoni, uzobona inkinobho ye-Copilot, lapho ungavula khona iziphakamiso, uqale ingxoxo, futhi ufinyelele izinketho eziyinhloko.
  • Izenzo ze-in situ kumaseli: Uma iseli likhethiwe, isithonjana esikhanyayo se-Copilot singase sibonakale senza izenzo ezihambisana nalowo mongo othize.

Isetshenziswa kanjani ekusebenzeni

Ngaphambi kokucela noma yini u-Copilot, qiniseka ukuthi idatha ikufomethi eqondwa kahle: ngokufanelekile, kufanele uguqule ububanzi bube ithebula noma, okungenani, usebenze ngobubanzi obuchazwe ngokucacile ukuze umsizi abe nomxholo oqinile.

Kusuka kusithonjana se-Copilot Ungakhetha eziphakamisweni ezisheshayo, njengokwenza into entsha, ukuphakamisa amafomula namafomethi, noma ukufingqa idatha, futhi ungavula iwindi lengxoxo ukuze wenze esakho isicelo ngamazwi akho.

Uma ukhetha ukuxoxa, unemibono esheshayo echazwe kusengaphambili kanye nenkululeko yokubuza imibuzo noma ukunikeza imiyalelo, njalo uyinciphisa ifike kusethi yedatha efanelekile ukuze izimpendulo zisebenze ngokuqondile kusipredishithi sakho.

Umsebenzi we-Copilot(): ubizwa kanjani nokuthi kungani ubalulekile

Ukuyisebenzisa kungokwemvelo njengokuthayipha =SUM noma =VLOOKUP: Vele uthayiphe okuthi =COPILOT() futhi, ngaphakathi kwabakaki, ufake imiyalelo futhi, uma kusebenza, izinkomba zobubanzi. Umphumela obuyisiwe uziphatha njenganoma yikuphi okunye okukhiphayo okuvela enjinini yokubala, okuvumela ukuhlanganiswa okungenamthungo ekugelezeni komsebenzi wakho.

Umlingiswa womdabu wenza umehluko: Awuwadingi amamakhro noma izandiso, imiphumela ibalwa kabusha lapho idatha ishintsha, futhi uyaqhubeka nokusebenza ngobubanzi, amathebula, namagama achaziwe njengokujwayelekile, okunciphisa ijika lokufunda licishe libe uziro.

Izimo ezivamile zokusetshenziswa ngaphandle kokushiya ishidi

  • Ukuxoxa ngemicabango ngaphakathi kwencwadi: Ikhiqiza uhlu lwamagama, izihloko, noma amagama angukhiye encazelweni emfushane, noma icela ukubhalwa kabusha okucacile noma okusemthethweni okwengeziwe kombhalo onamathiselwe.
  • Izifinyezo ezifinyelela iphuzu: Ibonisa ububanzi obubanzi futhi icela isifinyezo esinamathrendi, aphakeme, namadiphu ukuze iphendule ithebula elide libe isigaba esichazayo esilungele umbiko.
  • Ukuhlunga okuqondile kumakholomu amasha: Kukholomu yamazwana, amathikithi, noma izimpendulo zenhlolovo, cela amalebula anjengokuthi positive, neutral, noma negative, bese wengeza isigaba esifushane ukuze usize ukuhlaziya.
  • Izinhlu kanye namathebula on the fly: Chaza isakhiwo osifunayo futhi usivumele siphakamise ithebula elinamakholomu anjengomsebenzi, umthwalo wemfanelo, usuku nesimo, eliphelele njengesisekelo sokuzihlela ngaphandle kokumosha isikhathi esakhiweni.

Isibonelo esisetshenziswayo: kusuka emibonweni ehlakazekile kuya kumininingwane engenzeka

Cabanga ngeshidi lokubuyekeza mayelana nomenzi wekhofi omusha.Amanye amazwana akhuluma ngokunambitha, amanye akhuluma ngomsindo, noma umthamo wethangi. Nge-Copilot, ungafunda leyo kholomu futhi ubone amakholomu ambalwa engeziwe kwesokudla ngomuzwa wamazwana ngamunye kanye nesigaba esifushane njengokunambitha, umsindo, noma umthamo wethangi.

Leso sinyathelo esincane sishintsha umdlalo: Usuka ohlwini olungahlelekile uye kokuthile okungahlungwa, kuhlungwe, futhi kufinyezwe ngamaminithi. Ungakwazi, isibonelo, ukubala izehlakalo ngezigaba, ugxile ezinkingeni ezivame kakhulu, noma ubhale isifinyezo esiphezulu ukuze wabelane neqembu.

Umehluko wobubanzi: Okwenziwa ngu-Copilot ngokumelene nokusebenza komdabu

Kukhona i-nuance ebalulekile mayelana nemithombo- Ulwazi olwakhelwe ngaphakathi lwe-Copilot lungakusiza ukuthi ungenise usuka kuwebhu, i-OneDrive, i-SharePoint, noma ukuxhumana kwangaphakathi, kuyilapho umsebenzi womdabu othi =COPILOT() ohlolwayo usebenza ngokuqinile nedatha ekhona encwadini yokusebenzela.

Ngamanye amazwi, umsizi akamane asuke eshidini lakho.Inani lilele ekuqondeni okuphambi kwakho, ukukuguqula nokukuchaza, ngaphandle kokuthi ugxumele ku-inthanethi noma kumadokhumenti enkampani ngokwakho, okuqinisa ukulandeleka kokuhamba komsebenzi nokuvikeleka.

Yini engakayenzi futhi kungani ingekho ku-autopilot?

Ungalindeli ukuthi ngizoxazulula amaphrojekthi ayinkimbinkimbi kusukela ekuqaleni kuze kube sekupheleni.: Imisebenzi emikhulu efana nokuhlanganisa amaleja angaphansi amaningi, ukuguqula izimali ngenani elisemthethweni, ukususa izimpinda, kanye nokukhiqiza ishidi lebhalansi lekota elinamashadi aqhathanisayo kusadinga izendlalelo zokulawula komuntu nezinyathelo eziphakathi nendawo.

Amandla omshayeli wendiza akukhonkolo: Iqonda imiyalelo yolimi lwemvelo esetshenziswa eshidini, isheshisa imisebenzi yokuhlaziya, iphakamisa amafomula futhi yethule okutholiwe, kodwa idinga ukuthi uchaze umongo futhi uqinisekise okuphumayo ngemibandela yobungcweti.

Imikhuba emihle yokulungiselela idatha

Ukufometha idatha kuthebula kusiza kakhulu- Uma uguqulela ububanzi kuthebula, i-Excel idala izihloko ezicacile nezithenjwa ezihlelekile, okwenza kube lula ku-Copilot ukuqonda okuqukethwe futhi ibuyisele imiphumela ezinzile, esebenziseka kabusha.

Ukuqamba ububanzi nokunakekela izihloko- Uma izinkambu ziqanjwe ngokucacile futhi ububanzi buchazwe kahle, imiyalelo yolimi lwemvelo iba nenemba kakhudlwana futhi imiphumela idinga ukulungiswa okumbalwa okwalandela.

Ukuchazwa nokufunda kwamafomula

Okukhulu okuxoxwa ngakho kancane yincazelo yamafomula: Uma u-Copilot ephakamisa ifomula, ingakwazi ukuchaza ngokuningiliziwe ukucabanga kwayo, ukusiza labo abangajwayelene nemisebenzi ethile ukuthi baqonde isizathu sengxenye ngayinye futhi bagweme amaphutha abangwa ukukopisha nokunamathisela ngaphandle kokuqonda.

Lokhu kuhumusha ekudluliseni ulwazi: Ngaphezu kokuthola isisombululo, ufunda indlela, okuthi ngesikhathi esimaphakathi iphakamisa izinga leqembu futhi inciphise ukuncika ekuzameni nasephutheni emisebenzini ephindaphindwayo.

Imiphumela yomdabu nokubala kabusha okuzenzakalelayo

Imiphumela iziphatha njenganoma yikuphi ukuphuma kwe-Excel.: zilondolozwa eshidini, zingabhekiselwa kwamanye amafomula, futhi ziyabuyekezwa lapho idatha yomthombo ishintsha, ngomjikelezo wokubala kabusha ofanayo osuwaziyo kakade.

Indlela yokusebenzisa i-Copilot+ ku-Windows
I-athikili ehlobene:
Ungakha kanjani isifinyezo sedokhumenti ye-Word nge-Copilot

Lokhu kugwema izendlalelo ezengeziwe zobuchwepheshe: Ngaphandle kwemibhalo noma ama-plugin, ukulungiswa kulula, ifayela lihlala linjalo, futhi ukusebenzisana nabanye abasebenzisi akudingi ukufakwa okwengeziwe.

Izilinganiso zokusetshenziswa nemikhawulo yokusebenza

Kunemikhawulo yokugwema ukuhlukumeza nokuqinisekisa ukuzinza: : Ukusetshenziswa komsebenzi kunemikhawulo, njengobuningi bezingcingo ezingaba yi-100 njalo ngemizuzu eyishumi kanye ne-300 ngehora, ngakho-ke kuyalulekwa ukuthi ugxilise kakhulu izicelo futhi ungazibangeli ngokungalawuleki.

Ukuhlela ukusebenzelana kuyasiza: Ukuqoqa imisebenzi efanayo ngamaqembu, ukuqinisekisa kumasampuli amancane ngaphambi kokwethula imiyalelo yesilinganiso esikhulu, nokubuyekeza imiphumela kunciphisa ubungozi bokufinyelela imikhawulo ngezikhathi ezibucayi.

Ukuthembeka, amaphutha angenzeka kanye nezimo ezibucayi

Ubuhlakani bokwenziwa bungenza amaphutha: Lokho okubizwa ngokuthi ama-hallucinations, okungukuthi, imiphumela ebonakala izwakala kodwa ingalungile, iyaqhubeka nokuba khona njengoba ubuchwepheshe buthuthuka. I-Microsoft ngokwayo incoma ukuqinisekisa imiphumela ngaphambi kokuyisebenzisa emibikweni noma ezinqumweni ezifanele.

Ayifanele izindawo ezinobungozi obukhuluUma kukhona imithelela yezomthetho, yokulawula, noma yokuthobelana, izinga lekhwalithi lidinga ukuhlolwa mathupha kanye nokulandeleka okugcwele, ngakho-ke u-Copilot kufanele aqhubeke ewusekelo kunokuba kube umthombo owodwa.

Ukutholakala, izidingo kanye nokusatshalaliswa

Ukufinyelela kwenzeka kancane kancane futhi kunezidingo: Okwamanje, abanayo bangazama. Ilayisensi ye-Microsoft 365 Copilot futhi zikusiteshi se-Beta, kokubili ku-Windows naku-Mac, futhi inkampani ihlela ukubaletha enguqulweni yewebhu ye-Excel ngohlelo lwe-Frontier.

Akukho okumele kwenziwe kusebenze mathupha.: Uma izimfuneko zifinyelelwa, isici sivela eshidini njenganoma yisiphi esinye isibuyekezo somkhiqizo, futhi ukusetshenziswa kwaso kungokuzithandela kumsebenzisi ngamunye noma ithimba.

Ubudlelwano ne-Microsoft 365 ecosystem

Ukusebenza nge-OneDrive kanye ne-SharePoint kwenza ukuhamba komsebenzi kube lulaUma amafayela akho eku-Microsoft cloud, ukungenisa nokuhlanganyela kwe-Copilot kuhlangana ngaphandle komthungo nesitoreji sakho nezinqubo zokwabelana.

Ukuxhumana nokuxhumana kwangaphakathiEzindaweni zezinkampani, u-Copilot angaphinde akuqondise ukuthi ulethe ulwazi olufanele oluvela kwezokuxhumana zenhlangano uma kufaneleka, njalo ngaphakathi kwezimvume ezisungulwe indawo okuyo.

Amathiphu okusebenzisa asebenzayo

Qala ngezicelo ezibambekayo nezilinganisekayo: Isibonelo, cela isilinganiso somzwelo kukholamu yamazwana, isifinyezo sobubanzi obunamadethi namanani, noma isiphakamiso sethebula elinezinkambu ezithile ozozisebenzisa.

Qinisekisa ngesilinganiso esincane futhi kamuva: Uma isitatimende sisebenza emigqeni eyishumi, cishe sizosebenza kweyinkulungwane, futhi ngale ndlela ugwema izimanga uma ububanzi bangempela buqukethe okuhlukile noma amafomethi obungawalindele.

Bhala izinqumo zakho eshidini ngokwalo: Londoloza iseli ngeziyalezo eziphumelela kakhulu noma bhala phansi izizathu zesifinyezo esikhiqiziwe ukuze abanye ofunda nabo baqonde umongo futhi bakwazi ukukuphinda.

Okulindelwe okungokoqobo kanye nebhalansi yomuntu-AI

Ngisho nezinguqulo ezithuthukisiwe asikho isiqiniseko esiphelele: Ukukhokhela isivinini noma amakhono amaningi akususi umkhawulo wephutha, ngakho ukwahlulela komuntu nokubuyekeza kusabalulekile ukuze kuqinisekiswe ukuthi izinombolo ziyahlanganiswa.

Inani le-Copilot lisekusheshiseni umsebenzi owenziwe kahle.Uma uhlela idatha yakho, uchaze izinjongo zakho ngokucacile, futhi ubuyekeze imiphumela yakho, ukonga isikhathi nemiphumela ecacile kubonakala, ngaphandle kokuyeka ukulawula izinqumo.

Noma ubani osebenza ne-Excel nsuku zonke uzolubona ushintsho.Nge-Copilot, imisebenzi ebihilela amafomula amaningi, izivivinyo, nezilungiso ngaphambilini ixazululwa ngomyalelo ocacile, kubuyisele ukugxila ekuhlaziyeni nasekudluliseleni iziphetho eziwusizo.

Ikusasa eliseduze likhomba ekuhlanganisweni koketshezi okwengeziweNjengoba ukuthunyelwa kuqhubeka futhi ukuthuthukiswa kufakwa, umugqa phakathi kokucela okuthile ngolimi lwemvelo nokuyakha mathupha uzofiphala kakhulu, kuyilapho kugcinwa ikhono lokuhlola nokulungisa isinyathelo ngasinye.

Ikhophi ku-Microsoft Word
I-athikili ehlobene:
Yenza kusebenze i-Copilot ku-Word futhi uthole ukuthi ingakusiza kanjani

Umbono osebenzayo: I-Copilot ku-Excel ayihloselwe ukumiselela ukwahlulela kwakho, kodwa kunalokho ukukunikeza isivinini nomongo ngaphakathi kwesipredishithi ngokwaso. Uma uyilungiselela kahle idatha yakho, sebenzisa amafomula acacile, futhi uyibuyekeze ngokucophelela, umsebenzi othi =COPILOT() kanye nolwazi oluhlanganisiwe luba umfelandawonye oguquguqukayo wokungenisa, ukuguqula, ukugqamisa, nokuchaza ulwazi ngaphandle kokushiya i-Excel. Yabelana ngomhlahlandlela ukuze abanye abasebenzisi bazi ngalo msebenzi we-Copilot().


Engeza njengomthombo okhethwayo