Pamene mukugwira ntchito ndi tebulo kapena deta yomwe ili ndi zambirimbiri, ndizotheka kuti mizera ina imabwerezedwa. Izi zikuwonjezera kuwonjezeka kwa deta. Kuonjezera apo, pamaso pa zowerengera, kuwerengera kolakwika kwa zotsatira muzotheka. Tiyeni tiwone momwe tingapezere ndikuchotsa mizere yachitsulo mu Microsoft Excel.
Sakani ndi kuchotsa
Pezani ndi kuchotsa ma tebulo omwe akuphatikizidwa, mwinamwake m'njira zosiyanasiyana. Pazigawo zonsezi, kufufuza ndi kuthetsa zowerengedwa ndizogwirizana pa njira imodzi.
Njira 1: kuchotsa mosavuta mazere awiri
Njira yosavuta yochotsera zolembazo ndi kugwiritsa ntchito batani lapadera pa tepi yokonzedweratu.
- Sankhani lonse magulu a tebulo. Pitani ku tabu "Deta". Timakanikiza batani "Chotsani Duplicates". Ipezeka pa tepiyi mu zida za zipangizo. "Kugwira ntchito ndi deta".
- Zopindulitsa kuchotsa zenera zikutsegula. Ngati muli ndi tebulo lokhala ndi mutu (ndipo mochulukirapo nthawi zonse ndilo), ndiye padera "Deta yanga ili ndi mutu" ayenera kuchotsedwa. Mu gawo lalikulu lawindo ndi mndandanda wa zipilala zomwe zidzayang'aniridwa. Mzere udzawerengedwa ngati wophiphiritsira kokha ngati deta yazitsulo zonse zitasankhidwa ndi chekeni. Izi zikutanthauza kuti ngati mutachotsa chekeni pa dzina la chingwe, izo zimapangitsa kuti muzindikire zolembazo mobwerezabwereza. Pambuyo pokonza zonse zofunikira, dinani pa batani. "Chabwino".
- Excel imachita ndondomeko yopezera ndi kuchotsa zobwerezabwereza. Pambuyo pomalizidwa, zenera likuwonekera, zomwe zimakuuzani kuchuluka kwazinthu zowonjezera zomwe zachotsedwa ndi chiwerengero cha zolembedwa zosiyana. Kutsegula zenera ili, dinani batani. "Chabwino".
Njira 2: Chotsani Zophatikiza mu Smart Table
Zonsezi zingachotsedwe ku maselo osiyanasiyana pogwiritsa ntchito tebulo lapamwamba.
- Sankhani lonse magulu a tebulo.
- Kukhala mu tab "Kunyumba" pressani batani "Pangani monga tebulo"yomwe ili pa tepi muzitali za zida "Masitala". Mu mndandanda womwe ukuwonekera, sankhani mtundu uliwonse womwe mumakonda.
- Kenaka pang'onopang'ono timatsegula zowonjezera zomwe mukufunikira kuti mutsimikizire osankhidwawo kuti mupange tebulo lapamwamba. Ngati mwasankha zonse molondola, ndiye mukhoza kutsimikizira, ngati mukulakwitsa, ndiye kuti zenera izi zikonzedwe. Ndifunikanso kumvetsetsa mfundo yakuti "Mndandanda ndi mutu" panali chongani. Ngati ayi, ndiye kuti iyenera kuikidwa. Pambuyo pokonzekera zonsezi, dinani pa batani. "Chabwino". Mapulogalamu ofunika adalengedwa.
- Koma kulengedwa kwa "tebulo lapamwamba" ndi sitepe imodzi yokha kuti athetse ntchito yathu yaikulu - kuchotsedwa kwa zowerengeka. Dinani pa selo lirilonse mndandanda wa tebulo. Gulu lina la ma tabo likuwonekera. "Kugwira ntchito ndi matebulo". Kukhala mu tab "Wopanga" dinani pa batani "Chotsani Duplicates"yomwe ili pa tepiyi mu zida za zipangizo "Utumiki".
- Pambuyo pake, kufotokozera zowonetsera zenera kutsegulidwa, ntchito yomwe inafotokozedwa mwatsatanetsatane pofotokoza njira yoyamba. Zochitika zina zonse zikuchitidwa motsatira ndondomeko yomweyo.
Njira iyi ndi yabwino kwambiri komanso yogwira ntchito yonse yomwe ikufotokozedwa m'nkhaniyi.
Phunziro: Momwe mungapangire spreadsheet mu Excel
Njira 3: yesetsani kusankha
Njira iyi sizimachotseratu zosiyana, chifukwa mtunduwo umabisa zolembedwa zomwe zili patebulo.
- Sankhani tebulo. Pitani ku tabu "Deta". Timakanikiza batani "Fyuluta"ili pamakonzedwe "Sankhani ndi kusefera".
- Fyuluta imatsegulidwa, monga zikuwonetseredwera ndi zithunzi zomwe zimawoneka ngati mawonekedwe a katatu mu maina a mndandanda. Tsopano tikufunikira kuyisintha. Dinani pa batani "Zapamwamba"ili pafupi ndi chirichonse chomwe chiri mu gulu limodzi la zida "Sankhani ndi kusefera".
- Zapamwamba zowonekera fyuluta yatsegula. Ikani nkhuni kutsogolo kwa gawolo "Zowonjezera zokhazokha". Zosintha zina zonse zatsalira ngati zosasintha. Pambuyo pake dinani pa batani "Chabwino".
Pambuyo pake, zolembera zobwereza zidzabisika. Koma amatha kusonyezedwa nthawi iliyonse podutsa batani kachiwiri. "Fyuluta".
Phunziro: Fulogalamu Yapamwamba ya Excel
Njira 4: Kupanga Maonekedwe Okhazikika
Mukhozanso kupeza maselo ofikira pogwiritsa ntchito ma tebulo ovomerezeka. Zoona, ziyenera kuchotsedwa ndi chida china.
- Sankhani malo a tebulo. Kukhala mu tab "Kunyumba"pressani batani "Mafomu Okhazikika"ili pamakonzedwe "Masitala". Mu menyu imene ikuwonekera, sitepe ndi sitepe "Malamulo a kusankha" ndi "Makhalidwe apamwamba ...".
- Mawindo okonza mapangidwe amatsegula. Choyambira choyamba mmenemo sichinasinthe - "Kupindula". Koma muchisankho chosankhidwa, mukhoza kuchoka kusasintha kosasankhidwa kapena kusankha mtundu uliwonse umene umakuyenererani, ndiye dinani pa batani "Chabwino".
Pambuyo pake, maselo omwe ali ndi makhalidwe ofanana adzasankhidwa. Ngati mukufuna, mutha kuchotsa maselowa mwa njira yoyenera.
Chenjerani! Fufuzani zowerengera pogwiritsa ntchito maonekedwe ovomerezeka sizinayende pa mzere wonse, koma pa selo iliyonse makamaka, choncho si oyenera pa milandu yonse.
Phunziro: Mafomu omvera mu Excel
Njira 5: kugwiritsa ntchito njirayi
Kuphatikiza apo, zowerengeka zingapezeke mwa kugwiritsa ntchito njirayi pogwiritsira ntchito ntchito zingapo kamodzi. Ndi chithandizo chake, mungathe kufufuza zolembedwa pamndandanda wapadera. Maonekedwe onse a mawonekedwe awa adzawoneka motere:
= IF ERROR (INDEX (chithunzi_chidutswa; MATCH) (0; comp.
- Pangani chigawo chosiyana chomwe ziphatikizidwa zidzawonetsedwa.
- Lowani ndondomeko ya template pamwambayi mu selo yoyamba yaulere ya gawo latsopanolo. Momwe ife timakhalira, njirayi idzakhala motere:
= IFRROR (INDEX (A8: A15; MATCHES (0; ACCOUNTS (E7: $ E $ 7; A8: A15) + IF (ACKS: A8: A15; A8: A15)> 1; 0; 1); 0)); "") - Sankhani ndime yonse ya zowerengera, kupatula mutu. Ikani cholozera pamapeto a bar. Dinani batani pa khididi F2. Ndiye lembani kuphatikiza kwachinsinsi Ctrl + Shift + Lowani. Ichi ndi chifukwa cha zenizeni za kugwiritsa ntchito mafomu pamakalata.
Pambuyo pazimenezi mu gawoli "Zambiri" Zotsatira zapadera zikuwonetsedwa.
Koma, njira iyi idakali yovuta kwambiri kwa ogwiritsa ntchito ambiri. Kuphatikiza apo, zimaphatikizapo kufufuza zowerengera, koma osati kuchotsa. Choncho, tikulimbikitsidwa kugwiritsa ntchito njira zosavuta komanso zogwirira ntchito zomwe tazitchula kale.
Monga mukuonera, mu Excel pali zida zambiri zomwe zimayesedwa pofuna kufufuza ndi kuchotsa zolembedwazo. Aliyense wa iwo ali ndi makhalidwe ake omwe. Mwachitsanzo, kupanga malemba kumaphatikizapo kufunafuna zowerengeka pa selo iliyonse padera. Kuwonjezera pamenepo, si zipangizo zonse zomwe zingathe kufufuza, komanso kuchotsani zomwe zimapindulitsa. Chinthu chofunika kwambiri padziko lonse ndicho kupanga tebulo yabwino. Mukamagwiritsa ntchito njirayi, mukhoza kusinthira kufufuza kwa zolembedwa molondola komanso momveka ngati n'kotheka. Komanso, kuchotsedwa kwawo kumachitika mwamsanga.
