Pakati pa ntchito zosiyanasiyana za Microsoft Excel, ntchito yodzitetezera iyenera kudziwika kwambiri. Zimathandiza kuthetsa deta yosafunikira, ndipo zimangokhala zokha zomwe wogwiritsa ntchito panopa akufunikira. Tiyeni tizimvetsetsa zochitika za maofesi ndi maofesi a Microsoft Excel.
Thandizani fyuluta
Kuti mugwire ntchito ndi zojambulazo, choyamba, muyenera kuwonetsa fyuluta. Izi zikhoza kuchitika m'njira ziwiri. Dinani pa selo iliyonse patebulo limene mukufuna kugwiritsa ntchito fyuluta. Kenaka, pokhala pakhomo la Pakhomo, dinani Pangani ndi Fuluta batani, yomwe ili mu Toolbar yolemba pa Ribbon. Mu menyu yomwe imatsegula, sankhani "Fyuluta".
Kuti muwathandize fyuluta mwanjira yachiwiri, pitani ku tabu ya "Deta". Ndiye, monga momwe zinaliri poyamba, muyenera kujambula pa imodzi mwa maselo omwe ali patebulo. Pamapeto omaliza, muyenera kodinkhani pa batani la "Fyuluta" lomwe liri mu bokosi la zida za "Kukonza ndi Kuwonetsa."
Mukamagwiritsa ntchito njira iliyonseyi, kusefera kudzathetsedwa. Izi zidzasonyezedwe ndi maonekedwe a mafano mu selo iliyonse ya tebulo yomwe ikuyendetserako, monga mawonekedwe okhala ndi mivi yolembedwa mmenemo, akulozera pansi.
Gwiritsani fyuluta
Kuti mugwiritse ntchito fyuluta, ingodinani pa chithunzicho m'ndandanda, mtengo umene mukufuna kufufuza. Pambuyo pake, mndandanda imatsegula kumene mungathe kusinthitsa zomwe timayenera kuzibisa.
Zitatha izi, dinani pakani "OK".
Monga momwe mukuonera, mizere yonse ndi mfundo zomwe tinachotsa zizindikiro za cheke zikuchoka patebulo.
Kukonzekera kwa Autofilter
Kuti muyambe kusungira galimoto, mukadali mndandanda womwewo, pitani ku chinthu "Zojambula Zakale", "Zosefera za Numeri", kapena "Zisudzo ndi Tsiku" (malingana ndi mawonekedwe a selo la chigawo), ndiyeno ndi mawu "Fyuluta yosintha ..." .
Pambuyo pake, wogwiritsa ntchito autofilter akutsegula.
Monga mukuonera, mu autofilter wogwiritsa ntchito mukhoza kufotokozera deta mu chingwe kamodzi ndi mfundo ziwiri. Koma, ngati mu fyuluta yeniyeni kusankhidwa kwa zikhulupiliro mukhola kungatheke pokhapokha kuthetsa zofunikira zosafunika, ndiye mutha kugwiritsa ntchito zida zonse zowonjezera. Pogwiritsa ntchito zojambulajambula zamtundu, mungasankhe mfundo ziwiri zilizonse m'kabukulo, ndikugwiritsa ntchito magawo otsatirawa:
- Ofanana;
- Osati ofanana;
- Zambiri;
- Zochepa
- Wamkulu kapena wofanana;
- Zochepa kapena zofanana;
- Yambani ndi;
- Sichiyamba ndi;
- Kutsirizika;
- Silikumaliza;
- Zili ndi;
- Alibe.
Pankhaniyi, tikhoza kusankha kugwiritsa ntchito miyeso iwiri ya deta mu maselo a pa nthawi imodzi, kapena imodzi yokha. Kusankha kwa njira kungatheke pogwiritsa ntchito "ndi / kapena" kusinthana.
Mwachitsanzo, m'ndandanda pa malipiro, timagwiritsa ntchito wopanga maulendo pa mtengo woyamba "wamkulu kuposa 10,000", ndipo wachiwiri "wamkulu kapena wofanana ndi 12821", ndi njira "ndi" yothandizira.
Pambuyo powonjezera batani "OK", mzere womwe uli waukulu kapena wofanana ndi 12821 mu maselo muzitsulo "Zowonjezera" zidzakhalabe patebulo, chifukwa zonsezi ziyenera kukumana.
Ikani chizindikiro mu "kapena" mawonekedwe, ndipo dinani "Bwino".
Monga momwe mukuonera, pakali pano, mizere yomwe ikufanana ndi imodzi mwazimene zimagwera mu zotsatira zowoneka. Mu tebuloyi tidzakhala ndi mizera yonse, mtengo wa ndalama zomwe zimaposa 10,000.
Pogwiritsa ntchito chitsanzo, tapeza kuti autofilter ndi chida chothandizira kusankha deta kuchokera kuzinthu zosafunikira. Mothandizidwa ndi fyuluta yodzisinthika, fyuluta ikhoza kuchitidwa pa chiwerengero chachikulu cha magawo kusiyana ndi muyezo woyenera.
