Sakani Microsoft Excel

Muzolemba za Microsoft Excel, zomwe zimakhala ndi magawo ambiri, nthawi zambiri zimayenera kupeza deta, dzina la mzere, ndi zina zambiri. Ndizovuta kwambiri pamene mukuyenera kuyang'ana pamizere yambiri kuti mupeze mawu oyenera kapena mawu. Kusaka komwe kumangidwa mu Microsoft Excel kumathandiza kupulumutsa nthawi ndi mitsempha. Tiyeni tiwone momwe imagwirira ntchito ndi momwe angaigwiritsire ntchito.

Sakani ntchito ku Excel

Ntchito yofufuzira mu Microsoft Excel imapereka mwayi wopeza zolemba zomwe mukufuna kapena manambala kudzera pa Pezani ndi Sinthani zenera. Kuphatikiza apo, pulogalamuyi imatha kusaka kwambiri deta.

Njira 1: Kusaka Kosavuta

Kusaka kosavuta kwa data mu Excel kumakupatsani mwayi kuti mupeze maselo onse omwe ali ndi zilembo (zilembo, manambala, mawu, ndi zina) zolowetsedwa mu bokosi losakira, osati milandu.

1. Kukhala mu tabu "Pofikira"dinani batani Pezani ndikuwunikiraili pa riboni m'bokosi la chida "Kusintha". Pazosankha zomwe zimapezeka, sankhani "Pezani ...". M'malo mwazomwe mungachite, mutha kungolembera njira yaying'ono pa kiyibodi Ctrl + F.



2. Mukadina pazinthu zoyenera pa riboni, kapena kupanikiza kuphatikiza kwa hotkey, zenera lidzatsegulidwa Pezani ndi Kusintha pa tabu Pezani. Timazifuna. M'munda Pezani lowetsani liwu, zilembo, kapena mawu omwe tifufuze. Dinani batani "Pezani chotsatira", kapena batani Pezani Zonse.



3. Mwa kukanikiza batani "Pezani chotsatira" timasamukira ku selo loyamba, lomwe lili ndi magulu omwe adalowetsedwa. Selo imayamba kugwira ntchito.

   Kusaka ndi kutumiza zotsatira kumachitika mzere ndi mzere. Choyamba, maselo onse a mzere woyamba amakonzedwa. Ngati palibe deta yolingana ndi momwe idapezekera, pulogalamuyo imayamba kufufuza mzere wachiwiri, ndi zina zotero, mpaka itapeza zotsatira zogwira mtima.

   Makonda osaka sayenera kukhala magawo osiyana. Chifukwa chake, ngati mawu akuti "ufulu" adafotokozedwa ngati funso, ndiye kuti maselo onse omwe ali ndi mawonekedwe awa ngakhale mkati mwa mawu awonetsedwa. Mwachitsanzo, pankhaniyi, liwu loti "Kumanja" lidzapezedwa ngati loyenera. Mukatchula nambala ya "1" mumsakatuli, yankho lidzaphatikizanso maselo omwe ali, mwachitsanzo, nambala "516".

   Kuti mupite ku zotsatira zotsatila, dinani batani kachiwiri "Pezani chotsatira".

   

   Izi zitha kupitilizidwa mpaka kuwonetsa zotsatira zikuyamba mzere watsopano.

4. Zikatero, mukayamba kufufuza, mumadina batani Pezani Zonse, zotsatira zonse zidzawonetsedwa mndandanda womwe uli pansi pazenera. Mndandandandawu umakhala ndi zidziwitso zamkati mwa maselo ndi zomwe zakwaniritsa zomwe mukufuna, tsamba lawo limafotokozeredwa, komanso pepala ndi buku lomwe zikukhudzana nazo. Kuti mupite pazotsatira zilizonse, ingodinani ndi batani lakumanzere. Pambuyo pake, cholozera chidzapita ku foni ya Excel yomwe wosuta adadina.

Njira 2: sakani pakatikati pakale

Ngati muli ndi tebulo lalikulu labwino, pamenepa sikuti nthawi zonse kumakhala kosavuta kusaka pepalalo lonse, chifukwa pazosaka zanu zitha kukhalapo zotsatira zosafunikira kwenikweni. Pali njira yochepetsera malo osaka ndi maselo angapo okha.

1. Sankhani malo omwe timasaka.



2. Kulemba njira yaying'ono Ctrl + F, pambuyo pake zenera lodziwika liyamba Pezani ndi Kusintha. Zochita zina ndizofanana ndendende ndi njira yapita. Kusiyana kokhako kudzakhala kuti kusaka kumachitika pokhapokha patalipidwa khungu.

Njira 3: Kusaka Kwambiri

Monga tafotokozera pamwambapa, pofufuza wamba, maselo onse omwe ali ndi mitundu yosakira ya mitundu iliyonse mosasamala kanthu, amapezeka pazotsatira zakusaka.

Kuphatikiza apo, osati zomwe zili mu selo linalake, komanso adilesi ya chinthu chomwe chimalozerako chitha kulowa. Mwachitsanzo, cell E2 ili ndi formula yomwe ndi chiwerengero cha maselo A4 ndi C3. Izi ndi 10, ndipo nambala iyi ndi yomwe ikuwonetsedwa mu cell E2. Koma, ngati tifunsa mukasaka nambala ya "4", pamenepo pazotsatira zakusaka idzakhala cell E2 yomweyo. Kodi zingachitike bwanji? Ndi cell ya E2 yokha yomwe ili ndi adilesi ya cell A4 ngati formula, yomwe imangophatikizapo nambala 4 yofunika.

Koma, tingadule bwanji izi, ndi zotsatira zina zosadziwika zosavomerezeka? Pazifukwa izi, pali kusaka kwapamwamba kwa Excel.

1. Pambuyo potsegula zenera Pezani ndi Kusintha mwanjira iliyonse ili pamwambapa, dinani batani "Zosankha".



2. Zida zingapo zowongolera zofufuza zimawonekera pazenera. Mwachidziwikire, zida zonsezi zili mumkhalidwe wofanana ndi kusaka kwabwino, koma mutha kusintha zina ngati pakufunika.

   

   Mwa kusachita, ntchito Mlandu ndi Maselo Onse ali ndi zilema, koma ngati tiwunika mabokosi pafupi ndi zinthu zomwe zikugwirizana, ndiye pankhani iyi, tikamapereka zotsatira, kaundula wolowetsedwa ndi machesi enieni azikumbukiridwa. Mukalowetsa liwu ndi chilembo chaching'ono, ndiye pazotsatira zakusaka, maselo okhala ndi kalembedwe ka mawuwa ndi chilembo chachikulu, monga momwe kungakhalire, sikadzagwa. Kuphatikiza apo, ngati ntchitoyo imayendetsedwa Maselo Onse, ndiye zinthu zokha zokhala ndi dzina lenileni ndizomwe zidzawonjezeredwa pamagaziniyo. Mwachitsanzo, ngati mungafotokoze zosaka "Nikolaev", ndiye kuti maselo omwe ali ndi mawu akuti "Nikolaev A. D." sawonjezedwa pazosaka.

   

   Mwachisawawa, kusaka kumachitika pokhapokha pa Excel works works. Koma, ngati chizindikiro "Sakani" mudzamasulira kukhala m'malo "M'buku", pamenepo kusaka kudzachitika pamapepala onse a fayilo yotseguka.

   

   Pamagawo Onani Mutha kusintha mayendedwe akusaka. Zosintha, monga tafotokozera pamwambapa, kusaka kumachitika mzere ndi mzere. Mwa kusunthira kusinthaku Column ndi safu, muthanso kulongosola dongosolo la mibadwo yazotsatira, kuyambira mzere woyamba.

   

   Pazithunzi Malo Osaka zimatsimikizika pakati pofufuza zomwe zimachitika. Mwachidziwikire, izi ndi njira, ndiye kuti, deta yomwe mukadina foni ikusonyezedwa mu barula yokhazikika. Awa amatha kukhala mawu, nambala, kapena foni. Nthawi yomweyo, pulogalamuyo, ikufufuza, imangodziwa ulalo wokhawo, osati zotsatira zake. Izi tafotokozazi. Kuti musakale ndi zotsatira, ndi deta yomwe ikuwonetsedwa mu khungu, osati fayilo yantchito, muyenera kukonzanso kusintha kuchokera pamalo Mawonekedwe m'malo "Makhalidwe". Kuphatikiza apo, ndizotheka kusaka ndi zolemba. Muna kuma kiaki, tufwete tanginina e kwikizi "Zolemba".

   

   Mutha kutchula kusaka kolondola kwambiri podina batani. "Fomu".

   

   Izi zimatsegula zenera la mawonekedwe. Apa mutha kukhazikitsa mtundu wamaselo omwe adzatenge nawo gawo pofufuza. Mutha kukhazikitsa zoletsa pamafayilo amitundu, mayendedwe, mawonekedwe, malire, kudzaza ndi chitetezo, malinga ndi chimodzi mwazigawo, kapena kuphatikiza pamodzi.

   

   Ngati mukufuna kugwiritsa ntchito mawonekedwe a selo linalake, ndiye kuti pansi pazenera dinani batani "Gwiritsani mawonekedwe a foni iyi ...".

   

   Pambuyo pake, chipangizocho chikuwoneka ngati bomba. Kugwiritsa ntchito, mutha kusankha fayilo yomwe mukufuna kugwiritsa ntchito.

   

   Pambuyo posaka mawonekedwe asinthidwa, dinani batani "Zabwino".

   

   Pali nthawi zina pamene mungafunike kusaka liwu linalake, koma kuti mupeze maselo omwe ali ndi mawu osakira mumtundu uliwonse, ngakhale atalekanitsidwa ndi mawu ena ndi zizindikiro. Kenako mawu awa ayenera kulembedwa mbali zonse ndi "*". Tsopano pazotsatira zakusaka maselo onse omwe mawu awa akupezeka mu dongosolo lililonse adzawonetsedwa.



3. Makonda akusaka akakhazikitsidwa, dinani batani Pezani Zonse kapena "Pezani chotsatira"kupita kuzotsatira zakusaka.

Monga mukuwonera, Excel ndiyosavuta, koma nthawi yomweyo zida zogwiritsidwa ntchito pakusaka. Kuti mupange kufinya kosavuta, ingoyitanitsani bokosi losakira, lembani funso, ndipo dinani batani. Koma, nthawi yomweyo, ndizotheka kusintha kusaka kwamunthu payekha ndi kuchuluka kwakukulu kwa magawo osiyanasiyana ndi makonda owonjezera.