Momwe mungachotsere fyuluta mu Excel

Kusefa deta mu Excel ndikofunikira kuti zikhale zosavuta kugwira ntchito ndi matebulo ndi zidziwitso zambiri. Chifukwa chake, mwachitsanzo, gawo lalikulu likhoza kubisika kwa wogwiritsa ntchito, ndipo fyuluta ikatsegulidwa, wonetsani zomwe zikufunika pakadali pano. Nthawi zina, pamene tebulo linalengedwa molakwika, kapena chifukwa cha kusadziwa kwa wogwiritsa ntchito, zimakhala zofunikira kuchotsa fyuluta muzitsulo zamtundu uliwonse kapena papepala. Momwe izi zimachitikira ndendende, tidzasanthula m'nkhaniyi.

Zitsanzo za kupanga matebulo

Musanayambe kuchotsa fyuluta, choyamba ganizirani zomwe mungachite kuti mulowetse mu Excel spreadsheet:

• Kulowetsa kwapamanja. Lembani mizere ndi mizati ndi mfundo zofunika. Pambuyo pake, tikuwunikira maadiresi a malo a tebulo, kuphatikizapo mitu. Pitani ku tabu "Data" pamwamba pa zida. Timapeza "Zosefera" (zikuwonetsedwa ngati funnel) ndikudina ndi LMB. Sefa yomwe ili pamitu yapamwamba iyenera kutsegulidwa.

• Kutsegula kwachangu kwa kusefa. Pankhaniyi, tebulo limadzazidwanso, kenako mu "Styles" tabu timapeza kutsegulira kwa mzere wa "Sefa ngati tebulo". Payenera kukhala zosefera zokha m'mitu yaing'ono ya tebulo.

Chachiwiri, muyenera kupita ku tabu "Ikani" ndikupeza chida cha "Table", dinani ndi LMB ndikusankha "Table" pazotsatira zitatu zotsatirazi.

Pazenera lotsatira la mawonekedwe lomwe limatsegulidwa, mayankhulidwe a tebulo lopangidwa adzawonetsedwa. Zimangotsala kuti zitsimikizire, ndipo zosefera pamitu yaing'ono ziziyatsa zokha.

Malangizo a akatswiri! Musanasunge tebulo lomalizidwa, onetsetsani kuti deta yalowetsedwa bwino komanso kuti zosefera zayatsidwa.

Zitsanzo zogwirira ntchito ndi fyuluta mu Excel

Tiyeni tisiye kuti tiganizire za tebulo lachitsanzo lomwe linapangidwa kale pamizati itatu.

• Sankhani ndime yomwe mukufuna kusintha. Mwa kuwonekera pa muvi mu selo pamwamba, mukhoza kuona mndandanda. Kuti muchotse chimodzi mwazinthu kapena mayina, sankhani bokosi lomwe lili pafupi nalo.
• Mwachitsanzo, timangofunika zamasamba zokha kuti zikhale patebulo. Pawindo lomwe limatsegula, sankhani bokosi la "zipatso", ndikusiya masamba akugwira ntchito. Vomerezani podina batani "Chabwino".

• Pambuyo poyambitsa, mndandandawo udzawoneka motere:

Taonani chitsanzo china cha momwe fyuluta imagwirira ntchito:

• Gomelo lagawidwa m'mizati itatu, ndipo yomaliza imakhala ndi mitengo yamtundu uliwonse wazinthu. Iyenera kukonzedwa. Tinene kuti tiyenera kusefa zinthu zomwe mtengo wake ndi wotsika kuposa mtengo "45".
• Dinani pa chithunzi cha fyuluta mu selo losankhidwa. Popeza kuti gawoli ladzaza ndi manambala, mutha kuwona pawindo kuti mzere wa "Numeric filters" ukugwira ntchito.
• Pozungulira pamwamba pake, timatsegula tabu yatsopano yokhala ndi zosankha zosiyanasiyana zosefera tebulo la digito. Mmenemo, sankhani mtengo "zochepa".

• Kenako, lowetsani nambala "45" kapena sankhani potsegula mndandanda wa manambala muzosefera zomwe mwamakonda.

Chenjerani! Kulowetsa mfundo "zosakwana 45", muyenera kumvetsetsa kuti mitengo yonse yomwe ili pansi pa chithunzichi idzabisika ndi fyuluta, kuphatikizapo mtengo "45".

Komanso, mothandizidwa ndi ntchitoyi, mitengo imasefedwa mumtundu wina wa digito. Kuti muchite izi, muzosefera zachizolowezi, muyenera kuyambitsa batani la "OR". Kenako ikani mtengo "wochepa" pamwamba, ndi "chachikulu" pansi. M'mizere ya mawonekedwe kumanja, magawo ofunikira a mtengo wamtengo wapatali amaikidwa, omwe ayenera kutsalira. Mwachitsanzo, zosakwana 30 ndi zoposa 45. Zotsatira zake, tebulo lidzasunga manambala 25 ndi 150.

Kuthekera kwa kusefa zidziwitso ndizambiri. Kuphatikiza pa zitsanzo zomwe zili pamwambazi, mukhoza kusintha deta ndi mtundu wa maselo, ndi zilembo zoyambirira za mayina ndi zina. Tsopano popeza tadziwana bwino ndi njira zopangira zosefera ndi mfundo zogwirira ntchito nawo, tiyeni tipitirire ku njira zochotsera.

Kuchotsa zosefera

1. Choyamba, timapeza fayilo yosungidwa yomwe ili ndi tebulo pakompyuta yathu ndikudina kawiri LMB kuti mutsegule mu Excel application. Patsamba lomwe lili ndi tebulo, mutha kuwona kuti zosefera zili m'gawo la "Mitengo".

Malangizo a akatswiri! Kuti musavutike kupeza fayilo pakompyuta yanu, gwiritsani ntchito zenera la "Sakani", lomwe lili mu "Start" menyu. Lowetsani dzina la fayilo ndikusindikiza batani la "Enter" pa kiyibodi ya kompyuta.

2. Dinani pa chizindikiro cha pansi.
3. M'bokosi la zokambirana lomwe limatsegulidwa, mutha kuwona kuti cholembera chomwe chili moyang'anizana ndi nambala "25" sichimachotsedwa. Ngati sefa yogwira idachotsedwa pamalo amodzi okha, ndiye njira yosavuta ndiyo kubwezeretsanso bokosi ndikudina batani la "Chabwino".
4. Apo ayi, fyuluta iyenera kuzimitsidwa. Kuti muchite izi, pawindo lomwelo, muyenera kupeza mzere "Chotsani fyuluta pagawo "..." ndikudina ndi LMB. Kuzimitsa kokha kudzachitika, ndipo zonse zomwe zidalowetsedwa kale zidzawonetsedwa kwathunthu.

Kuchotsa zosefera patsamba lonse

Nthawi zina zinthu zitha kuchitika pakafunika kuchotsa zosefera patebulo lonse. Kuti muchite izi, muyenera kuchita zotsatirazi:

1. Tsegulani fayilo ya data yosungidwa mu Excel.
2. Pezani mizati imodzi kapena zingapo pomwe zosefera zimayatsidwa. Pankhaniyi, ndi Names column.

3. Dinani pamalo aliwonse patebulo kapena sankhani kwathunthu.
4. Pamwamba, pezani "Data" ndikuyiyambitsa ndi LMB.

5. Pezani "Zosefera". Motsutsana ndi ndimeyi pali zizindikiro zitatu mu mawonekedwe a faneli yokhala ndi mitundu yosiyanasiyana. Dinani pa batani la ntchito "Chotsani" ndi funnel yomwe ikuwonetsedwa ndi crosshair yofiira.
6. Kenako, zosefera zomwe zikugwira zidzayimitsidwa patebulo lonse.

Kutsiliza

Zosefera patebulo zimapangitsa kugwira ntchito ku Excel kukhala kosavuta, koma, mwatsoka, munthu amakonda kulakwitsa. Pankhaniyi, pulogalamu ya multifunctional Excel imathandizira, zomwe zingathandize kukonza deta ndikuchotsa zosefera zosafunikira zomwe zidalowetsedwa kale ndikusunga zoyambira. Izi ndizothandiza makamaka podzaza matebulo akuluakulu.