Zosefera zapamwamba mu Excel. Momwe mungagwiritsire ntchito, momwe mungaletsere kusefa kwapamwamba

Pulogalamu ya Excel ili ndi ntchito zambiri. Kusefa zidziwitso ndi ntchito wamba ya spreadsheet. Ogwiritsa ntchito ambiri amagwiritsa ntchito kusefa pamene akugwira ntchito ndi deta yambiri, koma si aliyense amene amadziwa kuti pali fyuluta yapamwamba yomwe imawonjezera zatsopano. Kuchokera m'nkhaniyi, mupeza zonse zosefera zapamwamba ndikuphunzira momwe mungagwiritsire ntchito izi.

Kodi kusefa kwa data mu Excel ndi chiyani

Kusefa kwa data ndi chinthu chothandiza chomwe chimakupatsani mwayi wosankha zidziwitso malinga ndi zomwe zatchulidwa, ndikubisa mizere yosafunika.

Kugwiritsa Ntchito Zosefera Zapamwamba mu Excel

Tiyerekeze kuti tili ndi tebulo lomwe lili ndi chidziwitso chomwe chiyenera kusefedwa.

Malangizo atsatanetsatane amawoneka motere:

1. Poyambirira, timapanga tebulo lowonjezera la 2, lomwe lidzakhala ndi zosefera. Timajambula mutu wa tebulo loyamba ndikuchiyika chachiwiri. Kuti timvetse bwino chitsanzocho, tiyeni tiyike mbale yothandizira pamwamba pang'ono kuposa yoyambayo. Kuwonjezera apo, lembani chatsopanocho ndi mthunzi wosiyana. Ndikoyenera kudziwa kuti tebulo lachiwiri likhoza kuikidwa paliponse osati pa pepala lothandizira, koma pa bukhu lonse.

2. Pa gawo lotsatira, tidzadzaza mbale yowonjezera ndi chidziwitso chofunikira pa ntchito ina. Timafunikira zizindikiritso kuchokera pagawo loyambira, zomwe tidzasefa zambiri. Muchitsanzochi, tikuyenera kusefa potengera jenda la akazi komanso masewera monga tennis.

3. Pambuyo podzaza mbale yowonjezera, timapita ku sitepe yotsatira. Timaloza cholozera cha mbewa pa selo iliyonse ya gwero kapena matebulo owonjezera. Pamwamba pa mawonekedwe a spreadsheet editor, timapeza gawo la "Data" ndikudina ndi LMB. Timapeza chipika cha malamulo otchedwa "Zosefera" ndikusankha chinthu cha "Advanced".

4. Zenera laling'ono lapadera linawonekera pazenera, lotchedwa "Advanced Filter". Apa mutha kupanga zokonda zosiyanasiyana zosefera zapamwamba.

5. Chida ichi chili ndi ntchito ziwiri. Njira yoyamba ndi "Koperani zotsatira kumalo ena" ndipo njira yachiwiri ndi "Sefa mndandanda m'malo". Izi zimagwiritsa ntchito zotulutsa zosiyanasiyana za data yosefedwa. Kusintha koyamba kumawonetsa zomwe zidasefedwa pamalo ena m'buku, zomwe zidafotokozedweratu ndi wogwiritsa ntchito. Kusintha kwachiwiri kumawonetsa zomwe zasefedwa mu mbale yayikulu. Timasankha chinthu chofunikira. Muchitsanzo chathu chenicheni, timayika cholembera pafupi ndi mawu akuti "Seferani mndandanda m'malo." Tiyeni tipitirire ku sitepe yotsatira.

6. Mu mzere "List range" muyenera kulowa adilesi ya mbale pamodzi ndi mitu. Pali njira ziwiri zogwiritsira ntchito njirayi yosavuta. Njira yoyamba ndiyo kulemba makonzedwe a mbale pogwiritsa ntchito kiyibodi. Chachiwiri - mutatha kuwonekera pazithunzi pafupi ndi mzere kuti mulowe mumtundu, muyenera kusankha mbaleyo pogwira batani lakumanzere. Mu mzere "Kusiyanasiyana kwa zinthu" mofananamo, timayendetsa mu adiresi ya mbale yowonjezera pamodzi ndi mitu ndi mizere yokhala ndi zikhalidwe. Dinani pa "Chabwino" kutsimikizira zosintha zomwe zachitika.

Zofunika! Posankha, samalani kuti musaphatikizepo maselo opanda kanthu m'dera lomwe mwasankha. Ngati selo lopanda kanthu ligwera m'malo osankhidwa, ndiye kuti kusefa sikudzachitidwa. Pachitika cholakwika.

7. Mukamaliza ndondomekoyi, chidziwitso chokha chomwe tikufunikira chidzatsalira mu mbale yaikulu.

8. Tiyeni tibwerere mmbuyo masitepe angapo. Ngati wogwiritsa ntchito asankha njira ya "Koperani zotsatira kumalo ena", ndiye kuti chizindikiro chomaliza chidzawonetsedwa pamalo omwe atchulidwa ndi iye, ndipo mbale yaikulu sidzasintha mwanjira iliyonse. Mumzere "Malo opangira malo" muyenera kuyendetsa ku adilesi ya malo omwe zotsatira zake zidzawonetsedwa. Apa mutha kulowa gawo limodzi, lomwe pamapeto pake lidzakhala chiyambi cha mbale yowonjezera yatsopano. Muchitsanzo chathu, iyi ndi cell yokhala ndi adilesi A42.

9. Mwa kuwonekera pa "Chabwino", mbale yowonjezera yatsopano yokhala ndi zosefera zomwe zafotokozedwa idzayikidwa mu selo A42 ndikutambasulidwa kudera loyandikana nalo.

Letsani kusefa kwapamwamba mu Excel

Pali njira ziwiri zoletsera kusefa kwapamwamba. Tiyeni tione njira iliyonse mwatsatanetsatane. Njira yoyamba yochotsera kusefa kwapamwamba:

1. Timapita ku gawo lotchedwa "Home".
2. Timapeza chipika cha malamulo "Sefa".
3. Dinani pa "Chotsani" batani.

Njira yachiwiri, yomwe imaletsa kusefa kwapamwamba:

1. Timapita ku gawo lotchedwa "Home".
2. Dinani batani lakumanzere la mbewa pa chinthu "Editing"
3. Pa gawo lotsatira, timatsegula mndandanda waung'ono wa "Sort and Filter".
4. Pazosankha zomwe zikuwonekera, dinani LMB pachinthu chotchedwa "Chotsani".

Zofunika! Ngati chizindikiro chowonjezera chokhala ndi zosefera zapamwamba chili pamalo atsopano, ndiye kuti njira yomwe yakhazikitsidwa kudzera mu "Clean" sichingathandize. Zosintha zonse ziyenera kuchitidwa pamanja.

Kutsiliza ndi ziganizo za njira zosefera zapamwamba

M'nkhaniyi, tawona m'magawo njira zingapo zogwiritsira ntchito fyuluta yazidziwitso zapamwamba mu Excel spreadsheet editor. Kuti mugwiritse ntchito njira yosavutayi, mbale yowonjezera yatsopano yokha ndiyofunika, momwe zosefera zidzakhalapo. Inde, njirayi ndi yovuta kwambiri kugwiritsa ntchito kusiyana ndi kusefa wamba, koma imagwiritsa ntchito kusefa munthawi imodzi pazifukwa zingapo. Njirayi imakulolani kuti mugwiritse ntchito mofulumira komanso moyenera ndi zambiri za tabular.