Mozilla Firefox Top Browser Add-ons

Pakukula kwa polojekiti yayikulu nthawi zambiri sitingakwanitse kugwira ntchito imodzi. Ntchitoyi ikuphatikiza gulu lonse la akatswiri. Mwachidziwikire, aliyense wa iwo ayenera kukhala ndi chidziwitso chomwe chili ntchito yogwirizana. Pachifukwa ichi, nkhani yotsimikiziranso kupititsa patsogolo nthawi zambiri imakhala yofunikira kwambiri. Excel ili ndi zipangizo zomwe zingapereke. Tiyeni tizindikire maonekedwe a kugwiritsa ntchito Excel mu zochitika za panthaŵi yomweyo ntchito ya ogwiritsa ntchito angapo ndi buku limodzi.

Ntchito yogwirizana

Excel sizingowonjezera kupatsana mafayilo, koma imathetsanso ntchito zina zomwe zimawonekera potsatira mgwirizano ndi buku limodzi. Mwachitsanzo, zida zothandizira zimakulolani kuti muwone zomwe zasintha ndi ophunzira osiyanasiyana, komanso kuvomereza kapena kuzikana. Tiyeni tipeze zomwe pulogalamuyi ingapereke ogwiritsa ntchito omwe akukumana ndi ntchito yofanana.

Kugawana

Koma tiyamba ndi kufotokoza funso la momwe mungagawire fayilo. Choyamba, ndiyenera kunena kuti ndondomeko yoyenera kugwiritsira ntchito bukuli sizingatheke pa seva, koma pa kompyuta. Choncho, ngati chikalatacho chimasungidwa pa seva, ndiye, choyamba, chiyenera kutumizidwa ku PC yanu komweko ndipo zonse zomwe zili pansipa ziyenera kuchitidwa.

  1. Bukuli litatha, pitani ku tabu "Kubwereza" ndipo dinani pa batani "Kufikira m'buku"yomwe ili mu chida chogwiritsa ntchito "Kusintha".

  2. Kenaka, mawindo otsogolera adiresi akutsegulira. Iyenera kuyika chizindikiro choyimira "Lolani ogwiritsa ntchito ambiri kuti asinthe buku panthawi yomweyo". Kenako, dinani pakani "Chabwino" pansi pazenera.

  3. Bokosi la bokosi likuonekera kukuthandizani kusunga fayilo monga adasinthidwa. Dinani pa batani "Chabwino".

Pambuyo pa masitepewa, fayizani kugawana kuchokera ku zipangizo zosiyanasiyana ndi pansi pa makaunti osiyanasiyana ogwiritsira ntchito. Izi zikusonyezedwa ndi mfundo yakuti kumtunda kwazenera, pambuyo pa mutu wa bukuli, dzina la mwayi wopeza amawonetsedwa - "General". Tsopano fayilo ikhoza kutumizidwa ku seva kachiwiri.

Kusintha kwapakati

Kuwonjezera pamenepo, onse muwindo loyang'ana mafayilo omwewo, mukhoza kukonza makonzedwe a opaleshoni yomweyo. Izi zikhoza kuchitidwa mwamsanga pamene mgwirizano umagwiritsidwa ntchito, ndipo mukhoza kusintha magawo pang'ono. Koma, mwachibadwa, amatha kuyang'aniridwa ndi wothandizira wamkulu, amene amayang'anira ntchito yonse ndi fayilo.

  1. Pitani ku tabu "Zambiri".

  2. Pano mungathe kufotokozera ngati kusunga zida zosintha, ndipo ngati zasungidwa, nthawi yanji (mwachinsinsi, masiku 30 akuphatikizidwa).

    Limafotokozanso momwe mungasinthire kusintha: kokha pamene bukulo likusungidwa (mwachinsinsi) kapena patatha nthawi yeniyeni.

    Chofunika kwambiri ndi chinthu. "Chifukwa cha kusintha kosagwirizana". Zimasonyeza momwe pulogalamuyi iyenera kukhalira ngati ogwiritsa ntchito nthawi imodzi amasintha selo lomwelo. Mwachizolowezi, nthawi zonse pempholi likuyankhidwa, zomwe gulu la polojekitiyi limapindula nazo. Koma mukhoza kukhala ndi chikhalidwe chosatha chomwe munthu amene watha kusunga kusintha poyamba adzakhala ndi mwayi.

    Kuonjezerapo, ngati mukufuna, mutha kutseka zosindikizira ndi zojambulidwa pamasewero anu polemba ma checkbox.

    Pambuyo pake, musaiwale kuti mukupanga kusintha komweku podindira pa batani. "Chabwino".

Tsegulani fayilo yogawana

Kutsegula fayilo yomwe kugawidwa kwapatsidwa kuli ndi mbali zina zapadera.

  1. Thamani Excel ndikupita ku tabu "Foni". Kenako, dinani pakani "Tsegulani".

  2. Amatsegula zenera lotseguka. Pitani ku seva yowonjezera kapena disk ya PC yomwe buku ili. Sankhani dzina lake ndipo dinani pa batani. "Tsegulani".

  3. Bukhu logawana nawo likuyamba. Tsopano, ngati mukufuna, titha kusintha dzina, pansi pano tidzakambidwa mu loti yosinthidwa. Pitani ku tabu "Foni". Kenaka, pita ku gawo "Zosankha".

  4. M'chigawochi "General" pali chigawo cha machitidwe "Kuyanjana ndi Microsoft Office". Kuno kumunda "Dzina la" Mutha kusintha dzina la akaunti yanu kwa wina aliyense. Pambuyo pokonza zonse zomwe zachitika, dinani pa batani. "Chabwino".

Tsopano mukhoza kuyamba kugwira ntchito ndi chikalata.

Onani zochita za mamembala

Kuphatikizana kumaphatikizapo kuyang'anitsitsa ndikugwirizanitsa ntchito zomwe gulu lonse likuchita.

  1. Kuti muwone zochita zomwe zimagwiritsidwa ntchito ndi munthu wina pogwiritsa ntchito bukhu, pokhala pa tab "Kubwereza" dinani pa batani "Malingaliro"zomwe ziri mu gulu la zida "Kusintha" pa tepi. Mu menyu yomwe imatsegula, dinani pa batani "Kuwunika kumasintha".

  2. Zowonongeka pazenera zimatsegula. Mwachindunji, bukuli litakhala loyamba, kutsegula patch kumasulidwa, monga momwe chisonyezedwe ndi chekeni choikidwa patsogolo pa chinthu chofanana.

    Zosintha zonse zalembedwa, koma pawindo pamasewera amawonetsedwa ngati makina a maselo kumtunda wawo wakumanzere, kuyambira pomwe nthawi yomaliza idasungidwa ndi wogwiritsa ntchito. Ndipo ganizirani zolingalira za ogwiritsa ntchito onse pa pepala lonse. Zochita za ophunzira aliyense zimadziwika ndi mtundu wosiyana.

    Ngati mutsegula chithunzithunzi pa selo losindikizidwa, ndemanga idzatsegulidwa, posonyeza kuti ndi ndani komanso pamene ntchitoyi ikuchitika.

  3. Kuti musinthe malamulo owonetsera zokonzekera, bwererani kuzenera zowonongeka. Kumunda "Panthawi" Zotsatila zotsatirazi zilipo posankha nthawi yoyang'ana mabala:
    • kusonyeza kuyambira kupulumutsidwa kotsiriza;
    • zosintha zonse zosungidwa mu database;
    • zomwe sizinawonedwe;
    • kuyambira tsiku lapadera.

    Kumunda "Mtumiki" Mukhoza kusankha munthu wina amene angakonzekere, kapena kusiya zochitika za ogwiritsa ntchito onse kupatula okha.

    Kumunda "M'kati", mungathe kufotokozera zamtundu wina pa pepala, zomwe zidzakumbukira zochita za mamembala kuti awone pazenera.

    Kuphatikizanso, poyang'ana makalata oyang'anila pafupi ndi zinthu, mungathe kuzimitsa kapena kusokoneza patching pazenera ndi kusonyeza kusintha pa pepala limodzi. Pambuyo pokonza zonsezi, dinani pa batani. "Chabwino".

  4. Pambuyo pake, pa pepala, zochita za otsogolera zidzawonetsedwa poganizira zoikidwazo.

Ndemanga ya anthu

Wogwiritsa ntchito wamkulu akhoza kugwiritsa ntchito kapena kukana kusintha kwa anthu ena. Izi zimafuna zotsatirazi.

  1. Kukhala mu tab "Kubwereza", dinani pa batani "Malingaliro". Sankhani chinthu "Landirani / Kanizani Mapazi".

  2. Kenaka, zenera zowonongetsera patch zimatsegula. Ndikofunika kupanga zoikidwiratu zosankha zomwe tikufuna kuvomereza kapena kukana. Zochita pazenera ili zikuchitidwa molingana ndi mtundu womwewo umene talingalira m'gawo lapitalo. Pambuyo mapangidwe apangidwa, dinani pa batani. "Chabwino".

  3. Window yotsatira ikuwonetseratu zonse zomwe zimakhutitsa magawo omwe asankhidwa kale. Kusankha kukonzekera kwachindunji mundandanda wazochita, ndikusindikiza botani lomwe liri pansi pazenera pansi pa mndandanda, mukhoza kulandira chinthucho kapena kutuluka. Palinso kuthekera kwa kuvomereza gulu kapena kukana ntchito zonsezi.

Kuthetsa wosuta

Pali milandu pamene wolemba aliyense ayenera kuchotsedwa. Izi zikhoza kukhala chifukwa chakuti adasiya ntchitoyo, komanso chifukwa cha zifukwa zomveka, mwachitsanzo, ngati akauntiyo inalowa molakwika kapena wophunzirayo anayamba kugwira ntchito kuchokera ku chipangizo china. Mu Excel pali zotheka.

  1. Pitani ku tabu "Kubwereza". Mu chipika "Kusintha" pa tepicho dinani batani "Kufikira m'buku".

  2. Fayilo yowonjezera maulendo odziwika bwino imatsegulidwa. Mu tab Sintha Pali mndandanda wa ogwiritsa ntchito onse omwe amagwira ntchito ndi bukhu ili. Sankhani dzina la munthu amene mukufuna kumuchotsa, ndipo dinani pa batani "Chotsani".

  3. Pambuyo pake, bokosi la mafunso liyamba pomwe limachenjeza kuti ngati wophunzirayo akukonzekera bukuli, zochita zake zonse sizidzapulumutsidwa. Ngati muli ndi chidaliro pachigamulo chanu, ndiye dinani "Chabwino".

Mtumiki adzachotsedwa.

Zoletsedwe za kugwiritsidwa ntchito kwa buku lonse

Mwamwayi, ntchito yomweyo yomwe ili ndi fayilo ku Excel ikuphatikizapo zolephera zambiri. Mu mafayilo onse, palibe aliyense wogwiritsa ntchito, kuphatikizapo wamkuluyo, amene angathe kuchita zotsatirazi:

  • Pangani kapena kusintha malemba;
  • Pangani matebulo;
  • Apatukani kapena phatikizani maselo;
  • Sinthani deta ya XML;
  • Pangani matebulo atsopano;
  • Chotsani mapepala;
  • Chitani maonekedwe ndi zochitika zina zambiri.

Monga mukuonera, zofookazo ndizofunikira kwambiri. Ngati, mwachitsanzo, mungathe kuchita popanda kugwira ntchito ndi deta ya XML, ndiye Excel ikuwoneka kuti sagwira ntchito nthawi zonse popanga matebulo. Kodi mungatani ngati mukufunikira kupanga tebulo latsopano, kuphatikiza maselo kapena kuchita china chirichonse kuchokera mndandanda wa pamwambapa? Pali njira yothetsera vutoli, ndipo ndi lophweka: muyenera kuletsa kanthawi kugawidwa kwa zikalata, kupanga kusintha koyenera, ndiyeno kuti athe kuyanjananso.

Khutsani kugawana

Ntchito yomanga pulojekitiyo ikatha, kapena, ngati kuli kotheka, kusintha kusintha kwa fayilo, mndandanda wa zomwe tinakambirana mu gawo lapitalo, muyenera kulepheretsa mgwirizano.

  1. Choyamba, onse oyenera ayenera kusunga kusintha ndikuchotsa fayilo. Wogwiritsa ntchito wamkulu amangokhala kuti agwire ntchito ndi chikalatacho.
  2. Ngati mukufuna kutumiza chipika chogulitsa mutatha kuchotsa mwayi wopezeka, ndiye kuti mutakhala pa tabu "Kubwereza", dinani pa batani "Malingaliro" pa tepi. Mu menyu yomwe imatsegula, sankhani chinthucho "Kuwunika kumasintha ...".

  3. Chotsegula chotsegula mawindo chimatsegula. Mipangidwe pano ikuyenera kukonzekera motere. Kumunda "Patapita nthawi" ikani parameter "Onse". Mosiyana ndi mayina akumunda "Mtumiki" ndi "M'kati" sayenera kusokoneza. Ndondomeko yofananayo iyenera kuchitika ndi parameter "Onetsani zikhomo pazenera". Koma mosiyana ndi zomwe zimachitika "Sinthani tsamba limodzi"M'malo mwake, chitsimikizo chiyenera kukhazikitsidwa. Zonsezi zitatha, dinani pa batani. "Chabwino".

  4. Pambuyo pake, pulogalamuyi idzakhazikitsa pepala latsopano lotchedwa "Lembani", momwe mfundo zonse zowonongolera fayiloyi muwonekedwe la tebulo zidzalowa.

  5. Tsopano zatsala kuti zitha kulepheretsa kugawana. Kuti muchite izi, zili mu tab "Kubwereza", dinani pa batani lomwe tidziwa kale "Kufikira m'buku".

  6. Window yolamulira yowonjezera ikuyamba. Pitani ku tabu Sinthangati zenera zinayambika muzamu ina. Sakanizani bokosi "Lolani ogwiritsa ntchito ambiri kuti asinthe fayilo nthawi yomweyo". Kukonza kusinthako dinani pa batani. "Chabwino".

  7. Bokosi lachiwunilo likuyamba kukuchenjezani kuti ntchitoyi idzapangitsa kuti ikhale yosatheka kugawana. Ngati mumakhulupirira kwambiri chigamulocho, dinani pa batani "Inde".

Pambuyo pa masitepewa, fayilo yogawana idzatsekedwa, ndipo chipika cha patch chidzachotsedwa. Chidziwitso pa ntchito zomwe zachitika kale zikhoza kuwonedwa patebulo pokha pa pepala. "Lembani", ngati ntchito zoyenera kusungira zidziwitsozi zinachitidwa kale.

Monga mukuonera, pulogalamu ya Excel imapereka mphamvu yowathandiza kugawa mafayilo komanso ntchito yomweyo. Kuwonjezera apo, pogwiritsa ntchito zipangizo zamtengo wapatali, mukhoza kuyang'ana zochita za munthu aliyense pa gulu logwira ntchito. Njirayi imakhalabe ndi zofooka zina, zomwe zingathetsedwe pang'onopang'ono kuti zisafike pafupipafupi ndikuchita zofunikira pazinthu zoyenera.

Posts Popular

https://termotools.com ny.termotools.com © Mozilla firefox 2024