Kusefa Kapangidwe kadziwitso ndikofunikira kuti mugwiritse ntchito matebulo ndi zambiri. Chifukwa chake, mwachitsanzo, gawo lofunikira lomwe lingabisike kwa wogwiritsa ntchito, ndipo poyambitsa Fyuluta, onetsani zambiri zomwe zilipo. Nthawi zina, tebulo likapangidwa molakwika, kapena pazifukwa zodziwikiratu kwa wogwiritsa ntchito, pakufunika kuchotsa zosefera mumiyala yopatula kapena pa pepala kwathunthu. Zikuchitika bwanji ndendende, tidzasanthula m'nkhaniyi.
Zitsanzo za Chilengedwe Chachilengedwe
Musanayambe kuchotsa fyuluta, choyamba lingalirani zosankha za kuphatikiza kwake mu tebulo lambiri:
- Kulowa kwa deta. Dzazani mizere ndi zigawo ndi zofunikira. Pambuyo pake, sankhani kuyanjana ndi malo a tebulo, kuphatikizapo mitu. Pitani ku "data" pamwamba pa zida. Timapeza "Fyuluta" (imawonetsedwa mu mawonekedwe a zotsala) ndikudina pa LKM. Fyuluta imayambitsidwa m'mitu yapamwamba.
![Momwe mungachotsere fyuluta mu Excel 15035_1](/userfiles/21/15035_1.webp)
- Kusefa kokha. Pankhaniyi, tebulo lilinso lodzala ndi nthawi yomwe imachitika mu "masitayilo" tabu, imapezeka kuti iyambitse "sefa ngati tebulo" chingwe. Payenera kukhala zosefera zokha mufilimu.
![Momwe mungachotsere fyuluta mu Excel 15035_2](/userfiles/21/15035_2.webp)
Mlandu wachiwiri, muyenera kupita ku tabu ya "kuyika" ndikupeza chida cha tebulo, dinani ndi LKM ndi njira zitatu zotsatirazi kusankha "tebulo" kuti musankhe "tebulo".
![Momwe mungachotsere fyuluta mu Excel 15035_3](/userfiles/21/15035_3.webp)
Zenera lotsatira lotsatira lomwe likutsegulira, kuyankhula kwa tebulo lopangidwa likuwonetsedwa. Zimangotsimikizira izi, ndipo zosefera mu mawu amphamvu zimangoyatsidwa zokha.
![Momwe mungachotsere fyuluta mu Excel 15035_4](/userfiles/21/15035_4.webp)
Zitsanzo ndi zosefera pa Excel
Siyani kuti muganizire tebulo lomweli lofanana ndi mizere itatu.
- Sankhani mzere womwe muyenera kusintha. Mwa kuwonekera pa muvi mu khungu lam'mwamba, mutha kuwona mndandanda. Kuchotsa lingaliro limodzi kapena zinthu, muyenera kuchotsa nkhuni mosemphana.
- Mwachitsanzo, timafunikira masamba okha patebulo. Pazenera lomwe limatsegula, chotsani nkhupakuko ndi "chipatso", ndikusiya masamba akhamwa. Gwirizanani podina batani la "OK".
![Momwe mungachotsere fyuluta mu Excel 15035_5](/userfiles/21/15035_5.webp)
- Pambuyo poyambitsa mndandandawo uziwoneka motere:
![Momwe mungachotsere fyuluta mu Excel 15035_6](/userfiles/21/15035_6.webp)
Ganizirani chitsanzo china cha zosefera:
- Gome limagawidwa m'magawo atatu, ndipo mitengo yomaliza ya mtundu uliwonse ya mankhwala amaperekedwa. Iyenera kusintha. Tiyerekeze kuti tikufuna kusefa zinthu zomwe mtengo wake ndi wotsika kuposa mtengo "45".
- Dinani chithunzi chosefera mu khungu lomwe lasankhidwa ndi US. Popeza mzatiyo wadzazidwa ndi zidziwitso za manambala, ndiye pazenera mutha kuwona kuti zingwe za "manambala" zili munthawi yogwira.
- Kukhala ndi chotemberera pamenepo, tsegulani tabu yatsopano ndi mitundu yosiyanasiyana ya kusefedwa patenthedwe ya digito. Mmenemo, sankhani mtengo "wochepera".
![Momwe mungachotsere fyuluta mu Excel 15035_7](/userfiles/21/15035_7.webp)
- Kenako lembani nambala yakuti "45" kapena sankhani potsegula mndandanda wa manambala mu Autofiter.
Komanso, mothandizidwa ndi ntchitoyi, mitengoyo imasefedwa mumtundu wapadera wa digito. Kuti muchite izi, muyenera kuyambitsa batani la "kapena" mu Autofiter. Kenako pamwamba pangani mtengo wake "wochepera", komanso pansi pa "ochulukirapo". Mu zingwe zoyimira kumanja kumanja, magawo ofunikira a mtengo amapezeka kuti achokepo. Mwachitsanzo, ochepera 30 ndi opitilira 45. Zotsatira zake, tebulo lisunga nambala 25 ndi 150.
![Momwe mungachotsere fyuluta mu Excel 15035_8](/userfiles/21/15035_8.webp)
Njira zosefera za chidziwitso ndizochulukirapo. Kuphatikiza pazitsanzo, ndizotheka kusintha deta pamtundu wa maselo, malinga ndi makalata oyamba a mayina ndi zinthu zina. Tsopano, tikamachita bwino kwambiri ndi njira zopangira zosefera ndi mfundo zogwira nawo ntchito, pitani ku kuchotsa njira.
Chotsani zofananira
- Choyamba, timapeza fayilo yopulumutsidwa ndi tebulo pakompyuta yanu ndikudina LKM tsegulani. Pa pepala ndi tebulo, mutha kuwona kuti Fyuluta ili munthawi yogwira mtengo.
![Momwe mungachotsere fyuluta mu Excel 15035_9](/userfiles/21/15035_9.webp)
- Dinani pa lipenga.
- Mu bokosi la zokambirana lomwe limatseguka, mutha kuwona kuti cheke chizindikirocho moyang'anizana ndi manambala "25" chimachotsedwa. Ngati kusefa kwamphamvu kunangochotsedwa pamalo amodzi, ndiye njira yosavuta yokhazikitsa chizindikiro ndikudina batani la "Ok".
- Kupanda kutero, ndikofunikira kuyimitsa fyuluta. Kuti muchite izi, muzenera lomwe mufunika kupeza zingwe "Chotsani zosefera kuchokera pachinthu" ... "ndikudina LKM. Padzakhala kutseka kokha, ndipo zonse zomwe zidalowetsedwa kale zidzawonetsedwa kwathunthu.
![Momwe mungachotsere fyuluta mu Excel 15035_10](/userfiles/21/15035_10.webp)
Kuchotsa zosefera kuchokera pa pepala lonse
Nthawi zina zochitika zimachitika pakafunika kuchotsa zosefera patebulo lonse. Kuti muchite izi, muyenera kuchita zotsatirazi:
- Tsegulani fayilo ndi deta yosungidwa bwino.
- Pezani mzere umodzi kapena zingapo pomwe fyuluta imayambitsidwa. Pankhaniyi, iyi ndi gawo la "Dzinalo".
![Momwe mungachotsere fyuluta mu Excel 15035_11](/userfiles/21/15035_11.webp)
- Dinani pamalo aliwonse mu tebulo kapena kuwunikira kwathunthu.
- Pamwamba, pezani "deta" ndikuyambitsa LKM yawo.
![Momwe mungachotsere fyuluta mu Excel 15035_12](/userfiles/21/15035_12.webp)
- Net "Fyuluta". Mosiyana ndi mzati ndi zizindikiro zitatu mu mawonekedwe a chokhazikika ndi mitundu yosiyanasiyana. Dinani pa batani la Ntchito "Chotsani" ndi mapangidwe owonetsedwa ndi ofiira ofiira.
- Kenako idzazimitsa zosewerera patebulo lonse.
Mapeto
Zosemphana ndi zomwe zili mu tebulo zimathandizira kwambiri kugwira ntchito bwino, koma mwatsoka, munthuyo amakonda kulakwitsa. Pankhaniyi, pulogalamu ya exustifotal yowonjezera imadzanso kupulumutsa, yomwe ingathandize kukonza deta ndikuchotsa zosefera zosafunikira zomwe zalembedwa kale ndi kusungidwa kwa magwero. Izi ndizothandiza kwambiri mukadzaza matebulo akuluakulu.
Mauthenga Momwe Mungachotsere Fyulutayo ku Excered woyamba kuzatswiri chidziwitso.