Pogwira ntchito ku Excel, nthawi zina muyenera kuwerengera mizere mumizere inayake. Pali njira zingapo zochitira izi. Tisanthula za algorithm pochita njirayi pogwiritsa ntchito njira zosiyanasiyana.
Kuwona kuchuluka kwa mizere
Pali njira zambiri zowonetsera kuchuluka kwa mizere. Mukamagwiritsa ntchito, zida zosiyanasiyana zimagwiritsidwa ntchito. Chifukwa chake, muyenera kuyang'ana pa mlandu kuti musankhe njira yoyenera.
Njira 1: zolemba patali
Njira yosavuta yothetsera ntchitoyi mumtundu wosankhidwa ndikuyang'ana nambala yomwe ili mu bar. Kuti muchite izi, ingosankha mtundu womwe mukufuna. Ndikofunikira kudziwa kuti kachitidwe kameneka kamawerengera kalikonse ndi deta ya gawo lina. Chifukwa chake, kuti tipewe kuwerengera kawiri, popeza tifunikira kudziwa kuchuluka kwa mizere, timasankha gawo limodzi pagawo la kafukufuku. Pampiringidzo wa mawu pambuyo pa mawu "Kuchuluka" kumanzere kwa batani kusinthitsa mabatani, chizindikiritso cha kuchuluka kwa zinthu zomwe zadzazidwa mumtundu wosankhidwa ziwoneka.
Zowona, izi zimachitikanso ngati mulibe mizere yonse patebulopo, ndipo mzere uliwonse umakhala ndi mfundo. Pankhaniyi, tikasankha gawo limodzi lokha, ndiye kuti zinthu zomwe sizili ndi chitsimikizo siziphatikizidwanso pakuwerengera. Chifukwa chake, sankhani mwachidule mzere, kenako, ndikugwira batani Ctrl dinani pa maselo odzazidwa, m'mizereyo yomwe simunapezeke muzosankhidwa. Poterepa, musapange cell yoposa imodzi pamzere uliwonse. Chifukwa chake, batani ya mawonekedwe idzawonetsa kuchuluka kwa mizere yonse mumigawo yosankhidwa momwe khungu limodzi lodzaza.
Koma pamakhala nthawi zina mukasankha maselo odzazidwa m'mizere, ndikuwonetsa kwa chiwerengerocho pazomwe mulibe. Izi zikutanthauza kuti mawonekedwewa ndi olumala chabe. Kuti muzitha, dinani kumanja pa bar yamugulu ndi menyu omwe akuwoneka, yang'anani bokosi pafupi ndi mtengo wake "Kuchuluka". Tsopano chiwerengero cha mizere yosankhidwa chikuwonetsedwa.
Njira 2: gwiritsani ntchito ntchito
Koma, njira yomwe ili pamwambapa siyimalola kukonza zotsatira zowerengera m'dera linalake papepala. Kuphatikiza apo, zimapereka mwayi kuwerengera mizere yokha momwe mfundo zilipo, ndipo nthawi zina ndikofunikira kuwerengera zinthu zonse zomwe zaphatikizidwa, kuphatikiza zopanda kanthu. Poterepa, ntchitoyo ipulumutsa CHARTI. Matchulidwe ake ndi awa:
= STROKE (gulu)
Itha kuyendetsedwa mu selo iliyonse yopanda pepala, koma ngati mkangano Menya sinthanitsani maulalo omwe mumafuna kuwerengera.
Kuti muwonetse zotsatira pazenera, dinani Lowani.
Komanso, ngakhale mizere yopanda kanthu idzawerengedwa. Ndizofunikira kudziwa kuti, mosiyana ndi njira yapita, mukasankha dera lomwe lili ndi mizati ingapo, wothandizira amangoganizira mizere.
Ndiosavuta kwa ogwiritsa ntchito omwe sadziwa zambiri zama fomu ku Excel kuti azigwira ntchito ndi opangirawo Fotokozerani Wizard.
- Sankhani khungu lomwe gawo lomwe mwamaliza kuwerenga pazinthuzo lizitulutsa. Dinani batani "Ikani ntchito". Ili pomwepo kumanzere kwa baramu yamu formula.
- Zenera laling'ono limayamba Ogwira Ntchito. M'munda "Magulu" khazikitsani malo Malingaliro ndi Kufika kapena "Mndandanda wathunthu wa zilembo". Kuyang'ana phindu CHSTROK, sankhani ndikudina batani "Zabwino".
- Ntchito yotsutsana ndi ntchito imatsegulidwa. Ikani wolemba m'munda Menya. Sankhani masanjidwewo patsamba, kuchuluka kwa mizere yomwe mukufuna kuwerengera. Pambuyo pazolumikizana za malowa zikuwonetsedwa pazenera la zokangana, dinani batani "Zabwino".
- Pulogalamuyi imayendetsa zidziwitso ndikuwonetsa zotsatira za kuwerengera mizere mu khungu lomwe limatchulidwa kale. Tsopano chiwonetserochi chikuwonetsedwa mderali pafupipafupi, ngati simungaganize kuzimitsa pamanja.
Phunziro: Excel Feature Wizard
Njira 3: gwiritsani ntchito zojambula zojambula
Koma pali nthawi zina pamene pakufunika kuwerengetsa mizere yonse, koma okhawo omwe akukwaniritsa gawo linalake. Poterepa, kuwongolera pamitundu yonse ndikujambulani pambuyo pake kudzakuthandizani
- Sankhani mtundu womwe mukayang'ana.
- Pitani ku tabu "Pofikira". Pa nthiti yomwe ili m'bokosi la chida Masitaelo dinani batani Njira Zakukonzerani. Sankhani chinthu Malamulo Osankha Maselo. Kenako, chinthu cha malamulo osiyanasiyana chimatsegulidwa. Mwachitsanzo, timasankha "Zambiri ...", ngakhale pa milandu ina kusankha kumayimitsidwa kwina.
- A zenera limatseguka momwe mkhalidwe udayikidwira. M'munda wakumanzere, tchulani nambala, maselo omwe amaphatikiza mtengo woposa womwe utapakidwa utoto. M'munda woyenera, ndizotheka kusankha mtundu uwu, koma mutha kuwusiya mwangwiro. Pambuyo kukhazikitsa zinthu kumaliza, dinani batani "Zabwino".
- Monga mukuwonera, zitatha izi maselo omwe amakhutitsa mkhalidwewo adasefukira ndi utoto wosankhidwa. Sankhani mfundo zamitundu yonse. Kukhala mu chilichonse mumtundu womwewo "Pofikira"dinani batani Sanjani ndi Fyuluta pagulu lazida "Kusintha". Pamndandanda womwe umawonekera, sankhani "Zosefera".
- Pambuyo pake, chithunzi cha fyuluta chimawonekera mumitu ya mzere. Timadula patsamba lomweli pomwe zosinthazo zidachitidwa. Pazosankha zomwe zimatsegulira, sankhani "Sulani ndi utoto". Kenako, dinani mtundu womwe unadzaza maselo osanjidwa omwe amakwaniritsa zomwe zili.
- Monga mukuwonera, maselo osakhala ndi mawonekedwe zitachitika izi kuti zobisika. Ingosankhani maselo otsala osiyanasiyana ndikuyang'ana "Kuchuluka" m'mbali mwa mawonekedwe, monga kuthetsa vutolo m'njira yoyamba. Ndi nambala iyi yomwe izisonyeza kuchuluka kwa mizere yomwe ikukwaniritse vuto linalake.
Phunziro: Zowongolera mu Excel
Phunziro: Sanjani ndi kusefa deta mu Excel
Monga mukuwonera, pali njira zingapo zopezera kuchuluka kwa mizere mu chidutswa chosankhidwa. Iliyonse ya njirazi ndi yoyenera pazolinga zapadera. Mwachitsanzo, ngati mukufuna kukonza zotsalazo, ndiye kuti njira iyi ndi ntchito ndiyoyenera, ndipo ngati ntchitoyo ndi kuwerengera mizere yomwe ikukwaniritsidwa, ndiye kuti mtundu wa mafayilo osinthidwa ndi mafayilo omaliza adzakuthandizani.
