Momwe mungagawire fayilo ya Excel nthawi yomweyo

Pogwiritsa ntchito chikalata cha Excel, nthawi zambiri zimakhala zofunikira kuti anthu angapo alumikizane nazo nthawi imodzi. Ndipo nthawi zambiri chiwerengero chawo chikhoza kuwerengedwa mu angapo angapo. Choncho, nkhani ya mgwirizano sikuti imangogwirizanitsa anthu, chifukwa nthawi zambiri amatha kusintha zotsutsana zomwe zimafunika kuphunzira momwe angasinthire mofulumira komanso moyenera.

Ndani angachite izo? Munthu yemwe ali ndi udindo wogwiritsa ntchito. Mwachidule, ndi chiyani chomwe chiyenera kuchitidwa kuti tigwirizane ndi chikalata osati chotheka, komanso chogwira mtima?

Makhalidwe ogwirira ntchito ndi fayilo yogawana ya Excel

Kugwira ntchito ndi fayilo yogawana ku Excel kuli ndi mawonekedwe ake. Chifukwa chake, zochita zina sizipezeka kwa ogwiritsa ntchito:

1. Kupanga matebulo.
2. Kuwongolera zochitika, kuphatikiza kuziwona.
3. Kuchotsa mapepala.
4. Ogwiritsa ntchito sangathe kuphatikiza ma cell angapo kapena, mosiyana, kugawa omwe adaphatikizidwa kale. 
5. Zochita zilizonse zomwe zili ndi data ya XML.

Kodi ziletso zimenezi zinganyalanyazidwe bwanji? Mukungoyenera kuchotsa mwayi wamba, ndikubwezeretsanso pakafunika kutero.

Nayi spreadsheet ina yomwe ili ndi ntchito zina zomwe zingatheke kapena sizingatheke ngati mukugwira ntchito ndi anthu angapo pa spreadsheet imodzi.

Momwe mungagawire fayilo ya Excel

Choyamba muyenera kumvetsetsa kuti ndi fayilo iti yomwe iyenera kuperekedwa kuti ikonzedwe ndi anthu angapo nthawi imodzi. Itha kukhala fayilo yatsopano kapena yomwe ilipo. 

Zikhazikiko

Chilichonse chomwe muyenera kuchita kuti mugawane fayilo mu Excel chili mu gawo la Kugawana Mabuku, lomwe lingapezeke popita ku Review tabu.

Iwindo lidzawonekera ndi ma tabu awiri. Tili ndi chidwi ndi yoyamba, yomwe imatsegula zokha. Tiyenera kuyang'ana bokosi pafupi ndi chinthu cholembedwa pazithunzi ndi rectangle yofiira. Ndi iyo, timathandizira ogwiritsa ntchito angapo kuwongolera zolemba.

Titatsegula mwayi woti tisinthire, tiyenera kuyikonza. Kuti muchite izi, tsegulani tabu yachiwiri.

Pambuyo polowa magawo, timatsimikizira zochita zathu. Kuti muchite izi, dinani batani "Chabwino". Kugawana kumatha kutsegulidwa ku buku lililonse, latsopano komanso lomwe lilipo. Choyamba, muyenera kupeza dzina lake. 

Pambuyo pake, muyenera kusunga fayilo pa kompyuta yanu.

Zofunika! Mtundu uyenera kukhala wotero kuti fayilo ikhoza kutsegulidwa ndi wogwiritsa ntchito aliyense ndi mtundu wawo wamasamba.

Kutsegula fayilo yogawana

Muyenera kusunga fayilo kugawo la netiweki kapena foda yomwe ili ndi mwayi kwa omwe akufuna kugwiritsa ntchito fayiloyo. Pambuyo posankha chikwatu, timangodina batani la "Save".

Komabe, sikuloledwa kugwiritsa ntchito seva yapaintaneti kuti musunge fayilo yomwe mwagawana. 

Pambuyo pochita ntchito zonse zomwe tafotokozazi, muyenera kufufuza ngati n'zotheka kugwirizanitsa anthu ena. Kuti muchite izi, tsegulani tabu ya "Data" ndikupeza chinthu cha "Connections" pansipa. Ngati mudina, mudzatha kusintha maulalo kapena maulalo. Ngati palibe batani lolingana, ndiye kuti palibe mafayilo ogwirizana.

Kenako, tabu "Status" imatsegulidwa, mothandizidwa ndi zomwe zingatheke kuyang'ana kugwirizana. Mfundo yakuti zonse zili bwino zitha kudziwika ndi kukhalapo kwa batani "Chabwino".

Momwe Mungatsegule Buku Logawana la Excel Workbook

Excel imakupatsaninso mwayi kuti mutsegule buku logawana nawo. Kuti muchite izi, muyenera dinani batani la Office. Pamene pop-up gulu likuwonekera, tiyenera kusankha "Open" chinthu ndi kusankha buku kuti ntchito kugawana. Pambuyo pake, dinaninso batani la Office, ndikutsegula zenera la "Excel Options", lomwe lingapezeke pansi.

Kumanzere kwa zenera lomwe likuwoneka, mudzatha kusankha gulu la zoikamo, koma tili ndi chidwi ndi yoyamba, yomwe ili ndi magawo ambiri.

Kenaka, pitani ku chinthu cha "Personal setting", kumene mukufunikira kufotokoza deta yomwe imakulolani kuti musefe ogwiritsa ntchito - dzina lolowera, dzina lakutchulidwa.

Pambuyo pochita izi, zimakhala zotheka kusintha zomwe zili muzolemba kapena kuwonjezera zina. Musaiwale kusunga zosintha zanu mutazipanga.

Izi nthawi zina zimatha kuyambitsa mavuto posunga. Mwachitsanzo, kugawana kumangopezeka pakutsegulira koyamba, ndipo mukayesa kutsegula chikalata kachiwiri, pulogalamuyo imaponya cholakwika. Izi zitha kuchitika pazifukwa zotsatirazi:

1. Ngati anthu angapo alowetsa deta nthawi imodzi mu selo imodzi. Kapena gawo lina lililonse.
2. Kupanga chosintha chomwe chimapangitsa kuti buku lantchito likule kukula. Izi zimabweretsa mavuto.
3. Wogwiritsa wachotsedwa kugawana. Pankhaniyi, kupulumutsa zosintha sikungagwire ntchito pa kompyuta yake yokha. 
4. Ma network adzaza kwambiri.

Kuti mukonze vutoli, muyenera kuchita izi:

1. Chotsani changelog kapena kufufuta zambiri za izo. 
2. Chotsani zambiri mu chikalata chomwe.
3. Yambitsaninso kugawana. 
4. Tsegulani chikalata cha Excel mu mkonzi wina waofesi, ndikuchisunganso mumtundu wa xls.

Zowona, m'matembenuzidwe aposachedwa kulakwitsa uku sikuchitika pafupipafupi ngati akale.

Momwe mungawonere ntchito za membala

Pogwira ntchito limodzi, muyenera kuyang'anitsitsa nthawi zonse kuti mmodzi mwa omwe akutenga nawo mbali asawononge chinachake. Choncho, muyenera kuphunzira kumvetsa zimene anachita ndi mmodzi wa iwo. Kuti muchite izi, muyenera kuchita zotsatirazi.

1. Pitani ku tabu "Review", ndipo pezani chinthucho "Zowongolera". Mu menyu, sankhani chinthucho "Sankhani zosintha".
   

   

2. Kenako, zenera adzaoneka mmene mungapezere zimene kusintha anapangidwa ndi owerenga. Mndandandawu umapangidwa zokha. Mutha kutsimikizira kuti izi ndi momwe zilili poyang'ana bokosi loyang'ana pafupi ndi chinthu chomwe chili m'bokosi la zokambirana.
   

   

    Pankhaniyi, zosintha zokhazo zomwe zapangidwa kuyambira posungira komaliza zidzawonetsedwa pamndandanda womwe uli pamwamba kumanzere. Izi zimachitika kuti zitheke, mutha kuwona zosintha zam'mbuyomu m'magazini.

3. Wophunzira aliyense amapatsidwa mtundu winawake, womwe mungamvetsetse yemwe adasintha. Zolembazo zili pamwamba kumanzere. Mutha kukhazikitsanso zosintha zotsatiridwa ndi nthawi, wogwiritsa ntchito kapena pagulu linalake, komanso kuletsa mawonekedwe awo.
   

   

4. Mukayandama pamwamba pa selo lomwe lili ndi chizindikiro choterocho, pamakhala kachidutswa kakang'ono komwe mungamvetse yemwe adasintha.
   

   

5. Kuti musinthe malamulo owonetsera zosintha, muyenera kubwerera kuwindo la zoikamo, ndikupeza gawo la "By Time", kumene mungathe kukhazikitsa poyambira kuti muwone kusintha. Ndiko kuti, nthawi yomwe kukonzanso kudzawonetsedwa. Mutha kukhazikitsa nthawi kuyambira posungira komaliza, kuyika kuti muwonetse zosintha zonse nthawi zonse, osawonedwa, kapena kutchula tsiku lomwe zidzasonyezedwe.
   

   

6. Mukhozanso kuyang'anira kuwonetsera kwa zokonzedwa kokha ndi membala wina.
   

   

7. Pogwiritsa ntchito gawo lofananira, mutha kukhazikitsa mtundu wa pepala lomwe zochita za lamulo zidzalowetsedwa.

Mutha kusinthanso zina poyang'ana mabokosi oyenerera omwe ali m'malo oyenera.

Mndandanda wa zosintha si wakufa. Wogwiritsa ntchito wamkulu amatha kuwonanso zosintha za ena omwe atenga nawo mbali, kutsimikizira kapena kukana. Kodi kuchita izo?

1. Pitani ku tabu "Review". Pali menyu "Zokonza" pomwe wogwiritsa ntchito amatha kukonza zosintha. Mugawo lodziwikiratu, muyenera kusankha njira "Landirani / kukana zosintha", kenako zenera lidzawonetsedwa pomwe zosintha zikuwonetsedwa.
   

   

   

2. Kusankhidwa kwa zosintha kumatha kuchitidwa molingana ndi zomwe tafotokoza kale: ndi nthawi, ndi wogwiritsa ntchito, kapena mkati mwamitundu ina. Pambuyo kukhazikitsa magawo ofunikira, dinani OK batani.
3. Kenako, zosintha zonse zomwe zikugwirizana ndi zomwe zakhazikitsidwa mu gawo lapitalo zidzawonetsedwa. Mutha kuvomereza kusintha kwina kapena kukana podina batani loyenera pansi pazenera. Ndizothekanso kuvomereza kapena kukana zosintha.
   

   

Tsopano zosintha zofunikira zasiyidwa, ndipo zowonjezera zachotsedwa.

Momwe mungachotsere wosuta ku fayilo ya Excel

Nthawi ndi nthawi zimakhala zofunikira kuchotsa ogwiritsa ntchito polemba nawo. Pakhoza kukhala zifukwa zambiri: anapatsidwa ntchito ina, wophunzirayo anayamba kupanga zosintha kuchokera pa kompyuta ina, ndi zina zotero. Kukhazikitsa ntchitoyi mu Excel sikovuta konse.

Choyamba, tsegulani tabu ya "Review". Pali gulu "Zosintha", pomwe pali njira "Kufikira bukhu".

Pambuyo pake, zenera lomwelo lomwe tidawona kale lidzawonekera pazenera. Mndandanda wa anthu onse omwe angasinthe patebulo ukhoza kupezeka pa Sinthani tabu. Kuti muchotse wosuta yemwe sitikufuna pakadali pano, muyenera kuyipeza pamndandandawu, sankhani ndikudina batani lakumanzere ndikudina batani la "Chotsani", lomwe lili pansipa.

Kenako, Excel ichenjeza wogwiritsa ntchitoyo kuti zosintha zomwe watengayo sangasungidwe ngati akusintha bukhuli. Ngati mukuvomereza, dinani "Chabwino", ndipo wogwiritsa ntchito sadzagawidwanso.

Momwe mungachepetse kugwiritsa ntchito buku logawana nawo

Njira yabwino yochepetsera kugwiritsa ntchito buku logawana nawo ndikuchotsa wogwiritsa ntchito. Ngati izi sizoyenera, mutha kukhala ndi ufulu wowonera kapena kusintha bukulo ndi munthu amene mwatenga nawo mbali.

Izi zikunenedwa, ndikofunikira kukumbukira kuti zolepheretsa zina zimapangidwira kugawana mwachisawawa. Zafotokozedwa pamwambapa. Tizikumbukira, chifukwa kubwereza ndi mayi wa kuphunzira.

1. Ndizoletsedwa kupanga matebulo anzeru omwe amangosintha deta ndikukhala ndi zina zambiri.
2. Simungathe kukonza zolembedwa. 
3. Pali choletsa chomangidwira pakuchotsa mapepala, kulumikiza kapena kutulutsa ma cell.
4. Chitani ntchito zonse pa data ya XML. M'mawu osavuta, pali zoletsa pakupanga kuchuluka kwa data, kuphatikiza kusintha magawo awo. XML ndi imodzi mwamafayilo osadziwika bwino kwa oyamba kumene, koma ndiyosavuta. Ndi mtundu uwu wa fayilo, mutha kusamutsa deta popanga kusintha kwa batch ku chikalatacho. 

Mwachidule, kulemba limodzi kumakupatsani mwayi wochita ntchito zofananira pachikalata, koma zosankha zambiri zamaluso zimapezeka kwa munthu m'modzi yekha. Izi ndichifukwa choti ma macros kapena ma XML batch omwewo ndi ovuta kubweza. 

Kuletsa kugawana ndikuyambiranso ndi njira ina yochepetsera zomwe ogwiritsa ntchito a Excel angachite. Mutha kupanga kusintha kofunikira nokha, potero kumalepheretsa anthu ena mwayi wosintha zinazake kwakanthawi.

Kuti muchite izi, muyenera kutsatira izi.

1. Tsegulani tabu ya "Review", pitani ku "Corrections" ndikusankha chinthu cha "Unikani zosintha" kuchokera pamenyu yowonekera.
2. Pambuyo pake, zenera limawonekera momwe muyenera kuchotsera mabokosi omwe ali pafupi ndi zinthu "Wogwiritsa" ndi "Muzigawo".
3. Pambuyo pake, kusintha kwasintha kumawonekera, komwe ndikofunikira pakusunga zosunga zobwezeretsera.

Pambuyo pake, mutha kuzimitsa kugawana. Kuti muchite izi, pa tabu yomweyi pa riboni, sankhani chinthucho "Kufikira bukuli" ndikuchotsa "Lolani ogwiritsa ntchito angapo kuti asinthe fayilo."

Ndi zimenezo, tsopano kugawana kwayimitsidwa.

Chifukwa chake ndikosavuta kukhazikitsa olemba anzawo ku Excel. Inde, pali zoletsa zina zomwe sizikulolani kugwiritsa ntchito chikalatacho mokwanira. Koma amathetsedwa mophweka, ndikokwanira kuzimitsa kugawana kwa kanthawi, ndiyeno kuyatsa pamene kusintha kofunikira kwapangidwa.