Kuti zitheke kugwirako ntchito ndi magulu ambiri amtundu m'magawo, ayenera kulamulidwa nthawi zonse malinga ndi mtundu wina. Kuphatikiza apo, pazolinga zapadera, nthawi zina makonzedwe athunthu a data safunika, koma mizere yokhayo. Chifukwa chake, kuti tisasokonezedwe pazambiri, yankho lanzeru ndikuwongolera izi, ndikuzisefa pazotsatira zina. Tiyeni tiwone momwe deta imasanjidwira ndikusefa mu Microsoft Excel.
Kusintha kosavuta kwa deta
Kukonza ndi imodzi mwa zida zosavuta kwambiri mukamagwira ntchito ku Microsoft Excel. Pogwiritsa ntchito, mutha kukonza mizere ya tebuloyo motsatira zilembo za afabeti, kutengera ndendende zomwe zili m'maseramu.
Kusanja deta mu Microsoft Excel kumatha kuchitika pogwiritsa ntchito batani la "Sort and Filter", lomwe limapezeka "Tab" patsekati mu "zida" za "Kusintha". Koma, choyamba, tifunika kudina foni iliyonse yomwe tikhala.
Mwachitsanzo, patebulo lomwe lili pansipa, muyenera kusanja antchito zilembo. Timalowa mu khungu lililonse "Zina", ndikudina "Sinthani ndi Zosefera". Kuti musankhe mayina zilembo, kuchokera mndandanda womwe umawonekera, sankhani "Sintha kuchokera A mpaka Z".
Monga mukuwonera, deta yonse yomwe ili patebulopo imayikidwa, malinga ndi mndandanda wazilembo za mayina.
Kuti muthe kusanja machitidwe, mumenyu omwewo, sankhani batani kuchokera Z mpaka A. "
Mndandandawu udakonzedweranso munjira yosinthira.
Tiyenera kudziwa kuti mtundu wamtunduwu umangowonetsedwa ndi mtundu wa zolemba. Mwachitsanzo, pamasanjidwe, manambala amasankhidwa kuti "Kuyambira zochepa mpaka pamlingo waukulu" (komanso mosemphanitsa), komanso mawonekedwe amtunduwo, "Kuyambira wakale mpaka watsopano" (komanso mosemphanitsa).
Makonda anu
Koma, monga mukuwonera, ndi mitundu yosiyanasiyana yosankhidwa ndi mtengo umodzi, deta yomwe ili ndi mayina amunthu yemweyo imakonzedwa m'njira zosiyanasiyana.
Koma bwanji ngati tikufuna kusankha mayina zilembo, koma mwachitsanzo, ngati dzinalo likugwirizana, onetsetsani kuti zomwe zakonzedwazo zidakonzedwa ndi tsiku? Kuti tichite izi, komanso kugwiritsa ntchito zina, zomwe zili mumndandanda womwewo wa "Sort and Filter", tikuyenera kupita ku "Kusintha Kwa Makonda ...".
Pambuyo pake, zenera la makonzedwe amatsegulidwa. Ngati tebulo lanu lili ndi mitu, chonde dziwani kuti pazenera ili pazenera kukhala ndi cheke pafupi ndi njira "Zowerengera zanga zili ndi mutu".
M'munda wa "Column", onetsani dzina la chipilalachi momwe mtunduwo ungapangidwire. M'malo mwathu, iyi ndi "Zina" mzati. Gawo la "Sort" likuwonetsa mtundu wanji wazomwe zidzasankhidwa. Pali njira zinayi:
- Makhalidwe;
- Mtundu wama cell;
- Mtundu wamafuta;
- Chizindikiro cha foni.
Koma, pazambiri zazikuluzikulu, chinthu "Makhalidwe" chimagwiritsidwa ntchito. Amakonzedwa mwachisawawa. M'malo mwathu, tigwiritsa ntchito chinthu ichi.
Mu gawo la "Order" tikuyenera kuwonetsa momwe dongosololi lidzayendetsedwere motere: "Kuyambira A mpaka Z" kapena mosinthanitsa. Sankhani mtengo "Kuchokera A mpaka Z".
Chifukwa chake, tinakhazikitsa kusanja ndi imodzi mwazolowera. Pofuna kukhazikitsa mtundu wina, dinani batani la "Add Level".
Gawo lina la magawo akuwonekera, omwe ayenera kudzazidwa kale kuti agwirizane ndi mzati wina. M'malo mwathu, lolemba "Tsiku". Popeza mtundu wa masanjidwewo wakhazikitsidwa mu maselo amenewa, m'munda wa "Order" timayika zofunikira osati "Kuyambira A mpaka Z", koma "Kuyambira wakale mpaka watsopano", kapena "Kuyambira watsopano mpaka wakale".
Momwemonso, pawindo ili mutha kukhazikitsa, ngati kuli kotheka, ndikusintha ndi mizati inanso kuti mufike poyambira. Zosintha zonse zikamalizidwa, dinani batani "Chabwino".
Monga mukuwonera, tsopano patebulo lathu deta yonse imasankhidwa, choyambirira, ndi mayina antchito, kenako, masiku olipira.
Koma, izi sizotheka kutengera mtundu mwathunthu. Ngati mungafune, pazenera ili mutha kukhazikitsa kusintha osati ndi mizati, koma mizere. Kuti muchite izi, dinani batani la "Zosankha".
Pa zosankha zosankha zomwe zimatseguka, sinthani kusintha kwa "Range Lines" malo "Range Columns". Dinani pa "Chabwino" batani.
Tsopano, mwakufanizira ndi chitsanzo chapitacho, mutha kuyika deta yosankha. Lowetsani deta, ndikudina batani "Chabwino".
Monga mukuwonera, zitatha izi, mizati imasinthidwa malinga ndi zigawo zomwe zalowetsedwa.
Zachidziwikire, kwa tebulo lathu, chotengedwa mwachitsanzo, kugwiritsa ntchito posintha ndikusintha komwe kuli mzati sikothandiza kwenikweni, koma kwa matebulo ena mtundu uwu ukakhala woyenera kwambiri.
Zosefera
Kuphatikiza apo, Microsoft Excel ili ndi ntchito yosefera deta. Zimakupatsani mwayi wosiya zowoneka zokha zomwe mumawona kuti ndizofunikira, ndikubisa zina zonse. Ngati ndizofunikira, zosungidwa zobisika nthawi zonse zimatha kubwezeretsedwanso m'njira zowonekera.
Kuti mugwiritse ntchito ntchitoyi, timayima pa khungu lililonse pagome (ndipo makamaka pamutu), ndikudina batani "Sinthani ndi Zosefera" mu "zida" zosintha. Koma, nthawi ino, sankhani "Zosefera" mumenyu omwe akuwoneka. Mutha kuthanso m'malo mwa izi mungodinikiza kophatikiza Ctrl + Shift + L.
Monga mukuwonera, m'maselo omwe ali ndi mayina a zipilala zonse, chithunzi chidawoneka ngati lalikulu, pomwe cholembedwa chitatu chakutsogolo chidalembedwa.
Timadulira chithunzichi m'ndime yomwe tisefa. M'malo mwathu, tinaganiza zosefera mayina. Mwachitsanzo, tiyenera kusiya zidziwitso zokha kwa wogwira Nikolaev. Chifukwa chake, sanadziwe mayina a antchito ena onse.
Ndondomekoyo ikamaliza, dinani batani "Chabwino".
Monga mukuwonera, mizere yokha yokhala ndi dzina la wantchito Nikolaev idatsala patebulopo.
Tiyeni tigwirizane ntchitoyo, ndikusiya patebulo chokhacho chomwe chimakhudzana ndi Nikolaev wa kotala ya III ya 2016. Kuti muchite izi, dinani pazizindikiro mu "Tsiku" la cell. Pa mndandanda womwe umatsegulira, tsembani miyezi "Meyi", "June" ndi "Okutobala", popeza sakhala gawo lachitatu, ndikudina "batani".
Monga mukuwonera, ndi data yokhayo yomwe tikufuna yatsala.
Kuti muchotse zojambulazo ndi gawo linalake ndikuwonetsa chidziwitso chobisikanso, dinani pazithunzi zomwe zili m'chipindacho ndi mutu wa chipilalachi. Pazosankha zomwe zimatsegulira, dinani chinthu "Chotsani fyuluta kuchokera ...".
Ngati mukufuna kubwezeretsa fyuluta yonse malinga ndi tebulo, muyenera dinani batani la "Sinthani ndi zosefera" pa riboni ndikusankha "Chotsani".
Ngati mukufunikira kuchotsa chosefera chonse, ndiye kuti, monga momwe mumayendetsa, mumenyu womwewo muyenera kusankha chinthu "Fyuluta", kapena lembani njira yochezera ya Ctrl + Shift + L.
Kuphatikiza apo, ziyenera kudziwidwa kuti titayang'ana ntchito ya "Zosefera", mukadina pazithunzi zofananira muma cell a matebulo, ntchito zomwe takambirana pamwambapa zimapezeka mumndandanda womwe umawonekera: "Kutula kuchokera ku A kupita ku Z" , Sinthani kuchokera ku Z kupita ku A, ndipo Sinthani ndi Mtundu.
Phunziro: Momwe mungagwiritsire ntchito autofilter mu Microsoft Excel
Smart tebulo
Kutula ndi kusefa kumathandizanso kutsegula ndikusintha gawo la data lomwe mukugwira nawo kuti likhale tebulo lotchedwa anzeru.
Pali njira ziwiri zopangira tebulo labwino. Kuti mugwiritse ntchito oyamba a iwo, sankhani dera lonse la tebulo, ndipo, kukhala "Home" tabu, dinani batani "riboni ngati" Tafulo ngati tebulo ". Izi batani ili mu "Zida" chipika.
Kenako, sankhani chimodzi mwazithunzi zomwe mumakonda patsamba lomwe limatseguka. Kusankha sikungakhudze magwiridwe antchito a tebulo.
Pambuyo pake, bokosi la zokambirana limatsegulamo momwe mungasinthire magwirizano a tebulo. Koma, ngati mwasankhiratu malowo molondola, ndiye kuti palibe chomwe chingachitike. Chachikulu ndichakuti muwone kuti pali cheke pafupi ndi "Tebulo la mutu". Chotsatira, dinani batani "Chabwino".
Ngati mukuganiza kugwiritsa ntchito njira yachiwiri, ndiye kuti muyenera kusankha gawo lonse la tebulo, koma nthawi ino pitani ku "Insert" tabu. Kuchokera apa, pa riboni mu Tableboxbox, dinani batani la Tebulo.
Pambuyo pake, monga nthawi yotsiriza, zenera limatseguka pomwe mungathe kusintha magwirizano a tebulo. Dinani pa "Chabwino" batani.
Osatengera momwe mumagwiritsira ntchito popanga "tebulo labwino", mupanga ndi tebulo lomwe limakhala m'mipanda ya mutu womwe zithunzi zosefera zomwe zafotokozedwazi ziziikidwa kale.
Mukadina chizindikiro ichi, ntchito zofananira zonse zizipezeka mukayamba zosefera mwa njira yonse kudzera mu "Sinthani ndi kusefa".
Phunziro: Momwe mungapangire tebulo mu Microsoft Excel
Monga mukuwonera, zida zosanja ndikusintha, ngati zikugwiritsidwa ntchito moyenera, zimathandizira kuti owerenga azigwira ntchito ndi matebulo. Nkhani yakugwiritsa ntchito kwawo imakhala yofunika makamaka ngati gulu lalikulu kwambiri lajambulidwa patebulopo.
