Momwe mungagawire mzati pakhungu

Njira 1: Kulekanitsa ndi manambala

Tiyeni tiyambe ndi mawonekedwe osavuta kwambiri a mizati mu Excel, mfundo zomwe zimakhala ndi manambala ena. Mwathu, awa ndi masauzande ndi mazana, olekanitsidwa ndi comma - izi zikuwoneka mu chithunzi chotsatirachi.

Ntchito ndi yogawanitsa anthu masauzande ndi mazana mumitundu yosiyanasiyana, yomwe ingafunike ndikuwerengeranso kuchuluka kwa ndalamazi. Apa mutha kuchita popanda kupanga njira zopezerera, kulumikizana ndi chida chomwe chidapangidwa mu pulogalamuyi.

1. Sankhani mzati womwe mukufuna kugawanidwe, kenako pitani ku tabu ya data.



2. Dinani pa batani la "Column". Inde, ngakhale chida chikugwirizana ndi lembalo, sizingalepheretse chilichonse kugwiritsa ntchito ndalama za ndalama, masiku kapena manambala ena.



3. "Zowonjezera za Dizard Wizards" zimawonekera, momwe mumasankha kusankha "ndi olekanitsa" ndikupita ku gawo lotsatira.



4. Monga chizindikiro cholekanitsa, fotokozerani chizindikiro chomwe chimagwiritsidwa ntchito pamunsi. Ngati ndizosatheka kuzilemba ndi chizindikiro cha cheke, yambitsa njira "ina" komanso kuyika mawu awa.



5. Mu zitsanzo za data zomwe zilipo, onani momwe mizati imawonekera pambuyo polekanitsa.



6. Fomu ya data imasiyidwa kwathunthu kapena kukhazikitsa tsiku la icho ngati lingafike.



7. Mwachisawawa, mzati watsopanoyo amayikidwa mnjira, koma mutha kusankhira malo ake.



8. Lembani maderalo kapena ikani patebulo.



9. Zochita zogawika zikamalizidwa, dinani "kumaliza" kuti mugwiritse ntchito makonda atsopano.



10. Kubwerera pagome, Mudzaona kuti zonse zachitika molondola. Idzasiyidwa kuti isinthe pang'ono - mwachitsanzo, pitilizani kulekanitsa kapena mawonekedwe a patebulo.



11. Tidziwikira kuti palibe kusiyana pakati panu, ndipo kuchokera kwa inu mukamaika njirayi mumangofunika kuwonetsa mawonekedwe olekanitsa ndi malo omwe mukufuna kuyika mzati watsopano. Zochita zina zonse zimachitika zokha.

Ngati muli ndi tebulo ndi manambala osinthika omwe mukufuna kuti mugawike pafupipafupi pamizapatoyi, werengani malangizowo kuchokera pa njira yotsatirayi, yomwe imalongosola zolengedwa za formula mukamagawa mawu. Ndioyenera kuchuluka, zinthu zokhazo zomwe zingasinthe pang'ono.

Njira 2: Kupatukana

Kugawana mawu pazambiri, malamulo omwewo amagwiranso ntchito, koma pali njira yachiwiri - kupanga formula yovuta yomwe ingapangitse mizati iwiri kapena yochulukirapo ndi data ndikuwakwaniritsa. Ili ndi ntchito yovuta, kuthana ndi zomwe zimafunikira mu magawo, zomwe zimaperekedwanso ku gawo lina.

Werengani zambiri: kulekanitsidwa kwa zolemba mu Microsoft Excel