Kugwiritsa ntchito matebulo abwino mu Microsoft Excel

Pafupifupi aliyense wogwiritsa ntchito Excel anakumana ndi vuto pamene, pakuwonjezera mzere kapena mzere watsopano pa tebulo, ndikofunikira kubwezeretsanso mafomu ndi kupanga fomuyi kuti mukhale ndi kalembedwe kake. Mavuto amenewa sakanapezeka ngati, m'malo mwa njira yachizolowezi, timagwiritsa ntchito otchedwa tebulo yabwino. Izi zidzangokhala "kukokera" ku zinthu zonse zomwe wogwiritsa ntchito ali nazo pamalire ake. Pambuyo pake, Excel ikuyamba kuwazindikira ngati mbali ya tebulo. Iyi si mndandanda wathunthu wa zomwe zili zothandiza patebulo la "smart". Tiyeni tipeze momwe tingalenge, ndi mwayi womwe umapereka.

Ikani gome loluntha

Tebulo lapamwamba ndi mtundu wapadera wopanga maonekedwe, kenaka imagwiritsidwa ntchito pazinthu zofotokozedwa bwino, maselo ambiri amatenga katundu. Choyamba, pambuyo pompano pulogalamuyi ikuyamba kuiganizira osati monga maselo osiyanasiyana, koma monga chinthu chofunikira. Mbaliyi inkawonekera pulogalamuyi, kuyambira pa Excel 2007. Ngati mutalowa mkati mwa maselo omwe ali mzere kapena mzere womwe uli pafupi ndi malire, ndiye mzerewu kapena mzerewu umaphatikizidwira mwapadera.

Kugwiritsiridwa ntchito kwa teknolojiyi kumapangitsa kusabwereza mafomu pambuyo pa kuwonjezera mizere, ngati deta yomwe imachokera ku iyo ikulowetsedwera kuntchito ina, mwachitsanzo Vpr. Kuphatikizanso apo, pakati pa ubwino uyenera kutsindika zikhomo zapamwamba pamwamba pa pepala, komanso kukhalapo kwa zizindikiro za fyuluta pamutu.

Koma, mwatsoka, makina awa ali ndi malire ena. Mwachitsanzo, kuphatikiza selo ndi kosayenera. Izi ndizofunika makamaka pa kapu. Kwa iye, mgwirizano wa zinthu ndizosavomerezeka. Kuonjezera apo, ngakhale simukufuna kuti phindu lililonse likhale pamphepete mwa tebulo kuti liphatikizidwe (mwachitsanzo, chilemba), Excel idzaonedwa ngati gawo limodzi. Choncho, zolembedwera zonse zosafunikira ziyenera kuikidwa pakamwa kopanda kanthu kuchokera pa tebulo. Ndiponso, mawonekedwe omwe sangagwire ntchito ndipo bukuli silingagwiritsidwe ntchito pogawana. Maina onse a pamtundu ayenera kukhala osiyana, omwe, osabwerezedwa.

Kupanga tebulo lapamwamba

Koma tisanasunthire patsogolo kuti tifotokoze za mphamvu za tebulo lapamwamba, tiyeni tione momwe tingaligwiritsire ntchito.

1. Sankhani maselo osiyanasiyana kapena zinthu zina zomwe tikufuna kugwiritsa ntchito ma tebulo. Chowonadi n'chakuti ngakhale titakhala osakayikira mbali imodzi, pulogalamuyi idzagwira zinthu zonse zomwe zili pafupi ndi njirayi. Choncho, palibe kusiyana kwakukulu ngati mumasankha zolinga zonse kapena gawo limodzi chabe.

   Pambuyo pake kusamukira ku tabu "Kunyumba", ngati panopa muli m'ndandanda ina ya Excel. Kenako, dinani pakani "Pangani monga tebulo"yomwe imayikidwa pa tepi mu zida za zipangizo "Masitala". Pambuyo pake, mndandanda umayamba ndi kusankha kwa mitundu yosiyanasiyana ya tebulo. Koma kalembedwe kamene sikasokoneze kayendetsedwe ka ntchito mwanjira iliyonse, kotero ife timangosintha pa zosiyana zomwe mumaziwona zambiri.

   

   Palinso njira ina yosinthika. Mofananamo, sankhani zonse kapena mbali ya mapepala omwe tikutembenuzira ku tebulo. Chotsatira, pita ku tabu "Ikani" ndi pa tepi mu chida cha zipangizo "Matebulo" dinani pazithunzi zazikulu "Mndandanda". Pokhapokha, izi sizinaperekedwe posankha, ndipo zidzakhazikitsidwa mwachinsinsi.

   

   Koma njira yofulumira kwambiri ndiyo kugwiritsa ntchito makina osuta pambuyo posankha selo kapena gulu. Ctrl + T.

2. Pa chilichonse mwazomwe mungasankhe, firiji yaying'ono imatsegulidwa. Ili ndi adiresi yoyenera kutembenuzidwa. Muzochitika zambiri, pulogalamuyi imatsimikizira moyenera, mosasamala kanthu kuti mwasankha zonse kapena selo limodzi. Komabe, ngati mungayambe, muyenera kuyang'ana adiresi yazomwe muli kumunda ndipo, ngati sakugwirizana ndi zofunikira zomwe mukufunikira, zithetsani.

   Kuonjezerapo, tawonani kuti pali nkhupakupa pafupi ndi parameter "Mndandanda ndi mutu", monga nthawi zambiri mutu wa deta yapachiyambi waperekedwa kale. Mutatha kutsimikiza kuti zonsezi zalowa bwino, dinani pa batani "Chabwino".



3. Pambuyo pachithunzichi, deta yamtunduwu idzatembenuzidwa ku tebulo lapamwamba. Izi zidzasonyezedwa pakupeza zina zowonjezera katundu kuchokera pazomwezi, komanso kusintha masomphenya ake, malinga ndi kalembedwe kameneka. Tidzakambirana za zikuluzikulu zomwe zimaperekedwa.

Phunziro: Momwe mungapangire spreadsheet mu Excel

Dzina

Pambuyo patebulo la "nzeru", dzina lidzapatsidwa kwa iwo. Chosoweka ndi dzina la mtundu. "Table 1", "Table2" ndi zina zotero

1. Kuti muwone dzina la tableti lathu ndilo, sankhani chilichonse cha zinthu zake ndikusunthira ku tabu "Wopanga" ma tabola "Kugwira ntchito ndi matebulo". Pa tepi mu zida zamagulu "Zolemba" munda udzapezeka "Dzina lamasamba". Dzina lake liri mkati mwake. Kwa ife ndizo "Table3".



2. Ngati mukufuna, dzina lingasinthidwe mwa kusokoneza dzina m'munda wapamwamba.

Tsopano, pamene mukugwira ntchito ndi mayina, kuti muwonetsetse ntchito inayake yomwe mukufuna kuti mugwiritse ntchito mndandanda wonse wa tebulo, mmalo mwazigawo zowonongeka, mumangotchula dzina lake ngati adilesi. Kuonjezera apo, sizowonjezereka, koma komanso zothandiza. Ngati mugwiritsa ntchito adiresi yoyenera mu mawonekedwe a makonzedwe, kenaka kuwonjezera mzere pansi pa tebulo, ngakhale mutaphatikizidwapo momwe akugwiritsidwira ntchito, ntchitoyi siimagwirizanitsa mzerewu kuti igwiritsidwe ntchito ndipo iyenera kusokoneza mfundozo kachiwiri. Ngati mukulongosola, ngati ndewu yogwira ntchito, adiresi mu mawonekedwe a dzina la mndandanda wa tebulo, ndiye mizere yonse yowonjezeredwa mtsogolomu idzasinthidwa ndi ntchitoyo.

Sungani Range

Tsopano tiyeni tiganizire momwe mizere yatsopano ndi zipilala zowonjezera pazenera za tebulo.

1. Sankhani selo lirilonse mzere woyamba pansi pa tebulo. Timapanga mwayi wopita mosavuta.



2. Kenaka dinani pafungulo Lowani pabokosi. Monga mukuonera, mutatha izi, mzera wonse umene uli ndi rekodi yatsopanoyi yowonjezera mwadongosolo.

Komanso, mawonekedwe omwewo ankagwiritsidwa ntchito mosavuta monga momwe zilili patebulo lonse, ndipo maulendo onse omwe ali muzitsulo zofananazo adatengedwa.

Kuwonjezera kotereku kudzachitika ngati tipanga kulowa muzomwe zili pamphepete mwa tebulo. Adzaphatikizidwanso m'zinthu zake. Kuwonjezera pamenepo, adzalitchula dzina. Mwachinsinsi dzina lidzakhala "Column1", ndime yotsatira yowonjezera ndi "Column2" etc. Koma, ngati akukhumba, iwo angatchulidwe nthawi zonse.

Mbali ina yothandiza pa tebulo lapamwamba ndi yakuti ngakhale ziri zolemba zingati, ngakhale mutapita kumunsi, mayina a zipilala adzakhala patsogolo pa maso anu. Mosiyana ndi kukonzekera kwatsopano kwa makapu, pakadali pano mayina a zipilala zikapita pansi adzaikidwa pamalo pomwe palipangidwe lamakonzedwe.

Phunziro: Momwe mungawonjezere mzere watsopano ku Excel

Kulemba machitidwe

Poyambirira, tawona kuti pakuwonjezera mzere watsopano, mu selo yake ya gawolo la gome, momwe muli kale malemba, chikhochichi chimapopedwa. Koma kachitidwe ka deta yomwe timaphunzira imatha kuchita zambiri. Ndikokwanira kudzaza selo limodzi la gawo lopanda kanthu ndi ndondomeko kuti ilo lidzakopizidwa kuzinthu zina zonse za m'mbali iyi.

1. Sankhani selo yoyamba mu gawo lopanda kanthu. Ife timalowa mmenemo njira iliyonse. Timachita mwachizolowezi: ikani chizindikiro mu selo "="ndiye dinani maselo, ntchito ya masamu pakati pa zomwe titi tichite. Pakati pa maadiresi a maselo ochokera ku kibokosi timaika chizindikiro cha masamu pamchitidwe ("+", "-", "*", "/" ndi zina zotero) Monga mukuonera, ngakhale adiresi ya maselo amawonetsedwa mosiyana ndi momwe amachitira. Mmalo mwazigawo zowonongeka pamapangidwe osakanikirana ndi ofukula mu mawonekedwe a zilembo ndi zilembo za Chilatini, pamwambo uwu mayina a zipilala mu chinenero chomwe amalowetsamo akuwonetsedwa ngati maadiresi. Chizindikiro "@" amatanthawuza kuti selo liri mu mzere wofanana ndi njira. Zotsatira zake, mmalo mwa chiganizo chachizolowezi

   = C2 * D2

   timapeza mawu oti apange tebulo labwino:

   = [@ Quantity] * [@ Price]



2. Tsopano, kuti muwonetse zotsatirapo pa pepala, dinani pa fungulo Lowani. Koma, monga momwe tikuonera, kufunika kwa kuwerengetsera sikuwonetsedwa kokha mu selo yoyamba, komanso muzinthu zina zonse za m'ndandanda. Izi zikutanthauza kuti njirayi idasinthidwa mosavuta ku maselo ena, ndipo izi sizinafunikire kugwiritsa ntchito chikhomo chodzaza kapena zida zina zowonetsera.

Chitsanzo ichi sichimakhudza zowonongeka chabe, komanso zimagwira ntchito.

Kuwonjezera apo, tiyenera kukumbukira kuti ngati wogwiritsa ntchito mlojekiti yeniyeniyo ngati ndondomeko ya maadiresi a zigawo zina, iwo adzawonetsedwa mwa njira yoyenera, monga maulendo ena onse.

Chiwerengero cha mpanda

Chinthu china chabwino chimene mafotokozedwe omwe amagwiritsidwa ntchito mu Excel amapereka ndi kuchoka kwa totali ndi ndondomeko pamzere wosiyana. Kuti muchite izi, simukuyenera kuwonjezera mzere ndi kuwonjezera mwachidule malemba, chifukwa zipangizo za matebulo apamwamba zakhala ndi zofunikira zogwiritsira ntchito zida zawo.

1. Kuti muyambe kusindikiza, sankhani chinthu chilichonse cha tebulo. Pambuyo pake kusamukira ku tabu "Wopanga" magulu a matabu "Kugwira ntchito ndi matebulo". M'kati mwa zipangizo "Zithunzi Zamkatimu" tsimikizani mtengo "Mzere wa zonse".

   

   Mukhozanso kugwiritsa ntchito makina otentha kuti mutsegule mzere wa totals mmalo mwa masitepewa. Ctrl + Shift + T.

2. Pambuyo pake, mzere wina udzawonekera pansi pa tebulo, yomwe idzatchedwa - "Total". Monga mukuonera, chiwerengero cha gawo lomalizira chiwerengedweratu ndi ntchito yomangidwa. ZOKHUDZA IFEYO.



3. Koma tikhoza kuwerengera chiwerengero cha zikhomo zina, ndikugwiritsa ntchito mitundu yosiyanasiyana ya totali. Sankhani ndi batani lamanzere la selo iliyonse mzere. "Total". Monga mukuonera, chithunzi mwa mawonekedwe a katatu chikuwonekera kumanja kwa chigawo ichi. Dinani pa izo. Tisanayambe kutsegula mndandanda wa zosankha zosiyanasiyana polemba mwachidule:
   • Avereji;
   • Kuchuluka;
   • Kutalika;
   • Osachepera;
   • Mtengo;
   • Kupatukana kwachinyengo;
   • Kusweka kwa Shift.

   Timasankha njira yosintha zotsatira zomwe timaona kuti n'zofunikira.



4. Ngati ife, mwachitsanzo, timasankha "Chiwerengero cha nambala", ndiye mu mzere wa totali chiwerengero cha maselo m'ndandanda yomwe ili ndi manambala akuwonetsedwa. Mtengo umenewu udzawonetsedwa ndi ntchito yomweyo. ZOKHUDZA IFEYO.



5. Ngati mulibe zokwanira zomwe zimaperekedwa ndi mndandanda wa zida zofupikitsa zomwe tafotokoza pamwambapa, ndiye dinani pa chinthucho "Zina ..." pamunsi pake.



6. Izi zimayambira zenera Oyang'anira ntchitokumene wogwiritsa ntchito angasankhe ntchito iliyonse ya Excel yomwe iwo akupeza yothandiza. Zotsatira za kusinthidwa kwake zidzalowetsedwa mu selo lofanana la mzerewu. "Total".

Onaninso:
Excel ntchito wizara
Ntchito zongogwira ntchito zoposa

Kusankha ndi kusefera

Mu tebulo lapamwamba, mwachisawawa, ikalengedwa, zipangizo zothandiza zimagwirizanitsidwa motsimikizirika zomwe zimatsimikizira kusanthula ndi kusanthula deta.

1. Monga mukuonera, pamutu, pafupi ndi maina a mndandanda mu selo iliyonse, pali zithunzi kale monga mawonekedwe a triangles. Ndi kudzera mwa iwo timapeza mwayi wopita ntchito. Dinani pa chithunzi pafupi ndi dzina la ndime yomwe ife titi tipange kusokoneza. Pambuyo pake, mndandanda wa zochitika zowoneka zikutsegulidwa.



2. Ngati ndimeyi ili ndi malemba, ndiye kuti mukhoza kugwiritsa ntchito mogwirizana ndi zilembo kapena zolemba. Kuti muchite izi, sankhani chinthucho. "Sankhani A mpaka Z" kapena "Yambani pa Z mpaka A".

   

   Pambuyo pake, mizere idzakonzedwa mu dongosolo losankhidwa.

   

   Ngati mutayesa kukonza malingaliro omwe ali ndi ndondomeko yamakono, mudzapatsidwa kusankha zosankha ziwiri. "Kuyambira kalekale kupita kwatsopano" ndi "Kuyambira pa atsopano mpaka akale".

   

   Kwa mawerengedwe a nambala, zosankha ziwiri zidzaperekedwanso: "Sungani kuyambira pazitali kufika pamtunda" ndi "Yambani kuchokera pazitali kufika pazomwe".



3. Kuti mugwiritse ntchito fyuluta, mwanjira yomweyi, timayitanitsa masitimu ndi masewera podutsa pa chithunzichi m'mbali, mogwirizana ndi deta yomwe mungagwiritse ntchito. Pambuyo pake, mndandanda timachotsa zizindikirozo kuchokera ku mfundo zomwe mizere yomwe timafuna kubisala. Pambuyo pochita zochitikazi, musaiwale kuti tisiyeni pa batani. "Chabwino" pansi pa masewera a popup.



4. Pambuyo pake, mizere yokha idzakhala ikuwonekere, pafupi ndi yomwe mwasiya nkhupakupa mu zolemba zanu. Zonse zidzabisika. Makhalidwe, makhalidwe abwino mu chingwe "Total" adzasintha nayenso. Deta ya mizere yojambulidwa silingaganizidwe polemba mwachidule ndi kufotokozera zina zonse.

   

   Izi ndi zofunika kwambiri makamaka pamene mukugwiritsa ntchito nthawi ya summation function (SUM), osati woyendetsa ZOKHUDZA IFEYO, ngakhale chikhalidwe chobisika chikaphatikizidwa mu kuwerengera.

Phunziro: Kusankha ndi kusanthula deta ku Excel

Sinthani tebulo kuzinthu zachilendo

Inde, kawirikawiri, koma nthawizina pakadalibe kusowa kwa kusintha tebulo lodziwika bwino. Mwachitsanzo, izi zikhoza kuchitika ngati mukufuna kugwiritsa ntchito njira zamakono kapena zamakina ena omwe opaleshoni ya Excel sathandiza.

1. Sankhani chilichonse chomwe chili pa tebulo. Pa tepi musunthire ku tabu "Wopanga". Dinani pazithunzi "Sinthani"yomwe ili mu chida chogwiritsa ntchito "Utumiki".



2. Pambuyo pachithunzichi, bokosi la mafunso lidzawoneka ndikufunsani ngati tikufunadi kutembenuza mapangidwe apangidwe kukhala deta yabwino? Ngati wogwiritsa ntchito akukhulupirira zochita zawo, ndiye dinani batani "Inde".



3. Pambuyo pake, tebulo limodzi lidzatembenuzidwa kuti likhale labwino lomwe malamulo onse a Excel adzakhala oyenera.

Monga momwe mukuonera, tebulo lapamwamba ndizochita zambiri kuposa momwe zimakhalira. Ndi chithandizo chake, mungathe kufulumira ndi kuchepetsa njira yothetsera ntchito zambiri. Ubwino wogwiritsa ntchito ndikuphatikizapo kuwonjezereka kwawongolera powonjezera mizere ndi mizati, fyuluta ya magalimoto, kudzigudubuza kwa maselo ndi mayendedwe, mzere wambiri ndi ntchito zina zothandiza.