Kudzaza kwa khungu potengera phindu mu Microsoft Excel

Pogwira ntchito ndi matebulo, zomwe zimawonetsedwa ndizofunikira kwambiri. Koma chinthu chofunikira ndimapangidwe ake. Ogwiritsa ntchito ena amawona kuti ichi ndi chinthu chachiwiri ndipo samachita nawo chidwi. Koma pachabe, chifukwa gome lopangidwa mwaluso ndi gawo lofunika kuti lizindikire ndi kuzindikira kwa ogwiritsa ntchito. Udindo wofunikira kwambiri umachitika pakuwona. Mwachitsanzo, pogwiritsa ntchito zida zowonera, mutha kupaka maselo a tebulo kutengera zolemba zawo. Tiyeni tiwone momwe izi zingachitikire ku Excel.

Njira yosinthira mtundu wamaselo malinga ndi zomwe zilimo

Zachidziwikire, nthawi zonse zimakhala bwino kukhala ndi tebulo lopangidwa bwino momwe maselo, kutengera zomwe zilipo, amapaka utoto wosiyanasiyana. Koma izi ndizofunikira makamaka pamatafura akulu omwe ali ndi kuchuluka kwa deta. Potere, kudzaza maselo ndi utoto kudzathandizira chidwi cha ogwiritsa ntchito pazambiri izi, popeza zinganenedwe kuti zidapangidwa kale.

Mutha kuyesa kusintha utoto wa mapepala pamanja, koma kachiwiri, ngati tebulo ndi lalikulu, zimatenga nthawi yambiri. Kuphatikiza apo, pamakonzedwe amtundu wotere, chinthu chaumunthu chitha kutenga nawo gawo ndipo zolakwitsa zimapangidwa. Osanena kuti tebulo limatha kukhala lamphamvu komanso zomwe zimasinthidwa nthawi ndi nthawi, komanso zochuluka. Pakadali pano, kusintha kwamtundu wamunthu nthawi zambiri kumakhala kosatheka.

Koma pali njira yotulukirapo. Maselo omwe ali ndi mphamvu (zosintha) zamphamvu, zojambula zamagetsi zimagwiritsidwa ntchito, ndipo paziwerengero mutha kuzigwiritsa ntchito Pezani ndi Kusintha.

Njira 1: Zowongolera Zinthu

Pogwiritsa ntchito mawonekedwe anu, mungatchule malire amomwe ma cell amapangidwe utoto umodzi. Madontho adzachitika zokha. Ngati mtengo wamaselo, chifukwa cha kusinthako, ukupita kupitirira malire, ndiye kuti chinthucho chazopanga chimakonzedwa zokha.

Tiyeni tiwone momwe njirayi imagwirira ntchito pa mwachindunji. Tili ndi tebulo lamalonda lomwe bizinesi imasungidwa pamwezi. Tiyenera kuwonetsa mitundu yosiyanasiyana momwe phindu la ndalama limachepera 400000 ma ruble, ochokera 400000 kale 500000 ma ruble ndi zina zambiri 500000 ma ruble.

1. Sankhani mzere womwe umadziwa zambiri pazopeza bizinesiyo. Kenako timasunthira ku tabu "Pofikira". Dinani batani Njira Zakukonzeraniili pa riboni m'bokosi la chida Masitaelo. Pamndandanda womwe umatsegulira, sankhani "Kuwongolera malamulo ...".



2. Zenera lofufuza momwe makonzedwe akukhazikitsidwa amayamba. M'munda "Onetsani malamulo osintha a" ziyenera kukhazikitsidwa "Chidutswa chapano". Mwachisawawa, ziyenera kuwonetsedwa pamenepo, koma pokhapokha, onetsetsani ngati osagwirizana akusintha makulidwe malinga ndi malingaliro omwe ali pamwambapa. Pambuyo pake, dinani batani "Pangani lamulo ...".



3. Zenera lopanga mtundu wa fayilo limatsegulidwa. Pa mndandanda wamitundu yamalamulo, sankhani malo "Maselo okhawo omwe ali ndi". Pazolowera kufotokozera mu gawo loyamba, kusinthaku kuyenera kukhala pamalo "Makhalidwe". Pa gawo lachiwiri, ikani kusintha kwa Zochepa. Mu gawo lachitatu, fotokozerani za mtengo wake, zinthu za pepala zokhala ndi mtengo wochepera pomwe utoto utoto. M'malo mwathu, mtengo uwu udzakhala 400000. Pambuyo pake, dinani batani "Fomu ...".



4. Zenera la mtundu wamaselo limatsegulidwa. Pitani ku tabu "Dzazani". Sankhani mtundu wathunthu womwe tikufuna maselo ochepera 400000. Pambuyo pake, dinani batani "Zabwino" pansi pazenera.



5. Timabwereranso pazenera kuti tikapange mtundu wosintha ndipo, nawonso, dinani batani "Zabwino".



6. Pambuyo pa izi, tidzatumizidwanso ku Zoyenera Kukhathamiritsa Malamulo Manager. Monga mukuwonera, lamulo limodzi lawonjezedwa kale, koma tikuyenera kuwonjezera awiri. Chifukwa chake dinani batani "Pangani lamulo ...".



7. Ndiponso tikulowera pazenera la chilengedwe. Timasunthira ku gawo "Maselo okhawo omwe ali ndi". M'munda woyamba wa gawo ili, siyani chizindikiro "Mtengo wam'manja", ndipo yachiwiri tidakhazikitsa kusintha Pakati. M'munda wachitatu, tchulani mtengo woyambira womwe mitunduyo izapangidwira. M'malo mwathu, nambala iyi 400000. Mu chachinayi, tikuwonetsa mtengo wotsiriza wa mulingo uwu. Zidzatheka 500000. Pambuyo pake, dinani batani "Fomu ...".



8. Pazenera lopangidwe, timasunthanso ku tabu "Dzazani", koma nthawi ino tasankha kale mtundu wina, ndikudina batani "Zabwino".



9. Mukabwereranso pazenera la ulamuliro, onaninso batani "Zabwino".



10. Monga tikuwona, mkati Woyang'anira Takhazikitsa kale malamulo awiri. Chifukwa chake, zimakhalabe kuti zikhale chachitatu. Dinani batani Pangani Lamulo.



11. Pa zenera laulamuliro, timasunthanso ku gawo "Maselo okhawo omwe ali ndi". M'munda woyamba, siyani njira "Mtengo wam'manja". Mchigawo chachiwiri, sinthanitsani apolisi Zambiri. M'munda wachitatu timayendetsa angapo 500000. Kenako, monga momwe zinalili m'mbuyomu, dinani batani "Fomu ...".



12. Pazenera Mtundu Wa Cell pitani ku tabu kachiwiri "Dzazani". Nthawi ino sankhani mtundu womwe uli wosiyana ndi milandu iwiri yapitayi. Dinani batani. "Zabwino".



13. Pazenera lopanga malamulo, bwerezani kuwonekera batani "Zabwino".



14. Kutsegula Woyang'anira. Monga mukuwonera, malamulo onse atatuwa adapangidwa, kotero dinani batani "Zabwino".



15. Tsopano zinthu za patebulo zimakongoletsedwa malinga ndi momwe zakhazikidwira komanso malire ake mu mawonekedwe akukhazikitsidwa.



16. Ngati tisintha zomwe zili mu limodzi la maselo, ndikupita kupitirira malire amodzi mwa malamulo omwe afotokozedwawo, ndiye kuti chosinthacho chimasintha mtundu.

Kuphatikiza apo, mutha kugwiritsa ntchito mawonekedwe pamitundu ina mosiyanako pang'ono kuti mutengeko pepala.

1. Chifukwa cha izi Woyang'anira timapita pazenera lopanga masanjidwe, kenako timakhalabe m'gawolo "Sanjani maselo onse kutengera zomwe amaganiza". M'munda "Mtundu" mutha kusankha mtundu, mawonekedwe ake omwe adzaza zinthu za pepalalo. Kenako dinani batani "Zabwino".



2. Mu Woyang'anira komanso dinani batani "Zabwino".



3. Monga mukuwonera, zitatha izi maselo omwe ali mgululi adapangidwa utoto ndi mitundu imodzimodzi. Kukula kwakukulu komwe kumakhala ndi pepalalo, mthunziwo ndi wopepuka, wocheperako - wamdima.

Phunziro: Zowongolera mu Excel

Njira 2: gwiritsani ntchito chida cha Get and Select

Ngati tebulo lili ndi zosasunthika zomwe sizikukonzekera kusintha pakapita nthawi, ndiye kuti mutha kugwiritsa ntchito chida chosintha mtundu wa maselo ndi zomwe zili pansi pa dzina Pezani ndikuwunikira. Chida chomwe chatchulidwa chikupatsani mwayi kuti mupeze zofunikira zomwe mungasinthe ndikuti musinthe mtundu m'maselo awa kukhala wogwiritsa ntchito. Koma ziyenera kudziwidwa kuti pamene zomwe zalembedwazo zikusintha, mtundu sudzasintha zokha, koma udzakhalabe womwewo. Kuti musinthe mtundu kukhala wamakono, muyenera kubwerezanso ndondomekoyi. Chifukwa chake, njirayi siili yokwanira matebulo okhala ndi zochitika zamphamvu.

Tiona momwe izi zimagwirira ntchito pa konkriti, yomwe timayang'ananso momwe timalandirira ndalama.

1. Sankhani mzere womwe uli ndi dawunilodi kuti apangidwe ndi utoto. Kenako pitani ku tabu "Pofikira" ndipo dinani batani Pezani ndikuwunikira, yomwe imayikidwa pa tepi mu chipangizo chothandizira "Kusintha". Pamndandanda womwe umatsegulira, dinani chinthucho Pezani.



2. Tsamba limayamba Pezani ndi Kusintha pa tabu Pezani. Choyamba, pezani mfundozo 400000 ma ruble. Popeza sitikhala ndi khungu limodzi lokhala ndi zochepa 300000 ma ruble, ndiye, m'malo mwake, tifunika kusankha zinthu zonse zomwe zimakhala ndi manambala kuchokera 300000 kale 400000. Tsoka ilo, simungatchule mwachindunji tsambali, monga momwe zimakhazikitsira makonda, mwa njirayi.

   Koma pali mwayi wopanga china chosiyana, chomwe chingatipangitse chimodzimodzi. Mutha kutchula dongosolo lotsatirali mu bar "3?????". Chizindikiro cha mafunso chimatanthauza munthu aliyense. Chifukwa chake, pulogalamuyo ifufuza manambala onse asanu ndi amodzi omwe amayamba ndi digito "3". Ndiye kuti, mitengo yomwe ili mumtunduwo imagwera pazotsatira zakusaka 300000 - 400000, ndizomwe timafunikira. Ngati tebulo linali ndi ziwerengero zochepa 300000 kapena ochepera 200000, pamenepo pamtundu uliwonse wa handiredi sauzande, kusaka kunayenera kuchitika padera.

   Lowetsani mawuwo "3?????" m'munda Pezani ndipo dinani batani "Pezani zonse".



3. Pambuyo pake, zotsatira zakusaka zimatsegulidwa mkati mwa zenera. Dinani kumanzere kwa aliyense wa iwo. Kenako timalemba zophatikiza Ctrl + A. Zitatha izi, zotsatira zakusaka zonse zimawunikidwa ndipo nthawi yomweyo zinthu zomwe zikulembedwazo zikuwunikidwa.



4. Zomwe zidasungidwa mu mzere zasankhidwa, sitingafulumire kutseka zenera Pezani ndi Kusintha. Kukhala mu tabu "Pofikira" momwe tidasamukira m'mbuyomu, pitani ku tepi yomwe ili pa chipangizo cha zida Font. Dinani patatu mpaka kumanja kwa batani Dzazani Mtundu. Kusankha kwamitundu yosiyanasiyana kudzaza. Sankhani mtundu womwe tikufuna kugwiritsa ntchito pazinthu za pepala zomwe zimakhala zochepa 400000 ma ruble.



5. Monga mukuwonera, maselo onse omwe ali mgulu lomwe zofunikira zimakhala zochepa 400000 ma ruble ofunikira mumtundu wosankhidwa.



6. Tsopano tiyenera kupaka utoto momwe mfundo zake zimachokera 400000 kale 500000 ma ruble. Zosankhazi zikuphatikiza manambala omwe amafanana ndi mapangidwe. "4??????". Yendetsani mumunda wofufuzira ndikudina batani Pezani Zonseposankha gawo lomwe tikufuna.



7. Momwemonso, ndi nthawi yapita muzotsatira zakusaka, timasankha zotsatira zonse zomwe zimapezedwa ndikakanikiza kuphatikiza kwa hotkey CTRL + A. Pambuyo pake, sinthani ku chithunzi cha kusankha mtundu. Timasanja ndikudina chizindikiro cha mthunzi womwe mukufuna utotole zomwe zalembedwazo, pomwe mfundo zake zili pamtunda kuchokera 400000 kale 500000.



8. Monga mukuwonera, zitatha izi zinthu zonse za patebulo zomwe zili ndi nthawi yayitali kuchokera 400000 ndi 500000 yowunikidwa mu mtundu wosankhidwa.



9. Tsopano tikufunika kusankha magawo omaliza a mfundo - zina 500000. Pano tili ndi mwayi, popeza ziwerengero zonse ndizochulukirapo 500000 ali pamtunda kuchokera 500000 kale 600000. Chifukwa chake, m'malo osaka, lowetsani mawuwo "5?????" ndipo dinani batani Pezani Zonse. Zikadakhala kuti ndizofunikira kupitilira 600000, pamenepo tiyenera kuwonjezera mawuwo "6?????" etc.



10. Onaninso zotsatira zakusaka pogwiritsa ntchito kuphatikiza Ctrl + A. Kenako, pogwiritsa ntchito batani pa nthiti, sankhani mtundu watsopano kuti mudzaze nthawiyo mopitilira 500000 ndi fanizo lofananalo lomwe tidachita kale.



11. Monga mukuwonera, izi zitachitika, zinthu zonse za mzati zizijambulidwa, malinga ndi kuchuluka kwa manambala zomwe zimayikidwa. Tsopano mutha kutseka zenera lofufuza ndikudina batani loyandikira pakona yakumanja ya zenera, chifukwa ntchito yathu imatha kutha.



12. Koma tikasinthitsa nambala ndi ina yomwe imapitirira malire omwe akhazikitsidwa ndi mtundu winawake, ndiye kuti mtunduwo sungasinthe, monga momwe unalili kale. Izi zikuwonetsa kuti kusankha kumeneku kudzagwira ntchito modalirika pokhapokha pamatafura omwe sanasinthe.

Phunziro: Momwe mungasinthire ku Excel

Monga mukuwonera, pali njira ziwiri zochitira khungu maselo kutengera mtundu womwe uli mwa iwo: kugwiritsa ntchito mawonekedwe ndi kugwiritsa ntchito chida Pezani ndi Kusintha. Njira yoyamba ndiyopitilira patsogolo, popeza imakuthandizani kuti mukonzekere bwino momwe zinthu za pepalalo zidzawonekere. Kuphatikiza apo, ndi mtundu wa mawonekedwe, mtundu wa chinthucho umangosintha ngati zomwe zalembedwedwa zikusintha, zomwe njira yachiwiri singachite. Komabe, kudzaza maselo kutengera phindu pogwiritsa ntchito chida Pezani ndi Kusintha Ndizothekanso kugwiritsa ntchito, koma pokhapokha pamatafura okhazikika.