A cikin labarinmu na yau za mu bincika abubuwan Ayyukan ƙididdiga na Excel Mafi mahimmanci, idan kuna son ƙarin koyo game da wannan kayan aikin Microsoft, bari mu fara!
Gano hanya mafi kyau don amfani da lambobi, bayanai da ƙididdiga tare da Microsoft Excel
Ayyukan Ƙididdiga na Excel
Kafin shiga sararin duniya na ginshiƙai, sel da Ayyukan ƙididdiga na ExcelDole ne mu fara fahimtar menene Excel, menene don sa kuma menene ayyukan sa? Idan kuna son fahimtar duk wannan, ku kasance tare da mu! Domin a yau za mu amsa duk waɗannan tambayoyin.
Wannan kayan aikin yana da hanyoyin da ba su da iyaka don warware ayyukan, lissafin lissafi da ƙididdiga, duk da haka, ba shi da sauƙin fahimtar duk waɗannan ayyukan, amma tare da ilimi da aiki muna da tabbacin za ku iya cimma shi, yanzu, bari mu fara.
Menene Excel?
Aikace-aikacen Microsoft ne, wanda aka kirkira a cikin 1982 lokacin da kamfanin ya haɓaka tsarin da ake kira Multiplan, amma a lokacin jagora a cikin maƙunsar maƙallan shine LOTUS 1-2-3. Komai ya canza a cikin 1987 lokacin da Excel ya daidaita software ta zuwa Windows, kuma ya zama sananne a cikin kamfanoni.
Har wa yau har yanzu yana da amfani a fagen lissafin kuɗi ta amfani da maƙunsar bayanai da aka raba zuwa ginshiƙai, layuka da sel, yana da kayan aiki da yawa don warware matsalolin lissafi, lissafi da matsalolin lissafi.
Tun da yin amfani da editan VBA, Excel na iya sarrafa lambobi da haruffan haruffa, daidaitawa da aiwatar da waɗannan ayyuka masu rikitarwa ta amfani da ayyuka daban -daban da dabaru waɗanda za mu yi magana a kansu daga baya.
Menene Excel don?
Excel yana ba mu damar ƙirƙirar tebura da jadawalai masu mahimmanci, warware mahimman ayyukan lissafi ta atomatik kuma tsara su a cikin tsarin ginshiƙan da aka ambata ta haruffa da layuka masu lamba, irin na kayan aikin Microsoft.
Hakanan yana ba mu damar rarrabe waɗannan sel ta hanyar launi da haruffa, wanda ke da amfani idan kuna son ba ayyukan ku kyakkyawan yanayi mai sauƙin fassara.
Duk waɗannan ayyukan ana samun su a kusan duk sigogin Excel, waɗanda ke da goyan baya ga Windows, MacOS, Android da iOS, suna da sigar kyauta da ake kira Excel Online da sigar biya da ake kira Office 365.
Ayyukan Excel da dabaru
Yanzu da muka san menene wannan kayan aikin da abin da ake amfani da shi, lokaci yayi da zamuyi magana game da mahimman ayyukan ƙididdigar Excel, kuma don hakan zamu bincika kowannensu, don haka karanta!
Microsoft Excel yana da ayyukan ƙididdiga sama da 100, sune 108 idan muna son zama daidai, waɗanda ke da fa'ida sosai ga nau'ikan ayyuka daban -daban, duk da haka, a yau za mu ambaci wasu daga cikin waɗanda a ra'ayinmu sune mafi mahimmancin ayyuka masu amfani, kuma muna nuna su a ƙasa:
Yana da kayan aiki da yawa wanda zaku iya koyan amfani dashi a yau!
MADIYA
Wannan aikin yana taimaka mana cikin sauƙin samun lamba ta tsakiya cikin kewayon lambobi da muka bayar. Haɗin haɗin don amfani da wannan aikin shine: MADADI (A *: A *).
Haruffa suna wakiltar shafi kuma asterisks lambar ginshikan kewayon sel waɗanda muke so mu san cibiyar, kuma sakamakon zai dogara ne akan ƙimar da muke sarrafawa, tunda kewayon na iya zama lambobi, sunaye , da dai sauransu. Akwai irin wannan aikin da ake kira Average, duk da haka ya bambanta da wannan.
HIERARCHY
Aikin da ke bi yana nuna mana girman ƙima idan aka kwatanta da wasu a cikin jerin, yana kuma da masu canji guda biyu kamar HIERARCHY.EQV da HIERARCHY.MEDIA. Haɗin wannan aikin shine: HIERARCHY (A3; A2: A4; 1).
Kamar yadda kuka riga kuka sani, ƙimomin za su bambanta dangane da jere da shafi da muke son bincika. Darajar farko (A3) ita ce wacce muke so mu nemo matsayi, ƙima ta biyu (A2: A4) za ta kasance jerin layuka inda za a gudanar da bincike kuma ƙimar ƙarshe ta zaɓi ce, wannan zai zama tsari da muke so mu ba wa ƙimar farko.
Mun riga mun ambata cewa wannan aikin yana da bambance -bambancen guda biyu, na farko HIERARCHY.EQV zai nemo ƙimar girman dangi, idan akwai ƙima biyu tare da madaidaicin matsayi ɗaya, yana dawo da babban matsayi zuwa wannan.
Sauran bambance -bambancen HERARCH.MEDIA yana ba mu matsakaicin matsayi idan akwai ƙimomi da yawa tare da matsayi iri ɗaya. Dukansu bambance -bambancen suna amfani da ƙa'ida ɗaya.
Magajin gari
Aikin K.THE GREATEST ya dawo da mafi girman darajar jerin adadi, alal misali, ƙimar 2 mafi girma. Syntax na wannan aikin shine: K. MAI GIRMA (A10: B20; XNUMX).
Darajar farko (A2: B10) za ta kasance asali daga inda muke son bincika, kuma ƙimar ta biyu za ta nuna cewa muna nema, a wannan yanayin, ƙimar ashirin mafi girma a cikin kewayon da aka nuna.
KADAN
Aikin K.ESIMO.MENOR shine kishiyar al'amari ga wanda ya gabata, yana neman ƙaramin adadi na jerin bayanai. Syntax na wannan shine: K.ESIMO.MENOR (A2: B10; 20).
Darajar farko (A2: B10) za ta kasance zangon da kuke son bincika, kuma ƙima ta biyu za ta kasance, a wannan yanayin, mafi ƙarancin ashirin na mafi girman kewayon da aka nuna. Yanzu za mu nuna muku inda za ku sami waɗannan ayyukan a cikin Excel:
Hanyar da za mu samu dama ga duk waɗannan ayyukan za ta kasance ta taɓa maɓallin fx kamar yadda aka nuna a hoton.
Dole kawai ku zaɓi rukunin kuma ku nemi aikin da kuke so.
COUNTBLANK
Amfanin wannan aikin yana da sauƙi, nemo adadin sel marasa fa'ida a cikin takamaiman iyaka kuma ana samun godiya ga: COUNTIF.BLANK (A2: B6). Wannan ƙima ɗaya za ta kasance kewayon da muke son bincika sel marasa amfani, kamar yadda kuke gani, aiki ne mai mahimmanci amma mai amfani.
MAFITA
Kamar yadda sunan ke nunawa, ana amfani da wannan aikin don nemo sau nawa ake maimaita ƙima a cikin keɓaɓɓen kewayen sel. A wannan yanayin, lambar ita ce kamar haka: FREQUENCY (A2: A10; B2: B10).
Darajar farko (A2: A10) za ta zama adadin sel wanda muke so mu sami mitar, kuma ƙima ta biyu (B2: B10) za ta kasance sel inda za a haɗa sakamakon binciken mitar. Ya kamata a lura cewa wannan aikin yana la'akari da lambobi kawai, ba sel marasa amfani ko rubutu ba.
GYARA
Ana amfani da aikin TREND, wanda ya cancanci koma baya, don nemo yanayin kuma an jefa wannan ta hanyar layi, wato, ana amfani dashi don nemo sakamakon gaba na jerin ƙimomi. Haɗinsa shine: TREND (A2: A13, B2: B13, B16: B20).
Darajar farko (A2: A13) za ta zama ƙimar da muka sani daga lissafin Y = MXB, daidai da Y. Ƙimar ta biyu (B2: B13) tayi daidai da ƙimar X a lissafin da ya gabata da ƙima ta uku (B16: B20) za ta zama ƙimar X da muke son haifar daga Y.
QARAWA
Wannan aikin yana da rawar da ta yi kama da na baya, wanda shine don ƙididdige saurin haɓaka wanda bayanan da ake tambaya zasu samu. A wannan yanayin haɗin ginin zai zama: GIRMA (B2: B5, A2: A5, A7: A8).
Darajar farko (B2: B5) za ta zama sanannun ƙimar daidaiton Y = B * M ^ X, daidai da Y. Ƙimar ta biyu (A2: A5) tayi daidai da ƙimar X a lissafin da ya gabata , da ƙima ta uku (A7: A8), zai yi daidai da sabbin ƙimomin da muke son samu daga Y a X.
Idan kuna son wannan labarin, muna da ƙarin bayani game da Excel akan gidan yanar gizon mu. Da fatan za a ziyarci Canza txt zuwa Excel Yadda ake yin shi da sauri?
Bayan doguwar tafiya ta cikin Ayyukan ƙididdiga na Excel Mafi mahimmanci, wanda ya kasance mai ilimi da bayani sosai, dole ne ku tuna cewa akwai ayyukan ƙididdiga sama da 100 don amfani. Wannan shine dalilin da ya sa muka bar muku hanyar haɗi zuwa ƙarin bidiyon gabatarwa da asali ga sauran ayyukan Excel. Sai anjima!