Ungafriza kanjani umugqa, ikholomu noma isifunda ku-Excel? umbuzo ojwayelekile obuzwa abasebenzisi be-novice lapho beqala ukusebenza ngamatafula amakhulu. I-Excel inikeza amathuluzi amaningana okwenza lokhu. Uzofunda wonke lamathuluzi ngokufunda lesi sifundo kuze kube sekupheleni.
Uma usebenza ngenani elikhulu ledatha, kungaba nzima ukuhlobanisa ulwazi encwadini yokusebenzela. Nokho, i-Excel inamathuluzi amaningana akwenza kube lula ukubuka okuqukethwe kwezigaba ezahlukene zencwadi yokusebenzela ngesikhathi esisodwa, njengamafasitelana okuphina kanye namafasitela ahlukanisayo.
Friza imigqa ku-Excel
Kwesinye isikhathi ungafuna ukubona izindawo ezithile ekhasini lakho lomsebenzi le-Excel ngaso sonke isikhathi, ikakhulukazi izihloko. Ngokuphina imigqa noma amakholomu, uzokwazi ukupheqa okuqukethwe, kuyilapho amaseli aphiniwe ezohlala ebonakala.
- Gqamisa umugqa ongezansi kwalowo ofuna ukuwuphina. Esibonelweni sethu, sifuna ukuthwebula imigqa 1 no-2, ngakho sikhetha irowu 3.
- Chofoza Buka eteyipini.
- Phusha umyalo Ukulungisa izindawo bese ukhetha into yegama elifanayo kumenyu yokudonsela phansi.
- Imigqa izophinwa, futhi indawo yokuphina izokhonjiswa ngomugqa ompunga. Manje usungakwazi ukuskrola ishidi lokusebenza le-Excel, kodwa imigqa ephiniwe izohlala ibonakala phezulu eshidini. Esibonelweni sethu, siskrole ishidi saya kumugqa we-18.
Ukuqandisa amakholomu ku-Excel
- Khetha ikholomu kwesokudla sekholomu ofuna ukuyifriza. Esibonelweni sethu, sizomisa ikholomu A, ngakho sizogqamisa ikholomu B.
- Chofoza Buka eteyipini.
- Phusha umyalo Ukulungisa izindawo bese ukhetha into yegama elifanayo kumenyu yokudonsela phansi.
- Amakholomu azodokhwa futhi indawo yokudokha izokhonjiswa ngomugqa ompunga. Manje usungakwazi ukuskrola ishidi lokusebenzela le-Excel, kodwa amakholomu aphiniwe azohlala ebonakala ohlangothini lwesobunxele lwephepha lomsebenzi. Esibonelweni sethu, siskrole kukholomu E.
Ukuze uvule imigqa noma amakholomu, chofoza Ukulungisa izindawo, bese ukhetha kumenyu yokudonsela phansi Susa ukuphina izifunda.
Uma udinga ukufriza kuphela umugqa ophezulu (Umugqa1) noma ikholomu yokuqala (Ikholomu A), ungakhetha umyalo ofanele kumenyu yokudonsela phansi.