Microsoft Excel imatha kuwongolera kwambiri wogwiritsa ntchito ndi matebulo ndi mawu a manambala pogwiritsa ntchito zokhazokha. Izi zitha kuchitika pogwiritsa ntchito zida zofunsira ndi ntchito zosiyanasiyana. Tiyeni tiwone zothandiza kwambiri.
Kugwira ntchito ndi mawonekedwe a Excel
Chifukwa cha komwe amagwiritsa ntchito pulogalamuyi, wogwiritsa ntchito sadziwa nthawi zonse za mwayi womwe ungathe Kupitilira munkhani yomwe tikambirana za zinthu 10 zomwe zingakhale zothandiza pazinthu zosiyanasiyana, komanso kupereka maulalo okhudzana ndi zomwe zafotokozedwa pogwira ntchito ndi aliyense wa iwo.Ntchito "Pdd"
Chimodzi mwazomwe mungafunike kwambiri mu Microsoft Excel ndi "Vookup)". Pogwiritsa ntchito, mutha kukoka mfundo za matebulo amodzi kapena angapo kupita ina. Pankhaniyi, kusaka kumachitika kokha pamzere woyamba wa patebulopo, potsatira zomwe zimasintha deta mu tebulo lazomwezo, zomwe zimapangidwa zokha komanso patebulo lochokera ku mawerengeredwe omwe angawerengedwe. Mwachitsanzo, zidziwitso kuchokera pagome pomwe pali zothandizira katundu zitha kugwiritsidwa ntchito kuwerengera zizindikiro pagome patebulo lokhudza kugula mu ndalama.
ERP imayamba poika wothandizira OPR kuchokera ku "ntchito mbuye" m'chipinda chomwe deta iyenera kuwonetsedwa.
Pa zenera lomwe limawonekera, atayamba gawo ili, muyenera kutchula adilesi ya foni kapena maselo osiyanasiyana, kuchokera pomwe zomwe zidalili zikhazikike.
Phunziro: Kugwiritsa ntchito ntchito ya "MPH" ku Microsoft Excel
Matebulo ophatikizika
Gawo lina lofunika kwambiri la pulogalamu ya Excel ndikupanga gulu la chidule, ndikupereka gulu lina la matebulo ena pamiyeso yosiyanasiyana, ndikuwerengera, kuchulukitsa, kugawa, ndi zotsatirazi zimawonetsedwa patebulo lina. Pankhaniyi, pali zotheka kukhazikitsa minda ya pivot.
Amapangidwa kuti "ikani" Tab ndikukanikiza batani, lomwe limatchedwa - "tebulo lachidule".
Phunziro: Ikani magome achinsinsi mu Microsoft Excel
Kupanga Zojambula
Pazithunzi zowoneka bwino za data yomwe imayikidwa patebulopo, ndizotheka kugwiritsa ntchito zojambula. Nthawi zambiri amagwiritsidwa ntchito pofalitsa nkhani, kulemba ntchito zasayansi, chifukwa chofufuzira, ndi zina zambiri. Excel imapereka zida zosiyanasiyana pakupanga zojambula zosiyanasiyana.
Kuti mupange chithunzi, muyenera kuwonetsa maselo anu ndi zomwe mukufuna kuwonetsa. Ndiye, kukhala pa "tabu", sankhani mtundu wa tchati pa tepi, chomwe mumachiwona choyenera kwambiri kukwaniritsa zolinga.
Kukhazikitsa kotsimikizika kwa ma chart, kuphatikiza kukhazikitsa dzina lake ndi mayina a nkhwangwa, kumapangidwa mu tabu ya "ntchito ndi ma chart" tabu.
Chimodzi mwa mitundu ya ma chart ndi zithunzi. Mfundo yomangirira iwo ndi yofanana ndi mitundu yotsala ya ma chart.
Phunziro:
Ma Chart a Magwiridwe mu Microsoft Excel
Kumanga graph mu Microsoft Excel
Njira Zapamwamba
Kugwira ntchito ndi chidziwitso cha manambala, pulogalamuyi imapereka njira zapadera. Ndi thandizo lawo, mutha kupanga zochitika zingapo za masamu ndi deta mu matebulo: kuwonjezera, kuchotsera, kuchulukitsa, kupanga mizu, etc. Kugwiritsa ntchito fomula, muyenera kulowa m'chipindacho, komwe amakonzekera zotsatira zake, ikani chizindikirocho "=". Pambuyo pake, njira yokhayo imayambitsidwa, yomwe imatha kukhala ndi zizindikiro za masamu, manambala ndi ma adilesi. Kutchula adilesi ya khungu, pomwe zomwe zidawerengedwa kuti muwerenge, ndizokwanira kuti mudine ndi mbewa, ndipo magwiridwe ake adzawonekera mu cell kuti zotsatira zake zichitike.
Excel ndiyosagwiritsidwa ntchito komanso yowerengera wamba. Kuti muchite izi, mu mawonekedwe kapena mu khungu lililonse, mawu a masamu amangoyambitsidwa pambuyo pa "=" chizindikiro.
Phunziro: Kugwiritsa ntchito njira mu Microsoft Excel
Ntchito "Ngati"
Chimodzi mwazinthu zodziwika bwino zomwe zimagwiritsidwa ntchito popambana ndi "ngati". Zimapangitsa kuti zitheke kukhazikitsa zotsatira zokhazokha mu cell pomwe akuchita mawonekedwe ake ndi zotsatira zina ngati sizogwirizana. Syntax yake imawoneka motere: ngati (mawu omveka; zotsatira ngati chowonadi]; zotsatira ngati zili zabodza]).
Ogwira ntchito "ndi", "kapena" kapena "ndipo adasiyidwa" ngati "kutsatira mafakitani ambiri kapena imodzi mwazinthu zingapo.
Phunziro: Ikani ntchito "ngati" ntchito mu Microsoft Excel
Macro
Mothandizidwa ndi macros mu pulogalamuyi, kuphedwa kwa machitidwe ena kumalembedwa, kenako kumapangidwa zokha. Izi zimapulumutsa nthawi yochita ntchito yayikulu. Macros amalembedwa potembenuka pazomwe amachita mu pulogalamuyo kudzera pa batani logwirizana pa tepi.
Mbiri ya Macro ikhoza kulembedwanso pogwiritsa ntchito mawonekedwe a chinenerochi cha m'konzi.
Phunziro: Ikani macros ku Microsoft Excel
Kapangidwe kake
Kuti muwonetsetse zambiri, ntchito wamba yopangana imagwiritsidwa ntchito patebulopo, yomwe imakupatsani mwayi kukhazikitsa malamulo osankha maselo. Mawonekedwe okhazikika amaloledwa kuchitidwa ngati histogram, utoto kapena mawonekedwe a zifaniziro. Kusintha kwa iyo kumachitika kudzera mu "Home" ndi gawo la magawo osiyanasiyana omwe mukukonzekera. Kenako, mu "masitayilo" chida ", kanikizani batani kukhala ndi dzina" kapangidwe kake ". Pambuyo pake, zidzakhalabe kusankha njira yomwe mumaganizira yoyenera.
Kusintha kudzaphedwa.
Phunziro: Kugwiritsa ntchito kapangidwe ka chikhalidwe mu Microsoft Excel
"Flement"
Si ogwiritsa ntchito onse omwe amadziwa kuti tebulo, amangokokedwa ndi pensulo kapena malire, explel amawona ngati malo osavuta a maselo. Pangani pulogalamuyo kuti muwone zambiri izi patebulo zitha kusinthidwa. Izi zimachitika mophweka: Kuyamba ndi mtundu womwe mukufuna ndi deta, kenako, kukhala pa tabu yakunyumba, dinani pamtundu wa "batani la tebulo la". Mndandanda udzaonekera ndi mapangidwe osiyanasiyana, omwe amafotokoza zoyenera.
Gome limapangidwanso ndi kukanikiza batani la "tebulo", lomwe limapezeka pa "kuyika" tabu, kukhala ndi gawo lina la pepalalo ndi deta.
Maselo odzipereka a maselo mkonzi amawona ngati tebulo. Zotsatira zake, ngati mungalowetse deta ina m'maselo omwe ali kumalire, adzaphatikizidwanso mkati mwake. Kuphatikiza pa izi, poyenda pansi, chipewa chidzakhala mkati mwanga.
Phunziro: Kupanga tebulo ku Microsoft Excel
Kusankhidwa kwa parament
Pogwiritsa ntchito gawo losankhidwa, mutha kusankha gwero lazomwe zimafunidwa. Dinani "deta" ndikudina "kusanthula" Bwanji ", komwe amakhala mu" ntchito yokhala ndi deta ". Mu mndandanda womwe umawonekera, fotokozerani "kusankha kwa gawo ..." chinthu.
Zenera losankhidwa la parament limatseguka. Mu "kukhazikitsa mu gawo la cell", muyenera kutchula ulalo wa selo yomwe ili ndi njira yomwe mukufuna. Mu gawo la "mtengo", mathero omwe mukufuna kulandira. Mu "firiji yosintha", ikani magwiridwe antchito a cell agwirizane ndi mtengo wowongolera.
Phunziro: Kugwiritsa Ntchito Kusankha Kusankha kwa Microsoft Excel
Ntchito "Index"
Zotheka kuti "index" ili pafupi ndi kuthekera kwa ntchito "Pdd". Zimakupatsaninso kuti mufufuze deta mu mfundo zambiri ndikuwabwezeretsa ku selo. Syntax imawoneka ngati iyi: index (mtundu_anames; nambala__number_number).
Phunziro: Ikani "Index" ntchito mu Microsoft Excel
Uwu si mndandanda wathunthu wa ntchito zonse zomwe zimapezeka mu Microsoft Excel. Timangoganizira zodziwika kwambiri komanso zofunika kwambiri.