Zamkatimu
Kusanja ndi ntchito ya Excel yomwe imakhala yodziwika bwino komanso yodziwika kwa aliyense. Komabe, pali milandu ingapo yosavomerezeka komanso yosangalatsa yogwiritsira ntchito.
Mlandu 1. Sanjani ndi matanthauzo, osati motsatira zilembo
Tangoganizirani zochitika zofala kwambiri: pali tebulo momwe muli ndime yokhala ndi dzina la mwezi (Januware, February, Marichi ...) kapena tsiku la sabata (Lachisanu, Lachiwiri, Lachitatu ...). Ndi mtundu wosavuta pamzati uwu, Excel imakonza zinthuzo motsatira zilembo (ie kuchokera ku A mpaka Z):
Ndipo ndikufuna, ndithudi, kuti ndipeze mndandanda wanthawi zonse kuyambira Januwale mpaka December kapena kuyambira Lolemba mpaka Lachiwiri. Izi zikhoza kuchitika mosavuta ndi wapadera kusanja ndi mndandanda wamakonda (kusanja mndandanda wamwambo).
Sankhani tebulo ndikudina batani lalikulu Kusankha tsamba Deta (Deta - Sanjani). Bokosi la zokambirana lidzatsegulidwa momwe muyenera kufotokozera mtundu wamtundu (gawo) ndikusankha mtundu wamtundu womwe uli pamndandanda wotsikira pansi womaliza. Mndandanda Wazikhalidwe (Mndandanda Wamakonda):
Pambuyo pake, zenera lotsatira lidzatsegulidwa, momwe mungasankhire kutsatizana kwa miyezi kapena masiku a sabata omwe tikufuna:
Ngati mndandanda wofunikira (mwachitsanzo, miyezi, koma mu Chingerezi) palibe, ukhoza kulowetsedwa m'munda woyenera posankha njira. Mndandanda watsopano (Mndandanda Watsopano):
Mutha kugwiritsa ntchito ngati olekanitsa koma kapena kiyi Lowani. Mukapanga mndandanda woterewu, mutha kugwiritsa ntchito m'mabuku ena a Excel.
Chochititsa chidwi ndichakuti mwanjira imeneyi mutha kusanja mopusa motsatira zilembo, koma kufunikira ndi kufunikira kwazinthu zilizonse zotsogola, osati miyezi kapena masiku a sabata. Mwachitsanzo:
- maudindo (wotsogolera, wachiwiri kwa director, mutu wa dipatimenti, wamkulu wa dipatimenti…)
- magulu ankhondo (general, colonel, lieutenant colonel, major ...)
- ziphaso (TOEFL, ITIL, MCP, MVP…)
- makasitomala kapena katundu malinga ndi kufunikira kwanu (whiskey, tequila, cognac, vinyo, mowa, mandimu ...)
- etc.
Mlandu 2: Sinthani zolemba ndi manambala nthawi imodzi
Tiyerekeze kuti tebulo lathu lili ndi mzati ndi zizindikiro za magawo osiyanasiyana ndi misonkhano ya magalimoto (gawo nambala). Komanso, zigawo zazikulu zosonkhanitsidwa (mwachitsanzo, gearbox, injini, chiwongolero) zimasonyezedwa ndi code yeniyeni yadijito, ndipo zigawo zing'onozing'ono zomwe zikuphatikizapo zimasonyezedwa ndi code ndi kuwonjezera kwa nambala yowunikira kudzera, kunena, dontho. Kuyesera kusanja mndandanda wotere mwachizolowezi kumabweretsa zotsatira zosafunikira, chifukwa Excel imasankha manambala padera (chiwerengero chamagulu akulu pamsonkhano) komanso padera zolemba (zinambala zazing'ono zokhala ndi madontho):
Ndipo, ndithudi, ndikufuna kupeza mndandanda womwe pambuyo pa gawo lalikulu lililonse tsatanetsatane wake adzapita:
Kuti tichite izi, tifunika kuwonjezera kwa kanthawi gawo lina patebulo lathu, momwe timasinthira zilembo zonse kukhala mawu pogwiritsa ntchito TEXT ntchito:
Ngati mutasankha ndime imeneyo, Excel idzakufunsani momwe mungasankhire manambala ndi malemba:
Ngati musankha njira yachiwiri m'bokosi la zokambirana, ndiye kuti Excel sisintha ziwerengero zamagulu akuluakulu kukhala manambala ndipo idzasintha mndandanda wonse ngati malemba, zomwe zidzatipatsa zotsatira zomwe tikufuna. Gawo lothandizira likhoza, ndithudi, kuchotsedwa.
- Sanjani potengera mtundu
- Sanjani ndi mtundu ndi chowonjezera cha PLEX
- Sanjani potengera fomula