Esifundweni sokugcina, sajwayelana nezisekelo zokuhlunga ku-Excel, sahlaziya imiyalo eyisisekelo nezinhlobo zokuhlunga. Lesi sihloko sizogxila ekuhleleni ngokwezifiso, okungukuthi okwenziwe ngokwezifiso ngumsebenzisi. Ngaphezu kwalokho, sizohlaziya inketho ewusizo njengokuhlunga ngefomethi yeseli, ikakhulukazi ngombala wayo.
Kwesinye isikhathi ungahlangabezana neqiniso lokuthi amathuluzi okuhlunga ajwayelekile ku-Excel awakwazi ukuhlunga idatha ngendlela edingekayo. Ngenhlanhla, i-Excel ikuvumela ukuthi udale uhlu lwangokwezifiso lwe-oda lakho lokuhlunga.
Dala ukuhlunga ngokwezifiso ku-Excel
Esibonelweni esingezansi, sifuna ukuhlunga idatha eseshidini ngosayizi wesikibha (ikholomu D). Ukuhlunga okuvamile kuzohlela osayizi ngokulandelana kwezinhlamvu, okungeke kulunge ngokuphelele. Masidale uhlu lwangokwezifiso ukuze sihlele osayizi kusukela kwabancane kakhulu kuye kwabakhulu.
- Khetha noma yiliphi iseli kuthebula le-Excel ofuna ukulihlunga. Kulesi sibonelo, sizokhetha iseli D2.
- Chofoza Idatha, bese ucindezela umyalo Ukuhlunga.
- Ibhokisi lengxoxo lizovuleka Ukuhlunga. Khetha ikholomu ofuna ukuhlela ngayo ithebula. Kulokhu, sizokhetha ukuhlunga ngosayizi we-T-shirt. Khona ensimini Order ukuchofoza Uhlu Ngokwezifiso.
- Ibhokisi lengxoxo lizovela Izinhlu… Sicela ukhethe UHLU OLUSHA esigabeni Izinhlu.
- Faka osayizi bezikibha ebaleni Izinto zohlu ngendlela edingekayo. Esibonelweni sethu, sifuna ukuhlunga osayizi kusukela kwabancane kakhulu kuye kwabakhulu, ngakho-ke sizongena ngokushintshana: Okuncane, Okumaphakathi, Okukhulu kanye no-X-Enkulu ngokucindezela ukhiye. Faka ngemva kwento ngayinye.
- Chofoza Engezaukulondoloza uhlelo olusha lokuhlunga. Uhlu luzokwengezwa esigabeni Izinhlu. Qiniseka ukuthi ikhethiwe bese uchofoza OK.
- Iwindi lengxoxo Izinhlu izovala. Chofoza OK ebhokisini lengxoxo Ukuhlunga ukuze wenze ukuhlunga ngokwezifiso.
- Isipredishithi se-Excel sizohlelwa ngendlela edingekayo, kithina, ngosayizi wesikibha kusukela kwencane kakhulu kuye kwenkulu.
Hlunga nge-Excel ngefomethi yeseli
Ngaphezu kwalokho, ungakwazi ukuhlela isipredishithi se-Excel ngefomethi yeseli kunokuqukethwe. Lokhu kuhlunga kuwusizo ikakhulukazi uma usebenzisa ikhodi yombala kumaseli athile. Esibonelweni sethu, sizohlunga idatha ngombala weseli ukuze sibone ukuthi imaphi ama-oda anezinkokhelo ezingaqoqiwe.
- Khetha noma yiliphi iseli kuthebula le-Excel ofuna ukulihlunga. Kulesi sibonelo, sizokhetha iseli E2.
- Chofoza Idatha, bese ucindezela umyalo Ukuhlunga.
- Ibhokisi lengxoxo lizovuleka Ukuhlunga. Khetha ikholomu ofuna ukuhlela ngayo ithebula. Khona ensimini Ukuhlunga cacisa uhlobo lokuhlunga: Umbala Weseli, Umbala Wefonti, noma Isithonjana Seseli. Esibonelweni sethu, sizohlunga itafula ngekholomu Indlela yokukhokha (ikholomu E) nangombala weseli.
- In the Order khetha umbala ozowuhlunga. Esimweni sethu, sizokhetha umbala obomvu okhanyayo.
- Cindezela OK. Ithebula manje selihlungwe ngombala, ngamaseli abomvu akhanyayo phezulu. Leli oda lisivumela ukuthi sibone ngokucacile ama-oda asele.