I-Copilot ku-Excel: amafomula, amathebula, namashadi asuka olimini lwemvelo

Ukwethulwa kwe- Ikhophi ku-Excel Lezi kube yizindaba ezinhle kakhulu kulabo abasebenzisa lolu hlelo lwesipredishithi njalo. Amandla ayo makhulu kakhulu: ukusuka ekufingqeni nasekuhleleni idatha kuye ekukhiqizeni amafomula namashadi. Ithuluzi elibalulekile elikusindisayo futhi lisheshise ukuhlaziya kwansuku zonke.

Kubalulekile ukucacisa ngemithetho yomdlalo: Isebenza ngaphakathi kwencwadi yokusebenzela ye-Excel ngokwayo, kudatha oyibonayo.Ibeka umphumela ngqo kugridi, njenganoma yikuphi okunye okukhiphayo kwe-Excel. Okwenziwayo kujwayelekile, akudingi imibhalo noma izengezo, futhi imiphumela ibuyekezwa ngokuzenzakalelayo lapho idatha yakho ishintsha.

Yini i-Copilot ku-Excel futhi inikeza ini?

Ngaphezu kwalokho, idlula amafomula: Ikuvumela ukuthi ungenise idatha isuka kuwebhu, i-OneDrive, noma i-SharePoint....kanye nokuqukethwe kwezokuxhumana okuvela enhlanganweni yakho, ukuze uqale ngethebula elakhiwe kahle ngaphandle kokuzabalaza ngefomethi.

Umehluko oyinhloko yilokho Ihlanganisa ngokomdabu nenjini yokubala ye-Excel. Ayiphuli ukwakheka kwebhuku, ihlonipha ububanzi obuchaziwe, amathebula, namagama, futhi imiphumela yayo iziphatha njenganoma yikuphi okukhiphayo okuvamile kwe-Excel, ngokubala kabusha lapho idatha yomthombo ishintsha.

Lapho ungathola khona i-Copilot ku-Excel

Ngaphakathi ExcelUzoyibona kuthebhu ethi Ikhaya. Cindezela inkinobho ye-Copilot ku-treadmill ukuze uvule ideshibhodi yakho, bona iziphakamiso zokuqalisa, bese uqala ukukhuluma nomsizi.

Ungasebenza futhi ezingeni leseli. Khetha iseli bese usebenzisa isithonjana sombani esivela eduze kwayo. ukusebenzisa izenzo zomongo ezithinta lelo phuzu noma ububanzi obutholiwe.

Ukulungiselela kanye nezinyathelo zokuqala

Uma uvula iphaneli, ungakhetha izinqamuleli ukuze udale okuthile okusha, uphakamise amafomula noma ukufometha, noma ufinyeze idatha. Uma ukhetha indlela yamahhala, faka inketho yengxoxo nge-Copilot. bese ubhala isidingo sakho ngamazwi akho.

Imisebenzi esemqoka kanye nezibonelo ezingokoqobo

U-Copilot uphumelela kakhulu emisebenzini ephindaphindwayo noma leyo edinga ukwahlulela mayelana nayo yonke. Lezi izindawo zayo eziwusizo kakhulu eqabungeni langempela:

• Ngenisa idatha kalulaItshele ukuthi ilethe ulwazi olusuka kuwebhu, olusuka ku-OneDrive noma i-SharePoint, noma oluvela kwezokuxhumana kwangaphakathi; kukusiza ukuthi wakhe itafula elilungele ukuhlaziywa.
• Gqamisa, hlunga, futhi uhlungeIcele ukuthi igqamise idatha oyithandayo, dala izihlungi zangokwezifiso, noma uhlunge ngenkambu evumelana nawe, okuhlanganisa nemithetho njengokuthi "amaseli kuphela anezinombolo" noma "amanani angaphezu kuka-5".
• Ukukhiqiza nokuqonda amafomulaCela amakholomu amasha noma imigqa ebalwe ngokusekelwe kudatha yakho; U-Copilot angachaza ukuthi ifomula ngayinye isebenza kanjani ukuze ufunde futhi wethembe umphumela.
• Thola ulwazi olubalulekileBuza imibuzo mayelana nedatha yakho futhi uthole amashadi, amathebula e-pivot, izifinyezo, amathrendi, noma izexwayiso zangaphandle ngaphandle kokushiya ishidi.

Futhi unekhono kakhulu ezimweni ezisekelwe ematheksthini. Ungakwazi ukuhlunga uhlu lwamazwana ngomuzwa (okuhle, okungathathi hlangothi, okungalungile) futhi uwanikeze isigaba esifushane esifana nokuthi "flavour", "umsindo" noma "umthamo", okhiqiza amakholomu amasha ukuze uqhubeke nokuhlaziya.

Dala ihluzo ngokuqondile

Uma unetafula futhi ufuna ukulibuka, vele ubuze. Vula i-Excel, khetha ububanzi bakho ngefomethi efanele bese ubuza u-Copilot ngohlobo lweshadi oludingayo.

1. Njengoba idatha isilungile, vula iphaneli ye-Copilot bese ubhala inhloso yakho: Isibonelo, "dala ishadi lebha elinentengiso ngenyanga".
2. I-Copilot izokhiqiza igrafu kumongo. Uma uqiniseka, sebenzisa inketho ethi +Engeza eshidini elisha ukuyihambisa kuthebhu ehlukile encwadini.

Uma ukhetha ugqozi, zama imilayezo ehlukahlukene neqondile. Okucacayo ububanzi nenkambu okumele imelweUmphumela uzoba ngcono ngaphandle kokulungiswa okwenziwa ngesandla.

Umsebenzi we-=COPILOT(): sebenzisa njenganoma iyiphi enye ifomula

Esinye sezici ezintsha ezithakazelisa kakhulu ukuthi i-Copilot nayo iziphatha njengomsebenzi. Ungabhala okuthi =COPILOT() kuseli futhi uyidlulise, ngezingcaphuno, isiyalo ngolimi lwemvelo, kanye nezinkomba zobubanzi uma udinga umongo.

Umphumela ubekwe ngqo kugridi. Awekho amamenyu afihliwe noma amaqhinga ayinqaba.Isetshenziswa njengokuthi ungasebenzisa =SUM() noma =VLOOKUP(), ngenzuzo eyengeziwe eqonda izincazelo futhi ikhiqize okuphumayo ngokusekelwe kudatha yakho.

Le ndlela ilungele amakholomu "okuthuthukisa": hlunga ngomuzwa, khipha amathegi, finyeza umbhalo, noma khiqiza izigaba nge-syntax ejwayelekile kunoma yimuphi umsebenzisi we-Excel.

I-Copilot ku-Excel ngePython: Ukuhlaziya Okuthuthukile

Uma umsebenzi udinga ileveli ejulile, u-Copilot angathembela kuyo I-Python ngaphakathi kwe-Excel. Chaza ngolimi lwemvelo ukuhlaziya okufunayo futhi iwizadi izokhiqiza ngokuzenzakalelayo, ichaze, futhi ifake ikhodi yePython kusipredishithi sakho.

1. Vula i-Excel futhi uqinisekise ukuthi idatha yakho isethebulani noma kububanzi obuchazwe kahle. Iya kokuthi Qala bese uvula imenyu ngaphansi kwenkinobho ye-Copilot Izokukhombisa izinketho ezimbalwa.
2. Khetha Amakhono Ohlelo Lokusebenza bese ukhetha inketho «Ukuhlinzeka ngombono oyingqayizivele usebenzisa iPython". Lindela impendulo yokuqala bese ubuyekeza indlela. ukuthi iphakamisa ukuhlaziya kwakho.
3. Uma ivela, cindezela «Qala Ngokubonisana Okujulile". Noma, sebenzisa inketho "Thola imiphumela ejulile usebenzisa imodi yokuhlaziya ethuthukisiwe" bese kuba inkinobho yokuqala Ukubonisana Okujulile.
4. Lapho engena kule modi, u-Copilot udala ishidi elisha futhi Faka ikhodi yePython edingekayo ngohlelo oluphelele noluhlelekile ukuhlaziya kwakho.
5. Uma usuqedile, buyela kuphaneli bese ukhetha okuthi «Misa ukuhlaziya okuthuthukile»ukuphuma kumodi futhi uphinde uthole amanye amakhono ka-Copilot.

Imodi yokucabanga ejulile iyasiza uma ukuhlaziya kudinga izinyathelo ezimbalwa ezixhunyiwe. Ikunikeza uhlelo lokuhlasela futhi izenzele ngokuzenzakalelayo ukubulawa ngekhodi elandelekayongakho-ke ungafunda kunqubo noma uyilungise ngendlela othanda ngayo.

Ukutholakala kanye nelayisensi: ubani ongayisebenzisa

I-Copilot ivela kuthebhu yasekhaya ye-Word, Excel, PowerPoint, ne-Outlook kuwebhu uma unayo. Ukubhalisa kwe-Copilot. Uma uhlelo lwakho lwe-Microsoft 365 luhlanganisa izinhlelo zokusebenza zedeskithophuUzophinda uyibone kulezo zinhlelo zokusebenza zedeskithophu.

Kubasebenzisi basekhaya, udinga eyodwa yalawa malayisensi: Microsoft 365 Personal, Microsoft 365 Family noma Copilot ProUma usebenzisa inguqulo yebhizinisi, imfuneko yi-Microsoft 365 Business Basic, Business Standard, Business Premium, E3, E5, F1 noma F3, kanye ube ne-Microsoft 365 Copilot ehlotshaniswa ne-akhawunti yakho.

Okubalulekile kumafayela endawo noma amasha angalondoloziwe: I-akhawunti eyinhloko evela phezulu ewindini le-Microsoft 365 kufanele inikezwe ilayisense. ukuze u-Copilot atholakale kulelo fayela.

Ukuthunyelwa kuhamba kancane. Okwamanje, i-Copilot ye-Excel inikezwa abasebenzisi abanelayisensi abasesiteshini se-Beta. ku-Windows noma i-Mac; inguqulo yewebhu izofika ngohlelo lwe-Frontier njengoba ukuqaliswa kuqhubeka.

Izilungiselelo zobumfihlo zivulwe yi-Copilot

Kunezilungiselelo ezimbili zobumfihlo okuthi, uma zikhutshaziwe, zingafihla i-Copilot ezinhlelweni zokusebenza ze-Microsoft 365. Okokuqala, hlola izilungiselelo zakho zeWindows. Futhi uma usebenzisa i-Mac, hlola iphaneli elilinganayo.

1. Ku-Windows: Vula i-Word, i-Excel, noma i-PowerPoint. Iya ku Ifayela > I-akhawunti bese uchofoza Ubumfihlo be-akhawunti > Phatha izilungiselelo.
2. Yenza kusebenze «Okuhlangenwe nakho okuhlaziya okuqukethwe kwabo» futhi uqiniseke ukuthi unenketho evuliwe «Konke okuhlangenwe nakho kuxhunyiwe»ukuze u-Copilot avele ezinhlelweni zokusebenza.
3. Ku-Mac: Vula i-Word bese uya ku Igama > Izintandokazi > Ubumfihlo. Sebenzisa izinketho ezimbili ezifanayo ukuqinisekisa ukuthi uCopilot uyatholakala.

Uma ungayiboni ngemva kokushintsha lezi zilungiselelo, hlola ilayisense yakho noma buyekeza isiteshi. Ezimweni eziningi, akukho okunye okumele "kusebenze".Isici sivela ngemuva nje kokuthi i-akhawunti, ubumfihlo, nezidingo zenguqulo kuhlangatshezwane nazo.

Imibono yokuthola okuningi kuyo ngaphandle kokushiya ikhasi

Ukuze uvule ukusizakala kwayo, cabanga ngo-Copilot njengomsizi oqondile kumaseli akho. Nansi eminye imibono efakazelwe yokonga isikhathi Usuku nosuku:

• Ukuxoxisana ngokomongoKhiqiza uhlu lwamagama, izihloko, noma amagama angukhiye ngencazelo emfushane. Futhi bacele ukuthi babhale kabusha umbhalo ngezwi elicacile noma elisemthethweni.
• Izifinyezo ezixoxa indabaKhetha ububanzi obubanzi futhi ucele umbhalo omfushane onamathrendi, aphakeme kakhulu, namadiphu. Iphelele ekuguquleni amathebula abe yizigaba ezilungele umbiko.
• Ukuhlukaniswa okuqondile: letha ikholomu enamazwana noma izimpendulo zenhlolovo bese ucela amalebula “okuhle/okungathathi hlangothi/okubi” kanye nesigaba esifushane kokufakiwe ngakunye.
• Izinhlu kanye namathebula on the flyChaza ukuthi yini oyidingayo bese ucela ithebula elinamakholomu abalulekile (umsebenzi, iqembu elinomthwalo wemfanelo, usuku, isimo). Lesi yisisekelo esiqinile sokuhlela umsebenzi ngaphandle kokuphikisana mayelana nefomethi.

Indlela yokusebenzisana: iphaneli, ingxoxo nezenzo

Uma uthanda indlela yokuxoxa, vula iphaneli bese ukhetha okuthi "Xoxa noCopilot". Uzothola imibono yesikhangiso ukuze uqalise ngokushesha.Noma ungabhala isidingo sakho ngokukhululeka bese ulungisa impendulo ngemiyalo yokulandelela.

Ngezenzo ezithile, isithonjana sombani kuseli siwusizo kakhulu. Ikuvumela ukuthi usebenzise imiyalo endaweni Ngaphandle kokushintsha umongo, kulungele ukudala ikholomu ebaliwe eduze kwedatha oyibuyekezayo.

Ezimpendulweni, u-Copilot uzonikela ngokulungisa umphumela. Mcele ukuthi aguqule igrafu ibe imigqa, futhi ahlunge ngomkhawulo ohlukile. noma lokho kuchaza ifomula ekhiqiziwe isinyathelo ngesinyathelo, konke ngaphandle kokushiya ishidi.

Ikhophi ku-Microsoft 365 ecosystem

Umsizi akakhawulelwe ku-Excel. Ikhona ku-Word, PowerPoint, kanye ne-Outlook kuwebhu uma unokubhalisele okuhambisanayo. Uma uhlelo lwakho lubandakanya izinhlelo zokusebenza zedeskithophu, uzophinde ulubone kulezo zinguqulo.

Nge-Word, ikusiza ukuthi ubhale ukusuka ekuqaleni, ufinyeze, noma ulungise iphimbo. Ku-PowerPoint, dala izethulo ngombono noma idokhumenti ekhona.ukuphakamisa isakhiwo kanye nomklamo. Inzuzo enkulu ukuhambisana kokusetshenziswa phakathi kwezinhlelo zokusebenza.

Le ndlela ebumbene isho ukuthi lokho okufunda kuhlelo lokusebenza olulodwa kuzokusiza kolunye. Isithonjana sikuthebhu ethi Ikhaya futhi ukugeleza kuyaphinda.Yivule, chaza okufunayo, futhi uyicwenge ize ibe ngokuthanda kwakho.

Amaqhinga anembayo ukuze uthole imiphumela engcono

Uma ucaca kakhudlwana, kungcono. Cacisa ububanzi, izinkambu, kanye nethagethi Esicelweni sakho: “kusukela ebangeni le-TablaVentas, ngibonise imikhiqizo emi-5 enamayunithi amaningi bese udala ishadi lebha.”

Uma uzocela izibalo, lungisa indawo. Qiniseka ukuthi izinhlobo zedatha zilungile nokuthi azikho izihloko eziyimpinda. Futhi qinisekisa ukuthi amakholomu ezinombolo awanawo umbhalo ofihliwe; uzogwema izimpendulo ezingacacile.

Umkhuba owusizo uwukucela incazelo yesixazululo. Mcele ukuthi akubonise ifomula futhi akutshele ukuthi ingxenye ngayinye yenzani.Uzofunda ukufaka iphethini ekuhambeni kwakho komsebenzi ngaphandle kokuthembela kumsizi njalo.

Amathebula e-pivot namafomula asebenza kanzima

I-Copilot ingakha amathebula e-pivot ngokusekelwe encazelweni yakho. Yisho isilinganiso, imigqa, namakholomu ngolimi lwemvelo, futhi umsizi uzodala okuguquguqukayo ongakwazi ukukucwenga lapho undiza.

Ngamafomula athuthukile, chaza umgomo esikhundleni somsebenzi. Icele ukuthi "idale ikholomu ebala ukukhula kwenyanga nenyanga" futhi uvumele u-Copilot anqume inhlanganisela engcono kakhulu yezici; bese ubuyekeza incazelo ukuze uqinise ukufunda kwakho.

Uma ubambeka, buza "kanjani". Cela indlela engcono kakhulu yokwenza ukuhlehla kumakholomu amabili noma indlela yokwejwayelekile uchungechunge; ngaphezu kokukunikeza okukhiphayo, izochaza indlela.

Oda, izihlungi, nokufometha okuhlakaniphile

Uma kunamarekhodi amaningi, ukuthola ukucaciseleka kuwuhhafu womsebenzi. I-Copilot ingadala izihlungi zangokwezifiso njengokuthi “bonisa kuphela amaseli anezinombolo” noma “gcina amanani amakhulu kuno-5”.

Ungasebenzisa futhi ukugqamisa ukuze ugxilise ukunaka. Mcele ukuthi agqamise izinto ezingu-N eziphezulu, ukuze afake imibala kokungaphandle. noma lokho kumaka imigqa engahlangabezani nombandela. Lokhu ukuthuthukiswa kokufundeka okusheshisa ukubuyekezwa.

Kuma-oda ayinkimbinkimbi, cacisa imibandela kanye nokubalulekile. “Oda ngokwehla kweNzuzo futhi, uma ilingana, ngamayunithi akhuphukayo” Kwanele ukusebenzisa ukulandelana okuphelele ngaphandle kokuvula amabhokisi ezingxoxo.

Uthembe nini futhi nini ukuqinisekisa

Isiqubulo esinengqondo sithi "themba, kodwa qinisekisa." Qinisekisa imiphumela ngaphambi kokuyisebenzisa ezinqumweniikakhulukazi ezimweni ezinezidingo zomthetho noma zokuhambisana.

Akukho ukuvikeleka okuphelele, ngisho nasezinhlelweni ezithuthukisiwe. Izinkampani zikhumbuza wonke umuntu ukuthi amaphutha angenzeka.Kuyingxenye yesimo samanje sobuchwepheshe. Ukwahlulela kwakho kuhlala kuwukuthinta kokugcina okubalulekile.

Okuhle ukuthi ukufunda kuyathuthuka. Uma uyisebenzisa kakhulu ngedatha eyakhiwe kahle, uzothola izimpendulo ezingcono. Futhi uzohlanganisa amaphethini amaningi ekuhambeni kwakho komsebenzi ngaphandle kokuthembela kumsizi wayo yonke into.

I-Mastering Copilot ku-Excel akukhona ukuvumela i-AI "isebenze umlingo," kodwa imayelana nokusebenzisa isivinini sayo lapho inikela khona kakhulu: Ngenisa futhi uhlele idatha, finyeza, ubone ngeso lengqondo, dala amafomula achaziwe, futhi uhlaziye ngokuzenzakalelayo ngePython Lapho inselelo ifuna. Ngamalayisensi alungile, izilungiselelo ezilungile zobumfihlo, kanye nesistimu yedatha emiswe kahle, iba isisheshisi sangempela semisebenzi yakho yansuku zonke yesipredishithi.