Yakha uluhlu lokuhlawula phantsi kwi-Excel ukusuka kwenye iWindows Worksheet

Ukudala uluhlu lokuhlahla kwi-Excel kukuvumela ukuba ufake idatha kwisisele esithile kwiphepha lokusebenzela ukusuka kuluhlu olufakwe ngaphambili.

Iintlobo zokusebenzisa uluhlu lokuhlahlala ziquka:

• Ukwenza ukungena kwedatha kulula
• Ukukhusela iimpazamo zokungena kwedatha
• Ukukhawulela inani leendawo zokufaka idatha

I-Excel I-Down-Down List Uluhlu lweSigaba seTutorial Topics

• Ukufaka i-Tutorial Data
• Ukudala umgama obizwa ngokuba yiDatha
• Ukuqala uLuhlu oluLahlayo
• Ukusebenzisa uLuhlu lokuVunywa kweDatha
• Ukufaka uMthombo wedatha nokugcwalisa uLuhlu lokuLahla
• Ukutshintsha izinto zoLuhlu
• Izinketho zokuKhusela uLuhlu lokuLahla

Ukufaka i-Tutorial Data

Isinyathelo sokuqala sokwakha uluhlu lokuhlahla kwi-Excel kukungenisa idatha .

Qaphela: Imiyalelo yokufundisa ayifaki ukufomatha amanyathelo kwiphepha lokusebenzela.

Oku akuyi kuphazamisana nokugqiba uqeqesho. Iphepha lokusebenzela liya kubonakala lihluke kunomzekelo kwiphepha 1, kodwa uluhlu oluphahlayo luya kunika iziphumo ezifanayo.

Faka idatha engezantsi kwiiseli eziboniswe kwiimakhishithi enye kunye ezimbini zeencwadi ze-Excel.

Iimfundiso zeTutorial

1. Faka idatha elandelayo kwiiseli ezichanekileyo kwiShidi 1 lomsebenzi: D1 - Uhlobo lwe-Cookie:
2. Cofa kwiThebhu yeTekethi yeSheyibhile 2.
   
3. Faka idatha elandelayo kwiiseli ezichanekileyo kwiShedyuli yesi-2 kwiphepha lokusebenzela:
   I-A1 - I-Gingerbread A2 - i-Lemon A3 - i-Oatmeal Raisin A4 - i-Chocolate Chip

Uluhlu lokuhlahla luya kufakwa kwiseli E1 kwiphepha 1.

Ukudala Uhlobo Oludumiweyo loLwazi lweDatha

Uluhlu olukhethiweyo lukuvumela ukuba ubhekisele kwiqela elithile leeseli kwiincwadi ze-Excel.

Amanqanaba anegama aninzi asetyenziswayo kwi-Excel kuquka ukuwasebenzisa kwiifomula nakwindlela yokudala amashadi.

Kuzo zonke iimeko, uluhlu olukhankanyiweyo lusetyenziselwa endaweni yeendidi ezibhekiselele kubonisa indawo yendawo kwiphepha lokusebenzela.

Xa lisetyenziswe kuluhlu oluphahlayo, uluhlu oluchongiweyo lusetyenziswa njengemithombo yoluhlu lwezinto.

Iimfundiso zeTutorial

1. Hudula ukhethe iiseli A1 - A4 kwiShedyuli 2.
2. Cofa kwiBhokisi legama elisezantsi kwekholam A
3. Thayipha "ikhukhi" (akukho zicaphulo) kwiBhokisi legama
4. Cinezela i- ENTER iqhosha kwikhibhodi
5. Iiseli ezi-A1 ukuya kwi-A4 kwiphepha 2 ngoku inegama legama "ikhukhi"
6. Londoloza iphepha lakho lomsebenzi

Ukuvula iBhokisi yoLwazi lweNgcaciso yeDatha

Zonke iinketho zokuqinisekiswa kwedatha kwi-Excel, kubandakanywa uluhlu lokuhlalisa, lubekwe kusetyenziswa ibhokisi yencoko yebhokisi yencoko.

Ibhokisi yencoko yencoko yencoko yababini iphantsi kwethebhu yedata yebhoni .

Iimfundiso zeTutorial

1. Cofa kwiTebhu ye-1 yeTebhu phantsi kwekrini ukutshintshela kwiphepha 1
2. Cofa kwifowuni E1 ukwenzela ukuba yenze iseli esebenzayo - yilapho uluhlu lokuhlahla luya kuba khona
3. Cofa kwiTebhu yedata ye menu yebhondi ngaphezulu kwiphepha lokusebenzela
4. Cofa kwi icon ye- Data Validation kwi-Ribbon ukuvula imenyu ehlayo
5. Cofa kwiKhowudi yokuQiniseka kweDatha kwimenyu ukuvula ibhokisi yencoko yababini yokuqinisekisa

Ukusebenzisa uLuhlu lokuVunywa kweDatha

Ukongezelela ukongeza uluhlu lwezintlu kwi-worksheet, ukuqinisekiswa kwedatha kwi-Excel nako kusetyenziselwa ukulawula okanye ukunciphisa uhlobo lweedatha ezingeniswa kwiiseli ezithile.

Ezinye zeendlela eziqhelekileyo ezisetyenziswayo:

• Uludwe
• Imihla kunye / okanye amaxesha
• Amanani onke
• Umbhalo
• Iifomula (zibekwe phantsi kwekhetho lomntu)

Kule nyathelo, siza kukhetha ukhetho lwoluhlu njengoko uhlobo lokuqinisekiswa kwedatha oluya kusetyenziswa kwi-cell E1 kwiphepha 1.

Amanyathelo

1. Cofa kwiZetyuli zebhokisi kwibhokisi yencoko
2. Cofa kwitolo elihlayo ekupheleni komgca wokuvumela ukuvula imenyu ehlayo
3. Cofa kuluhlu ukukhetha uluhlu lokuhla kweedatha ukuqinisekiswa kwiseli D1 kwaye usebenzise umgca woMthombo kwibhokisi yencoko

Ukufaka uMthombo weDatha nokugqiba uLuhlu lokuLahla

Ekubeni umthombo wedatha loluhlu lokuhlahla lufumaneka kwiphepha elihlukileyo lokusebenzela, udidi olukhethiweyo oludalwe kwangaphambili luya kufakwa kumgca woMthombo kwibhokisi yencoko .

Amanyathelo

1. Cofa kuMgca woMthombo
2. Uhlobo "= ikhukhi" (akukho zicatshulwa) kumgca woMthombo
3. Cofa Kulungile ukuqedela uluhlu lokuhlalisa kwaye uvale ibhokisi yencoko yoqinisekiso yokuDatha
4. Isithonjana esincinci esincinci esisezantsi kwicala le-E1
5. Ukuchofoza kwisicatshulwa esezantsi kufuneka uvule uluhlu lokuhlahla oluqulethwe ngamagama amane ekhukhi angena kwiiseli A1 ukuya ku-A4 kwiphepha 2
6. Ukuqakraza kwelinye lamagama kufuneka ufake igama lelo kwi-cell E1

Ukuhlela izinto zeeNcwadi

Ukugcina uluhlu lokuhla kwexesha ngokutsha kunye neenguqu kwi data yakho, kunokufuneka ukuba uguqule ngokukhawuleza ukhetho oluluhlu.

Ekubeni sasebenzisa uluhlu olukhankanywe njengoluhlobo lwezinto zethu zohlulo kunokuba luhlu lwamagama ahlukileyo, ukutshintsha amagama e-cookie kwibanga elikhankanyiweyo elikhoyo kwiiseli A1 ukuya ku-A4 kwiphepha 2 ngokukhawuleza utshintshe amagama kwibala lokuhla.

Ukuba idatha ingeniswa ngqo kwibhokisi yencoko, ukwenza utshintsho kuloluhlu kubandakanya ukubuyela kwibhokisi yencoko kwaye uhlele umthombo wendawo.

Kule nyathelo, siza kutshintsha i- Shortbread ukuya kwi- Oatmeal Raisin kwiluhlu lokuhlahla ngokutshintsha idatha kwi-cell A3 yegama elithethiweyo.

Amanyathelo

1. Cofa kwiseli A3 kwiphepha 2 (i-shortbread) ukwenza iseli esebenzayo
2. Thayipha i- Oatmeal Raisin kwiseli A3 uze ucinezela ukungena kwikhibhodi
3. Cofa kwitolo elihlayo lohlu lokuhla kweloluhlu kwi-cell E1 yephepha 1 ukuvula uluhlu
4. Isiqendu 3 kuloluhlu kufuneka ngoku sifunde i- Oatmeal Raisin esikhundleni se- Shortbread

Izinketho zokuKhusela uLuhlu lokuLahla

Ekubeni idatha yethu isebenza kwiphepha elihlukileyo lomsebenzi ukusuka kuluhlu lokuhla kwezinto ezimbini ezikhethiweyo ezikhoyo ukukhusela idatha yoluhlu:

• Fihla iphepha lokusebenzela eliqulethe idatha (iphepha 2)
• Khusela iphepha lokusebenzela elibandakanya ukuvalela iiseli A1 ukuya ku-A4 kwiphepha 2

Ukuba ukhuseleko aluyixhalaba, ukufihla iphepha lokusebenzela eliqulethe uluhlu lwedatha lukhetho olufanelekileyo kuba kulula ukwenza ukuhlaziywa uluhlu xa lufuneka.

Ukuba ukhuseleko lugxininiswa kwiphasiwedi xa ukhusela iphepha lokusebenzela ukukhusela utshintsho kwizinto eziluhlu.

Ukudala uluhlu lokuhlawula phantsi kwi-Worksheet eyahlukeneyo

Uluhlu lwehla lokungena luvumela ukuba ufake idatha kwi-spreadsheet ye-Excel ukusuka kwoluhlu olufakwe ngaphambili.

Icandelo 1 lihlanganisa amanyathelo okudala uluhlu lokuhlahla kunye nedatha kwiphepha elifanayo njengoluhlu lokuhla.

Olu qeqesho luquka ukudala uluhlu lokuhla kwephepha lokusebenzela.

Umzekelo: Ukudala uluhlu lokuhla kwezantsi kunye nedata kwiphepha elifanelekileyo lomsebenzi

Faka idatha elandelayo kwiiseli ezichanekileyo kwiShedyuli 1 yephepha lokusebenzela:
E1 - I-Cookie Shop
D2 - Uhlobo lwecookie:
Cofa kwiThebhu yeTekethi yeSheyibhile 2.
Faka idatha elandelayo kwiiseli ezichanekileyo kwiShedyuli 2 okanye kwiphepha lokusebenzela:
A1 - Gingerbread
A2 - iLimi
A3 - Oatmeal Raisin
I-A4 - i-Chocolate Chip
Gqamisa iiseli A1 - A4 kwiShedyuli 2.
Thayipha "ikhukhi" (akukho zicaphulo) kwiBhokisi legama uze ucinezela ukhiye wokungena kwikhibhodi.
Cofa kwiTebhu yeTekethi yeSebe 1
Cofa kwiseli E2 - indawo apho iziphumo ziza kuboniswa khona
Cofa kwiThebhu yedata
Cofa kwiCandelo lokuQinisekisa iDatha kwi-Ribbon ukuvula imenyu
Cofa kwiNgcaciso yeDatha kwimenyu ukukhupha ibhokisi yencoko
Cofa kwiZetyuli zebhokisi kwibhokisi yencoko
Ukusuka kwi-Imenyu yemenyu khetha Uludwe
Uhlobo = ikhukhi kuMgca woMthombo kwibhokisi yencoko
Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela
Inqolo ephantsi kufuneka ibonakale ecaleni kweseli E2
Xa ucofa kwisalathisi uluhlu oluphahlayo lufanele luvule ukubonisa amagama amane ekhukhi