Ungadala kanjani uhlu lokudonsa phansi ku-Excel

Izinketho zokuqinisekiswa kwedatha ye-Excel zihlanganisa ukwakha uhlu lokudonsa olwenqabela idatha engangena esitokisini esithile ohlwini lokufakwa ngaphambilini.

Uma uhlu lokudonsa lufakwa esitokisini, umcibisholo uboniswa eceleni kwawo. Ukuchofoza kumcibisholo kuzovula uhlu bese kukuvumela ukuba ukhethe okukodwa ohlwini lwezinto ukungena esitokisini.

Idatha esetshenziswe ohlwini ingatholakala:

• ekhasini elifanayo lomsebenzi njengoluhlu
• ekhasini lokusebenzela elihlukile ebhokisini elifanayo
• encwadini ehlukile

Isifundo: Ukusebenzisa Idatha Egcinwe Encwadini Yezincwadi Ehlukile

Kulesi sifundo, sizokwenza uhlu oludonsa phansi usebenzisa uhlu lokufakwayo olusencwadini ethize ehlukile.

Izinzuzo zokusebenzisa uhlu lwamafomu afakwe encwadini ehlukile zifaka phakathi ukubeka phakathi idatha yolwazi uma isetshenziselwa abasebenzisi abaningi futhi ivikela idatha kusuka ekushintsheni ngengozi noma ngamabomu.

Qaphela: Uma idatha yolwazi igcinwa ebhukwini elihlukile zombili izincwadi zokusebenzela kumele zivuleke ukuze uhlu lusebenze.

Ukulandela izinyathelo ezihlokweni zezifundo ngezansi kukuhamba ngokudala, ukusebenzisa, nokushintsha uhlu lokudonsa olufana nalowo obonwe esithombeni ngenhla.

Lezi ziqondiso zokufundisa, noma kunjalo, azibandakanyi izinyathelo zokufometha zamashidi.

Lokhu ngeke kuphazamise ukuqedela ukufundisa. Iphepha lakho lokusebenzela lizobonakala lihlukile kunesibonelo ekhasini 1, kodwa uhlu lokudonsa luzokunika imiphumela efanayo.

Izihloko zezifundo

• Ukuvula Amafayela nokulondoloza Idatha Yokufundisa
• Ukwakha Ranges Ezimbili Ezibizwa
• Ukuvula ibhokisi lokungena lokuqinisekisa idatha
• Ukufaka Umthombo WeDatha nokugcwalisa Uhlu Lokudonsa phansi
• Ukushintsha Izinto Zohlu
• Izinketho zokuvikela uhlu lokudonsa phansi

01 ka-06

Ukufaka idatha yokufundisa

Ukuvula Amabhuku Amabhuku Ase-Excel

Njengoba kukhonjisiwe, kule tutorial idatha yohlu lokudonsa izobe itholakala encwadini yokusebenzela ehlukile ohlwini lokudonsa phansi.

Ukuze lolu hlelo lulandele lezi zinyathelo:

1. Vula amabhuku amabili e-Excel angenalutho
2. Londoloza ibhuku elilodwa lomsebenzi negama- data-source.xlsx - le ncwadi yokusebenza izoqukatha idatha yohlu lokudonsa phansi
3. Gcina incwadi yesibili negama elihlaselwa phansi-uhlu.xlsx - le ncwadi ibandakanya uhlu lokudonsa phansi
4. Shiya kokubili izincwadi zokusebenzela zivule ngemuva kokulondoloza.

Ukufaka idatha yokufundisa

1. Faka idatha engezansi kumaseli A1 kuya ku-A4 ebhukwini le- data-source.xlsx njengoba kuboniswe esithombeni ngenhla.
2. A1 - I-Gingerbread A2 - I-Lemon A3 - I-Oatmeal Raisin A4 - I-Chocolate Chip
3. Londoloza ibhuku futhi uyishiye livulekile
4. Faka idatha ngezansi kumasethini B1 ebhokisini lencwadi yokudonsa-uhlu.xlsx .
5. B1 - Uhlobo lwe-Cookie:
6. Londoloza ibhuku futhi uyishiye livulekile
7. Uhlu lokudonsa luzofakwa kwiseli C1 yale ncwadi yokusebenzela

02 ka 06

Ukwakha Ranges Ezimbili Ezibizwa

Ukwakha Ranges Ezimbili Ezibizwa

Ibanga elibizwe likuvumela ukuthi ubheke ububanzi obuthile bamaseli encwadini ye-Excel.

Izigaba ezibizwa ngokuthi i-Excel zibandakanya ukuzisebenzisa ngamafomula kanye nokudala amashadi.

Kuzo zonke izimo, ububanzi obunqunyelwe busetshenziselwa indawo yobuningi bezinkomba ezibonisa ukuthi indawo yedatha kushicilelo.

Uma lisetshenziswe kuhlu oluphansi lwezincwadi olusebhuku elihlukile, amabanga amabili aqoshiwe kumele asetshenziswe.

• Enye idalwe ezintweni zohlu ebhokisini lapho kutholakala khona idatha
• Iwesibili idalwe encwadini yokusebenzela lapho uhlu olwehlisiwe lukhona. Leli lizwe elibizwa ngokuthi ububanzi lihlanganiswa nobubanzi obuqanjwe ebhokisini lokuqala lokusebenzela

Izinyathelo Zokufundisa

Range LokuQala Olubizwa Ngegama

1. Khetha amaseli A1 - A4 encwadini yedatha-source.xlsx ukuwagqamisa
2. Chofoza ebhokisini legama elisenhla kwekholomu A
3. Thayipha "Amakhukhi" (ayikho izingcaphuno) ebhokisini legama
4. Cindezela inkinobho ENTER ekhibhodi
5. Amaseli A1 kuya ku-A4 wencwadi yedatha-source.xlsx manje inegama lebanga lamakhukhi
6. Londoloza ibhuku

Umzila Obizwa Ngesibili

Ibanga lesibili elibizwe lingasebenzisi amareferensi weselula kusuka ebhukwini lokudonsa phansi-list.xlsx .

Kunalokho, kuyobe, njengoba kukhonjisiwe, kuxhumene negama lebanga lamakhukhi kubhuku le- data-source.xlsx .

Lokhu kuyadingeka ngoba i-Excel ngeke yamukele izithenjwa zeseli ezivela ebhokisini elihlukile lomkhakha ochazwe. Kuzobe kunjalo, ngaphandle kwegama elinye lebala.

Ukudala ububanzi obunqunyiwe, ngakho-ke, akukwenziwe ngokusebenzisa iBhokisi Legama kodwa ngokusebenzisa inketho yeMenenja yegama elisendaweni yefomathi yebhande.

1. Chofoza kuselili C1 kubhuku lokusebenzela phansi-list.xlsx
2. Chofoza kumafomula> Imenenja Yegama egubheni ukuze uvule ibhokisi lengxoxo yeMenenja yegama
3. Chofoza inkinobho entsha ukuvula ibhokisi lengxoxo yegama elisha
4. Igama lohlobo lwegama: Idatha
5. Kuloluhlobo lombhalo: = 'data-source.xlsx'! Amakhukhi
6. Chofoza u-Kulungile ukuqedela ububanzi obunqunyiwe bese ubuyela ebhokisini lebhokisi le-Igama Lomphathi
7. Chofoza Vala ukuze uvale ibhokisi lengxoxo yeMenenja yegama
8. Londoloza ibhuku

03 ka 06

Ukuvula ibhokisi lokungena lokuqinisekisa idatha

Ukuvula ibhokisi lokungena lokuqinisekisa idatha

Zonke izinketho zokuqinisekiswa kwedatha ku-Excel, kufaka phakathi uhlu lokudonsa phansi, zibekwe kusetshenziswa ibhokisi lengxoxo yokuqinisekisa idatha.

Ngaphezu kokungeza uhlu lwezintambo phansi kwiphepha lokusebenzela, ukuqinisekiswa kwedatha ku-Excel kungasetshenziswa futhi ukulawula noma ukukhawulela uhlobo lwedatha olungangena kumaseli athile kuphepha lokusebenzela.

Izinyathelo Zokufundisa

1. Chofoza kuseli C1 lencwadi yokudonsela phansi-uhlu.xlsx ukwenza kube yilali esebenzayo - yilapho uhlu lokudonsa luzobe lukhona
2. Chofoza kuthebhu yedatha yedatha yemenyu ye-ribbon ngaphezulu kwephepha lokusebenzela
3. Chofoza kusithonjana sokuqinisekiswa kwedatha kwi-Ribbon ukuvula imenyu yehla
4. Chofoza ku-Option Data Validation kwimenyu ukuvula ibhokisi lengxoxo ye-Data Validation
5. Shiya ibhokisi lengxoxo evulekile isinyathelo esilandelayo ekufundiseni

04 ka 06

Usebenzisa uhlu lokuqinisekisa idatha

Ukukhetha Uhlu Lokuqinisekisa Idatha

Njengoba kukhonjisiwe kukhona inamba yezinketho zokuqinisekiswa kwedatha ku-Excel ngaphezu kohlu lokudonsa phansi.

Kulesi sinyathelo sizokhetha ukhetho lohlu njengoba uhlobo lokuqinisekiswa kwedatha oluzosetshenziselwa iselula D1 kwiphepha lokusebenzela.

Izinyathelo Zokufundisa

1. Chofoza ku- Izilungiselelo ithebhu ebhokisini lengxoxo
2. Chofoza umcibisholo ophansi ekupheleni kwe- Allow line ukuze uvule imenyu yehla
3. Chofoza ohlwini ukuze ukhethe uhlu lokudonsa lokuqinisekiswa kwedatha kwiseli C1 futhi usebenze umthombo womthombo ebhokisini lengxoxo

Ukufaka Umthombo WeDatha nokugcwalisa Uhlu Lokudonsa phansi

Njengoba umthombo wedatha uhlu lokudonsa lukhona encwadini ehlukile, ibanga lesibili eliqanjwe ngaphambilini elizofakwa ekuqaleni lizofakwa emgqeni woMthombo ebhokisini lengxoxo.

Izinyathelo Zokufundisa

1. Chofoza kulayini lomthombo
2. Thayipha "= Idatha" (ayikho izingcaphuno) emgqeni womthombo
3. Chofoza u- Kulungile ukuqedela uhlu lokudonsela phansi bese uvale ibhokisi lengxoxo ye- Data Validation
4. I-icon encane engaphansi komcibisholo itholakala ngakwesokudla kweseli C1
5. Ukuchofoza umcibisholo ophansi kufanele uvule uhlu oluhlehlisiwe oluqukethe amagama amane ekhukhi angeniswe kumaseli A1 kuya ku-A4 ebhukwini le- data-source.xlsx
6. Ukuchofoza kumunye wamagama kufanele ufake lelo gama kuseli C1

05 ka 06

Ukushintsha Uhlu Lokudonsa phansi

Ukushintsha Izinto Zohlu

Ukuze ugcine uhlu olwehlisiwe lusesikhathini noshintsho kudatha yethu, kungase kudingekile ukushintsha ngezikhathi ezithile izinqumo ohlwini.

Njengoba sisebenzise ububanzi obubizwa ngokuthi umthombo wezinto zethu ohlwini kunamagama ohlu lwamagama, ukushintsha amagama wekhukhi ebangeni elifakwe ohlwini elisekholi A1 kuya ku-A4 yencwadi yedatha-source.xlsx ngokushesha ushintshe amagama ekudleni uhlu.

Uma idatha ingeniswa ngqo ebhokisini lebhokisi, ukwenza izinguquko ohlwini kufaka ukubuyela emuva ebhokisini lengxoxo bese uhlela umthombo womsakazo.

Kulesi sinyathelo sizoguqula i- Lemon ku- Shortbread ohlwini lokudonsa ngokushintsha idatha ku-cell A2 yobubanzi obuqanjwe kumsebenzi we- data-source.xlsx .

Izinyathelo Zokufundisa

1. Chofoza ku-cell A2 encwadini yedatha-source.xlsx (i-Lemon) ukwenza kube iseli elisebenzayo
2. Thayipha izinhlamvu ezimfushane zibe esitokisini A2 bese ucindezela ukhiye we-Enter ekhibhodi
3. Chofoza umcibisholo ophansi ukuze uhlahlise ohlwini lweseli C1 lencwadi yokudonsa-uhlu.xlsx ukuvula uhlu
4. Into yesi-2 ohlwini kumele manje ifunde i- shortbread esikhundleni se- Lemon

06 ka-06

Izinketho zokuvikela uhlu lokudonsa phansi

Izinketho zokuvikela uhlu lokudonsa phansi

Kusukela idatha yethu isemakhasini ahlukene asebenzayo okukhethwa kukho ohlwini lwezintambo ezitholakala ekuvikeleni idatha yolwazi kufaka:

• Vikela iphepha lokusebenzela elifaka ukuvala amangqamuzana A1 kuya ku-A4 ekhasini 2
• Kudinga iphasiwedi ukuguqula ibhuku lokusebenzela
• Ukuba nencwadi yokuvula ivuliwe njenge- Read-only