Ayyukan aiki shine tsarin da aka saita a Excel da Google Sheets wanda aka nufa don aiwatar da ƙayyadaddun lissafi a cikin tantanin halitta wanda aka samo shi.
Haɗin aiki da jayayya
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Kamar kowane tsari, ayyuka sukan fara tare da alamar daidai ( = ) biye da sunan mai aiki da kuma muhawararsa:
- Sunan aikin suna gaya Excel abin da lissafi zasu yi;
- Ƙididdigar suna ƙunshe cikin cikin mahaifa ko zagaye na zagaye kuma suna gaya wa aikin abin da bayanai za su yi amfani da waɗannan ƙididdiga.
Alal misali, ɗayan ayyukan da aka fi amfani a cikin Excel da Google Sheets shine SUM aiki :
= SUM (D1: D6)
A wannan misali,
- sunan ya gaya Excel don ƙara tare da bayanai a cikin sassan da aka zaɓa;
- aikin da aka yi (D1: D6) yana ƙara abinda ke ciki na tantanin halitta D1 zuwa D6.
Ayyukan Nesting a Formulas
Amfani da ayyukan da aka gina a cikin Excel zai iya fadada ta hanyar yin aiki ɗaya ko fiye a cikin wani aiki a cikin wata hanya. Sakamakon ayyukan nesting shine don bada izinin ƙididdiga masu yawa aukuwa a cikin ɗayan ɗigon ɗawainiya ɗaya.
Don yin wannan, aikin da aka haɓaka yana aiki kamar ɗaya daga cikin muhawara don babban aiki ko waje.
Alal misali, a cikin wannan ƙira, aikin SUM yana kaddamar a cikin aikin ROUND .
Ana kammala wannan ta amfani da SUM aiki a matsayin aikin ROUND na Magana Number .
& # 61; ROUND (SUM (D1: D6), 2)
A lokacin da aka kimanta ayyukan da aka haɓaka, Excel yana aiwatar da mafi zurfi, ko aikin ciki, na farko, sa'an nan kuma ya yi aiki a waje. A sakamakon haka, dabarar a sama za ta yanzu:
- sami adadin dabi'u a cikin kwayoyin halitta D1 zuwa D6;
- zagaye wannan sakamakon zuwa wurare guda biyu.
Tun da Excel 2007, har zuwa matakan 64 na ayyuka masu kwarewa an yarda. A cikin sifofin kafin wannan, an yarda matakan bakwai na ayyuka da aka kafa.
Kayan aiki vs. Ayyuka na Kasuwanci
Akwai ayyuka biyu na ayyuka a cikin Excel da Google Sheets:
- Ayyukan aiki
- Abubuwan Ayyuka ko Yankakken Bayanan Mai amfani
Ayyukan aikin aiki sune wadanda ke cikin shirin, kamar su SUM da ROUND ayyukan da aka tattauna a sama.
Ayyuka na al'ada, a gefe guda suna da ayyukan da aka rubuta, ko aka ƙayyade , ta mai amfani.
A cikin Excel, ayyuka na al'ada an rubuta a cikin harshe shirye-shiryen ginawa: Na'urar Hoto don Aikace-aikace ko VBA don takaice. An halicci ayyuka ta amfani da Editan Kayayyakin Kasuwanci wanda yake a kan shafin Developer na kintinkiri .
Ayyuka na Google Sheets 'an rubuta su a cikin Apps Apps - wani nau'i na JavaScript - kuma an halicce su ta yin amfani da editan rubutun da ke ƙarƙashin menu na Musamman.
Ayyukan al'ada yawanci, amma ba koyaushe ba, karɓar wasu nau'i na shigar bayanai kuma dawo da sakamakon a cikin tantanin halitta inda aka samo shi.
Da ke ƙasa akwai misali na aikin mai amfani da aka ƙayyade wanda yake lissafin rangwame mai saye da aka rubuta a lambar VBA. Mai amfani na asali ya bayyana ayyuka, ko UDF an buga a shafin yanar gizon Microsoft:
Ƙididdigin aiki (yawa, farashin)
Idan yawan> = 100 Sa'an nan
Discount = yawa * farashin * 0.1
Ba haka ba
Raba = 0
Ƙare Idan
Rarraba = Application.Round (Dama, 2)
Ƙare Ayyukan
Ƙuntatawa
A cikin Excel, ayyukan da aka ƙayyade masu amfani zasu iya mayar da dabi'u zuwa tantanin halitta (s) inda suke. A yin haka, ba za su iya aiwatar da umarnin da za su iya canja yanayin yanayin aiki na Excel ba ta kowane hali - kamar gyaggyara abun ciki ko tsarawa na tantanin halitta.
Shafin sanarwa na Microsoft ya ƙayyade iyakokin da ake bi don ayyukan da aka tsara:
- Sanya, sharewa, ko tsara kwayoyin halitta a cikin takardun aiki;
- Canza darajar bayanai a cikin wani cell;
- Ƙarawa, sake sunawa, sharewa, ko ƙara ɗawainiya zuwa littafi ;
- Canza kowane zaɓin yanayi - irin su yanayin lissafi ko ra'ayoyi;
- Ƙaddara abubuwa ko aiwatar da mafi yawan hanyoyin.
Ayyukan Yankakken Mai amfani vs. Macros a Excel
Yayinda Google Sheets basu tallafa musu a halin yanzu ba, a Excel, macro shine jerin matakan da aka yi rikodin da suke sarrafa ayyukan aiki da yawa - irin su tsara bayanai ko kwafi da manna ayyuka - ta bin bin ayyuka na keystrokes ko ayyukan linzamin kwamfuta.
Ko da yake dukansu suna amfani da harshen shirin na VBA ta Microsoft, sun bambanta ne a cikin hanyoyi guda biyu:
- UDF ta yi lissafin yayin da Macros ke gudanar da ayyuka. Kamar yadda aka ambata a sama, UDF ba zai iya yin ayyukan da zai shafi yanayin ba yayin da macros zai iya.
- A cikin maɓallin Edita na Visual Basic, za'a iya bambanta su biyu saboda:
- UDF farawa da bayanin sanarwa kuma ya ƙare tare da Ayyukan Ƙarshe ;
- Macros fara tare da bayanan San kuma ƙare tare da End Sub .