Imvamisa, okuqukethwe kweseli etafuleni akuhambelani nemingcele ebekwe ngokwakhona. Kulokhu, impikiswano yokwanda kwabo iba efanelekile ukuze yonke imininingwane ilunge futhi iphambi komsebenzisi. Ake sibheke ukuthi yiziphi izindlela ongayenza ngazo le nqubo ku-Excel.
Inqubo yokunwetshwa
Kunezindlela eziningi zokukhulisa amaseli. Abanye babo bahlinzeka ngemikhombandlela yezandla yomsebenzisi, futhi ngosizo lwabanye kungenzeka ukumisa ukusebenza kwe-othomathikhi kwale nqubo kuye ngobude bokuqukethwe.
Indlela 1: mane uhudule bese uphonsa imingcele
Inketho elula kakhulu futhi enembile kakhulu yokwandisa usayizi weseli ukuhudula imingcele ngesandla. Lokhu kungenziwa ekuxhumaneni kwesilinganiso esime mpo naphakathi nendawo yemigqa namakholomu.
- Sibeka isikhombisi emngceleni ongakwesokudla womkhakha esikalini esivundlile sokuxhumanisa ikholomu esifuna ukuyandisa. Isiphambano sivele ngamaphoyinti amabili akhomba izinkomba eziphambene. Bamba inkinobho yegundane kwesobunxele bese udonsela imingcele kwesokudla, okungukuthi, kude nendawo ephakathi kweseli yokunwebeka.
- Uma kunesidingo, inqubo efanayo ingenziwa ngentambo. Ukuze wenze lokhu, beka isikhombisi emngceleni ongezansi womugqa ozowandisa. Ngendlela efanayo, bamba phansi inkinobho yesinxele bese udonsa imingcele phansi.
Ukunaka! Uma ubeka isikhombisi emngceleni wesobunxele wekholomu ekhulayo esikhungweni sokudidiyela esilinganayo, nasemngceleni ongenhla womugqa kulayini oqondile wokuqondisa ngokulandela inqubo yokudonsa nokudonsa, osayizi bamaseli okuqondiwe ngeke bande. Bavele bathuthele ohlangothini ngokushintsha usayizi wezinye izinto zeshidi.
Indlela 2: nweba amakholomu amaningi nemigqa
Kukhona nenketho yokwandisa amakholomu amaningi noma imigqa ngasikhathi sinye.
- Sikhetha imikhakha eminingana ngasikhathi sinye esikhaleni esime mpo nesiqinisiwe sizixhumanisi.
- Sibeka isikhombisi emngceleni ongakwesokudla weseli elingakwesokudla (esikalini esivundlile) noma emngceleni ongezansi weseli eliphansi kakhulu (lesikali esime mpo). Bamba inkinobho yegundane kwesobunxele bese udonsela umcibisholo ovela, ngokulandelana, ngakwesokudla noma phansi.
- Ngakho-ke, hhayi kuphela ububanzi obukhulu ngokweqile obunwetshiwe, kodwa futhi namaseli endawo yonke ekhethiwe.
Indlela 3: ngesandla faka usayizi ngemenyu yokuqukethwe
Ungafaka futhi usayizi weseli, olinganiswe ngamanani amanani. Ngokuzenzakalelayo, ukuphakama kungamayunithi ayi-12,75 kanti ububanzi ngamayunithi angama-8.43. Ungangeza ukuphakama kube ngamaphuzu aphezulu angama-409, nobubanzi bube ngu-255.
- Ukuze ushintshe amapharamitha wobubanzi beseli, khetha ibanga elifunekayo esikalini elivundlile. Sichofoza kukho inkinobho yegundane elifanele. Kumenyu yokuqukethwe evela, khetha Ububanzi bekholomu.
- Kuvulwa iwindi elincane lapho ufuna ukusetha khona ububanzi bekholomu abawufunayo amayunithi. Faka usayizi oyifunayo kusuka kukhibhodi bese uchofoza inkinobho KULUNGILE.
Ngendlela efanayo, ukuphakama kwemigqa kushintshiwe.
- Khetha lowo mkhakha noma ububanzi besilinganiso sokuqondisa ngokuqondile. Sichofoza lesi sigaba ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe, khetha "Ukuphakama kolayini ...".
- Kuvulwa iwindi lapho udinga ukushayela ukuphakama kweseli okufunayo kobubanzi obukhethiwe amayunithi. Senza lokhu bese sichofoza inkinobho "Kulungile".
Ukuzikhohlisa okungenhla kukuvumela ukuthi ukhuphule ububanzi nokuphakama kwamaseli amayunithi wokulinganisa.
Indlela 4: faka usayizi weseli ngokusebenzisa inkinobho kubambo
Ngaphezu kwalokho, kungenzeka ukusetha usayizi weseli obekiwe ngokusebenzisa inkinobho kubambo.
- Khetha amaseli osayizi ofuna ukuwabeka ephepheni.
- Iya kuthebhu "Ikhaya"uma sikomunye. Qhafaza inkinobho ethi "Fomatha", ebekwe iribhoni eqenjini lamathuluzi "Amaseli". Uhlu lwezenzo luyavula. Ngokuhlukile khetha izinto ezikuyo "Ukuphakama kolayini ..." futhi "Ububanzi bekholamu ...". Ngemuva kokuchofoza ngakunye kwalezi zinto, kuzovuleka amawindi amancane, achazwe ngokwencazelo yendlela edlule. Bazodinga ukufaka ububanzi obufisayo nokuphakama kobubanzi beseli abakhethiwe. Ukuze amaseli akhule, inani elisha lalezi zinhlaka kufanele libe likhulu kunalokho elisethwe ngaphambilini.
Indlela yesi-5: khuphula usayizi wawo wonke amaseli eshidini noma encwadini
Kunezimo lapho udinga ukwandisa ngokuphelele wonke amaseli eshidi noma incwadi. Ake sibheke ukuthi sikwenza kanjani.
- Ukuze uqedele lo msebenzi, okokuqala, ukugqamisa izinto ezidingekayo. Ukuze ukhethe zonke izinto zeshidi, ungavele ucindezele isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + A. Kukhona inketho yesibili yokukhetha. Kubandakanya ukuchofoza inkinobho ngendlela yoxande, ebekwe phakathi kwesilinganiso esime mpo nendawo esihlanganisiwe se-Excel izixhumanisi.
- Ngemuva kokuthi ukhethe ishidi nganoma iyiphi yalezi zindlela, chofoza inkinobho esivele siyayazi "Ifomathi" ekhasethini bese wenza ezinye izinto ngendlela efanayo naleyo echazwe indlela yangaphambilini kanye nokuhamba kwezinto "Ububanzi bekholamu ..." futhi "Ukuphakama kolayini ...".
Senza ngezenzo ezifanayo ukukhulisa usayizi wamaseli encwadi yonke. Ukukhetha kuphela wonke amashidi sisebenzisa iqhinga elihlukile.
- Sichofoza ngakwesokudla kwilebula yanoma imaphi amashidi, atholakala ezansi kwewindi ngokushesha ngaphezulu komugqa wesimo. Kumenyu evelayo, khetha "Khetha wonke amashidi".
- Ngemuva kokuthi amashidi esekhethiwe, senza isenzo kwitheyiphu sisebenzisa inkinobho "Ifomathi"ebechazwa ngendlela yesine.
Isifundo: Ungawenza kanjani amangqamuzana alinganayo ku-Excel
Indlela 6: Ububanzi Bokuzenzakalelayo
Le ndlela ayikwazi ukubizwa ngokuthi ukwanda okugcwele ngokuphelele ngosayizi wamaseli, kepha noma kunjalo, kuyasiza futhi ukulinganisa ngokuphelele umbhalo emingceleni ekhona. Ngosizo lwayo, izinhlamvu zemibhalo zincishiswa ngokuzenzakalela ukuze zingene esitokisini. Ngakho-ke, singasho ukuthi usayizi wayo ohambelana nombhalo uyanda.
- Khetha ibanga esifuna ukufaka kulo ubukhulu bokufanisa izakhiwo. Chofoza ekukhetheni ngenkinobho yegundane elifanele. Imenyu yokuqukethwe iyavula. Khetha into ekuyo "Ifomethi yeseli ...".
- Iwindi lokufometha liyavula. Iya kuthebhu Ukuqondanisa. Ebhuthini yezilungiselelo "Khombisa" hlola ibhokisi eliseduze kwepharamitha "Ububanzi be-Auto Fit". Chofoza inkinobho "Kulungile" phansi kwewindi.
Ngemuva kwalezi zenzo, noma ngabe irekhodi lide kangakanani, kodwa lizolingana esitokisini. Kuliqiniso, kufanele ucabangele ukuthi uma kunezinhlamvu eziningi kakhulu kuzinto zeshidi, futhi umsebenzisi ngeke azelule kwenye yezindlela ezedlule, khona-ke leli rekhodi lingaba lincane kakhulu, lingafundeki. Ngakho-ke, ukuneliswa kuphela ngale nketho ukuze uvumelane nedatha ngemingcele akuyona into eyamukelekayo ngaso sonke isikhathi. Ngaphezu kwalokho, kufanele kuthiwe le ndlela isebenza kuphela ngombhalo, kepha hhayi ngamanani ezinombolo.
Njengoba ukwazi ukubona, kunezindlela eziningi zokukhulisa usayizi wawo womabili amaseli namaqembu aphelele, okwandisa zonke izinto zeshidi noma incwadi. Umsebenzisi ngamunye angamkhetha inketho elula kakhulu yokwenza le nqubo ezimeni ezithile. Ngaphezu kwalokho, kunendlela eyengeziwe yokulingana nokuqukethwe ngaphakathi kweseli usebenzisa ububanzi obunga-auto. Kuliqiniso, indlela yokugcina inemikhawulo ethile.
