Ndi anthu ochepa okha omwe amakonda nthawi yayitali komanso mosasamala kuti alowe mu deta yomweyi. Uwu ndi ntchito yokongola kwambiri, kutenga nthawi yochuluka. Excel ili ndi mphamvu zowonetsera zomwe zakhala zikugwiritsidwa ntchito. Kwa ichi, ntchito ya maselo osayimitsidwa amaperekedwa. Tiyeni tiwone momwe zimagwirira ntchito.
Job AutoFill mu Excel
Kukonzekera kwathunthu ku Microsoft Excel ikuchitika pogwiritsa ntchito chizindikiro chodzaza. Kuti muyitane chida ichi muyenera kutsegula chithunzithunzi m'munsimu kumunsi kwa selo iliyonse. Mtanda waung'ono wakuda umawonekera. Ichi ndi chilemba chodzaza. Mukungoyenera kugwiritsira pansi batani lamanzere ndi kukwera kumbali ya pepala kumene mukufuna kudzaza maselo.
Momwe maselo adzakhudzidwire amadalira mtundu wa deta yomwe ili mu selo yoyamba. Mwachitsanzo, ngati muli ndi malemba omveka bwino, ndiye kuti mukakokera ndi chikhomo chodzaza, amakopera ku maselo ena a pepala.
Dzalitsani maselo ndi ma nambala
Kawirikawiri, kupomometsa kumagwiritsidwa ntchito kulemba manambala ambirimbiri omwe amatsatira. Mwachitsanzo, mu selo ina ndi nambala 1, ndipo tikuyenera kuwerengetsa maselo kuyambira 1 mpaka 100.
- Lembani chizindikiro chodzaza ndi kukokera pansi ku nambala yofunikira ya maselo.
- Koma, monga momwe tikuonera, kampani imodzi yokha idasindikizidwa maselo onse. Dinani pazithunzi, zomwe ziri pansi kumanzere kwa malo odzazidwa ndipo akutchedwa "Zosankha Zowonongeka".
- M'ndandanda imene imatsegulira, ikani kusinthana ku chinthucho "Lembani".
Monga mukuonera, patatha izi, mndandanda wonse wofunikira unadzazidwa ndi manambala mu dongosolo.
Koma mukhoza kuzipanga mosavuta. Simusowa kutcha zosankha zokhazikika. Kuti muchite izi, mukakokera chogwiritsira ntchito pansi, ndiye kuti pambali pamakani osakani a mouse, muyenera kugwira batani ina Ctrl pabokosi. Pambuyo pake, kudzazidwa kwa maselo ndi manambala mu dongosolo kumapezeka nthawi yomweyo.
Palinso njira yothetsera kupititsa patsogolo kwa autocomplete.
- Timalowa manambala awiri oyambirira a maselo oyandikana nawo.
- Sankhani. Pogwiritsa ntchito chikhomo chodzaza, timalowa deta mumaselo ena.
- Monga mukuonera, nambala yochuluka yowerengeka ndi sitepe yopezekayo imalengedwa.
Tengerani chida
Excel imakhalanso ndi chida chosiyana chomwe chimatchedwa "Lembani". Ipezeka pa tabu yachitsulo. "Kunyumba" mu chigawo cha zipangizo Kusintha.
- Timalowa deta mu selo iliyonse, ndikusankha izo ndi maselo ambiri omwe titi tidzaze.
- Timakanikiza batani "Lembani". Mu mndandanda womwe ukuwonekera, sankhani njira yomwe mungadzaze maselo.
- Monga mukuonera, zitatha izi, deta kuchokera mu selo imodzi idakopedwera kwa ena onse.
Ndi chida ichi mungathe kudzaza maselo ndi kupita patsogolo.
- Ikani chiwerengero mu selo ndikusankha maselo osiyanasiyana omwe adzadza ndi deta. Dinani pa batani "Lembani", ndipo mundandanda umene ukuwonekera, sankhani chinthucho "Kupitirira".
- Mawindo owonetsera mapulogalamu akuyamba. Pano mukufunika kupanga njira zingapo:
- sankhani malo omwe akupita (m'mizere kapena mizere);
- mtundu (geometric, masamu, masiku, autocomplete);
- yikani sitepe (mwachoncho ndi 1);
- Ikani malire malire (mungasankhe).
Kuonjezera apo, nthawi zina, mayunitsi a mayeso amaikidwa.
Pamene zochitika zonse zikupangidwa, dinani pa batani. "Chabwino".
- Monga momwe mukuonera, patatha izi, maselo onse osankhidwa amadzazidwa molingana ndi malamulo oyendetsedwa ndi inu.
Kulemba machitidwe
Chimodzi mwa zida zazikuru za Excel ndizo machitidwe. Ngati pali chiwerengero chofanana cha tebulo, mungagwiritsenso ntchito ntchito yoyimitsa. Chofunikacho sichimasintha. Ndikofunikira njira imodzimodziyo kuti mudzaze chikwangwani kuti mupange fomuyi kwa maselo ena. Pachifukwa ichi, ngati chiganizocho chiri ndi maumboni a maselo ena, ndiye osasintha, pakukopera motere, zigawo zawo zimasintha mogwirizana ndi mfundo ya kugwirizana. Choncho, maulaliki oterewa amatchedwa wachibale.
Ngati mukufuna kuti maadiresi akhazikitsidwe pamene mukudzaza, muyenera kuika chizindikiro cha dola kutsogolo kwa mzere ndi mndandanda wa zigawo mu selo yoyamba. Zogwirizana zoterezo zimatchedwa mtheradi. Ndiye, kachitidwe kawiri ka autofill kamagwiritsidwa ntchito pogwiritsa ntchito chikhomo chodzaza. Mu maselo onse odzazidwa motere, njirayi idzakhala yosasinthika.
Phunziro: Mtheradi ndi wachibale zimalumikizana ku Excel
Zidzitseni ndi zikhulupiliro zina
Kuonjezera apo, Excel imapereka zokhudzana ndi mfundo zina. Mwachitsanzo, ngati mutalowa tsiku lililonse, ndiyeno, pogwiritsa ntchito chidindo chodzaza, sankhani maselo ena, ndiye kuti yonse yosankhidwayo idzakhala yodzazidwa ndi masiku omaliza.
Mofananamo, mungathe kudzipiritsa pa masiku a sabata (Lolemba, Lachiwiri, Lachitatu ...) kapena miyezi (January, February, March ...).
Komanso, ngati pali chiwerengero chilichonse m'ndandanda, Excel adzachizindikira. Pogwiritsira ntchito chikhomo chodzaza, malembawo adzakopedwa ndi chiwerengero chosintha mwakuya. Mwachitsanzo, ngati mulemba mawu akuti "nyumba 4" mu selo, ndiye kuti mumaselo ena odzazidwa ndi chizindikiro chodzaza, dzina limeneli lidzakhala "5 kumanga", "6 kumanga", "nyumba 7", ndi zina zotero.
Onjezani mndandanda wanu
Mphamvu zazomwe zimagwira ntchito pa Excel sizikukhazikitsidwa pazinthu zina zowonjezera kapena mndandanda wazinthu, monga, masiku a sabata. Ngati mukufuna, wogwiritsa ntchito akhoza kuwonjezera mndandanda wake pa pulogalamuyi. Ndiye, pamene mawu aliwonse kuchokera ku zinthu zomwe zili m'ndandanda amalembedwa ku selo, mutatha kugwiritsa ntchito chikhomo chodzaza, maselo onse osankhidwa adzazidwa ndi mndandandawu. Kuti muwonjezere mndandanda wanu, muyenera kuchita zotsatirazi.
- Kupanga kusintha ku tab "Foni".
- Pitani ku gawoli "Zosankha".
- Kenaka, pita ku gawolo "Zapamwamba".
- Mu bokosi lokhalamo "General" mkatikati mwawindo pindani pakani "Sintha mndandanda ...".
- Mndandanda wazenera amatsegula. Kumanzere kumanzerepo kale mndandanda. Kuti muwonjezere mndandanda watsopano lembani mawu olondola mmunda "Zolemba Zolemba". Chigawo chilichonse chiyenera kuyamba ndi mzere watsopano. Zonsezi zitalembedwa, dinani pa batani "Onjezerani".
- Pambuyo pake, ndandanda yazenera idzayandikira, ndipo ikadzatsegudwanso, wogwiritsa ntchito adzawona zinthu zomwe adaziika kale mndandanda wazenera.
- Tsopano, mutatha kulowa mau omwe anali chimodzi mwa zinthu za mndandanda wowonjezera mu selo iliyonse ya pepala ndikugwiritsira ntchito chikhomo chodzaza, maselo osankhidwa adzadza ndi malemba kuchokera mndandanda womwewo.
Monga mukuonera, kudzipatulira mu Excel ndi chida chothandiza komanso chothandiza chomwe chimakulolani kuti muzisunga nthawi yowonjezera deta yomweyi, zolemba zolemba, ndi zina zotero. Ubwino wa chida ichi ndikuti ndizosinthika. Mungathe kupanga mndandanda watsopano kapena kusintha zakale. Kuphatikiza apo, pogwiritsa ntchito autocomplete, mumatha kudzaza maselo ndi mitundu yosiyanasiyana ya masamu.
