Kugwira ntchito ndi matebulo mu Excel

Excel amaonedwa ndi ambiri ngati pulogalamu ya spreadsheet. Choncho, funso la momwe mungapangire ndikugwira ntchito ndi matebulo likhoza kuwoneka lachilendo poyamba. Koma anthu ochepa amadziwa kusiyana kwakukulu pakati pa Excel ndi spreadsheets. Kuphatikiza apo, gawo ili la phukusi la Microsoft Office silimalumikizana nthawi zonse ndi ma spreadsheets. Komanso, ntchito yayikulu ya Excel ndikukonza zidziwitso zomwe zitha kuperekedwa m'njira zosiyanasiyana. Komanso mu mawonekedwe a tabular.

Kapena vuto likhoza kubwera pakafunika kusankha mtundu wosiyana wa tebulo ndikuupanga moyenerera. Nthawi zambiri, pali mwayi wambiri wogwiritsa ntchito matebulo, kotero tiyeni tiwone mwatsatanetsatane.

Lingaliro la matebulo anzeru

Padakali kusiyana pakati pa pepala la Excel ndi spreadsheet yanzeru. Choyamba ndi malo omwe ali ndi chiwerengero cha maselo. Ena a iwo akhoza kudzazidwa ndi mfundo zina, pamene ena alibe kanthu. Koma palibe kusiyana kwakukulu pakati pawo kuchokera pamalingaliro aukadaulo.

Koma Excel spreadsheet ndi lingaliro losiyana kwambiri. Sizimangotengera kuchuluka kwa data, ili ndi zake, dzina, kapangidwe kake komanso zabwino zambiri.

Chifukwa chake, mutha kusankha dzina losiyana la tebulo la Excel - "Smart Table" kapena Smart Table.

Pangani tebulo lanzeru

Tiyerekeze kuti tapanga mtundu wa data wokhala ndi zambiri zogulitsa.

Pakali pano si tebulo. Kuti musinthe mawonekedwe, muyenera kusankha ndikupeza tabu ya "Insert" ndipo pezani batani la "Table" mu chipika cha dzina lomwelo.

Zenera laling'ono lidzawoneka. Momwemo, mutha kusintha ma cell omwe mukufuna kusintha kukhala tebulo. Kuphatikiza apo, muyenera kufotokoza kuti mzere woyamba uli ndi mitu yandalama. Mutha kugwiritsanso njira yachidule ya kiyibodi Ctrl + T kuti mubweretse bokosi lomwelo.

Kwenikweni, palibe chomwe chiyenera kusinthidwa nthawi zambiri. Chochitacho chikatsimikiziridwa ndikukanikiza batani la "Chabwino", mndandanda womwe wasankhidwa kale udzakhala tebulo.

Musanakhazikitse mwachindunji katundu wake, muyenera kumvetsetsa momwe pulogalamuyo imawonera tebulo. Pambuyo pake, zinthu zambiri zidzawonekera.

Kumvetsetsa Mapangidwe a Table ya Excel

Matebulo onse ali ndi dzina lachindunji lowonetsedwa pa tabu yapadera ya Design. Imawonetsedwa pambuyo posankha cell iliyonse. Mwachikhazikitso, dzina limatenga mawonekedwe "Table 1" kapena "Table 2", ndipo motsatana.

Ngati mukufunikira kukhala ndi matebulo angapo m'chikalata chimodzi, ndibwino kuti muwapatse mayina otere kuti pambuyo pake mumvetse zomwe zili. M'tsogolomu, zidzakhala zosavuta kuyanjana nawo, kwa inu komanso kwa anthu omwe akuwona chikalata chanu.

Kuphatikiza apo, matebulo otchulidwa amatha kugwiritsidwa ntchito mu Power Query kapena zowonjezera zina.

Tiyeni titchule tebulo lathu "Ripoti". Dzinalo likhoza kuwoneka pawindo lotchedwa dzina manager. Kuti mutsegule, muyenera kutsatira njira iyi: Mafomula - Mayina Ofotokozedwa - Woyang'anira Dzina.

Ndizothekanso kulowa pamanja chilinganizo, pomwe mutha kuwonanso dzina la tebulo.

Koma chosangalatsa kwambiri ndichakuti Excel imatha kuwona tebulo nthawi imodzi m'magawo angapo: yonse, komanso m'mizere, mitu, ziwerengero. Ndiye maulalo adzawoneka chonchi.

Kawirikawiri, zomanga zoterezi zimaperekedwa kokha ndi cholinga chowongolera molondola. Koma palibe chifukwa chowaloweza. Amangowonetsedwa pazowonjezera zomwe zimawonekera mutasankha Table ndi momwe mabakiti apakati adzatsegulire. Kuti muwaike, choyamba muyenera kuyatsa masanjidwe a Chingerezi.

Njira yomwe mukufuna ingapezeke pogwiritsa ntchito kiyi ya Tab. Musaiwale kutseka mabatani onse omwe ali mu fomula. Mabwalo ndi chimodzimodzi pano. 

Ngati mukufuna kuwerengera zomwe zili mugawo lonse ndi malonda, muyenera kulemba zotsatirazi:

=SUM(D2:D8)

Pambuyo pake, zidzasintha zokha = SUM(Ripoti[Zogulitsa]). M'mawu osavuta, ulalo umatsogolera ku gawo linalake. Zosavuta, kuvomereza?

Chifukwa chake, tchati chilichonse, chilinganizo, mtundu, pomwe tebulo lanzeru lidzagwiritsidwa ntchito potengera deta kuchokera pamenepo, lidzagwiritsa ntchito zidziwitso zaposachedwa zokha.

Tsopano tiyeni tikambirane mwatsatanetsatane za matebulo omwe angakhale ndi katundu.

Matebulo a Excel: Properties

Tebulo lililonse lopangidwa likhoza kukhala ndi mitu yambiri. Mzere woyamba wamtunduwu umakhala ngati gwero la data.

Kuonjezera apo, ngati kukula kwa tebulo kuli kwakukulu kwambiri, pamene mukuyenda pansi, mmalo mwa zilembo zomwe zimasonyeza zipilala zogwirizana, mayina azitsulo akuwonetsedwa. Izi zidzakhala zokonda kwa wogwiritsa ntchito, popeza sikudzakhala kofunikira kukonza madera pamanja.

Zimaphatikizanso zosefera zokha. Koma ngati simukuzifuna, mutha kuzimitsa nthawi zonse pazokonda.

Komanso, zikhalidwe zonse zomwe zalembedwa pansipa pagawo lomaliza la tebulo zimamangiriridwa payokha. Choncho, angapezeke mwachindunji mu chinthu chilichonse chomwe chimagwiritsa ntchito deta kuchokera pamzere woyamba wa tebulo mu ntchito yake.

Nthawi yomweyo, ma cell atsopano amapangidwa kuti apange tebulo, ndipo mafomu onse okhudzana ndi gawoli amalembedwamo. M'mawu osavuta, kuti muwonjezere kukula kwa tebulo ndikulikulitsa, ingolowetsani deta yolondola. Zina zonse zidzawonjezedwa ndi pulogalamuyi. Zomwezo zimapitanso ndi magawo atsopano.

Ngati fomula yalowetsedwa mu selo imodzi, ndiye kuti imafalikira kugawo lonse. Ndiye kuti, simuyenera kudzaza pamanja ma cell, chilichonse chizichitika zokha, monga momwe tawonetsera pazithunzi zojambulidwa.

Zonsezi ndi zabwino. Koma mutha kusintha tebulo nokha ndikukulitsa magwiridwe antchito ake.

Kukonzekera kwa tebulo

Choyamba muyenera kutsegula tabu "Wopanga", pomwe magawo a tebulo ali. Mutha kuzisintha mwa kuwonjezera kapena kuchotsa mabokosi enieni omwe ali pagulu la "Table Style Options".

Zosankha zotsatirazi zaperekedwa:

1. Onjezani kapena chotsani mzere wamutu.
2. Onjezani kapena chotsani mzere wokhala ndi ziwopsezo.
3. Pangani mizere mosinthana.
4. Onetsani mizati mozama kwambiri.
5. Imayatsa kapena kuyimitsa kudzaza kwa mizere.
6. Zimitsani zosefera zokha.

Mukhozanso kukhazikitsa mtundu wina. Izi zitha kuchitika pogwiritsa ntchito zosankha zomwe zili mugulu la Masitayelo a Table. Poyambirira, mawonekedwewo ndi osiyana ndi omwe ali pamwambapa, koma momwemo mutha kusintha mawonekedwe omwe mukufuna.

Mutha kupezanso gulu la "Zida", pomwe mutha kupanga pivot table, kufufuta makope, ndikusintha tebulo kukhala mulingo wokhazikika.

Koma chinthu chosangalatsa kwambiri ndicho kupanga magawo.

Kagawo ndi mtundu wa fyuluta yomwe imawonetsedwa pazithunzi zosiyana. Kuti muyike, muyenera dinani batani la "Insert Slicer" la dzina lomwelo, ndikusankha mizati yomwe mukufuna kusiya.

Ndi zimenezo, tsopano gulu likuwonekera, lomwe limalemba zonse zapadera zomwe zili m'maselo a gawoli.

Kuti musefe tebulo, muyenera kusankha gulu lomwe lili ndi chidwi kwambiri pakadali pano.

Magawo angapo amatha kusankhidwa pogwiritsa ntchito chodulira. Kuti muchite izi, muyenera kukanikiza Ctrl kiyi kapena dinani batani lomwe lili pakona yakumanja kumanzere ndikuchotsa zosefera musanayambe kusankha.

Kuti muyike magawo mwachindunji pa riboni, mutha kugwiritsa ntchito tabu ya dzina lomwelo. Ndi chithandizo chake, mutha kusintha mawonekedwe osiyanasiyana agawo: mawonekedwe, kukula kwa batani, kuchuluka, ndi zina zotero.

Zolepheretsa Zazikulu za Smart Tables

Ngakhale kuti ma spreadsheets a Excel ali ndi zabwino zambiri, wogwiritsa ntchito amayenera kupirira zovuta zina:

1. Malingaliro sagwira ntchito. M'mawu osavuta, palibe njira yokumbukira magawo ena a pepala.
2. Simungathe kugawana bukuli ndi munthu wina.
3. Sizingatheke kuyika ma subtotals.
4. Simungagwiritse ntchito mitundu yosiyanasiyana.
5. Palibe njira yolumikizira ma cell. Koma sikovomerezeka kutero.

Komabe, pali zabwino zambiri kuposa zovuta, kotero zovuta izi sizingawonekere.

Zitsanzo za Smart Table

Tsopano ndi nthawi yoti tikambirane za momwe ma spreadsheets anzeru a Excel amafunikira komanso zomwe zingachitike zomwe sizingatheke ndi mtundu wamba.

Tiyerekeze kuti tili ndi tebulo losonyeza malisiti a ndalama zogulira T-shirts. Mzere woyamba uli ndi mayina a mamembala a gululo, ndipo ena - ndi T-shirts angati omwe anagulitsidwa, ndi kukula kwake. Tiyeni tigwiritse ntchito tebulo ili ngati chitsanzo kuti tiwone zomwe zingatheke zomwe zingatheke, zomwe sizingatheke pazochitika zokhazikika.

Kufotokozera mwachidule ntchito za Excel

Pazithunzi pamwambapa, mutha kuwona tebulo lathu. Tiyeni tifotokoze mwachidule makulidwe onse a T-shirts payekhapayekha. Ngati mugwiritsa ntchito kuchuluka kwa data kuti mukwaniritse cholingachi, muyenera kulowetsa pamanja mafomu onse. Ngati mupanga tebulo, ndiye kuti cholemetsachi sichidzakhalaponso. Ndikokwanira kungophatikiza chinthu chimodzi, ndipo pambuyo pake mzere wokhala ndi ziwopsezo udzapangidwa wokha.

Kenako, dinani pomwepa pamalo aliwonse. Menyu yowonekera imawonekera ndi chinthu cha "Table". Ili ndi mwayi "mzere wonse", womwe muyenera kuyiyambitsa. Ikhoza kuwonjezeredwa kudzera mwa womanga.

Kupitilira apo, mzere wokhala ndi ziwopsezo ukuwonekera pansi patebulo. Mukatsegula menyu yotsitsa, mutha kuwona makonda awa:

1. Avereji.
2. Kuchuluka.
3. Kuchuluka.
4. kupatuka kwa offset.

Ndi zina zambiri. Kuti mupeze ntchito zomwe sizinaphatikizidwe pamndandanda womwe uli pamwambapa, muyenera kudina "Zinthu Zina". Apa ndi yabwino kuti osiyanasiyana anatsimikiza basi. Tasankha ntchito SUM, chifukwa kwa ife tiyenera kudziwa kuti ndi T-shirts zingati zomwe zinagulitsidwa pamodzi.

Kulowetsamo ma fomula

Excel ndi pulogalamu yanzeru kwambiri. Wogwiritsa ntchito sangadziwe nkomwe kuti akuyesera kulosera zomwe adzachita. Tawonjezera chigawo kumapeto kwa tebulo kuti tifufuze zotsatira za malonda kwa aliyense wa ogula. Pambuyo poyika fomulo mumzere woyamba, imakopera nthawi yomweyo ku maselo ena onse, ndiyeno gawo lonselo limadzazidwa ndi zomwe timafunikira. Womasuka?

mtundu ntchito

Anthu ambiri amagwiritsa ntchito menyu yankhani kuti agwiritse ntchito izi kapena izi. Pali pafupifupi zochita zonse zomwe nthawi zambiri zimafunikira kuchitidwa. Ngati mugwiritsa ntchito matebulo anzeru, ndiye kuti magwiridwe antchito amakula kwambiri.

Mwachitsanzo, tiyenera kuyang'ana yemwe adasamutsa kale kulipira. Kuti muchite izi, muyenera kusanja deta ndi gawo loyamba. Tiyeni tipange malemba m'njira yoti tithe kumvetsetsa yemwe wapereka kale malipiro, omwe sanapereke, ndi omwe sanapereke zikalata zofunika pa izi. Yoyamba idzakhala yobiriwira, yachiwiri yofiira, ndipo yachitatu ndi yabuluu. Ndipo tiyerekeze kuti takumana ndi ntchito yowasonkhanitsa pamodzi. 

Komanso, Excel imatha kukuchitirani chilichonse. 

Choyamba muyenera dinani pa menyu yotsitsa yomwe ili pafupi ndi mutu wa gawo la "Dzina" ndikudina chinthucho "Sort by color" ndikusankha mtundu wofiira.

Chilichonse, tsopano chidziwitso cha yemwe adalipira chikuwonetsedwa momveka bwino. 

Kusungunula

Ndizothekanso kusintha mawonekedwe ndi kubisala zina za tebulo. Mwachitsanzo, ngati mukufuna kuwonetsa anthu okhawo omwe sanalipire, mutha kusefa deta ndi mtundu uwu. Kusefa ndi magawo ena kumathekanso.

Mawuwo

Chifukwa chake, ma spreadsheets anzeru ku Excel adzakhala othandiza kwambiri pothana ndi zovuta zilizonse zomwe muyenera kukumana nazo.