Copilot mu Excel: mafomula, matebulo, ndi ma chart kuchokera kuchilankhulo chachilengedwe

Kuyamba kwa Copilot mu Excel Izi zakhala nkhani yabwino kwa iwo omwe amagwiritsa ntchito pulogalamu ya spreadsheet nthawi zonse. Kuthekera kwake ndi kwakukulu: kuyambira pakufupikitsa ndi kusanja deta mpaka kupanga ma fomu ndi ma chart. Chida chamtengo wapatali chomwe chimakupulumutsirani ntchito ndikufulumizitsa kusanthula tsiku ndi tsiku.

Ndikofunika kumveketsa bwino malamulo amasewera: Imagwira mkati mwa buku la Excel lokha, pazomwe mumawona.Imayika zotsatira zake mwachindunji mu gridi, monganso zina zilizonse za Excel. Zomwe zimachitika ndizodziwika bwino, sizifuna zolemba kapena zowonjezera, ndipo zotsatira zimasintha zokha data yanu ikasintha.

Kodi Copilot mu Excel ndi chiyani ndipo amapereka chiyani?

Kuphatikiza apo, zimapitilira ma formula: Imakulolani kuti mutenge zambiri kuchokera pa intaneti, OneDrive, kapena SharePoint....ndiponso zoyankhulirana zochokera ku bungwe lanu, kuti mutha kuyamba ndi tebulo lopangidwa bwino popanda kulimbana ndi mawonekedwe.

Kusiyana kwakukulu kumodzi ndiko Imaphatikizana mwachilengedwe ndi injini yowerengera ya Excel. Simaphwanya dongosolo la bukhuli, imalemekeza magawo, matebulo, ndi mayina, ndipo zotsatira zake zimakhala ngati zotuluka zamtundu uliwonse za Excel, ndikuwerengeranso pomwe gwero likusintha.

Komwe mungapeze Copilot mu Excel

Dentro de ExcelMuziwona pa tabu Yanyumba. Dinani batani Copilot pa treadmill kuti mutsegule bolodi lanu, onani malingaliro oyambira, ndikuyamba kulankhula ndi wothandizira.

Muthanso kugwira ntchito pamlingo wa cell. Sankhani selo ndikugwiritsa ntchito chizindikiro cha mphezi chomwe chikuwoneka pafupi nacho. kugwiritsa ntchito zochitika zomwe zimakhudza mfundoyo kapena mtundu womwe wapezeka.

Kukonzekera ndi masitepe oyamba

Mukatsegula gululo, mutha kusankha njira zazifupi kuti mupange china chatsopano, perekani mafomula kapena masanjidwe, kapena kufotokoza mwachidule deta. Ngati mukufuna njira yaulere, lowetsani njira yochezera ndi Copilot. ndipo lembani chosowa chanu m'mawu anuanu.

Ntchito zazikulu ndi zitsanzo zothandiza

Copilot amachita bwino pa ntchito zobwerezabwereza kapena zomwe zimafuna chiweruzo chonse. Awa ndi madera ake othandiza kwambiri pa tsamba lenileni:

• Lowetsani deta mosavutaIwuzeni kuti ibweretse zambiri kuchokera pa intaneti, kuchokera ku OneDrive kapena SharePoint, kapena kuchokera ku mauthenga amkati; zimakuthandizani kumanga tebulo lokonzekera kusanthula.
• Onetsani, sinthani, ndi fyulutaIfunseni kuti iwunikire zomwe zimakusangalatsani, pangani zosefera, kapena sankhani malinga ndi gawo lomwe likuyenerani, kuphatikiza malamulo monga "maselo okha okhala ndi manambala" kapena "makhalidwe apamwamba kuposa 5".
• Kupanga ndi kumvetsetsa ma formulaFunsani mizati kapena mizere yatsopano yowerengedwera kutengera deta yanu; Copilot atha kufotokoza momwe fomula iliyonse imagwirira ntchito kuti muphunzire ndikukhulupirira zotsatira zake.
• Dziwani zambiri zamtengo wapataliFunsani mafunso okhudza deta yanu ndi kulandira ma chart, ma pivot table, chidule cha mawu, zomwe zikuchitika, kapena zidziwitso zakunja popanda kusiya pepala.

Amakhalanso waluso kwambiri pamachitidwe otengera zolemba. Mutha kusanja mndandanda wa ndemanga ndi malingaliro (zabwino, osalowerera ndale, zoyipa) ndi kuwagawira gulu lalifupi monga "flavour", "phokoso" kapena "capacity", ndikupanga magawo atsopano kuti apitilize kusanthula.

Pangani zithunzi mwachindunji

Ngati muli ndi tebulo ndipo mukufuna kuliwona, ingofunsani. Tsegulani Excel, sankhani mtundu wanu ndi mtundu woyenera ndipo funsani Copilot mtundu wa tchati chomwe mukufuna.

1. Zomwe zakonzeka, tsegulani gulu la Copilot ndikulemba cholinga chanu: Mwachitsanzo, "pangani tchati cha bar ndi malonda pamwezi".
2. Copilot adzapanga graph mu nkhani. Mukakhutitsidwa, gwiritsani ntchito njira ya +Add to tsamba latsopano kuti musunthire ku tabu yosiyana m'buku.

Ngati mukufuna kudzoza, yesani mauthenga osiyanasiyana komanso achindunji. Kumveka bwino kwamitundu ndi gawo lomwe likuyenera kuyimiridwaZotsatira zake zidzakhala bwino popanda kusintha kwamanja.

Ntchito ya =COPILOT (): gwiritsani ntchito ngati njira ina iliyonse

Chimodzi mwazinthu zatsopano zosangalatsa ndikuti Copilot amachitanso ngati ntchito. Mutha kulemba =COPILOT() mu cell ndikuchipereka, m'mawu, chilangizo chachilankhulo chachilengedwe, komanso maumboni amitundu ngati mukufuna nkhani.

Chotsatiracho chimayikidwa mwachindunji pa gridi. Palibe menyu obisika kapena zidule zachilendo.Imagwiritsidwa ntchito ngati momwe mungagwiritsire ntchito =SUM() kapena =VLOOKUP(), ndi phindu lowonjezera kuti imamvetsetsa mafotokozedwe ndikupanga zotulukapo kutengera deta yanu.

Njira iyi ndi yabwino pazambiri "zolemeretsa": sinthani ndi malingaliro, chotsani ma tag, fotokozani mwachidule mawu, kapena pangani magulu ndi syntax yodziwika bwino kwa aliyense wogwiritsa ntchito Excel.

Copilot mu Excel ndi Python: Advanced Analysis

Pamene ntchitoyo ikufuna mulingo wozama, Copilot akhoza kudalira Python mkati mwa Excel. Fotokozani mu chilankhulo chachilengedwe kusanthula komwe mukufuna ndipo wizard imangopanga, kufotokoza, ndikuyika nambala ya Python mu spreadsheet yanu.

1. Tsegulani Excel ndikutsimikizira kuti deta yanu ili patebulo kapena mndandanda wodziwika bwino. Pitani ku Start ndikutsegula menyu pansi pa batani la Copilot Idzakuwonetsani zosankha zingapo.
2. Sankhani Maluso a App ndikusankha njira «Kupereka mawonekedwe apadera pogwiritsa ntchito Python". Yembekezerani yankho loyamba ndikuwunikanso njirayo. kuti ikufuna kusanthula kwanu.
3. Ngati zikuwoneka, dinani «Yambani ndi Kukambitsirana Mwakuya". Kapenanso, gwiritsani ntchito kusankha "Pezani zotsatira zakuya pogwiritsa ntchito njira yowunikira" ndiyeno Kukambitsirana Kwakuya batani loyambira.
4. Mukalowa mumachitidwe awa, Copilot amapanga pepala latsopano ndi Ikani nambala yofunikira ya Python ndi dongosolo lathunthu komanso lopangidwa pakuwunika kwanu.
5. Mukamaliza, bwererani ku gulu ndikusankha «Lekani kusanthula kwapamwamba»kutuluka munjira ndikupezanso maluso ena onse a Copilot.

Kulingalira mozama kumakhala kothandiza pamene kusanthula kumafuna njira zingapo zogwirizana. Imakupatsirani dongosolo lowukira ndipo imagwiritsa ntchito makina osavuta kutsatirakotero mutha kuphunzira kuchokera panjira kapena kusintha momwe mukufunira.

Kupezeka ndi chilolezo: ndani angagwiritse ntchito

Copilot amawonekera pa Home tabu ya Mawu, Excel, PowerPoint, ndi Outlook pa intaneti ngati muli nayo. Kulembetsa kwa Copilot. Ngati dongosolo lanu la Microsoft 365 likuphatikiza mapulogalamu apakompyutaMudzaziwonanso mu mapulogalamu apakompyuta.

Kwa ogwiritsa ntchito kunyumba, mufunika chimodzi mwamalayisensi awa: Microsoft 365 Personal, Microsoft 365 Family kapena Copilot ProNgati mugwiritsa ntchito mtundu wabizinesi, chofunikira ndi Microsoft 365 Business Basic, Business Standard, Business Premium, E3, E5, F1 kapena F3, ndi khalani ndi Microsoft 365 Copilot yolumikizidwa ndi akaunti yanu.

Zofunikira pamafayilo am'deralo kapena atsopano osasungidwa: Akaunti yoyamba yomwe imapezeka pamwamba pa zenera la Microsoft 365 iyenera kukhala ndi chilolezo. kotero kuti Copilot akupezeka mu fayiloyo.

Kutulutsa kumachitika pang'onopang'ono. Pakadali pano, Copilot wa Excel amaperekedwa kwa ogwiritsa ntchito omwe ali ndi zilolezo omwe ali panjira ya Beta. pa Windows kapena Mac; mtundu wapaintaneti udzafika kudzera mu pulogalamu ya Frontier pomwe kukhazikitsidwa kukupitilira.

Zokonda zachinsinsi zotsegulidwa ndi Copilot

Pali makonda awiri achinsinsi omwe, ngati ali olumala, amatha kubisa Copilot mu mapulogalamu a Microsoft 365. Choyamba, onani makonda anu a Windows. Ndipo ngati mugwiritsa ntchito Mac, onani gulu lofanana.

1. Pa Windows: Open Word, Excel, kapena PowerPoint. Pitani ku Fayilo> Akaunti ndipo dinani Zinsinsi za akaunti > Sinthani makonda.
2. Yambitsani «Zochitika zomwe zimasanthula zomwe ali nazo» ndipo onetsetsani kuti mwayatsa njirayo «Zokumana nazo zonse zogwirizana»kuti Copilot awonekere mu mapulogalamu.
3. Pa Mac: Tsegulani Mawu ndikupita ku Mawu> Zokonda> Zinsinsi. Yambitsani njira ziwiri zomwezo kuwonetsetsa kuti Copilot alipo.

Ngati simukuziwona mutasintha makondawa, onani laisensi yanu kapena sinthani tchanelo. Nthawi zambiri, palibenso china "choyambitsa".Izi zimawonekera mukangopeza akaunti, zinsinsi, ndi zofunikira za mtunduwo.

Malingaliro kuti mupindule kwambiri popanda kusiya tsambali

Kuti mutsegule zothandiza, ganizirani za Copilot ngati wothandizira mwachindunji pama cell anu. Nawa malingaliro ena otsimikiziridwa opulumutsa nthawi m'moyo watsiku ndi tsiku:

• Kukambirana mwatsatanetsatanePangani mindandanda yamalingaliro, mitu, kapena mawu osakira kuchokera kukufotokozera mwachidule. Afunseninso kuti alembenso mawu omveka bwino kapena omveka bwino.
• Chidule cha nkhaniyiSankhani mitundu yotakata ndikupempha mawu achidule okhala ndi makonda, nsonga zapamwamba, ndi ma dips. Zabwino zosinthira matebulo kukhala ndime zokonzekera lipoti.
• Gulu lachindunji: perekani ndime yokhala ndi ndemanga kapena mayankho a kafukufuku ndipo funsani zolemba "zabwino / zosagwirizana / zoyipa" ndi gulu lalifupi pazolemba zilizonse.
• Mndandanda ndi matebulo pa ntchentcheFotokozani zomwe mukufuna ndikufunsani tebulo lomwe lili ndi magawo ofunikira (ntchito, chipani chodalirika, tsiku, udindo). Ichi ndi maziko olimba okonzekera ntchito popanda kukangana za kalembedwe.

Momwe mungayankhulire: gulu, macheza ndi zochita

Ngati mukufuna njira yolankhulirana, tsegulani gululo ndikusankha "Chat with Copilot". Mupeza malingaliro otsatsa kuti muyambitse mwachangu.Kapena mungathe kulemba chosowa chanu mwaufulu ndikukonza yankho ndi malangizo otsatila.

Pazochita zinazake, chithunzi cha mphezi mu cell ndichothandiza kwambiri. Zimakulolani kugwiritsa ntchito malamulo kwanuko Popanda kusintha mawu, ndibwino kuti mupange gawo lowerengeka pamodzi ndi zomwe mukuwunika.

M'mayankhowa, Copilot adzipereka kuti asinthe zotsatira. Muuzeni kuti asinthe graph kukhala mizere, ndi kusefa ndi malire osiyana. kapena zomwe zimafotokoza ndondomeko yopangidwa pang'onopang'ono, zonse popanda kusiya pepala.

Copilot mu Microsoft 365 ecosystem

Wothandizira samangokhala ku Excel. Imapezeka mu Word, PowerPoint, ndi Outlook pa intaneti mukakhala ndi zolembetsa zofananira. Ngati dongosolo lanu likuphatikiza mapulogalamu apakompyuta, mudzawonanso m'matembenuzidwe amenewo.

Mu Mawu, imakuthandizani kuti mulembe kuchokera poyambira, kufotokoza mwachidule, kapena kusintha kamvekedwe ka mawu. Mu PowerPoint, pangani zowonetsera kuchokera ku lingaliro kapena chikalata chomwe chilipo.kufotokoza kapangidwe ndi kapangidwe. Ubwino waukulu ndi kusasinthasintha kwa ntchito pakati pa mapulogalamu.

Njira yogwirizanayi ikutanthauza kuti zomwe mumaphunzira mu pulogalamu imodzi zidzakuthandizani mu zina. Chizindikiro chili pa tsamba Loyamba ndipo kutuluka kumabwereza.Tsegulani, fotokozani zomwe mukufuna, ndikuwongolera mpaka mutakonda.

Njira zolondola zopezera zotsatira zabwino

Mukamveka bwino, ndi bwino. Tchulani mtundu, minda, ndi chandamale Mu pempho lanu: "kuchokera pagulu la TablaVentas, ndiwonetseni zinthu 5 zomwe zili ndi mayunitsi ambiri ndikupanga tchati."

Ngati mufunsa mawerengedwe, konzani malo. Onetsetsani kuti mitundu ya data ndi yolondola komanso kuti palibe mitu yobwereza. Ndipo onetsetsani kuti mizati ya manambala ilibe zolemba zobisika; mudzapewa mayankho omveka bwino.

Njira yothandiza ndiyo kufunsa kufotokozera yankho. Mufunseni kuti akuwonetseni fomula ndikukuuzani zomwe gawo lililonse limachita.Mudzaphunzira kuphatikiza ndondomekoyi mumayendedwe anu osadalira nthawi zonse wothandizira.

Matebulo a pivot osachita khama ndi mafomula

Copilot akhoza kupanga ma pivot tables kutengera kufotokozera kwanu. Tchulani miyeso, mizere, ndi mizati m'chinenero chachibadwa, ndipo wothandizirayo adzapanga zosinthika zomwe mungathe kuzikonza pa ntchentche.

Kwa mafomu apamwamba, fotokozani cholinga m'malo mwa ntchito. Funsani kuti "pangeni gawo lomwe limawerengera kukula kwa mwezi ndi mwezi" ndikulola Copilot kudziwa kuphatikiza kwabwino kwazinthu; kenako, bwerezaninso kufotokozerako kuti mulimbikitse kuphunzira kwanu.

Ngati mukukakamira, funsani "momwe". Pemphani njira yabwino yosinthira pamizere iwiri kapena momwe mungasinthire mndandanda; kuwonjezera kukupatsani linanena bungwe, izo kufotokoza njira.

Konzani, zosefera, ndi masanjidwe anzeru

Pakakhala zolemba zambiri, kumveketsa bwino ndi theka la ntchitoyo. Copilot amatha kupanga zosefera zamakonda monga "kuwonetsa ma cell okha omwe ali ndi manambala" kapena "sungani mfundo zazikulu kuposa 5".

Mungagwiritsenso ntchito kuwunikira kuti muike chidwi. Mufunseni kuti aunikire zinthu zapamwamba za N, kuti azikongoletsa zakunja. kapena zomwe zikuwonetsa mizere yomwe sikugwirizana ndi chikhalidwe. Izi ndizowonjezera zowerengera zomwe zimafulumizitsa ndemanga.

M'madongosolo ovuta, tchulani zofunikira ndi zofunikira. "Onjezani potsika Phindu ndipo, ngati kuli kofanana, pokwera mayunitsi" Ndikokwanira kuyendetsa ndondomeko yonse popanda kutsegula mabokosi a zokambirana.

Nthawi yokhulupirira komanso nthawi yotsimikizira

Mwambi womveka ndi "kukhulupirira, koma tsimikizirani." Tsimikizirani zotsatira musanazigwiritse ntchito posankhamakamaka pankhani zalamulo kapena zotsatiridwa.

Palibe chitetezo chamtheradi, ngakhale mu mapulani apamwamba. Makampani amakumbutsa aliyense kuti zolakwika zimatha kuchitika.Ndi mbali ya zamakono zamakono. Kuweruza kwanu kumakhalabe kofunikira komaliza.

Ubwino wake ndikuti kuphunzira kumapita patsogolo. Mukamagwiritsa ntchito kwambiri ndi deta yokonzedwa bwino, mudzapeza mayankho abwino. Ndipo mudzaphatikizira machitidwe ambiri mumayendedwe anu osadalira wothandizira pachilichonse.

Mastering Copilot ku Excel sikungokhudza kulola AI "kuchita matsenga," koma kukulitsa liwiro lake komwe kumathandizira kwambiri: Lowetsani ndi kulinganiza deta, fotokozani mwachidule, onani, pangani mafomu ofotokozera, ndikusanthula mokhazikika ndi Python Pamene vuto likufuna. Ndi zilolezo zolondola, makonda olondola achinsinsi, ndi dongosolo la data lopangidwa bwino, limakhala chiwongolero chenicheni cha ntchito zanu zatsiku ndi tsiku.