Okuqukethwe
Ukuhlunga kuwumsebenzi we-Excel ojwayeleke kabuhlungu futhi ojwayele cishe wonke umuntu. Kodwa-ke, kunezimo eziningana ezingezona ezijwayelekile nezithokozisayo zokusetshenziswa kwayo.
Ikesi 1. Hlunga ngencazelo, hhayi ngama-alfabhethi
Cabanga ngesimo esivame kakhulu: kunetafula lapho kukhona ikholomu enegama lenyanga (Januwari, February, March ...) noma usuku lwesonto (uLwesihlanu, Lwesibili, Lwesithathu ...). Ngokuhlunga okulula kule kholomu, i-Excel ihlela izinto ngama-alfabhethi (okungukuthi ukusuka ku-A kuye ku-Z):
Futhi ngingathanda, vele, ukuthola ukulandelana okuvamile kusukela ngoJanuwari kuya kuDisemba noma kusukela ngoMsombuluko kuya ngoLwesibili. Lokhu kungenziwa kalula ngesipesheli ukuhlela ngohlu lwangokwezifiso (uhlu lwangokwezifiso).
Khetha ithebula bese ucindezela inkinobho enkulu Ukuhlunga ithebhu Idatha (Idatha - Hlunga). Ibhokisi lengxoxo lizovuleka lapho udinga ukucacisa khona inkambu yokuhlunga (ikholomu) bese ukhetha uhlobo lokuhlunga ohlwini lokugcina lokudonsela phansi. Uhlu Ngokwezifiso (Uhlu lwangokwezifiso):
Ngemva kwalokho, iwindi elilandelayo lizovuleka, lapho ungakhetha khona ukulandelana kwezinyanga noma izinsuku zesonto esizidingayo:
Uma uhlu oludingekayo (isibonelo, izinyanga, kodwa ngesiNgisi) lungatholakali, lungafakwa endaweni efanele ngokukhetha inketho. Uhlu olusha (Uhlu Olusha):
Ungasebenzisa njengesihlukanisi i-comma noma ukhiye Faka. Uma usudale uhlu lwangokwezifiso olunjalo, ungalusebenzisa kwezinye izincwadi zokusebenza ze-Excel.
I-nuance ethokozisayo ukuthi ngale ndlela awukwazi ukuhlunga hhayi ngobuwula ngama-alfabhethi, kodwa ngokubaluleka nokubaluleka noma yiziphi izinto ze-hierarchical, hhayi nje izinyanga noma izinsuku zesonto. Ngokwesibonelo:
- izikhundla (umqondisi, isekela lomqondisi, inhloko yomnyango, inhloko yomnyango…)
- izikhundla zezempi (ujikelele, uColonel, u-lieutenant colonel, omkhulu ...)
- izitifiketi (TOEFL, ITIL, MCP, MVP…)
- amakhasimende noma izimpahla ngokokubaluleka kwakho siqu (i-whisky, i-tequila, i-cognac, iwayini, ubhiya, i-lemonade…)
- njll
Icala 2: Hlunga umbhalo nezinombolo ngesikhathi esisodwa
Ake sithi itafula lethu linekholomu enamakhodi ezingxenye ezihlukahlukene nemihlangano yezimoto (ingxenye yenombolo). Ngaphezu kwalokho, izingxenye ezinkulu eziqoqiwe (isibonelo, i-gearbox, injini, isiteringi) ziboniswa ngekhodi yedijithali kuphela, futhi izingxenye ezincane ezihlanganisayo zikhonjiswa ngekhodi ngokungezwa kwenombolo ecacisayo, yithi, ichashazi. Ukuzama ukuhlunga uhlu olunjalo ngendlela evamile kuzoholela kumphumela ongafuneki, ngoba i-Excel ihlunga izinombolo ngokwehlukana (izinombolo zama-aggregate amakhulu emhlanganweni) futhi ngokwehlukana umbhalo (izinombolo zezingxenye ezincane ezinamachashazi):
 |  |
Futhi-ke, ngingathanda ukuthola uhlu lapho imininingwane yayo izohamba khona ngemuva kweyunithi ngayinye enkulu:
Ukuze sisebenzise lokhu, sidinga ukwengeza enye ikholomu okwesikhashana etafuleni lethu, lapho siguqula wonke amakhodi abe umbhalo sisebenzisa umsebenzi we-TEXT:
Uma usuhlela ngaleyo kholomu, i-Excel izokubuza ukuthi uzihlela kanjani izinombolo nombhalo:
Uma ukhetha inketho yesibili kuleli bhokisi lengxoxo, khona-ke i-Excel ngeke iguqule izinombolo zezibalo ezinkulu zibe izinombolo futhi izohlunga lonke uhlu njengombhalo, okuzosinika umphumela esiwufunayo. Ikholomu eyisizayo ingabe isisuswa.
- Hlunga ngombala
- Hlunga ngombala ngesengezo se-PLEX
- Hlunga ngefomula