I-Microsoft Excel ingenza kube lula kakhulu ukuthi umsebenzisi asebenze ngamatafula nezinkulumo zamanani, azenze ngokuzenzakalelayo. Lokhu kungafinyelelwa ngokusebenzisa i-toolkit yalolu hlelo lokusebenza, nemisebenzi yayo ehlukahlukene. Ake sibheke izici eziwusizo kakhulu ze-Microsoft Excel.
Umsebenzi we-Vpr
Esinye sezici ezithandwa kakhulu ku-Microsoft Excel yi-VLOOKUP. Ngalesi sici, ungakwazisa amanani wetayela elilodwa noma lamaningana, donsela kwenye. Kulokhu, ukusesha kwenziwa kuphela kukholomu yokuqala yetafula. Ngakho-ke, uma idatha ishintsha kuthebula lomthombo, idatha ivele ngokuzenzakalelayo kuthebula elisuselwe, lapho izibalo ezihlukene zingenziwa khona. Isibonelo, idatha esuka etafuleni lapho uhlu lwamanani entengo yamanani etholakala ingasetshenziswa ukubala izinkomba etafuleni, mayelana nomthamo wokuthenga ngemali.
I-CDF iqalwa ngokufaka opharetha "CDF" kusuka kwi-Function Wizard esitokisini lapho idatha kufanele iboniswe khona.
Ewindini ebonakalayo, emva kokuqala lo msebenzi, udinga ukucacisa ikheli leseli noma ububanzi bamaseli lapho idatha izokhipha khona.
Isifundo: Ukusebenzisa i-WFD ku-Microsoft Excel
Amathebula okufingqiwe
Esinye isici esibalulekile se-Excel yilapho kudalwa amatafula we-pivot. Ngalolu msebenzi, ungakwazi ukuqoqa idatha kusuka kwamanye amatafula ngokusho kwezinqubo ezahlukene, kanye nokwenza izibalo ezihlukahlukene nabo (isamba, ukuphindaphinda, ukwahlukanisa, njll), futhi ukhiphe imiphumela etafuleni elihlukile. Ngesikhathi esifanayo, kunezindlela ezinkulu kakhulu zokubeka amasimu etafuleni e-pivot.
Ithebula le-pivot lingadalwa kuthebhu ethi "Faka" ngokuchofoza inkinobho ethi "Pivot Table".
Isifundo: Ukusebenzisa i-PivotTables ku-Microsoft Excel
Ukwenza amashadi
Ukuboniswa kwedatha eboniswe etafuleni, ungasebenzisa amashadi. Angasetshenziselwa ukwakha izethulo, ukubhala amaphepha okucwaninga, ngezinjongo zocwaningo, njll. I-Microsoft Excel inikezela ngamathuluzi amaningi okudala izinhlobo ezahlukene zamashadi.
Ukwakha ishadi, kudingeka ukhethe isethi yamaseli nedatha ofuna ukuyibukisa ngokubukeka. Khona-ke, ekubeni kuthebhu ethi "Faka", khetha i-ribbon uhlobo lomdwebo ocabanga ukuthi ufaneleka kakhulu ekufinyeleleni imigomo ebekiwe.
Ukulungiselelwa okucacile kwemidwebo, kufaka phakathi ukusethwa kwamagama kanye nezinkomba, kwenziwa kuthebhu "Ukusebenza imidwebo".
Uhlobo olulodwa lweshadi ihluzo. Isimiso sokwakhiwa kwazo kufana nezinye izinhlobo zemidwebo.
Isifundo: Ukusebenzisa amashadi ku-Microsoft Excel
Amafomula ku-EXCEL
Ukuze usebenze ngemininingwane yamanani ku-Microsoft Excel, kulula ukusebenzisa amafomula akhethekile. Ngesizo sabo, ungenza imisebenzi ehlukahlukene yezibalo kanye nedatha kumatafula: ukuhlanganisa, ukususa, ukubuyabuyelela, ukwehlukanisa, ukuphakamisa izinga lezimpande zempande, njll.
Ukuze usebenzise ifomula, udinga esitokisini lapho uhlela khona ukubonisa umphumela, faka uphawu "=". Emva kwalokho, ifomula ngokwayo iqaliswa, okungaba nemifanekiso yamathematika, izinombolo, namakheli eseli. Ukuze ucacise ikheli leseli lapho idatha ethathwa khona, cindezela kuso ngegundane, futhi izixhumanisi zayo zizovela esitokisini ukubonisa umphumela.
Futhi, i-Microsoft Excel ingasetshenziswa njengendlela yokubala evamile. Ukuze wenze lokhu, kubha yefomula noma kunoma yisiphi iseli nje faka amagama abonisa izibalo ngemuva kwesibonakaliso "=".
Isifundo: Ukusebenzisa amafomula ku-Microsoft Excel
Umsebenzi we-IF
Esinye sezici ezidume kakhulu ezisetshenziswe ku-Excel yiyona "IF" umsebenzi. Ngesizo salo, ungasetha esitokisini ukukhishwa komphumela owodwa uma isimo esithile sihlangene, nomunye umphumela, uma kungenakwenzeka.
I-syntax yalo msebenzi ilandelayo: "I-IF (inkulumo enengqondo; [umphumela uma kuyiqiniso]; [umphumela uma kungamanga])".
Ngosizo lwabaqhubi "NO", "OR" kanye nomsebenzi osikiwe "IF", ungabeka ukuhambisana nezimo eziningana, noma esinye sezimo eziningana.
Isifundo: Ukusebenzisa umsebenzi we-IF ku-Microsoft Excel
Macros
Ukusebenzisa ama-macros ku-Microsoft Excel, ungabhala ukukwenziwa kwezenzo ezithile, bese uzidlala ngokuzenzekelayo. Lokhu kusindisa kakhulu isikhathi sokwenza umsebenzi omningi wohlobo olufanayo.
Ama-Macros angabhalwa ngokumane asebenze ukuqoshwa kwezenzo zabo ohlelweni, ngokusebenzisa inkinobho ehambelana ne-tape.
Futhi, ama-macros angabhalwa ngokusebenzisa ulimi lwe-Visual Basic ngolwazi lomhleli kumhleli okhethekile.
Isifundo: Ukusebenzisa i-Macros ku-Microsoft Excel
Ukufometha okunemibandela
Ukuze ukhethe idatha ethile etafuleni, umsebenzi wokufometha okunemibandela usetshenzisiwe. Ngalesi thuluzi, ungenza ngokwezifiso imithetho yokukhetha yeseli. Ukufometha okunemibandela ngokwayo kungenziwa ngendlela ye-histogram, isikali sombala, noma isethi yezimpawu.
Ukuze ufake ukufometha okunemibandela, udinga ukukhetha ububanzi bamaseli ozoyifometha, ngenkathi kuthebhu lasekhaya. Okulandelayo, kuthebhu yamathuluzi wezitayela, chofoza inkinobho, ebizwa ngokuthi Ukufometha Okumpoqo. Ngemuva kwalokho, udinga ukukhetha ukhetho lokufomatha ocingayo olufanele kakhulu.
Ukufometha kuzokwenziwa.
Isifundo: Ukusebenzisa ukufometha okunemibandela ku-Microsoft Excel
Ithebula elihlakaniphile
Akubona bonke abasebenzisi abawazi ukuthi itafula, elitholakala epencil, noma ukusebenzisa umngcele, i-Microsoft Excel ibona njengendawo elula yamaseli. Ukuze le datha isethwe ukuthi ibonwe njengetafula, kufanele iguquke.
Lokhu kwenziwa ngokumane. Okokuqala, khetha uhla olufunwa nedatha, bese-ke, ekubeni kuthebhu "Ekhaya", chofoza inkinobho ethi "Fometha njengetafula". Emva kwalokho, uhlu lubonakala ngezinketho ezihlukahlukene zokuklama ithebula. Khetha okungcono kakhulu kubo.
Futhi, itafula lingadalwa ngokuchofoza inkinobho ethi "Ithebula", esitholakala kuthebhu ethi "Faka", ngemuva kokukhetha indawo ethize yephepha lesedatha.
Ngemuva kwalokho, isethi ekhethiwe yamaseli e-Microsoft Excel izobonakala njengetafula. Ngenxa yalokho, isibonelo, uma ufaka idatha emaseli asezindaweni zetafula, zizofakwa ngokuzenzakalelayo kuleli tafula. Ngaphezu kwalokho, uma uphenya phansi, isihloko setafula sizohlala njalo ngaphakathi kwendawo yokubuka.
Isifundo: Ukwakha ispredishithi ku-Microsoft Excel
Ukukhethwa kwepharamitha
Ngosizo lomsebenzi wokukhetha ipharamitha, ungathatha idatha yomthombo ngokusekelwe ekugcineni okudingayo.
Ukuze usebenzise lo msebenzi, udinga ukuba ungene kuthebhu "YeDatha". Khona-ke, udinga ukuchofoza ku-"Ukuhlaziywa" kuthiwani uma "inkinobho, esitholakala ebhokisini lamathuluzi" Ukusebenza neDatha. "Khona-ke, khetha" Into yokukhethwa kweparameter ... "ohlwini oluvela.
Iwindi lokukhethwa kwepharamitha liqedwa. Emkhakheni "Faka esitokisini" kufanele ucacise isixhumanisi esitokisini esinefomula oyifunayo. Ensimini "Inani" kufanele lichazwe umphumela wokugcina ofuna ukuwuthola. Esikhathini esithi "Ukushintsha amanani weseli" udinga ukucacisa izixhumanisi zeseli ngexabiso elilungisiwe.
Isifundo: Ukusebenzisa ukukhethwa kweParameter ku-Microsoft Excel
Umsebenzi "INDEX"
Amakhono anikezwe umsebenzi we-INDEX aseduze kakhulu namakhono omsebenzi we-CDF. Ibuye ikuvumele ukuthi useshe idatha ngamanani amanani, bese ubuyisa esitokisini esicacisiwe.
I-syntax yalo msebenzi ilandelayo: "INDEX (ibanga leseli; inombolo yomugqa; inombolo yekholomu)."
Lokhu akulona uhlu oluphelele lwemisebenzi ekhona ku-Microsoft Excel. Sabeka ukunakekelwa kuphela ethandwa kakhulu, futhi kubaluleke kakhulu kubo.
