Indlela yokusebenzisa i-Copilot ku-Excel: Gcwalisa umhlahlandlela wesinyathelo ngesinyathelo

I-Microsoft 365 Copilot ilapha ukuze iguqule indlela esisebenza ngayo ne-Excel, iyasivumela ukushintsha imisebenzi y hlaziya idatha ngendlela esebenza kahle kakhulu. Siyabonga ku ukuhlakanipha okufakelwayo, leli thuluzi lisisiza ukuthi sidale amafomula, inhlamvu ihluzo futhi wenze lula izinqubo ezinde ngokuchofoza okumbalwa nje.

Uma ungakaze usebenzise lesi sici noma ufuna ukuzuza okuningi kuso, nawu umhlahlandlela ophelele onakho konke odinga ukukwazi mayelana ne-Copilot ku-Excel. Sizohlola kusuka kuyo izici eziyisisekelo ezinkingeni ezivame kakhulu nokuthi zingazixazulula kanjani.

Iyini i-Copilot ku-Excel futhi isetshenziselwa ini?

I-Copilot ku-Excel isici esakhelwe ku-Microsoft 365 esikuvumela ukuthi usisebenzise ukuhlakanipha okufakelwayo ukwenza imisebenzi ethuthukisiwe ngaphakathi kwamaspredishithi. Phakathi kokusetshenziswa kwayo okuyinhloko, sithola Ukwenziwa kwefomula okuzenzakalelayo, lo ukuhlonza iphethini kudatha kanye ne ukudala amashadi ngokwezifiso.

Leli thuluzi yakhelwe ukusiza abasebenzisi kokubili abaqalayo nabathuthukisiwe, abasiza ukuhlaziya idatha nge imiyalo elula ngolimi lwemvelo. Siyabonga ku-Copilot, kungenzeka ukwenza imibuzo efana nale "igqamisa ukuthengiswa okuphezulu kakhulu kwekota" o "khiqiza ishadi lebha ngale datha" ngaphandle kokubhala amafomula ayinkimbinkimbi.

Ungavula kanjani futhi uqale ukusebenzisa i-Copilot ku-Excel

Uma namanje ungayiboni inketho ye-Copilot ku-Excel yakho, kungase kudingeke uyivule noma uqiniseke ukuthi uyahlangabezana nezidingo. izidingo. Landela lezi zinyathelo ukuze uvule futhi uqale ukusebenzisa leli thuluzi:

1. Qiniseka ukuthi unokubhalisele i-Microsoft 365. I-Copilot itholakala kuphela kubasebenzisi abane- i-akhawunti yebhizinisi o kuyafundisa.
2. Buyekeza inguqulo yakho ye-Office. Ukuze wenze lokhu, yiya ku Ifayela > I-akhawunti > Vuselela Izinketho > Vuselela Manje.
3. Vula ifayela le-Excel eligcinwe ku-OneDrive noma ku-SharePoint. I-Copilot isebenza kuphela ngamafayela asingathwe ku- ifu.
4. Chofoza isithonjana se-Copilot kuribhoni noma khetha iseli bese ucindezela inkinobho ethi Copilot eduze kwayo.
5. Faka isicelo sakho ngolimi lwemvelo. Ungamcela ukuthi adale ihluzo, finyeza idatha noma ukukhiqiza amafomula.

Izibonelo zemiyalo ewusizo ene-Copilot ku-Excel

Umshayeli wendiza angaphendula izicelo eziningi ezihlukahlukene futhi akusize sebenza ngokushesha. Eminye imiyalo ongayizama yilena:

• «Bala iphesenti lokukhula phakathi kwekholomu A nekholomu C».
• "Dala ithebula le-pivot ukuze uhlaziye le datha".
• "Khiqiza igrafu yomugqa ngokuthengiswa kwekota".
• "Hlunga uhlu lwamaklayenti ngokukhokhisa ukusuka kokuphezulu kuye kokuphansi kakhulu".

Ukuxazulula izinkinga ezivamile nge-Copilot ku-Excel

Uma u-Copilot engabonakali ku-Excel yakho noma engasebenzi kahle, nanka amathiphu: izixazululo lokho kungakusiza:

1. Umshayeli wendiza akatholakali kuribhoni

Qinisekisa ukuthi uyayithobela le izidingo inguqulo, ilayisensi nezilungiselelo zobumfihlo:

• Qiniseka ukuthi usesiteshini Sebhizinisi Samanje noma Sanyanga Zonke. Uma usebenzisa Isiteshi Sonyaka, i-Copilot ingase ingasebenzi.
• Hlola izilungiselelo zakho zobumfihlo. Iya ku Ifayela > I-akhawunti > Ubumfihlo Be-akhawunti > Phatha izilungiselelo futhi usebenzise izinketho Okuhlangenwe nakho okuxhunyiwe y Okuhlangenwe nakho okuhlaziya okuqukethwe kwakho.

2. Umshayeli wendiza akaphenduli ngendlela efanele

Ezinye izimpendulo ze-Copilot zingaqukatha amaphutha noma amaphutha. Ukuze unciphise le nkinga:

• Buyekeza futhi uhlele izimpendulo ezikhiqiziwe. Qiniseka ukuthi idatha futhi izibalo zilungile.
• Buza imibuzo ecacile neningiliziwe. Uma isicelo sakho sicace kakhudlwana, kangcono kuzoba yimiphumela.

3. Incwadi yokusebenza ye-Excel inkulu kakhulu

U-Copilot angahlaziya aze afike amaseli ayizigidi ezimbili, kodwa uma ifayela lakho lidlula leli nani, i ukusebenza angathinteka. Zama ukunciphisa idatha ngokufaka isicelo filtros noma ukuhlukanisa imininingwane ibe amashidi amaningana.

Ubumfihlo nokuvikeleka ku-Copilot

I-Microsoft isebenzise izindlela zokuphepha ukuze kuqinisekiswe ukuthi i-Copilot ku-Excel uyayihlonipha ubumfihlo bomsebenzisi. Noma kunjalo, kuhle ukulandela okuthile izinyathelo zokuzivikela:

• Gwema ukwabelana ngedatha ebucayi usebenzisa i-Copilot. Yize i- IA sebenza ngolwazi ngaphakathi kwe-Excel yakho, kuhlale kungcono ukukugcina idatha eyimfihlo kuvikelwe.
• Buyekeza okuqukethwe okukhiqizwa ngaphambi kokwenza izinqumo. I-Copilot ayihlali ilungile ngo-100% ngaso sonke isikhathi, ngakho-ke kufanelekile ukuyiqinisekisa imiphumela.
• Bheka izinqubomgomo zobumfihlo ze-Microsoft uma unemibuzo mayelana nokusetshenziswa kwedatha.

I-Copilot ku-Excel iyithuluzi lenguquko elenza ukuphathwa kwedatha kube lula, kuyathuthuka ukukhiqiza futhi ilungiselela izinqubo zansuku zonke kunoma iyiphi inkampani noma indawo yokusebenza. Ngokuzijwayeza kanye imiyalo efanele, uzokwazi ukusebenzisa amandla ayo aphelele okwenza imisebenzi ngokuzenzakalelayo futhi wenze izinqumo ezinolwazi ngesikhathi esincane.