Kusankha mu Excel - chidziwitso chofunikira

Kusanja deta mu Excel ndi chida chothandiza kwambiri chomwe chimakupatsani mwayi wowongolera malingaliro a chidziwitso, makamaka ndi ma voliyumu akulu. Mu phunziro ili, tiphunzira momwe tingasankhire, kuphunzira malamulo oyambira, komanso kudziwa mitundu ya kusanja mu Excel.

Powonjezera deta ku Excel, ndikofunikira kukonza bwino zomwe zili patsamba lantchito. Chida chimodzi chomwe chimakulolani kuchita izi ndikusanja. Mothandizidwa ndi kusanja, mutha kupanga mndandanda wazolumikizana ndi dzina lomaliza, kukonza zomwe zili patebulo motsatira zilembo kapena motsika.

Sinthani Mitundu mu Excel

Mukasankha deta mu Excel, chinthu choyamba muyenera kusankha ndikuyika mtunduwo patsamba lonse (tebulo) kapena pama cell angapo.

• Kusankha pepala (tebulo) kumakonza zonse zomwe zili mugawo limodzi. Pamene kusanja kumayikidwa pa pepala, mfundo zokhudzana ndi mzere uliwonse zimasanjidwa pamodzi. Mu chitsanzo chotsatira, ndime Dzina lolumikizidwa (gawo A) losanjidwa motsatira zilembo.
• Masanjidwe amasanja deta m'maselo osiyanasiyana. Kusanja kumeneku kungakhale kothandiza mukamagwira ntchito ndi mapepala a Excel okhala ndi matebulo angapo azidziwitso omwe ali pafupi ndi mnzake. Mtundu womwe umagwiritsidwa ntchito pamitundu yosiyanasiyana sukhudza data ina patsamba lantchito.

Momwe mungasinthire pepala (tebulo, mndandanda) mu Excel

Muchitsanzo chotsatirachi, tidzakonza mawonekedwe a T-sheti yoyitanitsa Dzina langa lomaliza (Mzere C) ndi kuwakonza motsatira zilembo.

1. Sankhani selo yomwe mukufuna kusanja. Mu chitsanzo chathu, tidzasankha selo C2.
2. Dinani Deta pa Riboni, kenako dinani lamulo Kusanja kuchokera ku A mpaka Zkusankha mwadongosolo lokwera, kapena kulamula Sinthani kuchokera ku Z kupita ku Akusankha mwadongosolo lotsika. Mu chitsanzo chathu, tidzasankha lamulo Kusanja kuchokera ku A mpaka Z.
3. Gome lidzasanjidwa ndi gawo losankhidwa, mwachitsanzo ndi dzina lomaliza.

Posankha tebulo kapena mndandanda mu Excel, iyenera kulekanitsidwa ndi data yakunja patsamba lantchito ndi mzere kapena mzere umodzi. Kupanda kutero, data yakunja idzaphatikizidwa pakusanja.

Momwe mungasinthire mitundu mu Excel

Muchitsanzo chotsatirachi, tidzasankha tebulo laling'ono lapadera mu Excel worksheet kuti tisankhe chiwerengero cha T-shirts cholamulidwa masiku ena.

1. Sankhani ma cell omwe mukufuna kusanja. Mu chitsanzo chathu, tidzasankha mitundu A13:B17.
2. Dinani Deta pa Riboni, kenako dinani lamulo Kusankha.
3. Bokosi la zokambirana lidzatsegulidwa Kusankha. Sankhani ndime yomwe mukufuna kusanja. Mu chitsanzo ichi, tikufuna kukonza deta ndi chiwerengero cha malamulo, kotero tidzasankha ndime Order.
4. Khazikitsani dongosolo (lokwera kapena lotsika). Mu chitsanzo chathu, tidzasankha akwera.
5. Ngati magawo onse ali olondola, dinani OK.
6. Masanjidwewo adzasanjidwa ndi magawo Order kuyambira wamng'ono mpaka wamkulu. Dziwani kuti zina zonse zamasamba sizinasanjidwe.

Ngati kusanja mu Excel sikunachitike bwino, ndiye choyamba fufuzani ngati mfundozo zalembedwa molondola. Ngakhale typo yaying'ono imatha kubweretsa zovuta posankha matebulo akulu. Muchitsanzo chotsatira, tinayiwala kuyika hyphen mu cell A18, zomwe zimapangitsa kuti zikhale zolakwika.