Pofuna ogwiritsa ntchito, Excel palibe chinsinsi chomwe mu pulogalamuyi mutha kupanga mitundu yosiyanasiyana masamu, mainjini ndi ndalama. Izi zimachitika ndikugwiritsa ntchito njira zosiyanasiyana. Koma, ngati Excel amagwiritsidwa ntchito kuwerengera izi, funso la bungwe lofunikira pa zida izi ndizofunikira mwachindunji pa pepalalo, lomwe lidzakulitsa liwiro la ogwiritsa ntchito. Tiyeni tiwone momwe mungayankhirenso.
Njira Zopangira Zopangira
Ntchito yosindikiza makamaka imakhala ngati ikufunika kuwerengera nthawi zonse ndi kuwerengera komwe kumagwirizana ndi mtundu wina wa zochitika. Mwambiri, kuwerenga konse ku Excel kungagawike m'magulu awiri: Universal (amagwiritsidwa ntchito pa masamu wamba masamu) ndi mbiri yopapatiza. Gulu lomaliza limagawidwa m'mitundu yambiri: ukadaulo, ndalama, ngongole, ngongole. Kuchokera ku magwiridwe antchito a Calculator, Choyamba, kusankha kwa algorithm kuti chilengedwe chake chimadalira.Njira 1: Gwiritsani macros
Choyamba, lingalirani za algorithms pakupanga zowerengera zamitundu. Tiyeni tiyambe ndikupanga kwa chowerengera chosavuta kwambiri padziko lonse lapansi. Chida ichi chidzagwira ntchito za masamu: kuwonjezera, kuchulukitsa kwa kuchotsa kuchotsera, magawano, etc. Amakhazikitsidwa pogwiritsa ntchito macro. Chifukwa chake, musanatsatidwe ndi kupanga, muyenera kuonetsetsa kuti mwathandiza ma macros ndi proteder gulu. Ngati sichoncho, ndiye kuti muyenera kuyambitsa ntchito ya macros.
- Pambuyo pazolosera pamwambapa zimapangidwa, kusamukira ku "wopanga". Tadidina chithunzi cha "choyambirira" choyambirira, chomwe chili pa tepi mu "Code" chida.
- Zenera la VBA limayamba. Ngati dera lapakati likuwonetsedwa mu imvi, osati loyera, ndiye zikutanthauza kuti gawo lakusintha kwa code silikupezeka. Kuti mutsegule chiwonetsero chake, pitani "ndi menyu" ndikudina pa "Code" zolemba zomwe zikuwoneka. Mutha, mmalo mwa izi, kanikizani fungulo la F7. Mulimonsemo, gawo lolowera la code lidzawonekera.
- Pano m'dera lapakati tikufunika kulemba nambala ya Macro. Ili ndi mawonekedwe awa:
Calculator ()
Sta conxps ngati chingwe
'Kulowetsa deta kuti awerenge
Strexprpt = bokosi lolowera ("Lowani deta")
'Kuwerengera kwa zotsatira zake
MsGBOBT STEXPT & "=" & Ntchito.evaltur (Straxpr)
Kutha kwa sig.
M'malo mwa mawu akuti "Lowani deta" mutha kuwotcha zovomerezeka zanu. Ndi zomwe zidzapezeke pamwamba pa munda.
Pambuyo polemba, fayiloyi iyenera kulembedwa. Nthawi yomweyo, iyenera kupulumutsidwa mwa mtunduwo ndi macros. Timadina chithunzi mu mawonekedwe a floppy disk pa chipangizo cha VBA mkonzi.
- Zenera losunga chikalata limayambitsidwa. Pitani ku chikwatu pa disk hard disk kapena media yochotsa komwe tikufuna kupulumutsa. Mu "fayilo ya fayilo", mumapereka dzina lililonse kapena kusiya chosakhazikika chomwe chimaperekedwa kwa icho. Povomerezedwa mu gawo la fayilo, sankhani dzina "buku la" Excel Buku la Macros (* .xlm) "kuchokera ku mitundu yonse yomwe ilipo. Pambuyo pa izi, dongo pa batani la "Sungani" pansi pazenera.
- Pambuyo pake, mutha kutseka zenera la Macro podina chithunzi chotseka mu mawonekedwe a lalikulu lofiira ndi mtanda woyera pakona yakumanja.
- Kuti muyambitse chida chogwiritsa ntchito ma mero ali ku dafuti la proser tabu, dongo pa macros chithunzi pa tepi mu "Khodi".
- Pambuyo pake, zenera la Macro limayamba. Sankhani dzina la Macro, omwe tidangopanga, ndikudina pa batani la "Run".
- Pambuyo pochita izi, wowerengera amayambitsidwa potengera pa Macro.
- Pofuna kuwerengera mmenemo, kulemba m'munda. Chovuta kwambiri kugwiritsa ntchito kiyibodi ya manambala pazolinga izi, zomwe zili kumanja. Pambuyo pamawuwo atalowetsedwa, kanikizani batani la "OK".
- Kenako zenera laling'ono limawonekera pazenera, lomwe lili ndi yankho la yankho la mawuwo. Kutseka, kanikizani batani la "OK".
- Koma vomerezani kuti ndizosavuta nthawi iliyonse yomwe mukufuna kupanga zochita, sinthani ku Macros zenera. Tiyeni tisinthike kukhazikitsidwa kwa tsamba la zenera. Kuti muchite izi, ali mu dambo la proser tabu, dinani chithunzi cha Macros kale kutikumbutsa kale.
- Kenako mu Macros Windows, Sankhani dzina la chinthu chomwe mukufuna. Dinani pa "magawo ..." batani.
- Pambuyo pake, zenera limayambika ngakhale kochepa kuposa kale. Mmenemo, titha kuyika makiyi otentha, mukadina pomwe chowerengera chidzakhazikitsidwa. Ndikofunikira kuti kuphatikiza uku sikugwiritsidwa ntchito kutchula njira zina. Chifukwa chake, zilembo zoyambirira zilembo sizikulimbikitsidwa. Chinsinsi choyamba cha kuphatikiza chimakhazikitsa pulogalamu yapamwamba. Ili ndiye fungulo la CTRL. Chinsinsi chotsatira chimakhazikitsa wogwiritsa ntchito. Lolani kuti ikhale fungulo la v (ngakhale mutha kusankha lina). Ngati kiyi iyi imagwiritsidwa ntchito kale ndi pulogalamuyi, kiyi ina imangowonjezeredwa kuphatikizidwa - kusintha. Timalowetsa chizindikiro chosankhidwa mu gawo la "Kiyibodi" ndikudina batani la "Ok".
- Kenako tsekani zenera la Macro podina chithunzi chotseka pakona yakumanja.
Tsopano, mukakhazikitsa kuphatikiza makiyi otentha (kwa ife, Ctrl + Shift + v) idzayambitsa zenera lowerengera. Vomekaza, limathamanga kwambiri komanso losavuta kuposa kuyitcha nthawi iliyonse kudzera pazenera la Macro.
Phunziro: Momwe Mungapangire Macro Pabwino
Njira 2: Funsani Ntchito
Tsopano tiyeni tikambirane njira yopangira chowerengera cha mbiri yochepa. Idzapangidwa kuti tichite ntchito zapadera, zapadera ndipo zimapezeka mwachindunji papepala la Excel. Pofuna kupanga chida ichi, chomwe chimapangidwa bwino chidzagwiritsidwe ntchito.
Mwachitsanzo, pangani chida cha kutembenuka mtima. Polenga zake zolengedwa, tigwiritsa ntchito ntchito yamakono. Wogwiritsa ntchito uyu amakhudzana ndi ukadaulo wa zopangidwa ndi Exel. Ntchito yake ndikusintha mfundo za muyeso umodzi. Syntax ya izi ndi motere:
= Pultoob (nambala; Ex_Dad_msm; kon_D_ism)
"Nambala" ndi mkangano womwe uli ndi kuchuluka kwa kuchuluka kwa kuchuluka kwa kukula komwe kuyenera kusinthidwa kukhala muyeso wina.
"Gawo loyamba la muyeso" ndi mkangano womwe umatsimikizira gawo la muyeso kuti lizikopezeredwa. Amafotokozedwa ndi nambala yapadera yomwe ikufanana ndi gawo linalake.
"Gawo lomaliza la muyeso" ndi mkangano womwe umatsimikizira gawo la muyeso wa kuchuluka komwe nambala yoyamba yatembenuka. Ikulongosoleranso mothandizidwa ndi ma code apadera.
Tiyenera kukhala mwatsatanetsatane mayanjano awa, popeza amawafunira mtsogolo mukamapanga cholembera. Makamaka, timafunikira ma code a miyeso yambiri. Nayi mndandanda wawo:
- G - gramu;
- kg - kilogalamu;
- Mg - milligram;
- Lbm - mapaundi achingelezi;
- Ozm - oz;
- SG - Kugulitsa;
- Iwe ndi gulu la atomiki.
Ndikofunikiranso kunena kuti mfundo zonse za gawoli zitha kukhazikitsidwa ngati zikhulupiriro ndi kulumikizana ndi maselo omwe amayikidwa.
- Choyamba, timapanga ntchito yogwira ntchito. Chida chathu chogwiritsa ntchito chidzakhala ndi minda inayi:
- Mtengo wosinthika;
- Gwero la muyeso;
- Zotsatira za kutembenuka;
- Gawo lomaliza la muyeso.
Timakhazikitsa mitu yomwe minda iyi iikidwa ndikugawa mapangidwe awo (Dzazani ndi malire) kuti muwone zowoneka zambiri.
Mu "munda wosinthika", mawu oti "gwero la muyezo" ndi "malire omaliza" adzaikidwa ndi deta, komanso njira yosinthira "ndi yotulutsa.
- Timachita kuti wogwiritsa ntchito akhoza kulowa machitidwe ovomerezeka mu gawo la "mtengo wosinthika", ndiye nambala zambiri zero. Sankhani khungu momwe mtengo wosinthika udzapangidwe. Pitani ku "data" ndi "kugwira ntchito ndi" chida cha data "pa" deta yotsimikizika ".
- Chida chotsimikizika "chakhazikitsidwa. Choyamba, mudzachita zoikamo mu "magawo" tabu. Mu gawo la mtundu wa data, sankhani "yovomerezeka". Mu gawo la "mtengo", nawonso lekaninso kusankha pa gawo la "zochulukirapo". Mu "gawo lochepera", khazikitsani mtengo "0". Chifukwa chake, manambala ovomerezeka okha ndi omwe angaperekedwe ku chipinda ichi (kuphatikizapo fraction), zomwe ndizokulirapo kuposa zero.
- Pambuyo pake, timasamukira ku tabu ya zenera lomwelo "kutumiza" zenera. Apa mutha kufotokoza kuti ndikofunikira kulowa wogwiritsa ntchito. Idzaziwona zikakulumira gawo lam'malo. Mu gawo la "uthenga", lembani izi: "Lowani mlingo wambiri womwe ukutembenukira".
- Kenako timasamukira ku "uthenga wolakwika" tabu. Mu gawo la "uthenga", tiyenera kulemba malingaliro omwe wosuta awona ngati deta yolakwika yolowa. Takulandilani izi: "Mtengo wolowetsa uyenera kukhala nambala yabwino." Pambuyo pake, kumaliza ntchitoyo pazenera lotsimikizira lazolowetsa ndikusunga makonda omwe adalowetsedwa nafe, dinani batani la "Ok".
- Monga tikuwona, foniyo ikasankhidwa, lingaliro logwirira ntchito limawonekera.
- Tiyeni tiyesere kulowa mtengo wolakwika, mwachitsanzo, zolemba kapena nambala yoyipa. Monga mukuwonera, uthenga wolakwika umawonekera ndipo zoyendetsera zimatsekedwa. Dinani batani la "Chotsani".
- Koma mtengo wolondola umayambitsidwa popanda mavuto.
- Tsopano timapita ku "gwero la muyeso". Apa tichita kuti wosuta asankha mtengo kuchokera pamndandanda womwe umapanga mfundo zisanu ndi ziwirizi, mndandanda wazomwe udaperekedwa pamwambapa akamalankhula zonena za ntchito. Lowetsani mfundo zina sizigwira ntchito.
Tikutsindika khungu, lomwe lili pansi pa dzina "gwero la muyeso". Apanso, dongo pa chithunzi cha "Data cheke".
- Pawindo lotsika la data lomwe limatsegulira, pitani ku "magawo" tabu. Mu "mtundu wa data", khazikitsani gawo la "mndandanda". Pamunda "Soul Source kudzera kudzera mu semicolon (;) Timalemba mayina a unyinji wa unyinji wa ntchito yokonzekera nkhani zomwe zinali zapamwamba. Kenako, dinani batani la "OK".
- Monga mukuwonera, tsopano, ngati mungasankhe gawo la "gwero la muyeso", ndiye kuti zithunzi mu mawonekedwe a makona atatu zimapezeka kumanja kwake. Mukamadina pa Iyo imatsegula mndandanda ndi mayina a mayunitsi a misa.
- Njira yofananirayo mu zenera la "Data Check" imachitika ndi foni yomwe ili ndi dzina "chomaliza cha muyeso". Imapezanso mndandanda womwewo wa magawo a muyeso wa muyeso.
- Pambuyo pake, pitani zotsatira "zotsatira zotembenuka". Zili mkati mwake zomwe zidzakhala ndi ntchito ya priogi ndi zomwe zidachitika chifukwa cha kuwerengera. Timagawa mgawo la pepalalo ndikudina pa "ntchito ya ntchito".
- Ntchito zomwe Mbuye amayamba. Pitani mu gulu la "uinjiniya" ndikugawa dzinalo "ziweto" pamenepo. Kenako dongo pa batani la "OK".
- Zenera lotsegulira zotsutsana ndi zotsutsana ndi zomwe zimachitika. Mu "nambala ya", ndikofunikira kuti mulowetse mgwirizano wa cell pansi pa dzina "mtengo wosinthika". Kuti muchite izi, ikani cholozera m'munda ndikudina batani la mbewa lamanzere pafoni iyi. Adilesi yake nthawi yomweyo imawonetsedwa m'munda. Momwemonso, timayambitsa magwiridwe antchito mumunda "Womaliza" ndi "gawo lomaliza". Pakadali pano podina maselo okhala ndi mayina omwewo monga minda iyi.
Pambuyo pa zonse zomwe zalembedwa, dinani batani la "OK".
- Tikangomaliza kuchita zinthu komaliza, m'chipindacho "zotsatira za kutembenuza" pamenepo, chifukwa cha kukonzekera kwakukulu, malinga ndi zomwe zidalowetsedwa kale, adawonetsedwa pomwepo.
- Tiyeni tisinthe deta mu "mtengo wosinthika", gawo loyambirira "ndi" gawo lomaliza la muyeso ". Monga tikuwonera, ntchito ikasintha magawo amakumbukira zotsatira zake. Izi zikusonyeza kuti kashing yathu yathu ikugwira ntchito mokwanira.
- Koma sitinapange chinthu chimodzi chofunikira. Maselo olowera deta amatetezedwa kuti afotokozere mfundo zosayenera, koma chinthucho potulutsa deta sichitetezedwa. Koma mwa anthu ambiri, ndizosatheka kulowa chilichonse, apo ayi njira yowerengera imangochotsedwa ndipo cholembera chidzalowa mu chikhalidwe chosagwira ntchito. Mwalakwitsa mu khungu lino mutha kulowa mu deta ndi inu nokha, kuti musatchule ogwiritsa ntchito chipani chachitatu. Pankhaniyi idzakonzanso njira yonse. Muyenera kuletsa kulowa kwina kulikonse apa.
Vuto ndikuti kutsekereza kumayikidwa papepala lonse. Koma ngati titseka pepalalo, sitingathe kulowa mu deta mu minda yolowera. Chifukwa chake, tifunikira m'malo mwa mawonekedwe a khungu kuti muchotse kuthekera konse kuchokera ku zinthu zonse za pepalalo, kenako perekani izi kuti zitheke kwa cell kuti zibweretse zotsatira zake ndikutsekanso pepalalo.
Dinani pa batani lamanzere la mbewa pagawo kumapeto kwa gulu lozungulira ndi lolunjika. Izi zikuwonetsa pepala lonse. Kenako dinani batani lakumanja. Menyursert aster atsegule, momwe mumasankha "Fomu Yanu ...".
- Zenera lomwe limayambitsidwa. Pitani ku "chitetezo" mmenemo ndikuchotsa bokosi la foni kuchokera pagawo la "lotetezedwa". Kenako dongo pa batani la "OK".
- Pambuyo pake, timangogawa khungu kuti litulutse zotsatira zake ndikudina batani la mbewa. Muzosankha, dongo pa "mawonekedwe a maselo".
- Apanso pawindo lopanga, pitani ku "chitetezo", koma nthawi ino, m'malo mwake, khazikitsani bokosi pafupi ndi gawo la "Cell Call". Kenako dinani batani la "OK".
- Pambuyo pake, timasamukira ku "kuwunika" ndikudina chithunzi cha "Kuteteza tsamba la masamba", komwe kumapezeka mu "Chida chosintha".
- Zenera loteteza pepala limatsegulidwa. Mu "achinsinsi oletsa kuteteza pepala", timalowetsa mawu achinsinsi, ngati kuli kotheka, mungachotse chitetezo mtsogolo. Zikhazikiko zotsalazo zitha kusiyidwa osasinthika. Dinani pa batani la "OK".
- Kenako zenera lina laling'ono limatseguka, momwe gawo lomwe likuthandizira chinsinsi liyenera kubwerezedwa. Timachita ndikudina batani la "OK".
- Pambuyo pake, mukamasintha kusintha kulikonse, zotsatirapo zake zidzatsekedwa, monga zalembedwa m'bokosi la dialog.
Chifukwa chake, tidapanga chiwerengero chokhazikika chofuna kutembenuza kuchuluka kwa misa m'magawo osiyanasiyana.
Kuphatikiza apo, m'nkhani yosiyana, akuti za kulengedwa kwa mitundu ina ya calpel Calculator pa bwino kuwerengera ndalama zolipirira ngongole.
Phunziro: Kuwerengera kwannuity kulipirira
Njira 3: Kukulitsa Zowerengera Opambana
Kuphatikiza apo, ku ukapolo kuli ndi zowerengera zawo zapadziko lonse lapansi. Zowona, mosavomerezeka, batani loyambira likusowa pa tepi kapena pagawo lofikira mwachangu. Ganizirani momwe mungayambitsire.
- Pambuyo poyambitsa pulogalamu yapamwamba, timasamukira ku "Fayilo".
- Kenako, pawindo lomwe limatsegula, pitani ku "magawo".
- Pambuyo poyambitsa makezelo owonjezera, timasamukira ku gawo lolowera mwachangu.
- Zenera limatseguka, mbali yakumanja ya yomwe imagawidwa m'magawo awiri. Pa gawo lolondola ndi zida zopezeka kale zomwe zidawonjezeredwa kale ku gulu lachidule. Kumanzere kumapereka zida zonse zomwe zimapezeka bwino, kuphatikizapo kusowa pa tepiyo.
Pamalo kumanzere mu "Sungani Malamulo a Malamulo a" Sankhani Malangizo a ", sankhani" malamulo osati pa tepi ". Pambuyo pake, mndandanda wa zida za mdindoyo, ndikuyang'ana dzina "cholembera". Kukhala kosavuta kupeza, popeza mayina onse ndi omwe ali. Kenako apange magawano a dzinali.
Pamwamba pa dera lamanja ndi "kusintha kwa gulu lolowera mwachangu". Ili ndi magawo awiri:
- Zikalata zonse;
- Chifukwa bukuli.
Mosavomerezeka, adakonzedwa kuti alembe zikalata zonse. Nyanjayi ikulimbikitsidwa kuti isasinthidwe osasinthika ngati mulibe zokambirana.
Pambuyo makonda onse amapangidwa ndi dzina "cholembera" chikuwonetsedwa, dinani batani la "onjezerani"
- Pambuyo pa dzina "Zowerengera" limapezeka pazenera lamanja, dinani batani la "OK" pansipa.
- Pambuyo pa zenera ili, magawo owonjezera adzatsekedwa. Kuti muyambe kuwerengera, muyenera kudina chithunzi cha dzina lomweli, lomwe tsopano limapezeka pagawo lalifupi.
- Pambuyo pake, "chitsimikizo" chowerengera chidzakhazikitsidwa. Imagwira, ngati analogue wamba, okha pamabatani omwe mungafunike kukanikiza mbewa ya mbewa, kumanzere.
Monga tikuwonera, pali zosankha zambiri pakupanga zowerengera kuposa zofunikira zosiyanasiyana. Izi ndizothandiza kwambiri mukamanyamula mbiri yopapatiza. Komabe, kwa zosowa wamba, mutha kugwiritsa ntchito chida cha pulogalamu yomangidwa.