Microsoft Excel ikhoza kumuthandiza kwambiri wogwiritsa ntchito ndi matebulo ndi mawerengero, ndikuzikonza. Izi zingapezeke pogwiritsa ntchito bukhuli la ntchitoyi, ndi ntchito zake zosiyanasiyana. Tiyeni tione mbali zothandiza kwambiri za Microsoft Excel.
Vpr ntchito
Chimodzi mwa zinthu zotchuka kwambiri ku Microsoft Excel ndi VLOOKUP. Ndi ntchitoyi, mutha kuyamikira ziyeso za imodzi kapena magome angapo, kukokera kwa wina. Pachifukwa ichi, kufufuza kumachitika kokha m'mbali yoyamba ya tebulo. Choncho, pamene deta ikusintha pa tebulo loyambira, deta imapangidwira patebulo lochokera, momwe ziwerengero zosiyana zikhoza kuchitidwa. Mwachitsanzo, deta kuchokera pa tebulo yomwe ilipo mtengo wa mtengo wamtengo wapatali angagwiritsidwe ntchito kuwerengetsa zizindikiro zomwe ziri patebulo, za mtengo wogula mu ndalama.
CDF imayambika mwa kuyika woyendetsa "CDF" kuchokera ku Function Wizard mu selo komwe deta iyenera kuwonetsedwa.
Muwindo lomwe likuwoneka, mutatha kuyambira, muyenera kufotokoza adiresi ya selo kapena maselo osiyanasiyana omwe deta idzatulutsidwa.
Phunziro: Pogwiritsa ntchito WFD ku Microsoft Excel
Chidule Mapepala
Mbali ina yofunikira ya Excel ndiyo kulenga matebulo ozungulira. Ndi ntchitoyi, mukhoza kugawa deta kuchokera ku matebulo ena molingana ndi zosiyana, komanso kupanga mawerengedwe osiyanasiyana ndi iwo (kuwerengera, kuchulukana, kugawa, ndi zina zotero), ndi kutulutsa zotsatira mu tebulo lapadera. Panthawi imodzimodziyo, pali mwayi waukulu wopezera masitepe.
Tawuni ya pivot ingathe kukhazikitsidwa mu tab "Insert" podalira pa "batcha" Pivot Table ".
PHUNZIRO: Pogwiritsa ntchito mazithunzi a Microsoft Excel
Kupanga masati
Kuti muwonetse mawonedwe owonetsedwa patebulo, mungagwiritse ntchito masati. Zitha kugwiritsidwa ntchito popanga zitsanzo, kulemba mapepala ofufuzira, kufunafuna kufufuza, ndi zina zotero. Microsoft Excel imapereka zipangizo zosiyanasiyana popanga mitundu yosiyanasiyana yamatcha.
Kuti mupange tchati, muyenera kusankha selo la maselo omwe muli ndi deta yomwe mumafuna kuwonekera. Kenaka, pokhala tab "Insert", sankhani mtundu wa chithunzi chimene mukuwona kuti n'choyenera kwambiri kuti mukwaniritse zolinga zomwe mwasankha.
Kupanga malemba, kuphatikizapo kukhazikitsa mayina ndi ndondomeko, kumachitika pa tsamba "Kugwira ntchito ndi zithunzi".
Mtundu umodzi wa tchati ndizojambula. Mfundo yomanga yomangamanga ndi yofanana ndi mitundu ina.
PHUNZIRO: Kugwiritsa ntchito ma chart mu Microsoft Excel
Mafomu a EXCEL
Kugwira ntchito ndi deta ya Microsoft Excel, ndizofunikira kugwiritsa ntchito maulendo apadera. Ndi chithandizo chawo, mungathe kuchita masabata osiyanasiyana ndi ma data pazowonjezerapo: kuwonjezera, kuchotsa, kuchulukitsa, kugawikana, kukweza kufika pa mulingo wa mizu, ndi zina zotero.
Kuti mugwiritse ntchito ndondomekoyi, mukufunika mu selo yomwe mukukonzekera zotsatira zake, yesani chizindikiro "=". Pambuyo pake, mawonekedwewo enieni amayamba, omwe angakhale ndi zizindikiro za masamu, manambala, ndi maadiresi a selo. Pofuna kufotokozera adiresi ya selo kumene deta ya mawerengedwe imatengedwa, ingodinani pa iyo ndi mbewa, ndipo makonzedwe ake adzawonekera mu selo kuti asonyeze zotsatira.
Ndiponso, Microsoft Excel ikhoza kugwiritsidwa ntchito ngati chogwiritsira ntchito nthawi zonse. Kuti muchite izi, muzenera zamtundu uliwonse kapena selo lirilonse limangowonjezera mawu a masamu pambuyo pa chizindikiro "=".
Phunziro: Kugwiritsa ntchito mawonekedwe mu Microsoft Excel
Ngati ntchito
Chimodzi mwa zinthu zotchuka kwambiri zomwe zimagwiritsidwa ntchito ku Excel ndi ntchito "IF". Ndi chithandizo chake, mutha kuyika selo zotsatira za zotsatira zake pamene vuto lina lidzakwaniritsidwa, ndi zotsatira zina, ngati sizidzakwaniritsidwa.
Chidule cha ntchitoyi ndi ichi: "IF (mawu omveka; [zotsatira ngati zoona]; [zotsatila ngati zonyenga])".
Pothandizidwa ndi ogwira ntchito "NDI", "OR" ndi chisa chochita "IF", mungathe kukhazikitsa zovomerezeka, kapena chimodzi mwa zinthu zingapo.
Phunziro: Kugwiritsa ntchito IF mukugwira ntchito mu Microsoft Excel
Macros
Pogwiritsira ntchito macros ku Microsoft Excel, mukhoza kulembetsa kuchitidwa kwa zochita zina, ndiyeno muziyimba mwachangu. Izi zimapulumutsa nthawi pakuchita ntchito zambiri zofanana.
Macros akhoza kulembedwa mwa kungolemba zojambulazo pazochitika pulogalamuyo, kupyolera mu botani lomwe likugwirizana pa tepi.
Ndiponso, macros akhoza kulembedwa pogwiritsa ntchito chinenero cha Visual Basic mumsinkhu wapadera.
Phunziro: Kugwiritsa Macros ku Microsoft Excel
Kupanga Maonekedwe
Kuti musankhe deta zina mu tebulo, ntchito yokhazikika yopangidwira imagwiritsidwa ntchito. Ndi chida ichi, mukhoza kusankha malamulo osankhidwa a selo. Zomwe zimapangidwira zokha zikhoza kuchitika monga mtundu wake wa histogram, mtundu wa mtundu, kapena zithunzi za zithunzi.
Kuti mupite maonekedwe ovomerezeka, muyenera kusankha ma selo osiyanasiyana omwe mukupita nawo kuti mukakonzeke, pomwe muli Pabupila. Kenaka, muzitsulo zojambulajambula, dinani pa batani, yomwe imatchedwa Kulemba Malamulo. Pambuyo pake, muyenera kusankha maonekedwe omwe mukuwona kuti ndi ofunika kwambiri.
Kupangidwira kudzachitika.
PHUNZIRO: Kugwiritsa ntchito zolemba machitidwe pa Microsoft Excel
Mndandanda Wodabwitsa
Osati ogwiritsira ntchito onse akudziwa kuti tebulo, loloĊµera pensi, kapena kugwiritsa ntchito malire, Microsoft Excel imadziwika ngati malo osavuta a maselo. Kuti chiwerengero ichi chiwonedwe ngati tebulo, chiyenera kusinthidwa.
Izi zachitika mophweka. Choyamba, sankhani maulendo okhutira ndi deta, ndiyeno, pokhala pa tsamba la "Home", dinani pazithunzi "Format monga tebulo". Pambuyo pake, mndandanda umapezeka ndi zosankha zosiyanasiyana za mapangidwe a tebulo. Sankhani bwino kwambiri.
Ndiponso, tebulo ikhoza kulengedwa powonjezera batani la "Table", lomwe liri mu tab "Insert", mutasankha malo enieni a pepala.
Pambuyo pake, seti yosankhidwa ya Microsoft Excel maselo idzawonetsedwa ngati tebulo. Zotsatira zake, mwachitsanzo, ngati mutalowa deta m'maselo omwe ali pamphepete mwa tebulo, iwo adzaphatikizidwa patebulo ili. Kuphatikizanso, pamene mukudutsa pansi, mutu wa tebulo udzakhala nthawi zonse mkati mwa masomphenya.
PHUNZIRO: Kupanga spreadsheet ku Microsoft Excel
Kusankha kwapakati
Pothandizidwa ndi ntchito yosankha, mungathe kutenga deta yomwe imachokera pamapeto omwe mukufunikira.
Kuti mugwiritse ntchitoyi, muyenera kukhala mu tabu la "Deta". Pomwepo, muyenera kutsegula pa "Sakanizani" ngati "batani," yomwe ili mu bokosi logwiritsa ntchito "Ntchito ndi Data." Kenaka, sankhani chinthu "Parameter selection ..." m'ndandanda yomwe ikuwonekera.
Zenera zosankha zosankhidwa zimachotsedwa. Kumunda "Sakani mu selo" muyenera kufotokoza chiyanjano cha selo chomwe chili ndi mawonekedwe omwe mukufuna. Kumunda "Chofunika" chiyenera kufotokozera zotsatira zomaliza zomwe mukufuna kuzipeza. Mu "Kusintha maselo a" maselo "muyenera kufotokoza makonzedwe a selo ndi mtengo wovomerezeka.
PHUNZIRO: Kugwiritsa Ntchito Kusankhidwa kwa Parameter ku Microsoft Excel
Ntchito "INDEX"
Zomwe zimaperekedwa ndi INDEX ntchito zimakhala pafupi ndi mphamvu za ntchito ya CDF. Ikuthandizani kuti mufufuze deta muzinthu zamtengo wapatali, ndi kubweretsanso ku selo lomwe lidatchulidwa.
Mawu omasulira a ntchitoyi ndi awa: "INDEX (selo loyambira; nambala ya mzere; nambala ya chikhomo)."
Iyi si mndandanda wathunthu wa ntchito zomwe zilipo mu Microsoft Excel. Ife tasiya kuyang'ana kokha pa otchuka kwambiri, ndi ofunika kwambiri mwa iwo.
