Kodi mukufuna kudziwa zambiri za ntchito za Excel? Nanga bwanji kuphunzira momwe mungagwiritsire ntchito ntchito yanu? Microsoft Excel ili ndi ntchito zambiri kotero kuti ngakhale ogwiritsa ntchito odziwa zambiri sangathe kuyang'ana momveka bwino mitundu yonseyi. Chabwino 30 Excel imagwira ntchito m'masiku 30 idzakhala chilimbikitso champhamvu chakudzitukumula nokha ndipo idzakuphunzitsani kupanga zinthu zodabwitsa m'mabuku a Excel.
Ngati ndinu wogwiritsa ntchito novice Excel ndipo mwabwera patsamba lino kuti muphunzire chilichonse kuchokera pazoyambira, ndikupangira kuti muyang'ane kaye za Maphunziro athu a Excel Oyamba. Mmenemo mudzapeza zambiri zapamwamba komanso zothandiza.
Kodi maphunzirowa ndi otani?
Maphunziro onse 30 ndi kumasulira kwa mpikisano wothamanga wa zolemba ndi Canada Excel guru - Debrie Dalgleish. Tsiku lililonse kuyambira pa Januware 2, 2011 mpaka Januware 31, 2011, pamakhala nkhani pabulogu ya Contextures yofotokoza chimodzi mwazinthu izi. Ntchito zonse zili m'magulu: zolemba, zambiri, ndikusaka ndi maulalo. Gawo la List List limapereka maulalo omasulira zolemba zonsezi.
Nkhani iliyonse ili ndi izi:
- Kufotokozera mwatsatanetsatane momwe gawo lililonse limagwirira ntchito.
- Maphunziro onse 30 amatsagana ndi zowonera zomwe zimakupatsani mwayi wofotokozera momveka bwino zofunikira (zithunzizo zidatengedwa mu Excel 2010).
- Zitsanzo zothandiza zogwiritsira ntchito ma fomu a Excel paokha komanso ndi ntchito zina.
- Zowopsa zomwe zingachitike mukamagwira ntchito.
- Komanso zambiri zina zothandiza mofanana.
Ndipeza chiyani?
Mothandizidwa ndi marathon awa, mudzatha kukulitsa chidziwitso chanu cha ntchito za Microsoft Excel ndikupanga mabuku anu ogwira ntchito bwino. Dziwani zomwe zimagwira bwino nthawi zina, ndi zomwe muyenera kupewa.
Bukuli likuthandizani kuti mugwiritse ntchito bwino ntchito zomwe zadziwika bwino. Ngakhale ntchito za Excel zomwe mumagwira ntchito tsiku lililonse zitha kukhala ndi zobisika komanso misampha yomwe simunadziwe. Mutha kugwiritsa ntchito mosamala zitsanzo zonse zomwe zaperekedwa muzolemba zanu.
Mndandanda wazinthu:
Tsiku 01 - EXACT - ikhoza kuyang'ana zingwe ziwiri kuti zigwirizane ndendende, komanso, zokhala ndi vuto.
Tsiku 02 - MALO - Kubwezera chiwerengero cha madera mu ulalo.
Tsiku 03 - TRIM - Imachotsa mipata yonse pazingwe, kupatula mipata imodzi pakati pa mawu.
Tsiku 04 - INFO - Imawonetsa zambiri zamagwiritsidwe ntchito pano.
Tsiku 05 - SKHANI - Kubwezeretsanso mtengo kuchokera pamndandanda, ndikuwusankha molingana ndi manambala.
Tsiku 06 - ZOKHUDZITSIDWA - Imazungulira nambala ku malo enaake ndikubwezeretsa zotsatira mumtundu wamawu kapena opanda olekanitsa masauzande.
Tsiku 07 - CODE - Imabwezera nambala ya nambala ya zilembo zoyambirira za zingwe.
Tsiku 08 - CHAR - Imabwezera munthu wina yemwe khodi yake imafanana ndi nambala yomwe yalowetsedwa, kutengera tebulo la zilembo zapakompyuta yanu.
Tsiku 09 - VLOOKUP - Imayang'ana mtengo mugawo loyamba la tebulo ndikubwezeretsanso mtengo wina kuchokera pamzere womwewo patebulo.
Tsiku 10 - HLOOKUP - Imayang'ana mtengo mumzere woyamba wa tebulo ndikubweza mtengo wina kuchokera pamzati womwewo wa tebulo.
Tsiku la 11 - CELL (CELL) - limasonyeza zambiri za masanjidwe, zomwe zili ndi malo a selo pa ulalo womwe wapatsidwa.
Tsiku 12 - COLUMNS - Kubweza chiwerengero cha mizati motsatizana kapena maumboni.
Tsiku 13 - TRANSPOSE - Imabwezeranso ma cell angapo opingasa ngati mulingo woyima kapena mosemphanitsa.
Tsiku 14 - T (T) - Imabwezera malemba ngati mtengo mu selo ndi malemba, kapena chingwe chopanda kanthu ngati sichilemba.
Tsiku 15 - REPEAT (REPT) - kubwereza chingwe chalemba nthawi zingapo.
Tsiku 16 - LOOKUP - Imabwezera mtengo kuchokera pamzere umodzi, gawo limodzi, kapena gulu.
Tsiku 17 - ERROR.TYPE - Imazindikiritsa mtundu wa cholakwika ndi nambala kapena kubweza #N/A ngati palibe cholakwika chomwe chidapezeka.
Tsiku 18 - PANGANI - Yang'anani chingwe cha mawu mkati mwa zingwe zina, ndipo ikapezeka, ifotokoza momwe ilili.
Tsiku 19 – MATCH – Imabweza malo a mtengowo pamndandanda, kapena cholakwika cha #N/A ngati sichinapezeke.
Tsiku 20 - ADDRESS - Imabweza nsonga ya selo ngati malemba kutengera mzere ndi nambala ya gawo.
Tsiku 21 - TYPE - Imabweza nambala yomwe imatchula mtundu wa data.
Tsiku 22 - N (N) - Imabwezera mtengo wosinthidwa kukhala nambala.
Tsiku 23 - PEZANI - Amapeza zingwe zolembera mkati mwa zingwe zina, zokhala ndi vuto.
Tsiku 24 - INDEX - Imabweza mtengo kapena zonena za mtengo.
Tsiku 25 - REPLACE - Imalowetsa zilembo m'mawu kutengera kuchuluka kwa zilembo komanso malo oyambira.
Tsiku 26 - OFFSET - Imabwezeranso ulalo kuchokera pa ulalo womwe wapatsidwa ndi mizere ndi mizere.
Tsiku 27 - SUBSTITUTE - Imalowetsa mawu akale ndi mawu atsopano mkati mwa zingwe.
Tsiku 28 - HYPERLINK - imapanga ulalo womwe umatsegula chikalata chosungidwa pakompyuta, seva yapaintaneti, netiweki yapafupi kapena intaneti.
Tsiku 29 - CLEAN - Imachotsa zilembo zina zosasindikiza pamawu.
Tsiku 30 - INDIRECT - Imabwezeranso ulalo woperekedwa ndi zingwe.