Momwe mungasungire deta kuti ikhale yopambana

Mu Microsoft Of Extral, kuyambira mu 2007, ilinso ndi mwayi wokonza ndi kusefa maselo a matebulo. Ntchitoyi imalola mwachangu kuyendayenda kuyenda patebulo, zimawonjezera uphuluke komanso zopatsa chidwi. Nkhaniyi ifotokoza njira zoyambira kuti musefa chidziwitso mu utoto.

Kusefa fluse

Musanasinthe njira zosefera deta, ndikofunikira kusanthula zabwino zomwe zikupereka:

• Zidziwitso ndi zowunikira, zomwe zimakupatsani mwayi wosankha chidutswa cha mbaleyo ndikuchipeza mofulumira m'maselo ambiri.
• Maselo owoneka bwino a cell omwe ali ndi chidziwitso chofunikira amatha kusanthula mtsogolo.
• Kusefa mu utoto kumapereka chidziwitso chomwe chimakwaniritsa njira zomwe zatchulidwazi.

Momwe mungasinthire za utoto pogwiritsa ntchito njira zomwe zimapangidwa

Mtundu wosefera algorithm mu matebulo opambana agawidwa m'njira zotsatirazi:

1. Sankhani ma cell omwe angafune ndi fungulo lamanzere la nyumbayo ndikusamukira ku tabu "kunyumba" yomwe ili pamwamba pa pulogalamu ya Pulogalamuyi.
2. M'dera lomwe limapezeka mu gawoli, kusintha muyenera kupeza batani la "mtundu ndi sefa" ndikuyipereka podina muvi pansipa.

Zosankha za kusanja ndi kusefa deta ya tabular mu Excel

1. Mumenyu yowonetsedwa, dinani mzere wazosefera.

Pazenera losankhidwa, dinani batani la "Fyuluta"

1. Ngati zosefera zimawonjezeredwa, kenako mivi yaying'ono idzawoneka m'gulu la tebulo. Pakadali pano, ndi mivi iliyonse, wogwiritsa ntchito ayenera dinani LKM.

Arrogo adawoneka mumitu ya tebulo mutatha kuwonjezera zosefera

1. Atakakamizika muvi dzina la mzati, mndandanda wofananawo umawonetsedwa, momwe muyenera kuwerengera chingwe cha mzere. Tab zowonjezera ndi zinthu ziwiri zomwe zikupezeka zidzaululidwa: "Flaw Maluwa ofesedwa" ndi "fayilo ya utoto".

Zosankha za kusokoneza. Apa mutha kusankha mtundu uliwonse kuti ukhale pamwamba pa tebulo

1. Mu "sefa yam'manja, sankhani mthunzi womwe mukufuna kusefa tebulo pokakamiza Lkm pa iyo.
2. Onani zotsatira zake. Pambuyo kuwononga ndalama zomwe zili pamwambapa, maselo okha omwe ali ndi mtundu womwe watchulidwa kale udzakhala patebulo. Zotsalira zidzatha, ndipo mbale imachepetsedwa.

Maonekedwe a mbale yosinthidwa pambuyo posefa deta mkati mwake

Zosefera mu mndandanda wambiri zimatha kukhala pamanja, zotchinga zingwe ndi zigawo zokhala ndi mitundu yosafunikira. Komabe, wogwiritsa ntchitoyo ayenera kukhala ndi nthawi yowonjezera yochita izi.

Ngati mungasankhe mthunzi womwe mukufuna mu gawo la utoto wazosefa, mizere yokha ikhalabe mu tebulo, zolemba zomwe zalembedwa ndi mtundu wosankhidwa.

Momwe mungapangire deta pa mitundu yambiri ku Excel

Ndi kukonza mitundu ku Excel, nthawi zambiri pamakhala mavuto. Imachitika chimodzimodzi:

1. Mwa fanizo ndi mfundo yapitayo, onjezerani zosefera pa tebulo.
2. Dinani mu muvi womwe udawoneka mu dzina la nambala, ndipo mu Nont-pansi Sankhani "mtundu".

Kusankha mtundu wa utoto

1. Fotokozerani mtundu womwe mukufuna kusankha, mwachitsanzo, sankhani mthunzi womwe mukufuna mu "mzati wa foni.
2. Nditamaliza kulembako kwapakale, mizere ya mizere yokhala ndi tchati chomwe chasankhidwa kale likhala pamalo oyamba a khola. Muthanso kukonzanso mitundu yotsalira.

Zotsatira zomaliza zosintha ma cell mu tebulo

Momwe mungasewerere zidziwitso mu tebulo ndi utoto pogwiritsa ntchito ntchito yogwiritsa ntchito

Kusankha Fyuluta mu Microsoft Office Excel kuwonetsa mitundu ingapo patebulo, muyenera kupanga magawo owonjezera okhala ndi mawu odzaza. Malinga ndi mthunzi wopangidwa, zomwe zili mtsogolozi zidzasesa. Ntchito yogwiritsa ntchito bwino imapangidwa malinga ndi malangizo awa:

1. Pitani gawo la "wopanga", lomwe lili pamwamba pa menyu yayikulu ya pulogalamuyo.
2. Munthawi yomweyo tabu, dinani batani la "mawonekedwe".
3. Pulogalamu yomangidwa idzatsegulidwa, momwe mungafunikire kupanga gawo latsopano ndikulembetsa nambala.

Nambala ya pulogalamu yokhala ndi ntchito ziwiri. Choyamba chimatsimikizira mtundu wazaza chinthucho, ndipo chachiwiri chimayang'anira utoto mkati mwa khungu

Kutsatira ntchito yopangidwa, muyenera:

1. Bweretsani ku Excel Proces yogwira ntchito ndikupanga magulu awiri atsopano pafupi ndi gwero. Amatha kutchedwa "utoto wa maselo" ndi "mtundu wa mawu", motero.

Adapanga chimfine

1. M'ndime yoyamba, lembani fomu "= utoto ()". Mabakiti akuwonetsa mkangano. Muyenera kudina pafoni ndi mtundu uliwonse mu mbale.

Fomu mu Column "Mtundu wa Maselo"

1. Mu mzere wachiwiri, tchulani mkangano womwewo, koma kokha ndi utoto () "ntchito.

Formula mu Column "

1. Tambasulani zomwe zimapangitsa kuti patebulo lithe, kuzimitsa njira yonse. Zambiri zomwe zapezeka ndizomwe zimayambitsa mtundu wa khungu lililonse patebulo.

Zomwe zidapangitsa mutatambasula formula

1. Onjezani zosefera patebulo malinga ndi zomwe zili pamwambapa. Zambiri zidzasanjidwa ndi utoto.

Mapeto

Chifukwa chake, mu Ms Excel, mutha kusefa matebulo agwedeza mu mtundu wa maselo m'njira zosiyanasiyana. Njira zazikuluzikulu zosefera ndi kukonza, zomwe zimalimbikitsidwa kugwiritsa ntchito pochita ntchitoyi, takambirana pamwambapa.

Mauthenga Momwe mungasinthire deta mu utoto wowoneka woyamba kufotokozera zaukadaulo.