Mukamapanga ntchito zazikulu, nthawi zambiri zimasowa mphamvu ya wogwira ntchito m'modzi. Gulu lonse la akatswiri limakhudzidwa ndi ntchito ngati imeneyi. Mwachilengedwe, aliyense wa iwo ayenera kukhala ndi mwayi wopeza chikalatacho chomwe chiri chinthu chogwirizana. Pankhani imeneyi, funso lotsimikizira kuti nthawi ya munthawi yomweyo imakhala yofunika kwambiri. Pulogalamu ya Excel ili ndi zida zomwe zingathe. Tiyeni tizindikire munthawi ya ntchito ya Excel munthawi yomweyo ogwiritsa ntchito angapo okhala ndi buku limodzi.
Njira Yogwirizana
Excel singangopereka fayilo yogawana, koma kuthetsa ntchito zina zomwe zimawonekera munthawi yogwirizana ndi buku limodzi. Mwachitsanzo, zida zogwiritsira ntchito zimakulolani kuti mutsatire zosintha zomwe ophunzira osiyanasiyana adatenga nawo mbali, komanso kuwakana. Timazindikira kuti zitha kupereka pulogalamu kwa ogwiritsa ntchito omwe anagonjera ntchito yofananira.Kupereka zolowa
Koma tidayambabe kudziwa funso la momwe mungaperekere fayilo yogawana. Choyamba, muyenera kunena kuti njira yothandizira mogwirizana ndi buku sizingachitike pa seva, koma pokhapokha kompyuta. Chifukwa chake, ngati chikalatacho chimasungidwa pa seva, ndiye, choyamba, ziyenera kusumutsidwa ku PC ndipo padatulutsa zomwe zili pansipa.
- Bukulo litapangidwa, pitani ku "kuwunika" tabu ndikudina batani la "mwayi wopita ku buku la" kusintha, komwe kumapezeka mu "kusintha" chida.
- Kenako zenera lolowera fayilo limayambitsa. Mmenemo, muyenera kukhazikitsa zojambula pafupi ndi "Lolani kusintha buku la ogwiritsa ntchito angapo nthawi imodzi". Kenako, dinani batani la "OK" pansi pazenera.
- Bokosi la zokambirana limawonekera lomwe likufunsidwa kuti lisungitse fayiloyo ndikusintha. Dinani pa batani la "OK".
Pambuyo pazomwe zili pamwambazi, kugawana mafayilo a fayilo kuchokera pazida zosiyanasiyana ndipo pansi pa akaunti zosiyanasiyana za ogwiritsa ntchito kudzatsegulidwa. Izi zikuwonetsa kuti pamwamba pazenera pambuyo pa dzina la bukulo, dzina la njira yofikira limawonetsedwa - "wamba". Tsopano fayilo ikhoza kusamutsidwanso ku seva.
Makonzedwe
Kuphatikiza apo, zonse muzenera lomwelo lomwe mungakonzetse magawo a nthawi yomweyo. Izi zitha kuchitika nthawi yomweyo ndikutembenuza mogwirizana, ndipo mutha kusintha magawo pang'ono pambuyo pake. Koma, mwachilengedwe, wogwiritsa ntchito wamkulu yekha amene amayang'anira ntchito yonseyo ndi fayiloyo amatha kuyendetsedwa.
- Pitani ku tabu "zambiri".
- Apa mutha kutchula ngati zipika kuti musunge zosintha, ndipo ngati mungasunge, nthawi yanji (yopanda masiku 30 ikuphatikizidwa).
Zimafotokozedwanso momwe mungasinthire kusintha: pokhapokha bukuli litapulumutsidwa (mwakusintha) kapena nthawi yayitali.
Pulogalamu yofunikira kwambiri ndi chinthucho "chosinthana". Zimawonetsa momwe pulogalamuyi imayenera kukhala ngati ogwiritsa ntchito nthawi imodzi amasinthana khungu limodzi. Mwachisawawa, kupempha kosatha kumakhazikitsidwa, zochita za omwe ophunzira nawo ali ndi zabwino. Koma ndizotheka kuphatikiza momwe mwayiwo ungakhale nawo nthawi zonse kwa amene adakwanitsa kupulumutsa kusintha.
Kuphatikiza apo, ngati mukufuna, mutha kuletsa kusindikiza ndi zosefera kuchokera pa malingaliro aumwini, kuchotsa bokosi lomwe lili pafupi ndi zinthu zoyenera.
Pambuyo pake, musaiwale kukonza zosintha zomwe zachitika podina batani la "Ok".
Kutsegula fayilo wamba
Kutsegula fayilo yomwe kulumikizidwa kumathandizidwa kumakhala ndi zina.
- Thawirani Excel ndikupita ku "fayilo" tabu. Kenako, dinani batani la "Lotseguka".
- Zenera lotseguka layambitsidwa. Pitani ku chikwatu cha seva kapena hard disk ya PC, komwe bukuli lili. Gawani dzina lake ndikudina batani la "Lotseguka".
- Bukuli lalikulu limatseguka. Tsopano, ngati mukufuna, tidzatha kusintha dzina lomwe tidzafotokozedwera m'magazini ya Fayilo. Pitani ku "fayilo" tabu. Kenako, pitani ku "magawo".
- Gawo la "General" pali "makonzedwe a Microsoft Office" makonda. Pano mu "Munda wa Username" Mutha kusintha dzina la akaunti yanu. Zikhazikiko zonse zimapangidwa, dinani batani la "OK".
Tsopano mutha kugwira ntchito ndi chikalatacho.
Onani zochita za ophunzira
Kugwirizana kumapereka mwayi wowunikira mosalekeza ndi zochita za onse omwe ali mgululi onse.
- Kuti muwone machitidwe omwe amachitidwa ndi wogwiritsa ntchito wina akugwira ntchito pabuku, pomwe mu "Kuunikira" tabu podina batani la "Kusintha", Kusintha "Gulu la Zida pa tepi. Mumenyu zomwe zimatsegulidwa, dinani pa batani "lowunikira".
- Zenera lokhazikika limatseguka. Mwachisawawa, bukuli litakhala General, ma track owongolera okha amatembenukira, monga momwe chithunzi chawonekera chimayikidwa moyang'anizana ndi chinthu cholingana.
Zosintha zonse zalembedwa, koma pazenera lokhazikika lomwe limawonetsedwa ngati mitundu ya maselo omwe ali pakona yakumanzere, kuyambira poyambira chikalatacho ndi amodzi mwa ogwiritsa ntchito. Kuphatikiza apo, zosintha za ogwiritsa ntchito onse zimathandizidwa ndi pepala lonse. Zochita za aliyense amatenga nawo mbali ndi mtundu wina.
Mukabweretsa cholozera ku chipinda chosindikizidwa, cholemba chomwe chikuwonetsedwa, ndipo choyenera chidachitika.
- Pofuna kusintha malamulowo kuti awonetse zosintha, bweretsani ku zenera. Zosankha zotsatirazi zosankha zokonza zikupezeka mu "nthawi":
- Onetsani kuchokera ku chisungiko chomaliza;
- Zosintha zonse zosungidwa mu database;
- Iwo amene sanawonedwe;
- Kuyambira ndi tsiku lodziwika.
Mu "wogwiritsa ntchito", mutha kusankha wophunzira wina, zomwe zikuwongolera, kapena siyani zowonetsera onse, kupatula nokha.
Mu gawo la "Gent", mutha kutchulanso zingapo papepala zomwe zochita za gululi zidzakumbukiridwa kuti ziwonekere pazenera lanu.
Kuphatikiza apo, kukhazikitsa bokosi loyandikira, mutha kulola kapena kuletsa kuwunika kwa kukonza pazenera ndikuwonetsa kusintha kwa pepala lina. Pambuyo makonda onse akhazikitsidwa, dinani batani la "Ok".
- Pambuyo pake, papepala lochita, otenga nawo mbali awonetsedwe kuti afotokozere zosintha zomwe zidalowa.
Kuwunikiranso zochita za ogwiritsa ntchito
Wogwiritsa ntchito wamkulu amatha kugwiritsa ntchito kapena amakana ndi magawo ena. Izi zimafuna zochita zotsatirazi.
- Kukhala mu "Kuunikira" tabu, dinani batani la "kukonza". Sankhani "kuvomereza / Kusankha Konzani".
- Kenako imatsegulira zenera loyang'ana. Iyenera kupanga zosintha kuti musankhe kusintha komwe tikufuna kuvomera kapena kukana. Ntchito pazenera izi zimachitika ndi mtundu womwewo womwe takambirana m'gawo lapitalo. Zikhazikiko zitatha, dinani batani la "OK".
- Pawindo lotsatira limawonetsa kuwongolera konse komwe kumakwaniritsa magawo omwe amasankhidwa kale. Pokhala ndi kutsimikiza mwatsatanetsatane mndandanda wazomwe mungachite, ndikukanikiza batani loyenerera lomwe lili pansi pazenera pandandanda, mutha kuvomera izi kapena kukana. Palinso kuthekera kwa kukhazikitsidwa kwa gulu kapena kukana kwa ntchito zonsezi.
Kuchotsa wosuta
Pali zochitika ngati wosuta woyeretsa ayenera kuchotsedwa. Izi zitha kuchitika chifukwa chakuti adasiya ntchitoyo ndikupeza zifukwa zaukadaulo, mwachitsanzo, ngati akauntiyo sinali yolondola kapena ophunzirawo adayamba kugwira ntchito kuchokera ku chipangizo china. Zowonjezera, pali mwayi wotere.
- Pitani ku "kuwunika" tabu. Mu "kusintha" pa tepi timakanikiza "mwayi wopita ku buku la" batani.
- Chidziwitso chomwe chikuwazani kale kuti fayilo yolumikizira fayilo itseguke. Mu Edit Tab, pali mndandanda wa ogwiritsa ntchito omwe amagwira ntchito ndi bukuli. Munagawa dzina la amene muyenera kuchotsa, ndikudina batani "Chotsani".
- Pambuyo pake, makalata okambirana amatseka pomwe achenjezedwa kuti ngati membala uyu akusintha bukulo panthawiyi, zomwe adachita zonse sizidzapulumutsidwa. Ngati mukulimbana ndi yankho lanu, dinani batani la "OK".
Wogwiritsa ntchito adzachotsedwa.
Zoletsa pakugwiritsa ntchito buku la General
Tsoka ilo, nthawi yomweyo ntchito yomwe ili ndi fayiloyo imapereka zoletsa zingapo. Mu fayilo yonse, palibe a ogwiritsa ntchito, kuphatikiza mphunzitsi wamkulu, sangathe kuchita izi:- Pangani kapena sinthani mawonekedwe;
- Pangani matebulo;
- Osiyana kapena kuphatikiza maselo;
- Mangani ndi XML Data;
- Pangani matebulo atsopano;
- Chotsani mapepala;
- Mawonekedwe ndi kuchuluka kwa zochita zina.
Monga mukuwonera, zoletsa ndizofunika kwambiri. Mwachitsanzo, ngati popanda kugwira ntchito ndi deta ya XML, nthawi zambiri zimakhala zotheka kuchita, kenako osapanga matebulo amagwira ntchito ku Excel saganiza konse. Zoyenera kuchita ngati mukufuna kupanga tebulo latsopano, kuphatikiza maselo kapena kuchita zina zilizonse kuchokera pamndandanda womwe uli pamwambazi? Pali njira yothetsera, ndipo ndi yosavuta: muyenera kuletsa kanthawi kochepa, chitani zosintha, kenako ndikulumikizanso kuthekera kwa mgwirizano.
Kuphatikizira Kufikira Kwambiri
Ntchito yogwira ntchitoyo itamalizidwa, kapena ngati kuli kotheka, kusintha fayilo, mndandanda womwe tidalankhula m'gawo lapitalo, uyenera kuletsa njira yogwirizana.
- Choyamba, onse otenga nawo mbali ayenera kupulumutsa zosintha zomwe zidapangidwa ndikutuluka fayilo. Wogwiritsa ntchito wamkulu yekha amakhala ndi chikalatacho.
- Ngati mukufuna kupulumutsa chipika cha ntchito mutachotsa cholumikizira, ndiye mukakhala mu "kuwunika" tabu, dinani batani la "Kukonza" pa tepi. Mumenyu zomwe zimatsegulira, sankhani chinthucho "zowunikira ...".
- Zenera ndi lotseguka. Zikhazikiko pano zimafunikira kuti zigawidwe motere. Mu "munthawi ya nthawi", ikani "zonse". Moyang'anizana ndi mayina a "wogwiritsa ntchito" ndi "m'minda ya" m'minda ya "imayenera kuchotsedwa. Njira yofananirayo iyenera kuchitika ndipo ndi "kusankha zosintha pazenera". Koma moyang'anizana ndi parameter "sinthani papepala lina", m'malo mwake, bokosi loyang'ana liyenera kukhazikitsidwa. Pambuyo pa zonse zomwe zili pamwambazi zimapangidwa, kanikizani batani la "OK".
- Pambuyo pake, pulogalamuyi imapanga pepala latsopano lotchedwa "Journation", momwe chidziwitso chonse chosinthira fayiloyi chidzalowetsedwa mu tebulo.
- Tsopano zikhala zolumala mwachindunji. Kuti muchite izi, atakhala pa "kuwunika" tabu, dinani pa batani lodziwika bwino "mwayi wopita ku buku la" batani.
- Zenera lodziwika bwino la Revercent limayambitsidwa. Pitani ku Sinthani tabu ngati zenera lakhazikitsidwa mu tabu ina. Chotsani bokosi la cheke pafupi ndi chinthucho "Lolani kusintha fayiloyo kwa ogwiritsa ntchito angapo nthawi imodzi." Kuteteza zosintha zomwe zachitika podina batani la "Ok".
- Bokosi la zokambirana limatsegulidwa pomwe limachenjezedwa kuti kuphedwa kumeneku kudzapangitsa kuti likhale losatheka kugawana chikalatacho. Ngati mukulimbana mwamphamvu pasankhidwe, kenako dinani batani la Yes.
Pambuyo pake, kugawana fayiloyo kudzatsekedwa, ndipo zosinthazi zidzatsukidwa. Zambiri zomwe zidachitika kale zitha kuwoneka ngati tebulo lokha pa pepala la "chipika", ngati chotsatira cholingana ndi zomwe zidachitika kale.
Monga mukuwonera, pulogalamu ya Excel imapereka mwayi wogawana fayilo ndipo nthawi yomweyo amagwira ntchito ndi iyo. Kuphatikiza apo, mothandizidwa ndi zida zapadera, mutha kuwunika zochita za omwe ali nawo pagululi. Makinawa alinso ndi zolephera zina zogwirira ntchito, zomwe, komabe, zimatha kuyang'aniridwa, ndikugawana kwakanthawi kochepa ndikuwonetsa ntchito zofunikira munthawi yokhazikika.