Yadda ake ƙirƙirar maɓallin In Fiye

Excel shine hadadden processor, kafin waɗanne masu amfani suka sanya ɗawainiya da yawa daban-daban. Wata irin wannan aikin shine ƙirƙirar maɓallin a kan takardar, latsa wanda zai kunna wani tsari. An warware matsalar ta amfani da amfani da kayan aikin Excel. Bari muyi ma'amala da waɗanne hanyoyi zaku iya ƙirƙirar wannan abu a cikin wannan shirin.

Hanyar kirkira

A matsayinka na mai mulkin, an tsara wannan maɓallin don yin aiki azaman tunani, kayan aiki don fara aiwatarwa, Macro, da sauransu. Kodayake a wasu yanayi, wannan abun na iya zama adadi na geometric, kuma ban da dalilai na gani, babu amfani da amfani. Wannan zabin, duk da haka, yana da wuya.

Hanyar 1: wuyar warwarewa

Da farko, yi la'akari da yadda ake ƙirƙirar maɓallin daga siffofin da aka fifita su.

1. Muna yin tafiya zuwa shafin "Saka" shafin. Danna kan "alamu" gunki, wanda yake kan kaset a cikin tef a cikin "zane" toshe kayan aiki. Jerin dukkan nau'ikan adadi da aka saukar. Zaɓi hoton da kuke ganin ya dace da matsayin maɓallin. Misali, irin wannan adadi na iya zama murabba'i mai dari tare da sterooted sterners.



2. Bayan latsa, muna motsa shi zuwa ga fannin takardar (tantanin halitta), inda muke son zama maballin, ku matsa kusa da shi cikin abu don ɗaukar girman da muke buƙata.



3. Yanzu ya kamata ku ƙara takamaiman aiki. Bari ya zama canji zuwa wani takaddun lokacin da ka danna maballin. Don yin wannan, danna shi dama linzamin kwamfuta. A cikin menu na mahallin, wanda aka kunna bayan wannan, zaɓi matsayin "hyperlink".



4. A cikin bude taga na hyperlink, je zuwa "wuri a cikin takaddar" Tab. Zaɓi takardar da muke ganin ya zama dole, danna maɓallin "Ok".

Yanzu, lokacin da ka danna abun da muke halittarmu, za a motsa shi zuwa takardar da aka zaɓa na takaddar.

Darasi: Yadda Ake Yin ko cire Hyperlinks a Fim

Hanyar 2: Hoton gefen

A matsayin maɓallin, Hakanan zaka iya amfani da tsarin ɓangare na uku.

1. Mun sami hoto na ɓangare na uku, alal misali, a yanar gizo, kuma zazzage shi zuwa kwamfutarka.
2. Bude takaddar Excel wanda muke son shirya abu. Je zuwa "Saka" alamar "adadi" wato, wanda yake kan kaset a cikin tef a cikin "zane" toshe.



3. Wurin Zaɓin Hoto yana buɗe. Tafi ta amfani da shi a cikin wannan jagorar na diski na diski, inda ake tsara hoton, wanda aka tsara don aiwatar da maɓallin. Ware sunan da kuma danna maɓallin "Manna" a kasan taga.



4. Bayan haka, an ƙara hoton zuwa jirgin sama na takardar aiki. Kamar yadda a cikin lamarin da ya gabata, ana iya murmurewa, jan iyakokin. Matsar da zane zuwa yankin da muke son a sanya abu.



5. Bayan haka, za a iya ɗaure shi da hyperlink a cikin cocin, kamar yadda aka nuna a hanyar da ta gabata, kuma zaka iya ƙara macro. A cikin wannan lamarin, ta danna maɓallin linzamin kwamfuta na dama akan zane. A cikin menu na mahallin wanda ya bayyana, zaɓi Macro ... "abu.



6. Wurin sarrafa Macro ya buɗe. Yana buƙatar nuna cewa Macro wanda kake son amfani da lokacin da maballin an matsa. Ya kamata a rubuta wannan Macro a cikin littafin. Wajibi ne a haskaka sunan sa kuma danna maɓallin "Ok".

Yanzu danna abun da za a ƙaddamar da zaɓin Macro.

Darasi: Yadda ake ƙirƙirar Macro a Excel

Hanyar 3: Aiki mai aiki

Za'a ƙirƙiri maɓallin mafi yawan lokuta a cikin abin da ya faru cewa abu ne mai aiki don kayan aikinta na farko. Bari mu ga yadda ake yin wannan a aikace.

1. Domin samun damar yin aiki tare da ayyukan aikix, da farko, kuna buƙatar kunna mahimmin shafin. Gaskiyar ita ce cewa ta hanyar tsohuwa an kashe shi. Saboda haka, idan har yanzu baku kunna shi ba, to sai je zuwa "Fayil", sannan matsar da sashin "sigogi".



2. A cikin wuraren da aka kunna da aka kunna, muna matsawa zuwa sashin "ribbon saitin". A gefen dama na taga, mun saita kaska kusa da "mai haɓakawa" idan an ɓace. Na gaba, danna maɓallin "Ok" a kasan taga. Yanzu za a kunna shafin mai samarwa a cikin sigar ku Excel.



3. Bayan haka, muna matsawa zuwa shafin mai haɓakawa. Latsa maɓallin "Saka", wanda ke kan tef a cikin "iko" kayan aiki. A cikin ayyukan aiki na aiki, danna kan farkon kashi da kanta, wanda ke da maballin.



4. Bayan haka, danna kowane wuri akan takarda wanda muke ganin ya zama dole. Nan da nan bayan wannan, kashi zai bayyana a can. Kamar yadda a cikin hanyoyin da suka gabata, gyara wurin da masu girma dabam.



5. Danna kan sakamakon sakamakon kashi biyu danna hagu maɓallin linzamin kwamfuta.



6. Editan Macro ya buɗe. Kuna iya yin rikodin kowane macro da kuke son a kashe shi lokacin da ka danna wannan abun. Misali, zaka iya rikodin rubutaccen rubutun rubutu na rubutu a cikin adadi na adadi, kamar yadda a hoton da ke ƙasa. Bayan an yi rikodin Macro, danna maɓallin rufewa a kusurwar dama ta sama.

Yanzu za a ɗaura Macro a kan abin.

Hanyar 4: Abubuwan sarrafawa na Tsara

Hanyar da ke gaba tana da kama da ga fasahar kisa akan sigar da ta gabata. Maɓallin ne don ƙara maɓallin ta hanyar abun sarrafawa. Hakanan amfani da wannan hanyar, ana buƙatar yanayin haɓakawa.

1. Je zuwa "mai haɓakawa" ka latsa maɓallin da aka saba "Saka", an sanya shi a kan tef a cikin "sarrafa" rukuni. Jerin yana buɗewa. Yana buƙatar zaɓi ɓangaren farko wanda is located a cikin abubuwan da aka gudanar da tsari "rukuni". Wannan abun yana gani daidai yake da irin wannan abu na Activex, munyi magana game da sama.



2. Abin ya bayyana a kan takardar. Gyara girman sa da wurin, kamar yadda suke akai akai akai.



3. Bayan haka, mun sanya macro ga abin da aka kirkiro, kamar yadda aka nuna a cikin hanyar 2 ko sanya hyperlink kamar yadda aka bayyana a cikin hanyar 1.

Kamar yadda kake gani, a cikin excele, ƙirƙirar maɓallin aiki ba shi da wahala kamar yadda zai iya zama kamar mai amfani da ƙwarewa. Bugu da kari, ana iya yin wannan hanyar ta amfani da hanyoyi daban-daban guda hudu a dace.