Kugwiritsa ntchito matebulo anzeru mu Microsoft Excel

Pafupifupi aliyense wogwiritsa ntchito Excel wakumana ndi zomwe pomwe muwonjezera mzere watsopano kapena mzere wazambiri wa tebulo, muyenera kutengera zolemba ndi kusanja mawonekedwe amtunduwo mwanjira wamba. Mavuto omwe akuwonetsedwa sangakhalepo ngati, m'malo mwa njira yokhazikika, gwiritsani ntchito mwanzeru. Izi "zimakoka" zokha kwa iye zinthu zonse zomwe wogwiritsa ntchito amakhala nazo pamalire ake. Pambuyo pake, Excel amayamba kuwazindikira ngati gawo la mndandanda wa tebulo. Uwu si mndandanda wathunthu wazomwe tebulo lanzeru likuthandizirani. Tiyeni tiwone momwe angapangire ndikupanga mwayi womwe umapereka.

Kugwiritsa Ntchito kwa Smart Table

Gome la "smart" ndi mtundu wapadera wamapangidwe, mutayigwiritsa ntchito pamasamba osiyanasiyana, maselo ambiri amakhala ndi zinthu zina. Choyamba, izi zitatha, pulogalamuyi imayamba kuiwona ngati maselo osiyanasiyana, koma monga chinthu chofunikira. Izi zidawoneka mu pulogalamu kuyambira pa mtundu wa Excel 2007. Ngati mujambulira chilichonse mwamaselo mzere kapena mzere womwe ukupezeka molunjika kumalire, ndiye kuti mzerewu kapena mzerewu umangophatikizidwa m'ndime iyi.

Kugwiritsa ntchito ukadaulowu kumathandizira kuti asayang'anenso njira mukawonjezera mizere ngati chidziwitsocho chatulutsidwa mu gawo lina ndi ntchito inayake, mwachitsanzo VPR. Kuphatikiza apo, pakati pa zabwino, ndikofunikira kuwunikira kapu pamwamba pa pepalalo, komanso kupezeka kwa mabatani azosefera mumutu.

Koma, mwatsoka, ukadaulo uwu uli ndi malire. Mwachitsanzo, ndikosayenera kugwiritsa ntchito mgwirizano wamaselo. Izi ndizowona makamaka zipewa. Kwa iye, kuphatikiza zinthu nthawi zambiri sikuvomerezeka. Kuphatikiza apo, ngakhale ngati simukufuna kuti phindu lina lomwe likhala m'malire amtundu wa tebulo likuphatikizidwenso (mwachitsanzo, cholembera), lidzawonedwabe ndi Excel monga gawo lofunikira nalo. Chifukwa chake, zilembo zonse zowonjezera ziyenera kuikidwa muzosamba zokhazokha zopanda kanthu kuchokera pamndandanda wazambiri. Komanso, mndandanda wamtundu wazambiri sungagwiremo ndipo bukuli silingagwiritsidwe ntchito pogawana. Mayina onse azigawo ayenera kukhala osiyana, ndiye kuti, osatinso.

Kupanga tebulo labwino

Koma tisanalongosole za kufotokoza kwa tebulo lanzeru, tiyeni tiwone momwe angapangire.

1. Sankhani maselo osiyanasiyana kapena chinthu chilichonse chomwe mukufuna kutsatira. Chowonadi ndi chakuti ngakhale mutasankha chinthu chimodzi cha mndandanda, pulogalamuyi imatenga mbali zonse zoyandikana nawo pakupanga. Chifukwa chake, palibe kusiyana kwakukulu kuti mumasankha mtundu wonse wa chandamale kapena gawo lokha.

   Pambuyo pake, pitani ku tabu "Pofikira"ngati muli pagulu lina la Excel. Kenako dinani batani "Fomati ngati tebulo", yomwe imayikidwa pa tepi mu chipangizo chothandizira Masitaelo. Pambuyo pake, mndandanda umayamba ndi kusankha kwamitundu yosiyanasiyana ya kapangidwe kazinthu zingapo. Koma mawonekedwe osankhidwa sangakhudze magwiridwe antchito mwanjira iliyonse, chifukwa chake tikudina kusankha komwe mungakonde kwambiri.

   

   Palinso njira ina yosinthira. Momwemonso, sankhani onse kapena gawo la mtundu omwe tikusintha kuti akhale ambiri. Kenako, pitani ku tabu Ikani ndi pa riboni m'bokosi la chida "Matebulo" dinani pachizindikiro chachikulu "Gome". Pokhapokha, kusankha kwamtundu wamtundu sikunaperekedwe, ndipo kumayikidwa pokhapokha.

   

   Koma njira yothamanga kwambiri ndikugwiritsa ntchito ma hotkeys mutasankha foni kapena mndandanda Ctrl + T.

2. Ndi zilizonse zili pamwambazi, zenera laling'ono limatseguka. Ili ndi adilesi yamagulu osiyanasiyana kuti asinthidwe. Mwambiri, pulogalamuyo imasankha mtunduwo molondola, mosasamala kuti mwasankha zonse kapena khungu limodzi lokha. Komabe, pokhapokha, muyenera kuyang'ana adilesi yomwe ili m'munda ndipo ngati sichikugwirizana ndi zomwe mukufuna, musinthe.

   Komanso, onetsetsani kuti pali cheke pafupi ndi paramayo Mutu wa Mitu, popeza nthawi zambiri pamitu yayikulu yazomwe zili ndi zomwe zidalipo kale zilipo. Mukatha kuwonetsetsa kuti magawo onse adalowetsedwa molondola, dinani batani "Zabwino".



3. Pambuyo pazochitazi, kuchuluka kwa deta kudzasinthidwa kukhala tebulo labwino. Izi zikuwonetsedwa pakupezeka kwazinthu zina kuchokera pamtunduwu, komanso pakusintha kowonekera kwake, malinga ndi kalembedwe kosankhidwa kale. Tilankhula za zinthu zazikulu zomwe zimaperekanso katundu uyu patsogolo.

Phunziro: Momwe mungapangire tebulo ku Excel

Dzinalo

Pambuyo patebulo "yanzeru", ikangopatsidwa dzina. Mwakusintha, ili ndi dzina la mtundu. "Tebulo1", "Tebulo2" etc.

1. Kuti muwone dzina lomwe mndandanda wathu womwe uli ndi tebulo uli nawo, sankhani chilichonse chomwe mwapanga ndikupita ku tabu "Wopanga" tabo block "Kugwira ntchito ndi matebulo". Pa nthiti m'gulu la zida "Katundu" mundawo udzapezedwa "Dongosolo la tebulo". Ili ndi dzina lake. M'malo mwathu, izi "Table3".



2. Ngati mukufuna, dzinali lingasinthidwe ndikungosokoneza dzinalo kuchokera pabokosi lomwe lili pamwambapa.

Tsopano pakugwira ntchito ndi mafomula, kuti muwonetse ntchito inayake yomwe ikufunika kukonza mndandanda wonse wa tebulo, m'malo mwa magwiritsidwe antchito, ndizokwanira kulowa dzina lake ngati adilesi. Kuphatikiza apo, sikuyenera, komanso othandiza. Ngati mungayike adilesi yoyenera ngati njira yolumikizirana, ndiye kuti mukuwonjezera mzere pansi pa tebulo, ngakhale mutaphatikizidwa, kapangidwe kake sikungagwiritse mzerewu pakukonza ndipo zomwe zikunenedwazo ziyenera kusinthidwanso. Ngati mungafotokoze, ngati lingaliro la ntchitoyo, adilesi yomwe ili mu dzina la mndandanda wa tebulo, ndiye kuti mizere yonse yowonjezedwa mtsogolo idzakonzedwa ndi ntchitoyi.

Tambasulani

Tsopano tiyeni tiwone momwe mizere yatsopano ndi zipilala zimawonjezedwera pamtundu wa tebulo.

1. Sankhani khungu lililonse mu mzere woyamba womwe uli pansipa ya tebulo. Timalowa mmenemo.



2. Kenako dinani fungulo Lowani pa kiyibodi. Monga mukuwonera, izi zitachitika, mzere wonse womwe amalemba kumene umangophatikizidwa pamndandanda wapa tebulo.

Kuphatikiza apo, mawonekedwe omwewo adangodzigwiritsira ntchito monga magawo ena onse a tebulo, ndipo mawonekedwe onse omwe amapezeka pazolowera motsatana nawonso adalimbitsidwa.

Zowonjezera zoterezi zidzachitika ngati tidzijambulira mzere womwe uli m'malire amtundu wapa tebulo. Adzaphatikizidwanso m'mapangidwe ake. Kuphatikiza apo, dzina lidzapatsidwa kwaokha. Mwakusintha, dzina likhala Column1Mzere wotsatira ndi Column2 Koma ngati mukufuna, mutha kuwapatsa mayina munthawi zonse.

Chinthu chinanso chothandiza pa tebulo lanzeru ndikuti ngakhale mutakhala ndi zochuluka motani, ngakhale mutatsikira pansi, mayina ammagawo azikhala pamaso panu nthawi zonse. Mosiyana ndi kukonza kwa zipewa, pamenepa, mayina a zipilala posunthira adzaikidwa pamalo pomwe pali yolinganiza yolumikizira.

Phunziro: Momwe mungapangire mzere watsopano ku Excel

Mafomu Ochita Zoyendetsa

Tinaona kale kuti mzere watsopano ukawonjezedwa m'chipinda chimenecho chokhala ndi zidutswa za thebulo zomwe zili kale ndi zofunikira, fomuloli imakopedwa zokha. Koma njira zomwe tikuwerenga ndizomwe zimatha. Ndikokwanira kuzaza khungu limodzi lopanda chopanda kanthu kuti lizingokhalidwa lokha kuzinthu zina zonse zomwe zalembedwa mgululi.

1. Sankhani khungu loyambirira lopanda chilichonse. Timalowetsa mtundu uliwonse kumeneko. Timachita izi mwachizolowezi: kuyika chizindikirocho m'chipindacho "=", pambuyo pake timadina ma cell, omwe tikuchita opanga ziwalo. Pakati pa ma adilesi amaselo kuchokera pa kiyibodi timayika chizindikiro cha masamu ("+", "-", "*", "/" etc.). Monga mukuwonera, ngakhale adilesi yama cell siziwonetsedwa monga zimakhalira. M'malo mwa maupangiri omwe awonetsedwa pamapangidwe a zilembo zamtundu wa Latin ndi izi, pamenepa, mayina amizilankhulo chomwe chilankhulidwe chomwe adalowetsedwa amawonetsedwa ngati adilesi. Chizindikiro "@" zikutanthauza kuti khungu lili pamzera womwewo ndi fomula. Zotsatira zake, m'malo mwa fomula mwachizolowezi

   = C2 * D2

   timapeza mawu akuti patebulo lanzeru:

   = [@ Kuchuluka] * [@ Mtengo]



2. Tsopano, kuti muwonetse zotsatira pamapepala, dinani batani Lowani. Koma, monga tikuwona, mtengo wowerengera suwonetsedwa mu khungu loyamba lokha, komanso pazinthu zina zonse za mzatiwu. Ndiye kuti, fomuloli idakopedwa zokha m'maselo ena, ndipo chifukwa cha izi sindinachite kugwiritsa ntchito chikhomo kapena zida zina zofananira.

Mtunduwu sugwira ntchito mwanjira wamba, komanso pantchito.

Kuphatikiza apo, ziyenera kudziwidwa kuti ngati wogwiritsa ntchito alowa mndandanda wazinthu zina zochokera muzilo zina mu mawonekedwe amtunduwu, awonetsedwa mwanjira ina iliyonse, monga pamitundu ina iliyonse.

Mizere wama tambala

China chabwino chomwe njira yofotokozedwera ku Excel imapereka ndikutulutsa masamba mzere pamzere wina. Kuti muchite izi, simuyenera kuwonjezera pamzere mwanjira ina ndikuwongolera mawonekedwe ake, chifukwa zida zanzeru patebulopo zili ndi kale zida zawo zoyikiratu.

1. Pofuna kukhazikitsa mabulangete, sankhani chilichonse patebulo. Pambuyo pake, pitani ku tabu "Wopanga" magulu a tabu "Kugwira ntchito ndi matebulo". Mu bokosi la zida "Zosankha zamtokoma" onani bokosi pafupi ndi mtengo wake "Mzere wathunthu".

   

   M'malo mwazomwe tatchulazi, mutha kugwiritsanso ntchito kuphatikiza kwa hotkey kuyambitsa mzere wonse. Ctrl + Shift + T.

2. Pambuyo pake, mzere wowonjezera udzawonekera pansi pake pazosankha. "Chidule". Monga mukuwonera, kuchuluka kwa gawo lotsiriza kuliwerengera zokha mwakugwiritsa ntchito ntchito yomangidwa ZOCHITIKA.



3. Koma titha kuwerengera mtengo wathunthu wamakola ena, ndikugwiritsa ntchito mitundu yosiyanasiyana. Dinani kumanzere khungu lililonse mzere "Chidule". Monga mukuwonera, chithunzi cha makona atatu chimawoneka kumanja kwa chinthu ichi. Timadulira. Pamaso pathu pali mndandanda wazosankha zingapo zachidule:
   • Pakatikati;
   • Kuchuluka;
   • Zolemba malire
   • Zochepera;
   • Kuchuluka
   • Kupatuka kopitilira muyeso;
   • Kusintha kosiyanasiyana.

   Timasankha kubweza zotsatira zomwe tikuwona kuti ndizofunikira.



4. Mwachitsanzo, ngati tisankha njira "Ziwerengero", ndiye kuti mzere wamtundu wa maselo omwe ali ndi mzere wambiri adzawonetsedwa. Mtengo uwu uwonetsedwa ndi ntchito yomweyo. ZOCHITIKA.



5. Ngati mulibe zofunikira zomwe mndandanda wazida zachidule zomwe zafotokozedwa pamwambapa, dinani "Zina ..." m'munsi mwake.



6. Izi zikuyamba zenera. Ogwira Ntchito, pomwe wogwiritsa ntchito amatha kusankha ntchito iliyonse ya Excel yomwe akuwona kuti ndi yofunika. Zotsatira zake zimakonzedwa mu cell yolingana ndi mzere "Chidule".

Kukonza ndi kusefa

Pa tebulo la "anzeru", mosakhazikika, ikalengedwa, zida zofunikira zimangolumikizidwa zokha zomwe zimapereka kutsatsa ndi kusefa deta.

1. Monga mukuwonera, pamutu wapafupi ndi mayina ammagulu aliwonse ali ndi zithunzi zojambulira zitatu. Ndi kudzera mwa iwo pomwe timatha kupeza ntchito yojambula. Dinani pa chithunzi chomwe chili pafupi ndi dzina la chipilalacho chomwe tikwaniritse. Pambuyo pake, mndandanda wazomwe ungachite umatsegulidwa.



2. Ngati mutuwo uli ndi mfundo zolemba, ndiye kuti mutha kuyika zosanja malinga ndi zilembo kapena kusintha. Kuti muchite izi, sankhani chinthucho moyenerera "Sanjani kuchokera A mpaka Z" kapena "Sinthani kuchokera ku Z mpaka A".

   

   Pambuyo pake, mizereyo imakonzedwa mwadongosolo losankhidwa.

   

   Ngati mukuyesa kusintha malingaliro omwe ali ndi danga mu mtundu wa deti, ndiye kuti mudzapatsidwa kusankha mitundu iwiri yosankha "Sinthani kuchokera kwakale mpaka watsopano" ndi "Sinthani kuchokera kwatsopano mpaka wakale".

   

   Pa mtundu wamitunduyi, zosankha ziwiri zimaperekedwanso: "Sanjani kuchokera kocheperako mpaka pamlingo wambiri" ndi "Sanjani kuchokera pamwambamwamba kupita pazochepera".



3. Kuti mugwiritse ntchito zosefera, momwemo momwe timayitanitsira kusanja ndi kujambula mndandanda mwa kuwonekera pa chithunzi chomwe chili patsamba loyenerana ndi deta yomwe mugwiritsa ntchito opaleshoniyo. Pambuyo pake, sanazindikire zomwe zalembedwa mndandanda zomwe tikufuna kubisa. Mukatha kuchita izi pamwambapa musaiwale kudina batani "Zabwino" pansi pa mndandanda wazopezeka.



4. Pambuyo pake, mizere yokha ndi yomwe izikhala yowoneka, pafupi ndi omwe mwasiya nkhupakupa mumakonzedwe a fyuluta. Zina zidzabisidwa. Nthawi zambiri, zomwe zili mu chingwe "Chidule" zisinthanso. Zambiri za mizere yosefedweratu sizingachitike mukamafupikitsa mwachidule zotsatira zina.

   

   Izi ndizofunikira kwambiri kuperekedwa kuti mukamagwiritsa ntchito muyezo wa DRM (SUM), osati wothandizira ZOCHITIKA, ngakhale mfundo zobisika zimatha kuwerengera.

Phunziro: Sanjani ndi kusefa deta mu Excel

Sinthani tebulo kukhala lambiri

Zachidziwikire, ndizosowa kwenikweni, koma nthawi zina pamafunikabe kusintha tebulo lanzeru kukhala lambiri. Mwachitsanzo, izi zitha kuchitika ngati mukufuna kugwiritsa ntchito njira zingapo kapena ukadaulo wina womwe machitidwe a Excel omwe timaphunzira sawathandiza.

1. Sankhani chilichonse chamtundu wazambiri. Pa nthiti, pitani ku tabu "Wopanga". Dinani pachizindikiro Sinthani Kuti Ndikhale Wosinthaili mu chipangizo "Ntchito".



2. Pambuyo pa izi, bokosi la zokambirana likhala likukufunsani ngati tikufunadi kusintha mawonekedwe a tebulo kuti akhale amtundu wanthawi zonse? Ngati wogwiritsa ntchitoyo ali wotsimikiza muzochita zawo, dinani batani Inde.



3. Pambuyo pake, gulu limodzi la matebulo lidzasinthidwa kukhala mndandanda wokhazikika, momwe katundu ndi malamulo a Excel onse azikhala oyenera.

Monga mukuwonera, tebulo labwino limagwira ntchito kwambiri kuposa momwe limakhalira. Ndi chithandizo chake, mutha kufulumizitsa ndikusavuta yankho la ntchito zambiri pokonza deta. Ubwino wa kugwiritsidwa ntchito kwake ndikuphatikiza kukulira kwa mtundu umodzi pokhapokha powonjezera mizere ndi mizati, mawonekedwe a autofilter, maselo otsogola okhala ndi ma formulas, mzere wamatali ndi ntchito zina zofunikira.