Njira zoyerezera matebulo mu Microsoft Excel

Nthawi zambiri, ogwiritsira ntchito Excel akukumana ndi ntchito yoyerekeza magome awiri kapena mndandanda kuti awone kusiyana kapena zosowa zawo. Wosuta aliyense amatha kugwira ntchitoyi mwa njira yake, koma nthawi zambiri nthawi yochulukirapo yatha kuthetsa vutoli, popeza si njira zonse zothetsera vutoli. Panthawi imodzimodziyo, pali zizindikiro zambiri zomwe zidzakuthandizani kuyerekezera mndandanda kapena mndandanda wa tebulo mu nthawi yochepa ndi nthawi yochepa. Tiyeni tiwone bwinobwino njira izi.

Onaninso: Kuyerekezera malemba awiri mu MS Word

Kuyerekezera Njira

Pali njira zingapo zofananitsira malo opezeka mu Excel, koma onsewa akhoza kugawa m'magulu akulu atatu:

Ndicho chifukwa cha mndandanda uwu kuti, choyamba, njira zoyerekeza zimasankhidwa, ndipo ntchito zenizeni ndi ndondomeko zogwirira ntchitoyo zatsimikiziridwa. Mwachitsanzo, poyerekezera ndi mabuku osiyanasiyana, muyenera kutsegula maofesi awiri a Excel.

Kuwonjezera apo, ziyenera kunenedwa kuti kuyerekezera mipangidwe yamasamba kumakhala kwanzeru pokhapokha ngati ali ndi mawonekedwe ofanana.

Njira 1: njira yophweka

Njira yosavuta yoyerezera deta mu matebulo awiri ndi kugwiritsa ntchito njira yosavuta yofanana. Ngati deta ikugwirizana, ndiye ikupereka mtengo weniweni, ndipo ngati ayi, ndiye - FALSE. N'zotheka kuyerekezera, deta komanso mbiri. Chosavuta cha njira iyi ndi chakuti ingagwiritsidwe ntchito ngati deta yomwe ili patebulo idalamulidwa kapena yosankhidwa mwanjira yomweyi, yosinthidwa ndipo ili ndi nambala yofanana ya mizere. Tiyeni tiwone momwe tingagwiritsire ntchito njirayi pochita chitsanzo pa matebulo awiri omwe anaikidwa pa pepala limodzi.

Kotero, tiri ndi matebulo awiri osavuta ndi mndandanda wa antchito ndi malipiro awo. Ndikofunika kuyerekezera mndandanda wa antchito ndikuzindikiritsa kusagwirizana pakati pa zigawo zomwe mayina aikidwa.

1. Pa ichi tikusowa gawo lina pa pepala. Lowani chizindikiro pamenepo "=". Kenaka dinani chinthu choyamba kuti chifanizidwe pa mndandanda woyamba. Apanso timaika chizindikiro "=" kuchokera ku kibodiboli. Kenaka dinani selo yoyamba ya chigawocho, yomwe tikuyimirira, mu tebulo lachiwiri. Mawuwa ndi awa:

   = A2 = D2

   

   Ngakhale, komabe, pazifukwa zonse zigawozo zidzakhala zosiyana, koma chofunikacho chidzakhala chimodzimodzi.

2. Dinani pa batani Lowanikuti mupeze zotsatira za kufanana. Monga mukuonera, poyerekeza maselo oyambirira a mndandanda wonsewo, pulogalamuyi inasonyeza chizindikiro "WOONA"kutanthauza kuti deta ikugwirizana.



3. Tsopano tifunika kuchita chimodzimodzi ndi maselo otsalira a magome onse awiri omwe timawayerekezera. Koma mungathe kungosintha kapangidwe kake, komwe kadzasunga nthawi. Ichi ndi chofunikira kwambiri poyerekeza mndandanda ndi mzere wambiri.

   Njira yokopera ndi yosavuta kuchita pogwiritsira ntchito mankhwalawa. Timayika chotsitsa kumbali ya kumanja ya selo, kumene ife tiri ndi chizindikiro "WOONA". Pa nthawi yomweyo, iyenera kutembenuzidwa ku mtanda wakuda. Ichi ndi chilemba chodzaza. Dinani batani lamanzere lamanzere ndikukoka chikhomo pansi ndi chiwerengero cha mizere yomwe ikufaniziridwa ndi tebulo.



4. Monga momwe tikuonera, tsopano muzowonjezera zonse zotsatira za kufanana kwa deta muzitsulo ziŵiri zazithunzi zazithunzi zikuwonetsedwa. Kwa ife, detayi sinagwirizane ndi mzere umodzi. Poyerekeza, ndondomekoyi inapereka zotsatira "ZINTHU". Kwa mizere ina yonse, monga momwe mukuonera, fomu yofananitsa imapereka chizindikiro "WOONA".



5. Kuwonjezera apo, n'zotheka kuwerengera chiwerengero cha zosagwirizana pogwiritsa ntchito njira yapadera. Kuti muchite izi, sankhani zomwe zili pa pepala, komwe ziwonetsedwe. Kenaka dinani pazithunzi "Ikani ntchito".



6. Muzenera Oyang'anira ntchito mu gulu la ogwira ntchito "Masamu" sankhani dzina SUMPRODUCT. Dinani pa batani "Chabwino".



7. Ntchito yotsutsana zenera ikusegulidwa. SUMPRODUCTamene ntchito yake yaikulu ndikuwerengera kuchuluka kwa zinthu zomwe zasankhidwa. Koma ntchitoyi ingagwiritsidwe ntchito pa zolinga zathu. Mawu ake omasulira ndi abwino kwambiri:

   = SUMPRODUCT (array1; array2; ...)

   Zonsezi, mungagwiritse ntchito maadiresi ofika pa 255 monga zifukwa. Koma kwa ife timagwiritsa ntchito zigawo ziwiri zokha, pambali pake, ngati kutsutsana kumodzi.

   Ikani cholozera mmunda "Massive1" ndipo sankhani kusiyana kwa deta kumalo oyambirira pa pepala. Pambuyo pake timaika chizindikiro pamunda. "osati ofanana" () ndipo sankhani mtundu wofanana wa chigawochi. Kenaka, pezani ndemanga yotsatirayi ndi mabotolo, omwe tisanayikepo malemba awiri "-". Kwa ife, ife timapeza mawu awa:

   - (A2: A7D2: D7)

   Dinani pa batani "Chabwino".



8. Wogwiritsira ntchito amawerengetsa ndi kusonyeza zotsatira. Monga momwe tikuonera, kwa ife zotsatira zake ndi zofanana ndi chiwerengero "1", ndiko kuti, zikutanthawuza kuti muzinndandanda zomwe anaziyerekezera zimapezeka chimodzimodzi. Ngati mndandanda uli chimodzimodzi, zotsatirazo zidzakhala zofanana ndi nambala "0".

Mofananamo, mukhoza kulinganitsa deta m'matawo omwe ali pamapepala osiyanasiyana. Koma pakadali pano ndi zofunika kuti mizere yomwe ili mkati mwake iwerengedwe. Zonsezi zikufanana ndi zomwe tafotokoza pamwambapa, kupatulapo kuti pamene mupanga fomu, muyenera kusintha pakati pa mapepala. Kwa ife, mawuwa adzakhala ndi mawonekedwe awa:

= B2 = Mapepala2! B2

Izi ndizo, monga momwe tikuwonera, zisanayambe kulembedwa kwa ma data, omwe ali pamapepala ena, osiyana ndi momwe zotsatira za kufananitsika zikuwonetsedwa, chiwerengero cha pepala ndi chizindikiro chowonetsera chikuwonetsedwa.

Njira 2: Sankhani Magulu Amaselo

Kuyerekeza kungapangidwe pogwiritsa ntchito chida chosankhira gulu. Ndicho, mungathe kuyerekezera mndandanda wazinthu zokonzedweratu. Kuonjezerapo, pakadali pano, mndandanda uyenera kukhala pafupi wina ndi mzake pa pepala limodzi.

1. Sankhani zofananazo. Pitani ku tabu "Kunyumba". Kenako, dinani pazithunzi "Pezani ndi kuonetsa"yomwe ili pa tepiyi mu zida za zipangizo Kusintha. Mndandanda umatsegulidwa momwe muyenera kusankha malo. "Kusankha gulu la maselo ...".

   

   Kuwonjezera apo, muwindo lofunidwa la gulu la maselo akhoza kupezedwa mwanjira ina. Njirayi idzakhala yothandiza kwambiri kwa omwe amagwiritsa ntchito pulogalamuyi kuposa Excel 2007, chifukwa njirayo kudzera mu batani "Pezani ndi kuonetsa" Mapulogalamuwa samathandiza. Sankhani zinthu zomwe tikufuna kuyerekezera, ndipo dinani makiyiwo F5.

2. Kanyumba kakang'ono kakasintha kamasintha. Dinani pa batani "Konzani ..." mu ngodya yake ya kumanzere kwenikweni.



3. Pambuyo pake, mwazigawo ziwiri zomwe mwasankha, mawindo a kusankha magulu a maselo ayambitsidwa. Ikani kusinthana kuti mukhale malo "Sankhani mzere". Dinani pa batani "Chabwino".



4. Monga mukuonera, patatha izi, miyezo yosiyana ya mizere idzawonetsedwa ndi mtundu wina. Kuonjezerapo, monga momwe angayesedwere kuchokera m'zinthu zowonjezereka, pulogalamuyi idzapanga maselo omwe akugwira ntchito muzitsulo zopanda malire.

Njira 3: Kujambula Momwemo

Mukhoza kufanizitsa pogwiritsa ntchito njira yokhazikika yopangidwira. Monga mwa njira yapitayi, malo oyerekeza ayenera kukhala pa pepala limodzi la Excel ndikuvomerezana wina ndi mzake.

1. Choyamba, timasankha malo omwe tifunika kulingalira mozama ndi omwe tiyenera kuyang'ana kusiyana. Chotsatira tidzatha mu tebulo lachiwiri. Choncho, sankhani mndandanda wa antchito omwe ali mmenemo. Kusunthira ku tabu "Kunyumba", dinani pa batani "Mafomu Okhazikika"yomwe ili pa tepi mu chipika "Masitala". Kuchokera pamndandanda wotsika, pitirizani "Ulamuliro wa Malamulo".



2. Woweruza woweruza zenera watsegulidwa. Timaphatikizira mmenemo pa batani "Pangani lamulo".



3. Muwindo lazitsulo, pangani kusankha kwa malo "Gwiritsani ntchito njira". Kumunda "Sezani maselo" lembani ndondomeko yomwe ili ndi maadiresi a maselo oyambirira a mizere ya zipilala zofanana, zosiyana ndi chizindikiro "chosalingana" (). Mawu awa okha adzakhala ndi chizindikiro nthawi ino. "=". Kuwonjezera apo, kulumikiza kwathunthu kuyenera kugwiritsidwa ntchito pazitsulo zonse za mndandanda muzondomekozi. Kuti muchite izi, sankhani ndondomekoyi ndi chingwe ndipo dinani katatu pa fungulo F4. Monga mukuonera, chizindikiro cha dola chimawoneka pafupi ndi maadiresi onse, zomwe zikutanthawuza kutembenuza maulendo kukhala omvera. Pachifukwa chathu, njirayi idzatenga mawonekedwe awa:

   = $ A2 $ D2

   Tikulemba mawu awa m'munda wapamwamba. Pambuyo pake dinani pa batani "Format ...".



4. Yatsegula zenera "Sezani maselo". Pitani ku tabu "Lembani". Pano pali mndandanda wa mitundu yomwe timayimitsa kusankha mtundu umene tikufuna kujambula zinthu zimenezo pamene deta sizigwirizana. Timakanikiza batani "Chabwino".



5. Kubwerera kuwindo kuti mupange ulamuliro wopanga maonekedwe, dinani pa batani. "Chabwino".



6. Pambuyo pang'onopang'ono amasamukira kuwindo Mtsogoleri Woyang'anira dinani pa batani "Chabwino" ndi mmenemo.



7. Tsopano mu tebulo lachiwiri, zinthu zomwe zili ndi deta zomwe sizikugwirizana ndi zoyenera za dera loyamba la tebulo zidzawonetsedwa mu mtundu wosankhidwa.

Pali njira ina yogwiritsira ntchito maonekedwe ovomerezeka kuti akwaniritse ntchitoyo. Mofanana ndi zosankha zam'mbuyomu, zimadalira malo onse awiri poyerekezera ndi malo omwe ali pa pepala limodzi, koma mosiyana ndi njira zomwe zafotokozedweratu kale, chikhalidwe chosinthanitsa kapena kusanthula deta sikudzakhala kofunikira, chomwe chimasiyanitsa njira iyi kuchokera pazofotokozedwa kale.

1. Sankhani malo omwe mukufuna kuyerekezera.



2. Pangani kusintha kwa tabu wotchedwa "Kunyumba". Dinani pa batani. "Mafomu Okhazikika". Mu mndandanda wochitidwa, sankhani malo "Malamulo a kusankha kusankhidwa". Mu menyu yotsatira tikupanga kusankha kwa malo. "Ziwerengero zobwereza".



3. Fenera la kukhazikitsa zosankha zapadera lidayambika. Ngati mwachita zonse molondola, ndiye kuti pawindo ili limangokhala pang'onopang'ono. "Chabwino". Ngakhale, ngati mukukhumba, mungasankhe mtundu wosankhidwawo pawindo ili.



4. Tikachita zomwe takambiranazo, zinthu zonse zofanana zidzasankhidwa mu mtundu wosankhidwa. Zinthu zomwe sizikugwirizana zidzakhala zofiira mu mtundu wawo wakale (zoyera ndi zosasintha). Potero, mungathe kuona nthawi yomweyo kuti pali kusiyana kotani pakati pa zilembo.

Ngati mukufuna, mungathe kupenta zinthu zosagwirizana, ndipo zizindikiro zomwe zikugwirizana zingasiyidwe ndi mtundu umodzimodzi. Pankhaniyi, ndondomeko ya zochitikazo ndi zofanana, koma pazenera zowonetsera kuti ziwonetserane zamtengo wapatali m'munda woyamba m'malo mwa parameter "Kupindula" sankhani kusankha "Wapadera". Pambuyo pake, dinani pa batani "Chabwino".

Choncho, zidzakambidwa zizindikiro zomwe sizikugwirizana.

PHUNZIRO: Kujambula kwapadera pa Excel

Njira 4: njira yovuta

Mukhozanso kuyerekezera deta pogwiritsa ntchito njira yovuta, yomwe imachokera ku ntchitoyi COUNTES. Pogwiritsira ntchito chida ichi, mungathe kuwerengera kuti chigawo chilichonse chochokera m'kabokosi osankhidwa mu tebulo yachiwiri chibwereza choyamba.

Woyendetsa COUNTES limatanthawuza gulu lowerengera la ntchito. Ntchito yake ndi kuwerenga chiwerengero cha maselo omwe amayenera kukwaniritsa mkhalidwe wapatsidwa. Mphatikiti wa wogwiritsira ntchitoyi ndi motere:

= COUNTERS (muyeso; ndondomeko)

Kutsutsana "Mtundu" ndi adiresi ya mndandanda momwe ziwerengero zofanana zikuwerengedwera.

Kutsutsana "Criterion" imayika chikhalidwe cha machesi. Kwa ife, zidzakhala makonzedwe a maselo enieni mu matebulo oyamba.

1. Sankhani chinthu choyamba cha chigawo chowonjezera chomwe chiwerengero cha masewera chidzawerengedwa. Kenako, dinani pazithunzi "Ikani ntchito".



2. Kuyamba kumapezeka Oyang'anira ntchito. Pitani ku gawo "Zotsatira". Pezani mndandanda dzina "COUNTES". Mukasankha, dinani pa batani. "Chabwino".



3. Wowonjezera zotsutsana zenera akuyambitsidwa. COUNTES. Monga mukuonera, maina a minda pawindo ili likufanana ndi mayina a zifukwa.

   Ikani cholozera mmunda "Mtundu". Pambuyo pake, mutagwiritsa ntchito batani lamanzere, sankhani zamtundu uliwonse wa malembawo ndi mayina a tebulo lachiwiri. Monga mukuonera, makonzedwewo amalowa nthawi yomweyo. Koma chifukwa cha zolinga zathu, adilesiyi iyenera kukhala yeniyeni. Kuti muchite izi, sankhani makonzedwe a m'munda ndikusakani pa fungulo F4.

   Monga mukuonera, chiyanjano chatenga mawonekedwe, omwe amadziwika ndi kupezeka kwa zizindikiro za dola.

   Ndiye pitani kumunda "Criterion"poika cholozera pamenepo. Timakani pa choyamba choyamba ndi maina otsiriza muyambe ya tebulo. Pachifukwa ichi, chokani chiyanjano. Pambuyo powonetsedwa m'munda, mukhoza kudinkhani pa batani "Chabwino".



4. Chotsatiracho chikuwonetsedwa muzowonjezera pepala. Ndilofanana ndi chiwerengero "1". Izi zikutanthauza kuti mndandanda wa mayina a tebulo lachiwiri dzina lomaliza "Grinev V.P."yomwe ili yoyamba mu mndandanda wa gome loyambirira, imapezeka kamodzi.



5. Tsopano tikufunikira kupanga mawonekedwe ofanana ndi zinthu zina zonse pa tebulo yoyamba. Kuti muchite izi, lembani izi pogwiritsa ntchito chidindo chodzaza, monga momwe tachitira kale. Ikani chotsekeracho m'munsi mwachindunji cha pepala chomwe chili ndi ntchitoyi COUNTES, ndipo mutatha kuyitembenuza ku chikhomo chodzaza, gwiritsani batani lamanzere la mchenga ndi kukokera pansi.



6. Monga momwe mukuonera, pulogalamuyi inalembetsa masewero poyerekeza selo iliyonse ya tebulo yoyamba ndi deta yomwe ili muzitsamba zachiwiri. Muzochitika zinayi, zotsatirazo zinatulukira "1", komanso pazinthu ziwiri - "0". Izi ndizakuti, pulogalamuyo sichipeza mu tebulo lachiwiri zikhalidwe ziwiri zomwe zili mu tebulo yoyamba.

Inde, mawu awa kuti afanizitse zizindikiro za tebulo, angagwiritsidwe ntchito mu mawonekedwe omwe alipo, koma pali mwayi wakuwongolera.

Tiyeni tipange kuti zikhulupiliro zomwe zilipo patebulo lachiwiri, koma palibe pomwepo, zikuwonetsedwa mndandanda wosiyana.

1. Choyamba, tiyeni tikambirane njira yathu COUNTES, zomwe zimapangitsa kuti zikhale zogwirizana ndi woyendetsa ntchitoyo NGATI. Kuti muchite izi, sankhani selo yoyamba imene operekerayo ali COUNTES. Mu barra yodutsa musanayambe kuwonjezera mawuwo "NGATI" popanda ndemanga ndi kutsegula bulangi. Kenaka, kuti tipewe ntchito, timasankha mtengo mu bar. "NGATI" ndipo dinani pazithunzi "Ikani ntchito".



2. Ntchito yotsutsana yenera ikutsegula. NGATI. Monga mukuonera, munda woyamba pazenera uli kale ndi mtengo wa wogwiritsira ntchito. COUNTES. Koma tikufunika kuwonjezera chinthu china m'munda uno. Timayika pomwepo ndipo timaphatikizapo kufotokozera kale "=0" popanda ndemanga.

   Pambuyo pake pitani kumunda "Kufunika ngati zoona". Pano ife tigwiritsanso ntchito chinthu china chodyetsedwa - LINE. Lowani mawu "LINE" popanda ndemanga, kenaka mutsegule mabalawo ndikufotokozerani makonzedwe a selo yoyamba ndi dzina lomaliza mu tebulo lachiwiri, kenaka mutseke mabala. Mwachindunji, kwa ife kumunda "Kufunika ngati zoona" ali ndi mawu awa:

   LINE (D2)

   Tsopano woyendetsa LINE adzanena ntchito NGATI nambala ya mzere yomwe dzina lenilenilo ilipo, ndipo ngati vutoli likufotokozedwa mu gawo loyamba likukwaniritsidwa, ntchitoyi NGATI adzapereka chiwerengero ichi ku selo. Timakanikiza batani "Chabwino".



3. Monga mukuonera, chotsatira choyamba chikuwonetsedwa ngati "ZINTHU". Izi zikutanthauza kuti mtengowo sumakhutitsa zikhalidwe za woyendetsa. NGATI. Ndiko, dzina loyambirira likupezeka mndandanda zonsezi.



4. Pogwiritsira ntchito chikhomo chodzaza, mwachizolowezi momwe timasulira mawu a woyendetsa NGATI pamphepete yonse. Monga mukuonera, pa malo awiri omwe ali patebulo lachiwiri, koma osati poyamba, chiganizochi chimapereka manambala a mzere.



5. Bwererani kuchokera pa tablespace kupita kumanja ndi kudzaza chigawocho ndi nambala mu dongosolo, kuyambira 1. Chiwerengero cha manambala chiyenera kufanana ndi nambala ya mizere m'tawuni yachiŵiri ikufananitsidwa. Kuti muthamangitse chiwerengero cha chiwerengero, mungathe kugwiritsa ntchito chikhomo chodzaza.



6. Pambuyo pake, sankhani selo yoyamba kumanja kwa ndimeyo ndi manambala ndipo dinani pazithunzi "Ikani ntchito".



7. Kutsegulidwa Mlaliki Wachipangizo. Pitani ku gawo "Zotsatira" ndi kupanga kusankha mayina "DZINA". Dinani pa batani "Chabwino".



8. Ntchito KALE, mawindo opangira mauthenga omwe atsegulidwa, apangidwa kuti asonyeze mtengo wotsika kwambiri womwe umatchulidwa ndi akauntiyo.

   Kumunda "Mzere" tchulani zogwirizanitsa zamtundu wazowonjezera "Chiwerengero cha masewera"zomwe tinasintha kale pogwiritsa ntchito ntchitoyi NGATI. Ife timapanga onse kulumikizana mtheradi.

   Kumunda "K" onetsani chifukwa chake mtengo wotsika kwambiri uyenera kuwonetsedwa. Pano ife tikuwonetsera makonzedwe a selo yoyamba ya chigawocho ndi chiwerengero, chimene ife tawonjezerapo posachedwapa. Adilesi imasiyidwa. Dinani pa batani "Chabwino".



9. Wogwiritsa ntchito amasonyeza zotsatira - nambala 3. Izi ndizowerengeka zochepa kwambiri za mizere yosasinthika ya magome a tebulo. Pogwiritsa ntchito chikhomo chodzaza, lembani fomuyi pansi.



10. Tsopano, podziwa ziwerengero za mndandanda wa zinthu zomwe sizikufanana, tikhoza kulowa mu selo ndi zikhulupiliro zawo pogwiritsa ntchito ntchitoyi INDEX. Sankhani chinthu choyamba cha pepala chomwe chili ndi ndondomekoyi KALE. Pambuyo pake pitani ku ndondomeko ya ndondomeko ndi dzina "DZINA" lembani dzina INDEX popanda ndemanga, nthawi yomweyo mutsegule mzere ndi kuyika semicolon (;). Kenako sankhani dzina mu bar. INDEX ndipo dinani pazithunzi "Ikani ntchito".



11. Pambuyo pake, mawindo ang'onoang'ono amatsegulidwa kumene muyenera kudziwa ngati malembawo akhale ndi ntchito INDEX kapena wokonzedwa kugwira ntchito ndi zolemba. Tikusowa njira yachiwiri. Imaikidwa mwachindunji, kotero pawindo ili chabe dinani pa batani. "Chabwino".



12. Ntchito yotsutsana zenera ikuyamba. INDEX. Mawu awa adakonzedwa kuti asonyeze mtengo umene uli pamtundu wapadera mu mndandanda womwe ulipo.

    Monga mukuonera, munda "Nambala ya mzere" kale wodzaza ndi machitidwe ogwira ntchito KALE. Kuchokera ku mtengo womwe ulipo kale, chotsani kusiyana pakati pa chiwerengero cha pepala la Excel ndi chiwerengero cha mkati mwa tebulo. Monga momwe mukuonera, pamwamba pa tebulo timakhala ndi kapu. Izi zikutanthauza kuti kusiyana ndi mzere umodzi. Kotero ife tikuwonjezera mmunda "Nambala ya mzere" tanthauzo "-1" popanda ndemanga.

    Kumunda "Mzere" tchulani adiresi ya miyezo yambiri ya tebulo lachiwiri. Panthawi imodzimodziyo, timapanga mgwirizano wonse, ndiko kuti, tikuyika chizindikiro cha dola kutsogolo kwa iwo momwe tinayankhulira kale.

    Timakanikiza batani "Chabwino".



13. Titatha kutulutsa zotsatira ku skiritsi, timatambasula ntchitoyo pogwiritsa ntchito chidindo chodzaza mpaka kumapeto kwa chigawocho. Monga mukuonera, mayina onse awiri omwe ali patebulo lachiwiri, koma osati loyambirira, amawonetsedwa muzosiyana.

Njira 5: Kuyerekeza zolemba m'mabuku osiyanasiyana

Poyerekeza mitsinje yosiyanasiyana m'mabuku osiyanasiyana, mungagwiritse ntchito njira zomwe tazilemba pamwambapa, osasankha njira zomwe zikufunikanso kuyika ma tebulo awiri pa pepala limodzi. Chikhalidwe chachikulu chotsatira ndondomeko yowonetsera kufanana ndikutsegulira mawindo onse awiri panthawi yomweyo. Palibe mavuto a ma Excel 2013 komanso pambuyo pake, komanso malemba asanayambe Excel 2007. Koma mu Excel 2007 ndi Excel 2010, kuti mutsegule mawindo onse panthawi imodzimodzi, zowonjezera zofunikira zimayenera. Momwe mungachitire zimenezi akufotokozedwa mu phunziro lapadera.

PHUNZIRO: Momwe mungatsegule Excel m'mawindo osiyana

Monga mukuonera, pali mwayi wambiri woyerekeza matebulo wina ndi mzake. Chosankha chomwe mungagwiritse ntchito chimadalira ndendende pamene deta yanu ili pafupi wina ndi mzake (pa pepala limodzi, m'mabuku osiyanasiyana, pamapepala osiyanasiyana), komanso momwe wolembayo akufuna kuti kufanana kwake kuwonetsedwe pawindo.