Kuti muthe kugwira ntchito ndi matebulo akuluakulu a data, amakhala ofunikira kupanga molingana ndi chitsimikizo. Kuphatikiza apo, kukwaniritsa zolinga zenizeni, nthawi zina kuchuluka kwa data sikofunikira, koma mzere umodzi wokha. Chifukwa chake, kuti musasokonezedwe mu chidziwitso chachikulu, yankho labwino lidzakonzedwa, ndi zosefera ku zotsatira zina. Tiyeni tiwone momwe kupangira ndi kusefa deta ku Microsoft Excel kumachitika.
Kusanja kwa data
Kusanja ndi imodzi mwazida zosavuta kwambiri pogwira ntchito ku Microsoft Excel. Kugwiritsa ntchito, mutha kuyimilira mizere ya tebulo molingana ndi deta yomwe ili mumitundu yolumikizira.
Kusintha kwa deta mu pulogalamu ya Microsoft excorvel kumatha kuchitika pogwiritsa ntchito batani la "mtundu ndi sefa", yomwe yaikidwa mu tabu yakunyumba pa tepi yazida. Koma, m'mbuyomu, tiyenera kudina khungu lililonse lomwe tichita kukonza.
Mwachitsanzo, patebulo ikuloseredwa pansipa, ndikofunikira kukonza antchito ndi zilembo. Timakhala mu khungu lililonse la "Dzinalo", ndikudina pa batani la "Mtundu ndi sefa". Kotero kuti mayina amakonzedwa ndi zilembo, sankhani chinthucho "chotsani kuchokera ku Z" pamndandanda.
Monga mukuwonera, zonse zomwe zili patebulo zilipo, malinga ndi mndandanda wa zilembo za Surnames.
Pofuna kusintha njira yosinthira, mumenyu yomweyo, sankhani batani la Score kuchokera ku I mpaka ".
Mndandandawo umamangidwanso mu dongosolo losintha.
Tiyenera kudziwa kuti mtundu womwewo wa mtundu womwe umawonetsedwa kokha ndi mawonekedwe a data. Mwachitsanzo, ndi mtundu wa manambala, kukonza "kuchokera kochepa mpaka kupitirira" (ndipo, m'malo mwake), ndipo mtundu wake ndi "kuchokera kwa zaka zatsopano" (ndipo, m'malo mwake).
Kusintha Kwachitukuko
Koma, monga tikuwona, ndi mitundu yotchulidwa yosintha ndi mtengo umodzi, zomwe zili ndi mayina a munthu yemweyo amangidwa mkati mwa mtunduwo munthawi yotsutsana.
Ndipo choti ndichite ngati tikufuna kulembera mayina molingana ndi zilembo, koma, mukafananitsa dzina kuti detaliyo ili ndi tsiku? Chifukwa cha izi, komanso kugwiritsa ntchito zinthu zina, chilichonse chomwe chili mu menyu "mtundu ndi zosefera", tiyenera kupita ku chinthucho "kukonza zosinthika ...".
Pambuyo pake, zenera lokhazikika limatseguka. Ngati pali mitu yanu pagome lanu, chonde dziwani kuti pazenera ili ndikofunikira kuyimilira chizindikiro cha cheke pafupi ndi "zambiri zanga zimakhala ndi" gawo.
Mu "munda", tchulani dzina la mzere womwe kukonza kudzachitidwa. Kwa ife, iyi ndiye "dzina" mzere. Mu "mtundu", zafotokozedwa molingana ndi zomwe zomwe zingapangitsidwe. Pali zosankha zinayi:
- Mfundo;
- Mtundu wa maselo;
- Utoto;
- Chizindikiro cha m'manja.
Koma, ambiri ambiri, chinthucho "chimagwiritsidwa ntchito. Amakhazikitsidwa mosasunthika. Tikatero, tidzagwiritsanso ntchito chinthu ichi.
M'munsi "Order" Tiyenera kunena, momwe data idzapezeke: "kuchokera ku Z" kapena mosemphanitsa. Sankhani mtengo "kuchokera ku a mpaka z."
Chifukwa chake, tidakhazikitsa cholembera chimodzi mwa mizamu. Pofuna kukonzanso nyumba ina, dinani pa batani la "Onjezani".
Minda ina imawonekera, yomwe iyenera kudzaza njira ina. M'malo mwathu, malingana ndi gawo la "Tsiku". Kuyambira tsiku la m'maselo lino lakhazikitsidwa, ndiye kuti gawo la "Lolani" lomwe timapereka zimbudzi zopanda "kuchokera ku Z", koma "Kuyambira Zakale", kapena "Kuchokera kwa Chatsopano" .
Momwemonso, pawindo ili mutha kusintha, ngati pangafunike kutengera mizati ina molingana ndi cholinga. Zikhazikiko zonse zikapangidwa, dinani batani la "OK".
Monga mukuwonera, tsopano pagome lathu la data zonse za data zonse za deta zonse za deta zonse za deta zonse, zolembedwa ndi anthu ogwira ntchito, kenako, polipira.
Koma, izi sizotheka konse pakusintha mwambo. Ngati mukufuna, pawindo ili, mutha kulinganiza kusanja kosakhala ndi mizamu, koma ndi mizere. Kuti muchite izi, dinani pa batani la "magawo".
Mu gawo losintha magawo omwe amatsegulira, timamasulira kusinthaku kuchokera ku "mzere mzere" kupita ku "Gent Codens". Dinani pa batani la "OK".
Tsopano, mwa fanizo ndi chitsanzo cha Chakale, mutha kudziwa zambiri chifukwa chosintha. Lowetsani deta, ndikudina batani la "OK".
Monga tikuwonera, zitachitika izi, mizata idasinthira malo, malingana ndi magawo omwe adalowa.
Zachidziwikire, patebulo lathu, yogwiritsitsa mwachitsanzo, kugwiritsa ntchito kusintha kwa kusintha komwe kumachitika komwe kumapezeka pamtunduwu sikugwira ntchito mwapadera, koma kwa matebulo ena amtunduwu omwe angakhale othandiza kwambiri.
Sefa
Kuphatikiza apo, mu Microsoft Excel, pali ntchito ya data ya data. Zimakupatsani mwayi woti muone zomwe mumawona kuti ndizofunikira, komanso chikopa chonsecho. Ngati ndi kotheka, deta yobisika imatha kubwezeredwa nthawi zonse.
Kuti tigwiritse ntchito gawo ili, timakhala pa tele iliyonse patebulo (ndipo makamaka mumutu), tinso dinani batani la "mtundu ndi sfat" mu bokosi lamagetsi. Koma, nthawi ino mumenyu yomwe imawoneka, sankhani "Fyuluta". Muthanso m'malo mwa zomwe mwachita izi zimangosindikiza CTRL + Shift + L Chofunika.
Monga tikuonera, maselo mu mawonekedwe a lalikulu adawonekera m'maselo omwe ali ndi dzina la mizati yonse, pomwe makona atatu amasokonekera.
Dinani pachizindikiro ichi mu mzere, malingana ndi momwe tikulembera. M'malo mwathu, tinaganiza zosefa ndi dzina. Mwachitsanzo, tifunika kusiya data yokha ndi wogwira ntchito ku Nikolaev. Chifukwa chake, kuwombera nkhupakupa kuchokera mayina a antchito ena onse.
Njira yopangidwa, dinani batani la "Ok".
Monga tikuwonera, zingwe zokha ndi dzina la wogwira ntchito wa Nikolaev adakhalabe patebulo.
Malizitsani ntchitoyo, ndipo tingosiyira tebulo pagome lomwe likugwirizana ndi Nikolaev for the III kotala la 2016. Kuti muchite izi, dinani pa chithunzi mu selo. Mu mndandanda womwe umatseguka, chotsani mabokosiwo miyezi "Meyi", "Juni" ndi "October", ndipo dinani batani la "Ok".
Monga mukuwonera, ndi zomwe tikufuna zidatsalira.
Pofuna kuchotsa fayiloyo pachinthu china, ndikuwonetsa deta yobisika, kachiwiri, dinani pa chithunzi chomwe chili mchipinda chimodzi chomwe chili mu mutuwo. Pa menyu otseguka, dinani "Chotsani Fyuluta c ..." chinthu.
Ngati mukufuna kukonzanso zosefera mokwanira patebulo, ndiye kuti muyenera dinani batani la "Mtundu ndi sefa" pa tepi, ndikusankha "chotsani" chotsani ".
Ngati mukufuna kuchotsa zosefera, ndiye, monga zitayamba, muyenera kusankha "Fyuluta" mumenyu imodzi, kapena lembani kiyi ya kiyibodi pa ctrl + l kiyibodi.
Kuphatikiza apo, ziyenera kudziwidwa kuti titatsegula ntchito "Fyuluta", ndiye kuti mukadina pa chithunzi chofananira m'maselo agome, ntchito zomwe timalankhula pamwambapa zimapezeka: "Sanjani a to z", "sankhani kwa ine kukhala", ndi "kukonza utoto."
Phunziro: Momwe mungagwiritsire ntchito autofilter mu Microsoft Excel
Tebulo lanzeru
Kusanja ndi zosefera kumathanso kukhazikitsidwa, kutembenuza malowa omwe mumagwira ntchito yomwe imatchedwa "tebulo lanzeru".
Pali njira ziwiri zopangira tebulo lanzeru. Pofuna kutenga mwayi woyamba wa iwo, gawani malo onse a tebulo, ndipo, ali mu "nyumba", dinani batani pa batani ". Batani ili ili mu "masitaelo".
Kenako, timasankha imodzi mwazomera zomwe mumakonda, mndandanda womwe umatsegulidwa. Simudzakhudzanso magwiridwe antchito a tebulo.
Pambuyo pake, bokosi la zokambirana limatseguka pomwe mutha kusintha magwiridwe a tebulo. Koma ngati mudagawana malowo molondola, simukufuna china chilichonse. Chinthu chachikulu, zindikirani kuti "tebulo lokhala ndi mutu wa" Parter idayimirira chizindikiro. Kenako, dinani batani la "OK".
Ngati mungaganize zopezera mwayi panjira yachiwiri, ndiye kuti muyenera kuwonetsa kudera lonse la tebulo, koma nthawi ino pitani ku tabu ya "kuyika". Pokhala pano, pa tepi mu "Zida Zam'manja" Block, muyenera dinani batani la "tebulo".
Pambuyo pake, ngati nthawi yotsiriza, zenera limatseguka pomwe mgwirizano wa khome lidzakonzedwa. Dinani pa batani la "OK".
Mosasamala momwe mungagwiritsire ntchito popanga "tebulo lanzeru", pamapeto pake timakhala patebulo, m'maselo a zipilala zomwe zalembedwa kale zaikidwa kale.
Mukadina chithunzichi, ntchito zonse zomwezo zidzakhalapo ngati mutayamba zosefera ndi njira yotheratu kudzera batani la "mtundu ndi sefa".
Phunziro: Momwe Mungapangire Tebulo Ku Microsoft Excel
Monga mukuwonera, kusanja ndi kusefa zinthu, pogwiritsa ntchito moyenera, kumatha kuthandizira ogwiritsa ntchito kuti azigwira ntchito ndi matebulo. Nkhani yofunikira kwambiri yogwiritsa ntchito imakhala pamwambowu kuti mndandanda waukulu kwambiri wa data umajambulidwa pagome.