Njira zabwino kwambiri zochepetsera Copilot ndi malamulo obisika kuti mugwire ntchito mwachangu

Ambiri mwa omwe amagwiritsa ntchito Copilot Tsiku lililonse, kaya mukusakatula, kugwiritsa ntchito foni yanu, kugwira ntchito mu Office, Excel, kapena kupanga mapulogalamu mu IDE yanu, mukungokanda pamwamba. AI iyi yochokera ku Microsoft ndi GitHub imabisa machenjerero ambiri omwe muyenera kudziwa kuti mupindule kwambiri ndi zonse zomwe imapereka. M'nkhaniyi, tasonkhanitsa zina mwa zabwino kwambiri. Njira zachidule zobisika za Copilot ndi malamulo. Musaphonye!

Kuchokera ku njira zolankhulirana za pa intaneti ndi mzere wolamula wokhala ndi "/", mpaka njira zazifupi za kiyibodi mu Visual Studio Code ndi JetBrains, komanso kugwiritsa ntchito kwamphamvu kwambiri mu Excel, Word, Teams, ndi Outlook. Chilichonse chimafotokozedwa m'Chisipanishi chosavuta, momveka bwino komanso popanda kusiya machenjerero ofunikira.

Njira zoyankhulirana ndi machenjerero oyambira mu Microsoft Copilot

Mtundu wa Copilot womwe mumagwiritsa ntchito mu msakatuli wanu kapena patsamba lake lokha nthawi zonse suyankha mofanana: Mutha kusankha kuchokera ku mitundu ingapo yokambirana yomwe imasintha momwe AI imaganizira komanso momwe imalembera., chinthu chofunikira kwambiri pakusintha zotsatira zake kuti zigwirizane ndi zomwe mukufuna nthawi iliyonse.

Mu msakatuli, nthawi iliyonse mukatsegula macheza atsopano, mitundu itatu ikuluikulu imawonetsedwa. Choyamba ndi Njira yolenga, yochokera pa GPT-4, yopangidwira zolemba zoyambirira, malingaliro openga, zolemba, ndakatulo kapena chilichonse chomwe malingaliro amatsogolera kuposa kulondola kwathunthu.

Kenako pali mode yolinganiza, yomwe nthawi zambiri imagwiritsa ntchito mtundu wa GPT-3.5Ndi malo abwino pakati pa ntchito zambiri: imayankha molondola, imasunga kamvekedwe kachibadwa, ndipo imalolabe luso linalake. Pa mafunso ambiri, maimelo wamba, kapena mafunso aukadaulo, nthawi zambiri ndiyo njira yabwino kwambiri.

Pomaliza, muli ndi njira yolondola (nthawi zina imatchulidwa ngati yokambirana kwambiri kapena yakale)Kutengera chitsanzo chakale, imayang'ana kwambiri kukupatsani mayankho afupiafupi komanso olunjika omwe ali pafupi kwambiri ndi zenizeni. Nthawi zambiri imasiya zokongoletsera ndi zitsanzo zazitali kuti ifike pachimake pa nkhaniyo.

Mu pulogalamu yam'manja, zinthu zimakhala zosavuta: Muli ndi batani limodzi loyatsa kapena kuzimitsa GPT-4.Mukagwiritsa ntchito njira yapamwamba, mumayandikira kwambiri momwe zinthu zilili; ngati mutayisiya pa GPT-3.5, kalembedwe kake kamakhala kofanana ndi momwe msakatuli amagwiritsira ntchito, koyenera kugwiritsidwa ntchito tsiku ndi tsiku.

Njira ina yosavuta koma yothandiza kwambiri ndiyo kulamulira chilankhulo. Copilot imazindikira chilankhulo cha dongosolo lanu, koma imayankha m'chilankhulo chilichonse chomwe mumagwiritsa ntchito polemba.Ngati mukufuna kuphunzira Chifalansa, kugwiritsa ntchito mawu omwe mudawawona mu Chingerezi, kapena kusakaniza zilankhulo mukulankhulana komweko, ingosinthani chilankhulo cha uthenga wanu ndipo AI idzasintha yokha.

Malamulo obisika a "/" mu Copilot a Office, Teams, ndi Microsoft apps

Chimodzi mwa zinsinsi zosadziwika bwino za Copilot, makamaka m'malo ogwirira ntchito monga Magulu, Outlook, kapena Word, ndichakuti Simuyenera kulemba ziganizo zonse nthawi zonse kuti mupemphe chinachakeIngolembani chilembo "/" mu bokosi la macheza kuti mutsegule menyu yaying'ono yokhala ndi malamulo achangu.

Kulemba “/” kudzawonetsa zochita zingapo zomwe zakonzedwa kale. Mwachitsanzo, lamulo /summarize imakulolani kufotokoza mwachidule chikalata, imelo, kapena msonkhano womwe mwatsegula mwachangu.kupanga chidule chachindunji popanda kufotokozera AI zomwe mukufuna kuti ichite.

Ngati mukufuna kulembanso lemba, muyenera /kulembanso, komwe kumasinthira zomwe zasankhidwa mwa kusintha kamvekedweYaukadaulo kwambiri, yosakhazikika, yolunjika kwambiri, ndi zina zotero. Ndi yabwino kwambiri poyeretsa maimelo musanawatumize kapena pofewetsa mauthenga achinsinsi mu Teams.

Mukasochera pakati pa maulalo ambiri a imelo kapena njira za Teams, /catch-up imakuthandizani kuti mukwaniritse zomwe mukufuna Kufotokozera mwachidule zokambirana zaposachedwa ndikuwonetsa mfundo zofunika kwambiri, zomwe zimapewa kuwerenga kwa maola ambiri mukabwerera kuchokera ku tchuthi kapena msonkhano wautali.

Inunso mwatero /draft kuti muyambe kulemba imelo kapena chikalata kuyambira pachiyambi, kukufunsani mfundo zazikulu (mutu, wolandira, cholinga) ndikupanga chikalata choyamba chomwe mungathe kubwerezanso ndi AI yokha.

Ndipo kwa iwo omwe amakhala mozunguliridwa ndi deta, /kuona ngati pali zinthu zomwe zimasintha matebulo kapena manambala kukhala machati ndi ma graph popanda kufunikira kuyenda m'mamenyu ovuta. Mumauza zomwe mukufuna kuwona ndipo Copilot amasamala kupereka mtundu woyenera kwambiri wa tchati.

Kukongola kwa malamulo obisika awa a Copilot ndikuti Ndi zachangu kwambiri kuposa kulemba mapempho ataliatali m'chilankhulo chachilengedwe.M'malo mwa "Kodi mungafupikitse chikalatachi?", mumalemba "/fupikitsa", dinani Enter, ndipo mwamaliza. Amagwiranso ntchito mofanana m'mapulogalamu osiyanasiyana ophatikizidwa ndi Copilot, kotero mumaphunzira kamodzi ndipo mutha kuwagwiritsa ntchito kulikonse.

Ntchito zopanga ndi zopanga zambiri mu Copilot web

Kupatula malamulo obisika a "mwachangu" a Copilot, mtundu wa pa intaneti wa Copilot (womwe mumagwiritsa ntchito mu Edge, Chrome, kapena pulogalamu yodziyimira payokha) ndi mpeni wa Swiss Army: Ingagwiritsidwe ntchito pothetsa kukayikira kwinakwake komanso kupanga zinthu zambiri kapena kuyanjana ndi masamba a pa intaneti..

Choyamba, zimakhala ngati injini yosakira yokambirana. Mungathe kufunsa mafunso okhudza chidziwitso cha anthu onse Funsani funso monga lakuti “Ndani anali Mzungu woyamba kufika ku America?” ndipo mudzalandira yankho lomveka bwino, nthawi zambiri ndi maulalo kapena maumboni kuti mudziwe zambiri. Mu mafunso amtunduwu, njira yoyenera nthawi zambiri ndiyo yabwino kwambiri.

Ngati kufotokozerako kukuwoneka kovuta kwambiri, pali njira yosavuta kwambiri: Mupempheni kuti akufotokozereni pamlingo winawake kapena kalembedwe kena.Mwachitsanzo, mawu monga "Ndifotokozereni ngati kuti ndili ndi zaka zisanu" amandipangitsa kulembanso yankho langa pogwiritsa ntchito chilankhulo chonga cha ana komanso zitsanzo zosavuta.

Momwemonso. Mungathe kukakamiza mawu asayansi, olankhulidwa, aukadaulo, kapena oseketsaIzi zimakupatsani mwayi wosintha mayankho kuti agwirizane ndi omvera omwe mukufuna kulemba (makasitomala, ophunzira, malo ochezera a pa Intaneti ...) popanda kulembanso chilichonse ndi manja.

Gawo loseketsa kwambiri limabwera mukafunsa mafunso olenga. Wothandizira angayankhe mwa kutsanzira mawu ofotokozera, kalembedwe ka anthu otchuka, kapena kapangidwe kake monga mavesi ndi nyimbo.Ndikoyenera kufunsa kuti "Ndifotokozereni mu mawonekedwe a rap" kapena "Ndifotokozereni mu ndakatulo ya ziganizo zinayi yokhala ndi mawu olembedwa ndi konsonanti," ndipo nthawi zambiri amatsatira.

Komanso imatha pangani maphunziro afupiafupi pang'onopang'onoNgati mufunsa chinthu chonga "Momwe mungasinthire RAM mu kompyuta", idzakubwezerani mndandanda wa njira zotsatizana ndi mafotokozedwe, machenjezo ndipo nthawi zambiri maulalo opita ku masamba komwe mungatsimikizire zambirizo.

Ntchito ina yakale ndi ya Womasulira wophatikizidwa wa mawu amodzi ndi malemba aataliMungathe kufunsa chinthu chosavuta monga “Tanthauzirani mawu oti ‘foni’ mu Chingerezi” kapena china chovuta kwambiri monga “Tanthauzirani mawu otsatirawa mu Chifalansa” kutsatiridwa ndi ndime zingapo. Ndi yothandiza makamaka pa maimelo, zikalata, ndi zolemba zaukadaulo.

Chifukwa cha intaneti yake, mungathenso Mufunseni kuti akuuzeni zomwe zili patsamba loyamba la webusaiti inayakeLamulo monga lakuti “Ndiuzeni tsamba loyamba la xataka.com” lidzalemba nkhani zazikulu, ngakhale kuti kulondola kwake kumadalira momwe tsamba lililonse lapangidwira.

Mogwirizana ndi izi, ntchito yofunika kwambiri ndi ya Lembani mwachidule nkhani zazitali pa intaneti pamene mulibe nthawi yoziwerenga zonseIngolembani “Sungani izi mwachidule:” ndikuyika ulalo wa mawuwo pambuyo pake. Zomwezo zitha kuchitika pomasulira masamba onse awebusayiti ndi mawu monga “Tanthauzirani nkhaniyi mu Chingerezi: URL”.

Pa luso, Copilot ndi wothandizira wabwino wa kulemba maimelo, zolemba zamavidiyo, nkhani, ndakatulo, kapena mawu a nyimboNgati muiganizira bwino (yemwe ikufuna, kamvekedwe kake, kutalika kwake) mupeza chikalata choyamba chomwe chili ndi tanthauzo lalikulu, chomwe mungathe kusintha.

Kuwonjezera pa kupanga malemba kuyambira pachiyambi, Wothandizira angasinthe kamvekedwe ka chinthu chomwe mwalemba kalekuzipangitsa kukhala zovomerezeka, zosavuta kumva, kapena zaukadaulo. Ndipo ngati mukopera lemba ndi kulipempha kuti "likonze kalembedwe ka lemba ili kuti limveke bwino," lidzabweretsa mtundu wosinthidwa ndipo, nthawi zambiri, kufotokozera kusinthako.

Kupanga zithunzi, ma logo, ndi zinthu zowoneka ndi Copilot

Chimodzi mwa zabwino zazikulu za Copilot kuposa ma AI ena okambirana ndichakuti Imagwiritsa ntchito DALL-E 3 m'njira yophatikizana popanga zithunzi kuchokera m'malemba. popanda ndalama zina m'malo ambiri, zomwe zimatsegula mwayi wosiyanasiyana wowonetsera mapulojekiti.

Chimodzi mwa njira zosavuta ndikuyamba uthenga wanu ndi mawu "Jambulani" kenako fotokozani mwatsatanetsatane zomwe mukufunaMungathe kusankha kalembedwe kake (koyenera, kopeka, zojambulajambula za ma pixel), kapangidwe kake (pafupi, kojambula kwambiri), mitundu, kapena chilichonse chomwe chiyenera kuwonekera pamalopo.

Ndi dongosolo lomweli mutha kupita patsogolo ndipo Pemphani kuti mupange ma logo, zizindikiro, zomata kapena zinthu zina zojambulira Pa mapulojekiti anu kapena mapangidwe anu. Ngati mulemba chinthu monga "Jambulani logo ya pulogalamu ya ntchito yotchedwa TaskFlow yokhala ndi kalembedwe kakang'ono komanso mitundu yabuluu ndi yoyera," Copilot apanga malingaliro angapo.

Zofunikira zikamveka bwino, zotsatira zake zimakhala zabwino. Ndikofunikira kuti mutchule mawu enieni omwe ayenera kuwonekera mu logoKupanda kutero, chitsanzocho nthawi zambiri chimapanga mawu kapena chimagwiritsa ntchito zilembo zokhala ndi zolemba zomwe sizikugwirizana ndi mtundu wanu.

Wothandizira pa maphunziro, ntchito, ndi kukonza moyo wanu

Kupatula kuyankha mafunso wamba, Copilot wachita Zothandiza kwambiri pophunzira, kukonzekera mayeso, kapena kupeza luso latsopanoNjira yodziwika bwino yogwiritsira ntchito ndi kupempha kuti ipange mayeso oyesera pa mutu kapena mulingo winawake.

Mwachitsanzo, mutha kulemba "Pangani mayeso a masamu a kusekondale ndi mafunso 10" ndipo adzabweza mayeso okhala ndi mafunso angapo. Sizimakhala zangwiro nthawi zonse, ndipo nthawi zina zimakonda kulumikizana ndi zinthu zakunja.Komabe, pokonza pempho (mlingo wa maphunziro, mtundu wa mafunso, kapangidwe kake) nthawi zambiri pamakhala ma simulation abwino.

Ngati mukuphunzira china chatsopano, monga kusewera chida choimbira kapena kuchita bwino pamasewera, Ikhoza kukupatsani malangizo ndi njira zochitira zinthu.Nkhani yofanana ndi yakuti “Momwe mungasewerere gitala ngati Ritchie Blackmore” ikufotokoza njira, masikelo, masewero olimbitsa thupi, ndi malangizo ophunzirira.

Pamlingo wakuthupi, mutha kumupempha kuti achite ngati mphunzitsi woyambira payekhaNdi mauthenga monga akuti “Ndiuzeni masewera olimbitsa thupi kuti ndilimbitse miyendo yanga,” mupeza mndandanda wa zochita (squats, lunges, ndi zina zotero) ndi malangizo. Nthawi zonse ndi bwino kufunsa katswiri, koma izi ndi poyambira pabwino.

Zimathandizanso kwambiri kukhitchini. Wothandizira akhoza kupanga menyu yonse kapena maphikidwe payekhapayekha kutengera zoletsa (zifukwa za ziwengo, kusalolera) kapena zosakaniza zomwe muli nazo kale kunyumba. Chitsanzo chabwino ndi "Konzani chakudya chamadzulo cha anthu awiri omwe sadya mtedza kapena nkhono ndi menyu ya zakudya zitatu."

Pankhani ya thanzi, ndikofunikira kukhala osamala: Siziyenera kulowa m'malo mwa chigamulo cha dokotala.Ngakhale zili choncho, mutha kupereka kufotokozera kwapadera za zizindikiro ndi matenda ("Mwachitsanzo, zizindikiro za chimfine A ndi ziti", nthawi zonse kuzitenga ngati chidziwitso chodziwikiratu.

Mukhozanso kuthandiza mu nthawi yanu yopuma. Ngati simukudziwa choti muwonere kapena choti musewere, mutha kufunsa. Malangizo a mndandanda wa pa TV, mafilimu, kapena masewera apakanema kutengera zomwe mumakonda kaleChinachake monga "Ndiuzeni mndandanda wofanana ndi Severance" chidzapangitsa kuti chipereke mitu ingapo yokhala ndi kufotokozera mwachidule kwa aliyense.

Ndipo ngati mukukonzekera ulendo, ndi mnzanu wabwino kwambiri: Mungagwiritse ntchito Copilot kukonzekera tchuthi, kulemba mndandanda wa zinthu zofunika kukhala nazo, ndikuyankha mafunso othandiza.Nthawi zambiri funso lakuti "Ndikukonzekera ulendo wopita ku Lisbon, ndiuzeni malo omwe muyenera kuwona," lomwe limasonyeza madera, zipilala, malo owonera zinthu, zakudya, ndi zina zotero.

Imathanso kuyendetsa zinthu zazing'ono za anthu, monga konzani mpikisano wachinsinsi wa SantaNgati mupatsa mndandanda wa omwe akutenga nawo mbali ndi zoletsa zingapo ("Loki sangakhudze Maria, Ines sangakhudze Javier"), Copilot adzapanga osewera motsatira zomwe zikuchitika.

Njira zazifupi za kiyibodi ndi malamulo obisika mu Copilot (VS Code ndi JetBrains)

Tikamalankhula za mapulogalamu, chithunzicho chimasintha kwambiri: GitHub Copilot imagwira ntchito ngati copilot wa code mkati mwa IDE yanuNdipo apa, njira zazifupi za kiyibodi zimapangitsa kusiyana pakati pa kugwira ntchito bwino ndi kulimbana ndi chida.

Gawo loyamba, mwachionekere, ndikuyika chowonjezeracho. Mu Visual Studio Code, Tsegulani mawonekedwe owonjezera ndi Ctrl+Shift+X (Cmd+Shift+X pa Mac)Sakani "GitHub Copilot", ikani chowonjezera chovomerezeka cha GitHub, ndikulowa mu akaunti yanu. Ngati muli ndi kulembetsa kapena kuyesa, chizindikiro cha Copilot chiyenera kuwonekera mu bar yowonetsera momwe zinthu zilili.

Akangoyatsidwa, kulumikizana kwakukulu kumachitika kudzera mu malingaliro apaintaneti. Kuti mulandire lingaliro lonse, ingodinani TabNgati simukukhutira, mutha kuichotsa ndi Escape ndikupitiriza kulemba mwachizolowezi kuti mupange malingaliro ena.

Mu Visual Studio Code, kuphatikiza apo, Muli ndi njira zinazake zoti mulandire mawu otsatira okha kapena mzere wotsatiraMwachitsanzo, kuvomereza mzere wotsatira nthawi zambiri kumalumikizidwa ndi Ctrl+Enter (kapena Cmd+Enter pa Mac), zomwe zimakulolani kupitirizabe m'njira yolunjika pamene simukufuna kuvomereza lingaliro lonse.

Kukakamiza Copilot kuti akuwonetseni malingaliro ngakhale atakhala kuti sakuwonekera okha, Mukhoza kuyambitsa kupanga ndi manja pogwiritsa ntchito njira zazifupi monga Alt+. kapena Ctrl+Enter, kutengera momwe zinthu zilili.Ndipo ngati muwona kuti ikukupatsani njira zingapo, mumayenda pakati pawo ndi Alt+] ndi Alt+[ (Option+] ndi Option+[ pa macOS).

Mu ma IDE a JetBrains monga IntelliJ kapena PyCharm, khalidweli ndi lofanana: Mumalandira malingaliro ndi Tab, pita ku lingaliro lotsatira ndi Alt+] ndikubwerera ku lingaliro lapitalo ndi Alt+[Escape imataya lingaliro lomwe lilipo ndipo imakulolani kuti mupitirize ndi khodi.

Kuwonjezera pa njira zazifupi, phale la malamulo a VS Code (Ctrl+Shift+P kapena Cmd+Shift+P) Ndi gawo lina lofunika kwambiri. Kuchokera pamenepo mutha kugwiritsa ntchito malamulo monga “Copilot: Enable” kuti muyambitse, “Copilot: Disable” kuti muyimitse, “Copilot: Open Settings” kuti musinthe zomwe mumakonda, kapena “Copilot: Show Next Suggestion” kuti muyendetse njira zomwe mungasankhe popanda kugwiritsa ntchito mbewa.

Uphungu wabwino ndi wakuti Sinthani njira zazifupi izi kuti zigwirizane ndi kapangidwe ka kiyibodi yanu Ngati zikutsutsana ndi zowonjezera zina kapena ndi kukumbukira kwa minofu yanu, makiyi amatha kukonzedwa mokwanira ndipo ndikofunikira kuwononga mphindi zochepa kuti muwakhazikitse momwe mukufunira.

Kuti mugwiritse ntchito bwino, ndibwino kuti muphunzire njira zingapo zabwino: Musavomereze lingaliro loyamba mwachimbulimbuli.Unikaninso khodi, ipangeni, yesani mayeso, ndikutsimikizira kuti ikukwaniritsa miyezo yanu yachitetezo. Wothandizira amasunga kulemba, koma udindo waukulu wa khodi nthawi zonse umakhala wanu.

Malamulo apamwamba a macheza ndi nkhani mu GitHub Copilot Chat

GitHub Copilot siimayima yokha ikamaliza: Imaperekanso njira yochezera yolumikizidwa mu mkonzi weniweni., yokhala ndi malamulo apadera komanso zosintha zamphamvu kwambiri zogwirira ntchito ndi ma codebase akuluakulu.

Mu Visual Studio Code, mwachitsanzo, Mutha kutsegula mawonekedwe a macheza ndi Ctrl+Alt+I pa Windows/Linux kapena Ctrl+Cmd+I pa macOSNgati mukufuna kuyambitsa macheza pa intaneti mwachindunji pa editor kapena terminal, gwiritsani ntchito Ctrl+I (Cmd+I pa Mac), yomwe imakulolani kufunsa kufotokozera kapena kusintha popanda kuchoka pawindo lomwe lilipo.

Mu macheza muli malamulo ochepetsa ntchito zomwe zimapangitsa kuti ntchito zachizolowezi zikhale zosavuta. /clear imachotsa zokambiranazo ndikuyamba gawo latsopano/delete imachotsa ulusi wakale, /help imakuwonetsani thandizo, ndipo /new imagwiritsidwa ntchito kuyambitsa pulojekiti yatsopano kapena nkhani.

Zosangalatsa kwambiri pa ntchito ya tsiku ndi tsiku ya wopanga mapulogalamu ndi /explain, /fix, ndi /tests. /explain imakupatsani kufotokozera kwa code yosankhidwa kapena block yomwe ilipo.Izi ndi zabwino kwambiri pomvetsetsa ntchito zovuta kapena khodi yakale. `/fix` ikuyesera kukonza zolakwika kapena kukonza chidutswa chomwe mwalemba, ndi `/tests` Amapanga mayeso a mayunitsi a khodi yosankhidwa.

Chinthu china chachikulu cha Copilot Chat ndi zosintha za m'nkhani zomwe zatchulidwa kale zisanachitike ndi "#"Mukalemba #block, #file, #function, #class, #selection, ndi zina zotero, mukuiuza gawo lenileni la code lomwe liyenera kuganizira kuti likupatseni yankho.

Mwachitsanzo, #file ikuphatikizapo fayilo yonse, #project imakupatsani chithunzithunzi cha malo ogwirira ntchito, ndipo #selection imachepetsa nkhaniyo kukhala lemba lomwe mwaliwonetsa. Izi zimapangitsa mayankho kukhala olondola kwambiri ndipo zimalepheretsa AI kuti "isasokonezedwe" ndi zigawo zina za code..

Mukhozanso kukoka ndikugwetsa mafayilo kapena mafoda mu gulu lochezera kuti muwonjezere nkhani zina, ndi Gwiritsani ntchito mawu otchulidwa ndi "@" pofotokoza mafayilo enaake, mavuto, kapena zopempha zokokaZonsezi zimathandiza Copilot kumvetsetsa bwino malo omwe mukugwira ntchito.

Pomaliza, ndikofunikira kukumbukira malangizo ena ofunikira pakupanga zovala: Khalani olunjika pa zomwe mukupempha, gawani ntchito zazikulu m'magawo ang'onoang'ono, ndipo lembani ndemanga zomveka bwino mu code.Mukafotokoza bwino cholinga chanu komanso polojekiti yanu ikakhala yoyera, Copilot wanu adzagwira ntchito bwino.

Wothandizira pa Excel, Power Query, ndi kusanthula deta

Pankhani ya ma spreadsheet, Copilot wakhala wopulumutsa moyo weniweni. Ikuphatikizidwa ndi Excel, imakuthandizani kuti muzitha kuchita ntchito zobwerezabwereza ndikuchita kusanthula kwapamwamba popanda kukhala katswiri wa formula..

Chimodzi mwa zinthu zamphamvu kwambiri ndi Copilot ndi Power Query. Power Query imagwiritsidwa ntchito kusintha ndi kuyeretsa kuchuluka kwa detaNdipo kulemba mafunso ndi manja kungakhale kovuta. Ndi Copilot, mutha kufotokoza zomwe mukufuna ("sefa mizere pomwe chigawo X chili chachikulu kuposa 100 ndikugawidwa ndi Y") ndipo zimapangitsa kuti mukhale ndi malingaliro ofunikira.

Zimathandizanso ndi matebulo ozungulira. Wothandizira angakupatseni njira zabwino kwambiri zokonzera, kufotokozera mwachidule, ndikugawa deta yanu Kutengera cholinga: ngati mukufuna kuwona malonda malinga ndi chigawo, avareji pa kotala, makasitomala 10 apamwamba, ndi zina zotero, ingofotokozani lipoti lomwe mukufuna.

Ponena za chitetezo, Copilot angakutsogolereni Momwe mungatetezere spreadsheet yachinsinsi, momwe mungaletsere mwayi wopeza ogwiritsa ntchito ena, kapena momwe mungatsekere ma cell ofunikira kotero kuti palibe amene angasinthe mwangozi. Zochita izi zakhalapo kwa zaka zambiri, koma tsopano zangokwanira kuzipempha m'chilankhulo chachilengedwe.

Komanso, ingakuthandizeni kusintha kwa ma audit komwe kwachitika ku fayilo ya Excelkukuwonetsani zosintha zomwe zapangidwa, liti komanso ndi ndani, zomwe zimathandiza kuwongolera mitundu pamene anthu ambiri akusintha chikalata chomwecho.

Chinthu china chosangalatsa kwambiri chomwe chimagwiritsidwa ntchito ndi kusinthasintha kwa malipoti a nthawi ndi nthawiMukhoza kukonza njira kuti, kutengera deta inayake, malipoti a mwezi uliwonse, kotala lililonse, kapena pachaka apangidwe, ndipo Copilot amawapanga mosasintha.

N'zotheka ngakhale kutumiza malipoti amenewo kudzera pa imelo ku mndandanda wa olandira, kukusungirani ntchito yanthawi zonse yotumiza, kulumikiza, ndi kulemba uthenga womwewo nthawi iliyonse.

Ngati mukuphunzira Excel, Copilot ikuphatikizapo Maphunziro olumikizana omwe amagwirizana ndi mulingo wanu wodziwa zambiriMungathe kupempha kuti ifotokoze ntchito inayake, kupereka malingaliro a zochita, kapena kukutsogolerani pang'onopang'ono pamene mukupanga lipoti kuyambira pachiyambi.

Tiyenera kukumbukira kuti Microsoft imasintha Copilot pafupipafupiZinthu zatsopano ndi kusintha kwa magwiridwe antchito zimatulutsidwa nthawi ndi nthawi, kotero ndikofunikira kuyang'ana zosintha zaposachedwa kuti mugwiritse ntchito bwino luso lawo mu Excel ndi zina zonse.

Ponseponse, Copilot yakhala njira yothandizira anthu omwe amapitilira patali kuposa AI yachizolowezi yolumikizirana: phunzirani njira zake zazifupi, malamulo obisika, ndi "misampha" yochepa yogwira ntchito. Zimakupatsani mwayi wolemba ma code mwachangu, kumvetsetsa bwino deta yanu, kupanga malipoti anu okha, kupanga zinthu zatsopano, komanso kukonza bwino ntchito yanu ndi moyo wanu wa digito popanda chidacho kukulepheretsani.