Ukuze kube lula ukusebenza ngedatha enkulu yedatha ematafuleni, kufanele i-ode njalo ngokuya ngenqubo ethile. Ngaphezu kwalokho, ukufeza izinhloso ezithile, kwesinye isikhathi lonke uhlu lwamadatha aludingeki, kepha imigqa eyodwa kuphela. Ngakho-ke, ukuze ungadideki enanini elikhulu lolwazi, isisombululo esinengqondo ukuhlela imininingwane, bese uyihlunga kweminye imiphumela. Ake sibheke ukuthi idatha ihlelwe kanjani futhi ihlungwa kanjani kuMicrosoft Excel.
Ukuhlelwa kwedatha okulula
Ukuhlunga kungenye yamathuluzi alula kakhulu lapho usebenza eMicrosoft Excel. Ukuyisebenzisa, ungahlela imigqa yetafula ngokulandelana kwama-alfabhethi, ngokusho kwemininingwane esezitokisini zekholomu
Ukuhlunga idatha ku-Microsoft Excel kungenziwa kusetshenziswa inkinombo "Hlunga Nokuhlunga", ebekwe kuthebhu "Ikhaya" kubhagi kubha yamathuluzi "Ukuhlela". Kepha, okokuqala, sidinga uchofoze kunoma isiphi iseli lekholamu esizolihlela.
Isibonelo, kuthebula elingezansi, kufanele uhlunge abasebenzi ngokwe-alfabhethi. Singena kunoma yiliphi iseli lekholomu "iGama", bese sichofoza inkinobho ethi "Hlunga Nokuhlunga". Ukuhlunga amagama ngama-alfabethi, kusuka kuhlu oluvelayo, khetha u- "Hlunga kusuka ku-A uye ku-Z".
Njengoba ukwazi ukubona, yonke imininingwane esetafuleni ibekwa, ngokohlu lwamagama lwama-alfabhethi.
Ukuze uhleleke ngokuhleleka okungafani, kwimenyu efanayo, khetha inkinobho Hlunga ukusuka ku-Z kuya ku-A. "
Uhlu luhlelwe kabusha ngokulandelana okuhlelekile.
Kufanele kwaziwe ukuthi lolu hlobo lokuhlunga lukhonjiswa kuphela ngefomethi yedatha yombhalo. Isibonelo, kufomethi yamanani, kuhlelwa ukuhlelwa "Kusuka ubuncane kuya kobukhulu" (futhi okuphambene nalokho), nangefomethi yosuku, "Kusuka kwakudala kuye kokusha" (futhi okuphambene nalokho).
Ukuhlunga ngokwezifiso
Kepha, njengoba ubona, ngezinhlobo ezikhonjisiwe zokuhlungwa ngenani elilodwa, imininingwane enamagama alo muntu ihlelwe ngaphakathi kobubanzi ngokulandelana kokuphikisana.
Kepha kuthiwani uma sifuna ukuhlunga amagama ngokwe-alfabhethi, kepha ngokwesibonelo, uma igama lifaniswa, qiniseka ukuthi imininingwane ihlelwe ngosuku? Ukwenza lokhu, kanye nokusebenzisa ezinye izinto, zonke kumenyu efanayo "Hlunga Nokuhlunga", sidinga ukuya entweni ethi "Ukuhlunga Ngezifiso ...".
Ngemuva kwalokho, iwindows yezilungiselelo zokuhlela iyavula. Uma itafula lakho linamakhanda, sicela uqaphele ukuthi kuleli windi kumele kube khona uphawu lokuhlola eceleni kwenketho "Imininingwane yami iqukethe izihloko".
Ensimini ethi "Ikholomu", bonisa igama lekholomu okuzokwenziwa ngalo ukuhlunga. Kithi, lokhu kuyikholomu "Igama". Inkambu ethi "Hlunga" ikhombisa ukuthi yiluphi uhlobo lokuqukethwe oluzohlungwa. Kunezindlela ezine:
- Amanani
- Umbala weseli;
- Umbala wefonti;
- Isithonjana seseli.
Kepha, ngobuningi bamacala, kusetshenziswa into ethi "Amanani". Isethwe ngokuzenzakalelayo. Esimweni sethu, sizosebenzisa le nto ethile.
Kwikholomu "I-oda" sidinga ukukhombisa ukuthi imininingwane ezohlelwa ukuthi ilandelwe kanjani: "Ukusuka ku-A kuye ku-Z" noma okuphambene nalokho. Khetha inani "Ukusuka ku-A uye ku-Z".
Ngakho-ke, sakha ukuhlunga ngenye yamakholamu. Ukuze ulungiselele ukuhlungwa ngenye ikholamu, chofoza inkinobho ethi "engeza Izinga".
Kuvela enye insimu, okufanele igcwaliswe lapho kakade ukuze ihlelwe ngenye ikholamu. Kithi, ngekholamu ethi "Usuku". Njengoba ifomethi yosuku isethwe kulawa maseli, enkambini ye- "Order" sibeka amanani hhayi "Ukusuka ku-A kuye ku-Z", kepha "Kusuka kwakudala kuya kokusha", noma "Kusuka kokusha kuya kokudala".
Ngendlela efanayo, kule windi ungalungiselela, uma kunesidingo, ukuhlela ngamanye amakholomu ngokulandelana kokubaluleka. Lapho wonke amasethingi eseqediwe, chofoza inkinobho "Kulungile".
Njengoba ukwazi ukubona, manje etafuleni lethu yonke imininingwane iyahlelwa, okokuqala, ngamagama abasebenzi, bese kuthi, ngezinsuku zokukhokha.
Kepha, lokhu akuwona wonke amathuba wokuhlela ngokwezifiso. Uma ufisa, kule windi ungalungiselela ukuhlela hhayi ngamakholomu, kepha ngezintambo. Ukuze wenze lokhu, chofoza inkinobho "Izinketho".
Ewindini lokukhethwa kukho elivulayo, hambisa ukushintshela kusuka endaweni ethi "Range Lines" uye isikhundla "seRange Columns". Chofoza inkinobho ethi "Kulungile".
Manje, ngokufana nesibonelo esedlule, ungafaka idatha yokuhlunga. Faka idatha, bese uchofoza inkinobho "OK".
Njengoba ubona, ngemuva kwalokho, amakholomu asatshintshwa ngokuya ngamapharamitha afakiwe.
Kuliqiniso, etafuleni lethu, elithathwe njengesibonelo, ukusetshenziswa kokuhlungwa nokushintsha indawo yezinsika akusizi kakhulu, kepha kwamanye amanye amatafula lolu hlobo lokuhlunga lungahle kakhulu.
Hlunga
Ngaphezu kwalokho, iMicrosoft Excel inomsebenzi wokuhlunga idatha. Ikuvumela ukuthi ushiye ubonakale kuphela idatha oyicabanga ukuthi iyadingeka, bese ufihla okunye. Uma kunesidingo, idatha efihlekile ingahle ibuyiselwe kwimodi ebonakalayo.
Ukuze usebenzise lo msebenzi, sma kunoma yisiphi iseli etafuleni (futhi mhlawumbe kunhlokweni), bese uqhafaza inkinobho ethi "Hlunga Nokuhlunga" kubha yamathuluzi "Ukuhlela". Kepha, kulokhu, khetha u- "Hlunga" kumenyu evela. Ungase futhi esikhundleni salezi zenzo umane ucindezele inhlanganisela yokhiye u-Ctrl + Shift + L.
Njengoba ubona, esitokisini esinamagama awo wonke amakholamu, kwavela isithonjana ngesimo sesikwele, lapho unxantathu waphenduka khona sibheke phansi.
Sichofoza lesi sithonjana kwikholamu esizohlunga kulo. Kithi, sinqume ukuhlunga ngegama. Isibonelo, sidinga ukushiya idatha kuphela isisebenzi sikaNikolaev. Ngakho-ke, ungahloli amagama abo bonke abanye abasebenzi.
Lapho inqubo isiqediwe, chofoza inkinobho "Kulungile".
Njengoba ubona, kuphela imigqa enegama lesisebenzi uNikolaev isele etafuleni.
Ake siwucindezele umsebenzi, futhi sishiya etafuleni kuphela imininingwane ehlobene noNikolaev wekota yesi-3 ka-2016. Ukuze wenze lokhu, chofoza isithonjana kuseli "Langa". Kuluhlu oluvulayo, ungahloli izinyanga "ngoMeyi", "Juni" kanye no- "Okthoba", njengoba zingeyona ingxenye yesithathu, bese uchofoza inkinobho ethi "Kulungile".
Njengoba ukwazi ukubona, yidatha kuphela esiyidingayo esalayo.
Ukuze ususe okokuhlunga ikholomu ethile bese ukhombisa idatha efihliwe, chofoza futhi isithonjana esisele esitokisini nesihloko sale kholamu. Kumenyu evulayo, chofoza entweni "Susa isihlungi ku ...".
Uma ufuna ukusetha kabusha isihlungi ngokuphelele ngokusho kwetafula, lapho-ke kuzodingeka uqhafaze inkinobho ethi "Hlunga bese uhlunga" kubambo bese ukhetha u- "Sula".
Uma udinga ukususa isihlungi ngokuphelele, khona-ke, njengalapho uyisebenzisa, kwimenyu efanayo kufanele ukhethe into ethi "Hlunga", noma uthayiphe isinqamuleli sekhibhodi i-Ctrl + Shift + L.
Ngaphezu kwalokho, kufanele kuqashelwe ukuthi ngemuva kokuvula umsebenzi we- “Hlunga”, uma uchofoza isithonjana esihambisanayo kumaseli enhloko yetafula, imisebenzi yokuhlela esikhulume ngayo ngenhla iyatholakala kwimenyu evela: "Ukuhlunga kusuka ku-A kuye ku-Z" , Hlunga kusuka ku-Z kuya ku-A, bese Hlunga ngombala.
Isifundo: Ungayisebenzisa kanjani i-autofilter ku-Microsoft Excel
Ithebula le-Smart
Ukuhlunga nokuhlunga kungabuye kwenziwe kusebenze ngokuguqula indawo yedatha osebenza nayo ekubizeni okuthiwa yitafula smart.
Kunezindlela ezimbili zokwakha itafula eli-smart. Ukuze usebenzise owokuqala wabo, khetha yonke indawo yetafula, futhi, ekubeni kuthebhu ethi "Ikhaya", chofoza inkinobho iribhoni le- "Fomatha njengoba kwetafula". Le nkinobho itholakala kubhulokhi Ithuluzi "Izitayela".
Okulandelayo, khetha esisodwa sezitayela osithandayo ohlwini oluvulayo. Ukukhetha ngeke kuthinte ukusebenza kwethebula.
Ngemuva kwalokho, ibhokisi lokuxoxisana liyavula lapho ungashintsha khona izixhumanisi zethebula. Kepha, uma uyikhethe kahle leyo ndawo ngokusobala, akukho okunye okudingeka kwenziwe. Into esemqoka ukuthi uqaphele ukuthi kukhona uphawu lokuhlola eduze kwethebula le- "Ithebula elinamakhanda". Okulandelayo, chofoza nje inkinobho ethi "Kulungile".
Uma uthatha isinqumo sokusebenzisa indlela yesibili, kuzodingeka futhi ukhethe yonke indawo yetafula, kepha kulokhu iya kuthebhu ethi "Faka". Ukusuka lapha, iribhoni kubhokisi lamathuluzi lamathebula, chofoza inkinobho yethebula.
Ngemuva kwalokho, njengesikhathi sokugcina, kuvulwa iwindi lapho ungalungisa khona izixhumanisi zetafula. Chofoza inkinobho ethi "Kulungile".
Kungakhathaleki ukuthi ulisebenzisa kanjani lapho udala “itafula smart”, uzogcina ngetafula kumaseli wekhanda lapho izithonjana zokuhlunga ezichazwe ngenhla zizovele zifakiwe.
Uma uqhafaza kulesi sithonjana, yonke imisebenzi efanayo izotholakala lapho uqala isihlungi ngendlela ejwayelekile ngenkinobho ethi "Hlunga nesihlungi".
Isifundo: Ungawakha kanjani itafula kuMicrosoft Excel
Njengoba ukwazi ukubona, amathuluzi wokuhlunga nokuhlunga, uma asetshenziswa kahle, angenza lula abasebenzisi ukuthi basebenze namatafula. Indaba yokusetshenziswa kwabo iba efanele ikakhulukazi uma uhlu olukhulu kakhulu lwedatha luqoshwa etafuleni.
