A cikin shirye-shiryen sassauki irin su Excel da Google Spreadsheets, wani tsararren yana da kewayon ko jerin jerin bayanai masu dangantaka wanda aka adana a cikin sassan da ke kusa a cikin takarda.
Tsarin tsararren tsari shine wata hanyar da take fitar da lissafi-irin su Ƙari, ko ƙaddamarwa-akan dabi'u a cikin ɗaya ko fiye da filayen maimakon ƙididdiga ɗaya.
Tsarin tsafi:
- Yi amfani da wannan mahimmanci azaman tsari na yau da kullum-duk suna farawa tare da alamar daidai (=) misali;
- Yi amfani da wannan ma'aikatan lissafi;
- kuma bi wannan tsari na aiki.
Ayyukan Array da Ayyuka na Excel
Yawancin aikace-aikace na Excel-irin su SUM , AVERAGE , ko COUNT -can kuma za a iya amfani da su a cikin tsari.
Har ila yau, akwai wasu ayyuka-irin su aikin TRANSPOSE-wanda dole ne a shigar da shi a kowane lokaci a matsayin tsararren domin ya yi aiki yadda ya kamata.
Amfani da ayyuka da yawa kamar INDEX da MATCH ko MAX da kuma IF za a iya kara ta ta amfani dasu tare a cikin tsari.
CSE Formulas
A cikin Excel, madauran tsari yana kewaye da takalmin gyare-gyare " {} ". Wadannan takalmin ba za a iya tattake su kawai ba, amma dole ne a kara su da wata takarda ta latsa Ctrl, Shift, da Shigar da mabuɗan bayan buga rubutu a cikin tantanin halitta ko sassan.
Saboda wannan dalili, wani mahimman tsari ne a wasu lokutan ana kiransa azaman CSE a Excel.
Baya ga wannan ka'ida shi ne lokacin da ake amfani da takalmin gyare-gyare don shigar da tsararrakin azaman gardama don aikin da ya ƙunshi kawai ƙira ɗaya ko tantancewar sel.
Alal misali, a cikin koyas da ke ƙasa da ke amfani da VLOOKUP da kuma aikin da zaɓaɓɓen aikin don ƙirƙirar daftarin binciken hagu, an halicci tsararren don aikin binciken na Index_num ta hanyar buga takalmin gyare-gyare a cikin jeri.
Matakai na Halitta Tsarin Rage
- Shigar da tsari;
- Riƙe maɓallin Ctrl da Shift a kan keyboard;
- Latsa ka kuma saki maɓallin Shigar don ƙirƙirar tsari;
- Saki Ctrl da makullin Shift .
Idan aka yi daidai, zancen ƙira zai kewaye ta da takalmin gyare-gyare kuma kowace tantanin halitta da ke riƙe da wannan tsari zai ƙunshi wani sakamako dabam.
Editing wani Formula Array
Duk lokacin da aka samarda lissafin tsararren gyare-gyaren gyaran gyare-gyaren gyare-gyare ya ɓace daga keɓaɓɓun tsari.
Don dawo da su, dole ne a shigar da tsarin da aka tsara ta danna maɓallin Ctrl, Shift, kuma Shigar da maimaita kamar yadda a lokacin da aka fara kirkira tsari.
Nau'in Formats na Array
Akwai manyan nau'i biyu na tsararren tsararraki:
- nau'in tsara tsarin mahaɗin halitta - irin wannan tsari yana samuwa a cikin fiye da ɗaya cell a cikin takardun aiki
- tsarin tantancewar sel guda ɗaya daya dabara daya da ke ɗauke da ƙididdiga masu yawa a cikin ɗayan ɗigon ɗawainiya ɗaya
Multi Formula Formats
Kamar sunansu yana nunawa, waɗannan matakan tsararren suna samuwa a cikin ɗakunan Kayan aiki masu yawa sannan kuma sun dawo da tsararren azaman amsar.
A wasu kalmomi, irin wannan tsari yana samuwa a cikin ƙwayoyin biyu ko fiye kuma ya karbi amsoshi daban-daban a kowace tantanin halitta.
Yadda yake yin hakan shine kowane kwafin ko misali na lissafin jigidar yana yin lissafi a cikin kowane tantanin da yake cikin, amma kowane misali na tsari yayi amfani da bayanai daban-daban a cikin lissafi kuma, sabili da haka, kowane misali yana samar da sakamako daban-daban.
Misali na tsararren tsararren tsararren tsararren tsararrakin halitta shine:
{= A1: A2 * B1: B2}
Idan misali na sama yana samuwa a cikin kwayoyin C1 da C2 a cikin takaddun aiki sa'annan sakamakon haka shine:
- bayanan da ke cikin A1 yana karuwa ta wurin bayanai a B1 da sakamakon da aka adana cikin ƙwayar C1
- bayanan da ke cikin A2 ya karu ta wurin bayanai a B2 da sakamakon da aka adana a C2 cell
Kwayoyin Kayan Kwayoyin Cell guda
Wannan nau'i na biyu na tsararren tsari ya yi amfani da aikin, kamar SUM, AVERAGE, ko COUNT, don hada da fitarwa daga tsarin mahaɗin tantanin halitta don darajar ɗaya a cikin tantanin halitta daya.
Misali na tsarin tsararren salula ɗaya shine:
{= SUM (A1: A2 * B1: B2)}
Wannan ƙari ya haɗa nauyin samfurin A1 * B1 da A2 * B2 kuma ya sake samo sakamakon guda ɗaya a cikin sel guda a cikin takardar aiki.
Wata hanya ta rubuta wannan samfurin shine:
= (A1 * B1) + (A2 * B2)
Jerin takardun Jirgin Ƙafi
Da ke ƙasa an jera yawan darussan da ke ƙunshe da matakan lissafi na Excel.
- Koyarwar farko ta kunshe da matakan tsaftace nau'i na kwayoyin halitta
- Koyaswa takwas na gaba sune game da tsarin tsararren salula guda ɗaya ta amfani da ayyuka na Excel
- Koyawa na ƙarshe shine akan aikin TRANSPOSE
01 na 10
Kwafin Fassara na Multi Excel
Tsarin maɓalli mai yawa ko ƙwayar mahaɗin mahaɗin shine tsarin tsararren da aka samo a cikin fiye da ɗaya cell a cikin takardun aiki . Ana yin lissafin wannan lissafin a cikin sel da yawa ta yin amfani da bayanai daban-daban don kowane nau'i. Kara "
02 na 10
Tsarin Samfurin Kwafi na Excel Single Cell Arra na Mataki ta Mataki na Mataki
Shirye-shiryen tsararren ƙwayoyin sirri guda ɗaya sukan fara gudanar da lissafin mahaɗin tantanin halitta (kamar ƙaddamarwa) sannan kuma amfani da aiki kamar AVERAGE ko SUM don hada da fitarwa daga cikin tsararren zuwa wani sakamako guda. Kara "
03 na 10
Kuna Ƙirar Kuskuren lokacin da kake nema BAYANIN
Za'a iya amfani da wannan tsarin tsararren don gano adadin yawancin data kasance yayin da ba a kula da dabi'u mara kyau kamar su # DIV / 0 !, ko #NAME?
Yana amfani da aikin AVERAGE tare da IF da ISNUMBER ayyuka. Kara "
04 na 10
Excel ta SUM IF Formats
Yi amfani da SUM aiki da aikin IF a cikin tsari mai tsafta don ƙidaya fiye da ɗakunan jinsunan da suka hadu da ɗaya daga cikin yanayi.
Wannan ya bambanta daga aikin na Excel ta COUNTIFS wanda ke buƙatar dukkanin yanayi da aka daidaita kafin a kidaya tantanin halitta.
05 na 10
Excel MAX IF Firarren Firayi don gano mafi yawan mafi kyau ko ƙananan lambar
Wannan koyo ya hada aiki na MAX da aikin IF a cikin tsari mai tsari wanda zai sami mafi girma ko ƙimar iyakar ga wani kewayon bayanai lokacin da aka ƙayyade wani ƙayyadaddun bayanin. Kara "
06 na 10
Formel MIN IF Formats - Samun Ƙananan Kyau ko Ƙananan Lambar
Hakazalika da labarin da ke sama, wannan ya hada aikin MIN da aikin IF a cikin tsari mai tsara don samo mafi ƙanƙanci ko mafi ƙarancin darajar don kewayon bayanai lokacin da aka ƙayyade wani ƙayyadadden bayanin. Kara "
07 na 10
MUSALIYAR MUTANE Idan Fassara Formula - Nemi Ƙasar ko Median Darajar
Ayyukan MEDIAN a Excel ya sami darajar tsakiya don lissafin bayanai. Ta hada shi tare da aikin IF a cikin tsari mai tsari, za'a iya samun darajar tsakiyar kungiyoyi daban-daban na bayanan. Kara "
08 na 10
Bincika Formula tare da Maɓalli Cif a cikin Excel
Ta hanyar amfani da tsarin tsararren tsari ana iya kirkiro wata hanyar da za ta iya amfani da sharuɗɗan ma'auni don neman bayani a cikin wani asusun. Wannan madaidaicin tsari ya shafi nesting ayyukan MATCH da INDEX . Kara "
09 na 10
Fom ɗin Neman Hanya na Ƙasar
Ayyukan VLOOKUP kawai ana nema ne kawai don bayanai da ke cikin ginshiƙai zuwa dama, amma ta hada shi tare da tsarin zaɓaɓɓen aikin da za'a iya ƙirƙira wanda zai bincika ginshiƙan bayanai a hannun hagu na binciken na Lookup_value . Kara "
10 na 10
Gyara ko Shirye-shiryen Flip ko ginshiƙai na Bayanai a Excel
Ana amfani da aikin TRANSPOSE don kwafe bayanan da aka samo a cikin jere a cikin wani shafi ko kwafe bayanan dake cikin wani shafi a jere. Wannan aikin yana ɗaya daga cikin 'yan kaɗan a cikin Excel wanda dole ne a koyaushe a yi amfani dashi azaman tsari. Kara "