Kupanga matebulo achidule mu Excel

Ma tebulo la chidule cha Excel amapatsa ogwiritsa ntchito malo amodzi kuti akhale ndi magulu ambiri omwe ali ndi zidziwitso zambiri zomwe zidapezeka m'matebulo ambiri, komanso malipoti athunthu. Makhalidwe awo amasinthidwa zokha mukasintha mtengo wa tebulo lililonse logwirizana. Tiyeni tiwone momwe mungapangire chinthu chotere ku Microsoft Excel.

Kupanga tebulo la pivot ku Excel

Popeza, kutengera zotsatira zake, zomwe wogwiritsa ntchito akufuna kulandira, tebulo lophatikizidwa limatha kukhala losavuta komanso lovuta kufotokoza, tiwona njira ziwiri zotipangitsire: pamanja ndikugwiritsa ntchito pulogalamu ya chida. Kuphatikiza apo, tikukuwuzani momwe zinthu zotere zimakonzedwera.

Njira 1: Tebulo lachidule

Tikambirana njira yopangira chitsanzo cha Microsoft Excel 2010, koma algorithm imagwira ntchito m'malo ena amakono a pulogalamuyi.

1. Monga maziko, timatenga tebulo la kulipira ndalama kwa ogwira ntchito. Ili ndi mayina a ogwira ntchito, pansi, gulu, tsiku ndi ndalama zolipira. Ndiye kuti, gawo lililonse la zolipira kwa wogwira ntchito chosiyana limafanana ndi mzere wosiyana. Tiyenera kukhala ndi zigawo zomwe zili patebulo patebulo ili patebulo limodzi, ndipo chidziwitsocho chidzatengedwera kotala lachitatu la 2016. Tiyeni tiwone momwe tingachitire izi mwachitsanzo.
2. Choyamba, timasintha tebulo lamphamvu kukhala lamphamvu. Ndikofunikira kuti mukhale ndi tebulo lophatikizidwa ndikuwonjezera mizere ndi zina. Timanyamula chotemberero ku khungu lililonse, masitayilo "limakhala pa tepi, dinani mtundu wa" batani "ndikusankha mawonekedwe a tebulo.



3. Bokosi la zokambirana limatseguka, lomwe timapereka kuti tifotokozere za malo asanja. Komabe, mosakayikira, magwiritsidwewo amathandizira kuti pulogalamuyi imathandizira, ndikuphimba tebulo lonse. Chifukwa chake titha kuvomera ndikudina pa "Ok". Koma ogwiritsa ntchito ayenera kudziwa kuti ngati angafune, amatha kusintha maofesiwa pano.



4. Gome limasandulika kukhala lamphamvu komanso lotambalala. Amakhalanso ndi dzina loti, ngati angafune, wosuta amatha kusintha kukhalako kosavuta. Mutha kuwona kapena kusintha dzina pa Tab.



5. Kuyamba mwachindunji kupanga, sankhani "kuyika". Apa tadina batani loyamba mu riboni, lomwe limatchedwa "tebulo lachidule". Menyu itsegulidwa, komwe muyenera kusankha kuti tipangire: tebulo kapena tchati. Pamapeto, dinani "Chidule Chake".



6. Pawindo latsopano, tifunika kusankha mtundu kapena patebulo. Monga mukuwonera, pulogalamuyo yokhayo idakonzekeretsa dzina la tebulo lathu, motero sichofunikira kuchita china chilichonse. Pansi pa bokosi la zokambirana, mutha kusankha malo omwe tebulo lachidule lipangidwira: pa pepala latsopano (lokhazikika) kapena chimodzimodzi. Zachidziwikire, nthawi zambiri, ndizosavuta kuzisunga papepala lina.



7. Pambuyo pake, pa pepala latsopano, mawonekedwe opangira tebulo la pivot litsegulidwa.
8. Gawo loyenerera lazenera ndi mndandanda wa minda, ndipo pansi pa madera anayi: Mayina Amtundu, Mayina, Mayina, Makhalidwe Abwino, Rustore. Ndikungokoka magome a tebulo m'malo oyenera m'dera lomwe mukufuna. Palibe lamulo lokhazikika lomwe, lomwe minda iyenera kusunthidwa, chifukwa zonse zimatengera tebulo loyambirira komanso ntchito zina zomwe zingayambike.



9. M'mayiko a konkriti, tinalimbikitsa m'mindayo "Paul" ndi "deti" ku Fyuluta ya reasert, "gulu la" "-" M'miyezo " Tiyenera kudziwa kuti kuwerengera konse kwa deta, taut kuchokera patebulo lina, ndizotheka m'dera lotsiriza. Ngakhale tachita zoterezi ndikusamutsa minda m'derali, tebulo lokhalo kumanzere kwa zenera, motero.



10. Idakhala tebulo lotere. Zosefera pansi ndi tsiku zimawonetsedwa pamwamba pake.

Njira yachiwiri: Master of the Deary Ma tebulo

Mutha kupanga tebulo lachidule pogwiritsa ntchito chida "chidule", koma chifukwa izi zimafunikira kuchotsera ku "gulu lolowera mwachangu".

1. Pitani ku menyu ya "fayilo" ndikudina pa "magawo".



2. Timapita ku gawo la "Pagawo la Ntchito Yachangu" ndikusankha malamulo kuchokera ku malamulo pa tepi. Pamndandanda wa zinthu zomwe akufuna "mbuye wa matebulo ndi matebulo. Tikutsindika, dinani batani la "Onjezani", kenako "Chabwino".



3. Chifukwa cha zochita zathu pa "Pancy Log Lotrack" Incon yatsopano idawonekera. Dinani pa Iwo.



4. Pambuyo pake, "chidule" chimatsegulidwa. Pali zosankha zinayi zomwe zimayambitsa deta, kuchokera komwe kuli chidule, chomwe timatchulanso zoyenera chidzapangidwe. Pansipa kuyenera kusankha kuti tikupanga: tebulo kapena tchati. Timasankha ndikupita "Kenako".



5. Zenera limawonekera ndi tebulo la data ndi deta, lomwe lingasinthidwe ngati mukufuna. Sitifunikira kuchita izi, chifukwa chake timangopita ku "Kenako".



6. Ndiye "mbuye wa magome achinsinsi" amapereka kusankha malo omwe chinthu chatsopano chidzapezeke: patsamba lomwelo kapena pa watsopano. Timapanga kusankha ndikutsimikizira kuti ndi "kumaliza".



7. Tsamba latsopano limatsegulidwa ndendende ndi mawonekedwe omwewo omwe anali ndi njira yokhazikika yopangira tebulo la pivot.
8. Zochita zina zonse zimachitidwa pa algorithm yemweyo yemwe wafotokozedwa pamwambapa (onani njira 1).

Kukhazikitsa tebulo lophatikizidwa

Tikamakumbukira kuchokera momwe ntchitoyo, tebulo liyenera kupitiliza kotala lachitatu. Pakadali pano, zambiri zimawonetsedwa nthawi yonseyi. Tiyeni tisonyeze chitsanzo cha momwe mungapangire kuti zikhale.

1. Kuti mubweretse tebulo pazomwe mukufuna, dinani batani pafupi ndi "Tsiku". Mmenemo, tinakhazikitsa msana wolembedwa "Sankhani zinthu zingapo". Chotsatira, chotsani mabokosi kuchokera masiku onse omwe sakugwirizana ndi nthawi yachitatu. Kwa ife, iyi ndi tsiku limodzi lokha. Tsimikizani zomwe zachitikazo.



2. Momwemonso, titha kugwiritsa ntchito fyuluta pansi ndikusankha malipoti, mwachitsanzo, amuna amodzi okha.



3. Tebulo lophatikizidwa limapeza mtunduwu.



4. Kuti muwonetsetse kuti mutha kuyang'anira zidziwitso patebulo momwe mungafunire, tsegulani fomu yamunda. Pitani ku "magawo" tabu, ndikudina pamndandanda wa "mndandanda wa minda". Timasuntha mutu "Tsiku" kuchokera ku Fyuluta ya lipotilo "mu" mu dzina la mzere ", ndipo pakati pa gulu la" gulu la Paulo "ndi" Paulo "limatulutsa kusinthanitsa kwa malo. Ntchito zonse zimachitika pogwiritsa ntchito zigawo zosavuta.



5. Tsopano tebulo limawoneka losiyana kwambiri. Ming'alu imagawidwa ndi minda, kuwonongeka kwa miyezi kumawonekera mu mizere, ndipo Fyulutayi ikhoza kuchitidwa ndi gulu la ogwira ntchito.



6. Ngati mndandanda wa minda, dzina la zingwe zimasuntha ndikuyika tsiku lomwe lili pamwambapa kuposa dzinalo, ndiye kuti tsiku lomaliza limagawidwa kukhala mayina antchito.



7. Muthanso kuonetsa mfundo za manambala a tebulo monga histogram. Kuti tichite izi, sankhani khungu lomwe lili ndi tsamba la manambala, tabu "kunyumba", dinani "mawonekedwe", sankhani "nkhani" komanso tchulani malingaliro ngati.



8. Histogram imangowoneka mu khungu lomwelo. Kutsatira lamulo la histogram pamaselo onse a tebulo, dinani batani, lomwe lidawonekera pafupi ndi histogram, ndipo pazenera lomwe limatsegulira, timamasulira mbali zonse za "ma cell onse".



9. Zotsatira zake, tebulo lathu la pivot linayamba kuwoneka zowoneka bwino.

Njira yachiwiri yodzikongoletsera imapereka zinthu zinanso, koma nthawi zambiri magwiridwe antchito a kusiyanasiyana kuti athe kugwira ntchitozo. Magome achidule amatha kupanga deta kuti afotokozere pafupifupi njira iliyonse yomwe wogwiritsa ntchito amalongosola m'magawo.