Momwe Mungapezere ndi Kuchotsa Kubwereza

Mukamagwira ntchito ndi tebulo kapena database yokhala ndi chidziwitso, zomwe zingachitike ngati mizere ina ikabwerezedwa. Izi zimachulukitsa malo owonjezera. Kuphatikiza apo, papezeka kwa zobwereza, kuwerengera zotsatira molakwika kumatheka. Tiyeni tiwone momwe mungapezere ndikuthamangitsa mizere yobwereza mu pulogalamu ya Microsoft Excortl.

Sakani ndi kuchotsa

Pezani ndi kuchotsa zikhulupiriro zam'matebulo zomwe zimatumizidwa, mwina m'njira zosiyanasiyana. Munjira iliyonse mwazisankhozi, kusaka ndi kudzichepetsa kwa zobwerezabwereza ndi kulumikizana komwe komweko.

Njira 1: Kuchotsa mizere yobwereza

Njira yosavuta yochotsera zobwerezabwereza ndikugwiritsa ntchito batani lapadera pa riboni lomwe linapanga izi.

1. Timatsindika pamtundu wonse. Pitani ku "deta" tabu. Dinani pa batani "chotsani zobwereza". Imapezeka pa riboni mu "ntchito yokhala ndi deta".



2. Zenera lobwereza limatsegulidwa. Ngati muli ndi tebulo ndi kapu (komanso ambiri mwamphamvu, nthawi zonse pamakhala mawu omwe), ndiye kuti " Pawindo lalikulu lazenera pali mndandanda wa mizamu, yomwe idzayesedwa. Chingwecho chidzawonedwa ngati chidole chokha ngati deta yamitundu yonse yotalikirana ndi chizindikiro cha cheke chizigwirizana. Ndiye kuti, ngati mutenga chopaka kuchokera ku dzina la mzati, powonjezera mwayi wojambulira kujambula mobwerezabwereza. Pambuyo pa zosintha zonse zomwe zimapangidwa, dinani batani la "Ok".



3. Excel imagwira ndikuchotsa zobwereza. Pambuyo pomaliza, zenera lazidziwitso limawonekera lomwe limanenedwa kuti ndi ma re-miyambo ingati yomwe ili ndi zolemba zapadera. Kutseka zenera ili, dinani batani la "OK".

Njira 2: Kubwezeretsanso mobwerezabwereza patebulo lanzeru

Zobwereza zitha kuchotsedwa pamitundu yambiri popanga tebulo lanzeru.

1. Timatsindika pamtundu wonse.



2. Tili mkati mwa tabu yakunyumba, dinani pamtundu wa "batani" batani la Medi ", lomwe lili pa tepi mu" masitayilo ". Pa mndandanda womwe umawonekera, sankhani mtundu uliwonse womwe mukufuna.



3. Kenako zenera laling'ono limatseguka, momwe muyenera kutsimikizira mtundu wosankhidwa kuti apange "wanzeru". Ngati mwapereka chilichonse molondola, mutha kutsimikizira ngati mwalakwitsa, ndiye kuti ziyenera kukhazikitsidwa pazenera ili. Ndikofunikanso kuwunika kuti "tebulo lokhala ndi mutu wa" Nthanda inaimirira chizindikiro. Ngati sichoncho, ndiye kuti muyenera kuyika. Pambuyo pazosintha zonse zimamalizidwa, dinani pa batani la "OK". "Tebulo lanzeru" linalengedwa.



4. Koma kulengedwa kwa "tebulo lanzeru" ndi gawo limodzi lokha lokha kuti muthetse ntchito yathu yayikulu - kuchotsedwa kwa zobwereza. Dinani pagome lililonse la tebulo. Nthawi yomweyo, gulu lowonjezera la tabu "likugwira ntchito ndi matebulo" limawonekera. Tili mu Conser Tab, dinani batani la "Chotsani", lomwe limapezeka pa tepi mu Chida cha Chida cha Ntchito.



5. Pambuyo pake, zenera lobwereza limatseguka, ntchito yomwe idafotokozedwa mwatsatanetsatane pofotokoza njira yoyamba. Zochita zina zonse zimapangidwa chimodzimodzi.

Njirayi ndiyomwe ndiyothandiza kwambiri komanso yogwira ntchito zonse zofotokozedwa m'nkhaniyi.

Phunziro: Momwe mungapangire tebulo ku Excel

Njira 3: Kusankha Kusankha

Njirayi siyichotsa kotheratu, chifukwa kusanja kwabizinesi mobwerezabwereza pagome.

1. Sankhani tebulo. Pitani ku "deta" tabu. Dinani pa batani la "Fyuluta", ili mu "mtundu ndi zosefera" zosintha ".



2. Fyuluta imaphatikizidwa, monga zikusonyezedwera ndi zithunzi zomwe zawonetsedwa mu mawonekedwe a zigawo zitatu zamitundu yamitundu yamayiko. Tsopano tiyenera kuwuzira. Dinani pa batani "yapamwamba", yomwe ili pafupi ndi onse m'gulu lomwelo la zida "kusanja ndi kusefa".



3. Zenera lofananira limatseguka. Ikani mmenemo mumakangana ndi "zolemba zapadera zokha". Zosintha zina zonse zimasiya kusakhazikika. Pambuyo pake, dinani batani la "OK".

Pambuyo pake, zolembedwa zobwereza zidzabisika. Koma chiwonetserochi chitha kuthandizidwa nthawi iliyonse powakanikiza batani la "Fyuluta" kachiwiri.

Phunziro: Fyuluta yapamwamba kwambiri

Njira 4: Mawonekedwe

Mutha kupezanso maselo obwereza pogwiritsa ntchito tebulo. Zowona, zikeni zomwe azikhala chida china.

1. Sankhani dera la tebulo. Ndili kunyumba yanyumba, dinani batani la "Malingaliro a Malamulo" omwe ali mu "masitayilo" makonda. Mumenyu zomwe zimawoneka, timadutsa machitidwe a maefloge malamulo ndi "zobwereza ...".



2. Zenera lokhazikitsa mawonekedwe limatseguka. Pulogalamu yoyamba mkati siyosinthidwa - "Kubwereza". Koma posankha gawo, mutha, momwe mungachokerere makonda osasunthika ndikusankha mtundu uliwonse woyenera kwa inu, pambuyo pake timadina batani la "OK".

Pambuyo pake, padzasankhidwa maselo obwereza. Maselo amenewa mudzatha kufufuta panu ndi njira yofananira.

Chidwi! Kusaka kwa dub ndi kugwiritsa ntchito kapangidwe kazinthu sikungokhala pamzere wonse, koma khungu lililonse limakhala loyenera nthawi zonse.

Phunziro: Mawonekedwe oyenera ku Excel

Njira 5: Kugwiritsa ntchito formula

Kuphatikiza apo, mutha kugwiritsa ntchito njira zowerengera pogwiritsa ntchito ntchito zingapo nthawi imodzi. Ndi izi, mutha kusaka zobwereza pamtundu wina. Kuwona kwakukulu kwa fomulayi kukuwoneka motere:

Konzani (Index (Adilesi_stols; Board Board (0; Adilesi_Stolbki_Stolbts_Stolbts_Stols (Adilesi_Stol) ;;

1. Pangani gawo lapadera lomwe limawerengera lidzawonetsedwa.



2. Timangoyambitsa njira yofikira template yomwe yatchulidwa mu khungu laulere la mzere watsopano. Pankhani yathu, njirayo idzakhala ndi mawonekedwe awa:

   = Ngati Ukuthandizira (index (A8: A15; Madera (0; Ski (E7: A15; A15; A15; 1); 0); 0); 0); 0); 0); 0); ) ";" ")



3. Tikutsindika mzere wonsewo kuti tidzatenge, kupatula Mtsogoleriyo. Ikani chotembere kumapeto kwa chingwe. Kanikizani batani la F2 pa kiyibodi. Kenako mumalemba Ctrl + Shift + kulowa. Izi zimachitika chifukwa cha zizindikiro za ma array.

Pambuyo pa izi potengera mzere wobwereza, zobwereza zimawonekera.

Koma njirayi idakali yovuta kwambiri kwa ogwiritsa ntchito ambiri. Kuphatikiza apo, amangoganiza zofufuza kawiri, koma osati kuchotsedwa kwawo. Chifukwa chake, tikulimbikitsidwa kugwiritsa ntchito mayankho osavuta komanso ogwira ntchito omwe afotokozedwa kale.

Monga mukuwonera, pali zida zambiri zomwe adapanga kuti afufuze ndikuchotsa kawiri. Aliyense wa iwo ali ndi mawonekedwe ake. Mwachitsanzo, mawonekedwe azomwe amafunikira amafunika kusaka kuwirikiza pa selo iliyonse payokha. Kuphatikiza apo, si zida zonse zomwe sizingasanthule okha, komanso chotsani zinthu mobwerezabwereza. Mtundu wapadziko lonse lapansi ndi chilengedwe cha "tebulo lanzeru". Mukamagwiritsa ntchito njirayi, mutha kukhazikitsa mosavuta kufunafuna kuti mupeze zokambirana. Kuphatikiza apo, kuchotsedwa kwawo kumachitika nthawi yomweyo.