Momwe mungachotsere fyuluta mu Excel

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.

chimodzi

• 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.

2.

Mlandu wachiwiri, muyenera kupita ku tabu ya "kuyika" ndikupeza chida cha tebulo, dinani ndi LKM ndi njira zitatu zotsatirazi kusankha "tebulo" kuti musankhe "tebulo".

3.

Zenera lotsatira lotsatira lomwe likutsegulira, kuyankhula kwa tebulo lopangidwa likuwonetsedwa. Zimangotsimikizira izi, ndipo zosefera mu mawu amphamvu zimangoyatsidwa zokha.

zinai

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".

zisanu

• Pambuyo poyambitsa mndandandawo uziwoneka motere:

6.

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".

7.

• 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.

zisanu ndi zitatu

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

1. Choyamba, timapeza fayilo yopulumutsidwa ndi tebulo pakompyuta yanu ndikudina LKM tsegulani. Pa pepala ndi tebulo, mutha kuwona kuti Fyuluta ili munthawi yogwira mtengo.

zisanu ndi zinai

1. Dinani pa lipenga.
2. 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".
3. 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.

10

Kuchotsa zosefera kuchokera pa pepala lonse

Nthawi zina zochitika zimachitika pakafunika kuchotsa zosefera patebulo lonse. Kuti muchite izi, muyenera kuchita zotsatirazi:

1. Tsegulani fayilo ndi deta yosungidwa bwino.
2. Pezani mzere umodzi kapena zingapo pomwe fyuluta imayambitsidwa. Pankhaniyi, iyi ndi gawo la "Dzinalo".

khumi chimodzi

1. Dinani pamalo aliwonse mu tebulo kapena kuwunikira kwathunthu.
2. Pamwamba, pezani "deta" ndikuyambitsa LKM yawo.

12

1. 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.
2. 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.