Ɗaya daga cikin siffofin mai ban sha'awa na Microsoft Excel shine aikin Don sarkar. Babban aikinsa shi ne hada hada da nau'i biyu ko fiye da daya. Wannan afaretan yana taimakawa wajen magance wasu matsalolin da ba za a iya fahimta tare da taimakon wasu kayan aikin ba. Alal misali, tare da taimakonsa yana dacewa don aiwatar da hanyar haɗuwa da sel ba tare da hasara ba. Ka yi la'akari da damar da wannan aikin yake ciki da kuma nuances na aikace-aikace.
Aikace-aikacen mai aiki CLUTCH
Yanayi Don sarkar yana cikin ƙungiyar masu aiki na Excel Excel. Babban aikinsa shi ne hada dukkan abinda ke tattare da kwayoyin da yawa da kuma halayen mutum a cikin tantanin halitta daya. Farawa tare da Excel 2016, ana amfani da aikin maimakon wannan afaretan. Mataki. Amma don kulawa da afaretocin haɗin baya Don sarkar Har ila yau, ya bar, kuma ana iya amfani da shi Mataki.
Rubutun ga wannan bayani shine kamar haka:
= CLUTCH (rubutu1; text2; ...)
Ƙididdiga na iya zama ko dai rubutu ko nassoshi ga sassan dake dauke da shi. Yawan jayayya na iya bambanta daga 1 zuwa 255.
Hanyar 1: Samar da Bayanin Lafiya
Kamar yadda ka sani, saba'in ƙungiyar sel a cikin Excel tana kaiwa ga asarar bayanai. Sai kawai bayanan da aka samo a cikin hagu na hagu na ajiye. Domin hada abin da ke cikin ɓangarorin biyu ko fiye a Excel ba tare da hasara ba, zaka iya amfani da aikin Don sarkar.
- Zaɓi tantanin halitta wanda muke shirya don sanya bayanai haɗe. Danna maballin "Saka aiki". Yana da taswirar hoto kuma yana hagu zuwa hagu na tsari.
- Yana buɗe Wizard aikin. A cikin rukunin "Rubutu" ko "Jerin jerin jerin sunayen" neman mai aiki "CLICK". Zaɓi wannan suna kuma danna maballin. "Ok".
- An kaddamar da taga na aiki. Tambayoyi na iya zama halayen tantance halitta wanda ya ƙunshi bayanai ko raba rubutu. Idan aikin shine hada hada da kwayoyin halitta, to, a wannan yanayin zamuyi aiki kawai tare da haɗi.
Saita siginan kwamfuta a filin farko na taga. Sa'an nan kuma zaɓi hanyar haɗin kan takardar da ke dauke da bayanan da aka buƙata don ƙungiyar. Bayan bayanan da aka nuna a cikin taga, muna ci gaba da hanya guda tare da filin na biyu. Saboda haka, zaɓi wani tantanin halitta. Muna yin irin wannan aiki har sai an tsara dukkanin jinsunan da ake buƙatar haɗuwa tare da su. Bayan haka, danna maballin "Ok".
- Kamar yadda kake gani, abubuwan da ke cikin yankunan da aka zaɓa suna nunawa a cikin tantanin tantanin halitta wanda aka ƙayyade. Amma wannan hanyar yana da muhimmin bita. Idan aka yi amfani da shi, abin da ake kira "gluing mara kyau" yana faruwa. Wato, babu sarari a tsakanin kalmomi kuma an haɗa su a cikin guda ɗaya. A wannan yanayin, da hannu tare da ƙara sararin samaniya bazai aiki ba, amma ta hanyar gyara madaidaicin.
Darasi: Wizard Function Wizard
Hanyar 2: Yi amfani da aikin tare da sarari
Akwai damar da za a gyara wannan lahani ta hanyar sakawa tsakanin wurare tsakanin muhawarar aiki.
- Yi aiki bisa ga wannan algorithm kamar yadda aka bayyana a sama.
- Danna maɓallin linzamin hagu sau biyu a kan kwayar halitta kuma kunna shi don gyarawa.
- Tsakanin kowace gardama mun rubuta bayanin a cikin wani wuri, wanda aka daura a gefe biyu ta hanyar sharhi. Bayan ƙara kowane irin darajar, mun sanya semicolon. Binciken ra'ayi na maganganun da aka kara da cewa ya zama kamar haka:
" "; - Domin nuna sakamakon akan allon, danna maballin. Shigar.
Kamar yadda kake gani, a wurin sanya wuri tare da kalmomi a cikin tantanin halitta, akwai rarrabe tsakanin kalmomi.
Hanyar 3: Ƙara sarari ta hanyar daftarin gardama
Tabbas, idan ba'a iya samun dabi'u mai yawa ba, to, samfurin da aka sama na raguwa na gluing yana cikakke. Amma zai zama da wuya a fassara fassarar sau da yawa idan akwai kwayoyin da yawa da suke buƙatar haɗuwa. Musamman ma, idan wadannan kwayoyin ba su cikin guda ɗaya ba. Kuna iya sauƙaƙa sauƙin sanya wuri ta amfani da zabin don saka shi ta hanyar maƙallin bayani.
- Biyu danna maballin hagu na hagu don zaɓar kowane ɗakin maras amfani a kan takardar. Yin amfani da keyboard ya saita sarari a ciki. Yana da kyawawa cewa ta kasance daga babban tsararren. Yana da matukar muhimmanci cewa wannan tantanin halitta bata cika da bayanan ba bayan wannan.
- Yi irin wannan matakai kamar yadda a cikin hanyar farko ta amfani da aikin. Don sarkar, har sai maɓallin kwastar mai aiki ya buɗe. Ƙara darajar tantanin farko tare da bayanan da ke cikin taga na taga, kamar yadda aka bayyana a baya. Sa'an nan kuma saita siginan kwamfuta a filin na biyu, sa'annan zaɓi ɗakin maras amfani tare da sarari, wadda aka tattauna a baya. Hanya yana bayyana a cikin filin jigilar gardama. Don ci gaba da tsari, za ka iya kwafin shi ta zaɓar da latsa maɓallin haɗin Ctrl + C.
- Sa'an nan kuma ƙara haɗi zuwa abun gaba don ƙarawa. A filin na gaba, sake ƙara hanyar haɗi zuwa ɓataccen ɗakin. Tun da mun kwafe adireshinsa, zaka iya saita siginan kwamfuta a filin kuma danna maɓallin haɗin Ctrl + V. Za a saka haɗin gwiwar. Ta wannan hanyar mun canza filin tare da adiresoshin abubuwa da kullun marayu. Bayan an shigar da bayanai, danna kan maballin "Ok".
Kamar yadda kake gani, bayan wannan, an kafa rikodin haɗin kai a cikin wayar da aka kera, wanda ya haɗa da abinda ke cikin dukan abubuwa, amma tare da sarari tsakanin kowace kalma.
Hankali! Kamar yadda kake gani, hanyar da aka sama ta hanzarta cigaba da aiwatar da daidai hada bayanai a cikin sel. Amma ya kamata a lura cewa wannan zaɓi yana cike da "faɗuwar hanyoyi". Yana da mahimmanci cewa a cikin kashi wanda ya ƙunshi sarari, a tsawon lokaci wasu bayanai basu bayyana ko ba a canza ba.
Hanyar 4: Gurbin Daidaitawa
Amfani da aikin Don sarkar Zaka iya hada bayanai da sauri daga ginshiƙai masu yawa zuwa ɗaya.
- Tare da jinsunan jeri na farko na ginshiƙan da ake haɗuwa, muna yin zaɓi na ayyukan da aka ƙayyade a cikin na biyu da na uku na amfani da hujja. Gaskiya ne, idan ka yanke shawarar yin amfani da hanyar tare da kullun maras amfani, to, hanyar haɗi zuwa gare shi zai buƙaci a cika. Don yin wannan, zamu sanya alamar dollar a gaban kowane haɗin gwiwar daidaitawa da kuma tsaye a cikin wannan tantanin halitta. ($). Yawanci, ya fi dacewa don yin wannan a farkon, don mai amfani zai iya kwafin shi zuwa wasu filayen da ke dauke da wannan adireshin, domin yana ƙunshe da cikakkun hanyoyin. A cikin sauran wurare bar links masu dangantaka. Kamar yadda kullum, bayan yin aikin, danna maballin. "Ok".
- Saita siginan kwamfuta a cikin kusurwar dama na kusurwar tare da tsari. Ɗauki yana bayyana a cikin hanyar gicciye, wanda ake kira alamar cika. Riƙe maɓallin linzamin hagu kuma saukar da shi a layi daya zuwa tsari na abubuwan da za a haɗa su.
- Bayan yin wannan hanya, za a haɗa bayanai a cikin ginshiƙan da aka ƙayyade zuwa ɗaya shafi.
Darasi: Yadda zaka hada ginshiƙai a Excel
Hanyar 5: ƙara karin haruffa
Yanayi Don sarkar za a iya amfani da su don ƙara ƙarin haruffa da maganganun da ba a cikin jeri na jeri na ainihi ba. Bugu da ƙari, ta amfani da wannan aikin, za ka iya shigar da wasu masu aiki.
- Yi ayyuka don ƙara dabi'un zuwa ƙididdigar aiki ta amfani da kowane daga cikin hanyoyin da aka bayyana a sama. A cikin ɗaya daga cikin filayen (idan ya cancanta, za'a iya samun dama daga cikinsu) mun ƙara kowane abu na rubutu wanda mai amfani ya dauka ya zama dole don ƙarawa. Dole ne a rubuta wannan rubutu a cikin sharuddan. Muna danna maɓallin "Ok".
- Kamar yadda kake gani, bayan wannan aikin, an kara rubutu a cikin bayanai wanda aka hade.
Mai sarrafawa Don sarkar - hanya guda kawai ta hada haɗin ba tare da hasara a Excel ba. Bugu da ƙari, ana iya amfani da shi don haɗa dukkan ginshiƙai, ƙara dabi'un rubutu, yi wasu manipulations. Sanin algorithm don yin aiki tare da wannan aikin zai sa ya fi sauƙi don magance tambayoyin da yawa ga masu amfani da wannan shirin.
