Adobe Gamma 3.0

Kwa ogwiritsa ntchito nthawi zonse a Excel, si chinsinsi kuti masamu, ma engineering ndi mawerengedwe a ndalama angapangidwe pulogalamuyi. Mbali imeneyi imakwaniritsidwa mwa kugwiritsa ntchito njira zosiyanasiyana ndi ntchito. Koma, ngati Excel nthawi zonse imagwiritsidwa ntchito kuwerengera, ndiye funso lokonzekera zipangizo zofunika pa tsambali likukhala loyenera, zomwe zidzakulitsa kwambiri kuŵerengera kwa chiwerengero ndi mlingo wokhala wogwiritsira ntchito. Tiyeni tipeze momwe tingagwiritsire ntchito kotengera ku Excel.

Ndondomeko ya Kulenga kwa Calculator

Chofunika kwambiri mwamsanga ntchitoyi imakhala, ngati n'koyenera, kuti nthawi zonse azichita zowerengera ndi zowerengera zomwezo zogwirizana ndi mtundu wina wa ntchito. Kawirikawiri, onse owerengera mu Excel angagawidwe m'magulu awiri: chilengedwe chonse (chogwiritsidwa ntchito powerengetsera masamu) ndi zochepa. Gulu lachiwirili ligawidwa m'magulu osiyanasiyana: engineering, ndalama, ndalama za ngongole, ndi zina zotero. Kusankha kwa algorithm kwa chilengedwe chake kumadalira ntchito ya calculator, choyamba.

Njira 1: Gwiritsani ntchito Macros

Choyamba, ganizirani zowonjezereka za kulenga owerengera. Tiyeni tiyambe mwa kupanga chojambulira chosavuta chozungulira zonse. Chida ichi chidzachita masewera olimbitsa thupi: kuonjezera, kuchulukitsa, kuchotsa, magawano, ndi zina. Zimagwiritsidwa ntchito pogwiritsa ntchito macro. Choncho, musanayambe ndondomeko yolenga chilengedwe, muyenera kutsimikiza kuti mwaphatikizapo macros ndi gulu lokonzekera. Ngati si choncho, ndiye kuti macro ayambe kuchitidwa.

1. Pambuyo pazomwe makonzedwe oyambirirawa apangidwira, pita ku tabu "Wotsambitsa". Dinani pazithunzi "Visual Basic"yomwe imayikidwa pa tepi mu zida za zipangizo "Code".



2. Wowonetsera VBA wowonjezera ayamba. Ngati muli ndi malo apakati omwe amawonetsedwa mwa imvi, osati oyera, izi zikutanthawuza kuti palibe malo olowera. Kuti athe kuwonetsera kwake pitani ku chinthu cha menyu "Onani" ndipo dinani palemba "Code" m'ndandanda umene ukuwonekera. Mutha kukanikiza fungulo la ntchito mmalo mwazimenezo. F7. Mulimonsemo, code yanu idzawonekera.



3. Pano m'derali tifunika kulemba code yaikulu. Ili ndi mawonekedwe otsatirawa:

   Sub Calculator ()
Dulani strExpr monga chingwe
Lowani deta kuti muwerengere
strExpr = InputBox ("Lowani deta")
'Zotsatira zowerengetsera
MsgBox strExpr & "=" & Application.Evaluate (strExpr)
Malizani pang'ono

   M'malo mwa mawu "Lowani deta" mukhoza kulemba china chilichonse chovomerezeka kwa inu. Kuti ikhale ili pamwamba pa munda.

   Pambuyo potsatira ndondomekoyi, fayilo iyenera kulembedwa. Komabe, iyenera kupulumutsidwa mwa maonekedwe ndi thandizo lalikulu. Dinani pa chithunzichi ngati floppy disk mu toolbar ya mkonzi wa VBA.



4. Fayilo lolemba mawonekedwe likuyamba. Pitani ku zolemba pa galimoto yanu yovuta kapena mauthenga ochotsedwera kumene mukufuna kuisunga. Kumunda "Firimu" perekani chilembedwecho dzina lililonse lofunikako kapena kuchoka pa zomwe wapatsidwa kwachinsinsi. Yoyenera kumunda "Fayilo Fayilo" kuchokera pa mafomu onse omwe alipo alipo sankhani dzina "Buku la ntchito la Excel la Macro (* .xlsm)". Pambuyo pa sitepe iyi, tambani pa batani. Sungani " pansi pazenera.



5. Pambuyo pake, mukhoza kutseka zenera zowonongeka pokha pokhapokha muzithunzi zapafupi pafupi ndi mtanda wofiira ndi mtanda woyera kumbali yake ya kumanja.



6. Kugwiritsa ntchito chida chogwiritsa ntchito kompyuta pogwiritsa ntchito macro, panthawiyi "Wotsambitsa"dinani pazithunzi Macros pa tepiyi mu zida za zipangizo "Code".



7. Pambuyo pake, zenera lalikulu likuyamba. Sankhani dzina la macro omwe tangolenga, sankhani ndipo dinani pa batani Thamangani.



8. Pambuyo pochita ichi, chojambulira chimapangidwa chomwe chimachokera ku macro.



9. Kuti tichite mawerengedwe mmenemo, timalemba zofunikira pamunda. Njira yabwino kwambiri yomwe mungagwiritsire ntchito pazinthu izi ndizeng'amba yamakani, yomwe ili kumanja. Mawuwo atalowa, dinani pa batani "Chabwino".



10. Kenaka tsamba laling'ono likuwonekera pawindo, lomwe liri ndi yankho la yankho la mawu omwe atchulidwa. Kuti mutseke, dinani pa batani. "Chabwino".



11. Koma zindikirani kuti ndizosokoneza nthawi iliyonse yomwe mukufunika kuchita zojambula, pita kuwindo lalikulu. Tiyeni tilepheretse kukhazikitsa kwazenera mawindo. Kwa ichi, pokhala mu tab "Wotsambitsa", dinani pazithunzi zomwe tidziwa kale Macros.



12. Kenaka muwindo lalikulu, sankhani dzina la chinthu chomwe mukufuna. Dinani pa batani "Zosankha ...".



13. Pambuyo pake, zenera zimayambitsidwa ngakhale zing'onozing'ono kuposa zomwe zapitazo. M'menemo, tikhoza kufotokoza kuphatikiza mafungulo otentha, omwe, pamene atsekedwa, adzayambitsa cholembera. Ndikofunika kuti mgwirizanowu usagwiritsidwe ntchito kutchula njira zina. Choncho, zilembo zoyambirira za alfabeti sizivomerezedwa. Gulu loyamba la mndandanda limapanga pulogalamuyo yokha Excel. Chinsinsi ichi Ctrl. Mtsinje wotsatira umayikidwa ndi wosuta. Lolani ilo likhale fungulo V (ngakhale mutha kusankha wina). Ngati makiyiwa agwiritsidwa ntchito kale ndi pulojekiti, imodzi yowonjezera idzawonjezeredwa kuphatikiza - Smphepo. Lowani khalidwe losankhidwa m'munda "Njira" ndipo dinani pa batani "Chabwino".



14. Kenaka tseka mawindo akuluakulu podalira chithunzi chomwe chili pafupi kumbali yakumanja.

Tsopano pakulemba kusakaniza kosankhidwa kosankhidwa (kwa ife Ctrl + Shift + V) window yowonjezera idzayambitsidwa. Gwirizanani, ndi mofulumira komanso mosavuta kuposa kuyitchula nthawi zonse kudzera pawindo lalikulu.

PHUNZIRO: Momwe mungapangire macro ku Excel

Njira 2: Kugwiritsa Ntchito Ntchito

Tsopano tiyeni tione njira yopanga choyimira chophweka. Idzapangidwira kuti ichite ntchito yapadera, yeniyeni ndikuyiyika mwachindunji pa pepala la Excel. Ntchito zomangidwa mu Excel zidzagwiritsidwa ntchito popanga chida ichi.

Mwachitsanzo, pangani chida chosintha miyezo ya misa. Potengera chilengedwe chake, tidzatha kugwiritsa ntchito ntchitoyi Preob. Wogwira ntchitoyi akunena za injini yowonjezeredwa yochita ntchito Excel. Ntchito yake ndikutembenuza miyezo ya muyezo umodzi. Chidule cha ntchitoyi ndi ichi:

= PREVENT (nambala; ish_ed_izm; con_ed_izm)

"Nambala" - Iyi ndi mtsutso womwe uli ndi mawonekedwe a mtengo wamtengo wapatali umene uyenera kusandulika muyeso wina.

"Chinthu Choyambitsa" - ndemanga yomwe imapanga chiyero cha kuyeza kwa mtengo wotembenuzidwa. Imayikidwa ndi code yapadera yomwe ikugwirizana ndi chiyero china.

"Chigawo chomaliza" - kutsutsana kumatanthawuza chiyero cha kuchuluka kwa kuchuluka kwa chiwerengero choyambirira chomwe chatembenuzidwa. Ikukhazikanso kugwiritsa ntchito zida zapadera.

Tiyenera kufotokozera mfundo izi, popeza tidzazifuna patapita nthawi popanga chojambulira. Mwachindunji, ife tikusowa zizindikiro za mayunitsi a misa. Nazi mndandanda wa iwo:

• g - gramu;
• makilogalamu - kilogalamu;
• mg - milligram;
• lbm - pounds English;
• ozm - ounce;
• sg - slag;
• u - atomic unit.

Ndiyeneranso kunena kuti zifukwa zonse za ntchitoyi zikhoza kufotokozedwa ndi zikhulupiliro ndi mafotokozedwe a maselo omwe ali.

1. Choyamba, timakonzekera. Chida chathu chogwiritsa ntchito kompyuta chidzakhala ndi minda inayi:
   • Mtengo wosinthika;
   • Chinthu Choyambitsa;
   • Zotsatira za kutembenuka;
   • Chigawo chomaliza.

   Timayika mutu umene masamba awa adzayikidwa, ndi kuwasankha ndi maonekedwe (kudzaza ndi malire) kuti muwone masomphenya.

   M'minda "Zotembenuza", "Malire amtengo wapatali" ndi "Mapeto a Kutheka" tilowetsa deta, ndi kumunda "Zotsatira za Kutembenuka" - kutulutsa zotsatira zomaliza.



2. Tiyeni tizipange kotero kuti kumunda "Zotembenuza" wogwiritsa ntchito angalowe muyeso yeniyeni yokha, yomwe ndi nambala yaikulu kuposa zero. Sankhani selo limene mtengo wotembenuzidwa udzalowetsedwa. Pitani ku tabu "Deta" ndi mu chida cha zipangizo "Kugwira ntchito ndi deta" dinani pazithunzi "Verification Data".



3. Chida chowonekera chimayambira. "Verification Data". Choyamba, pangani zoikiramo mu tab "Zosankha". Kumunda Mtundu wa Deta " sankhani parameter kuchokera m'ndandanda "Zoona". Kumunda "Phindu" Komanso kuchokera pa mndandanda womwe timaletsa kusankha pa parameter "Zambiri". Kumunda "Osachepera" ikani mtengo "0". Motero, nambala yeniyeni yokha (kuphatikizapo fractional), yomwe ili yaikulu kuposa zero, ikhoza kulowa mu selo ili.



4. Pambuyo pake kusamukira ku tabu lawindo lomwelo. "Uthenga wolowera". Pano mungathe kufotokozera zomwe mukufunikira kuti mulowe mulojekiti. Adzachiwona pamene akusankha miyezo yamagulu. Kumunda "Uthenga" lembani zotsatirazi: "Lowani kuchuluka kwa misa kuti mutembenuzire".



5. Kenaka pita ku tabu "Uthenga Wolakwika". Kumunda "Uthenga" Tiyenera kulemba ndemanga zomwe wogwiritsa ntchito akuwona ngati alowetsa deta yolondola. Lembani izi: "Kulembera kuyenera kukhala nambala yabwino." Pambuyo pake, kuti mutsirize ntchitoyi muzenera zowunikira pulogalamuyi ndikusunga zoikidwiratu zomwe talowa, dinani pa batani "Chabwino".



6. Monga mukuonera, mukasankha selo, chithunzi chikuwonekera.



7. Tiyeni tiyesere kulowa mmenemo mtengo wolakwika, mwachitsanzo, malemba kapena nambala yolakwika. Monga mukuonera, uthenga wolakwika umawonekera ndipo zotsatirazo zatsekedwa. Timakanikiza batani "Tsitsani".



8. Koma mtengo woyenera watsekedwa popanda mavuto.



9. Tsopano pitani kumunda "Chinthu Choyambitsa". Pano ife tipanga wosuta kusankha mtengo kuchokera pa mndandanda wokhala ndi malingaliro asanu ndi awiriwo, mndandanda wa zomwe zinaperekedwa pamwambapa pofotokozera zomwe zimagwira ntchito. Preob. Lowetsani makhalidwe ena sangagwire ntchito.

   Sankhani selo yomwe ili pansi pa dzina "Chinthu Choyambitsa". Dinani kachiwiri pazithunzi "Verification Data".



10. Muzenera yowonetsera deta yomwe imatsegulira, pitani ku tab "Zosankha". Kumunda Mtundu wa Deta " ikani chizindikiro "Lembani". Kumunda "Gwero" kudzera mu semicolon (;) timalemba mndandanda wa maina a mayina ochulukitsa ntchitoyi Preobza zomwe mudakambirana pamwamba. Kenako, dinani pakani "Chabwino".



11. Monga mukuonera, tsopano, ngati mutasankha munda "Chinthu Choyambitsa", ndiye chizindikiro cha katatu chimaonekera kumanja kwake. Mukamangogwiritsa ntchito, mndandanda umayamba ndi mayina a mayunitsi a masiyeso.



12. Momwemo ndondomeko yofanana muwindo "Verification Data" ife timachita ndi ndi selo ndi dzina "Chigawo chomaliza". Zili ndi ndondomeko yomweyo ya mayunitsi.



13. Zitatero pitani ku selo "Zotsatira za Kutembenuka". Idzakhala ndi ntchito Preob ndi kusonyeza zotsatira za kuwerengera. Sankhani izi pa pepala ndikusindikiza pazithunzi "Ikani ntchito".



14. Iyamba Mlaliki Wachipangizo. Timalowa mu gululo "Engineering" ndipo sankhani dzina pamenepo "PREOBR". Kenaka dinani pa batani. "Chabwino".



15. Fayilo yotsutsana ndi otsogolera imatsegula Preob. Kumunda "Nambala" Muyenera kulowetsa makonzedwe a selo pansi pa dzina "Zotembenuza". Kuti muchite izi, lembani malonda mmunda ndipo dinani batani lamanzere pa selo ili. Adilesi yake imapezeka nthawi yomweyo. Momwemonso ife timalowetsamo kumunda. "Chinthu Choyambitsa" ndi "Chigawo chomaliza". Ndi nthawi iyi yokha yomwe timadumpha pa maselo omwe ali ndi maina omwewo.

    Deta yonse italowa, dinani pa batani "Chabwino".



16. Titangomaliza ntchito yotsiriza, muwindo lazenera "Zotsatira za Kutembenuka" nthawi yomweyo anasonyeza zotsatira za kutembenuka kwa mtengo, molingana ndi deta yomwe inaloledwa kale.



17. Tiyeni tisinthe deta mu maselo "Zotembenuza", "Chinthu Choyambitsa" ndi "Chigawo chomaliza". Monga momwe mukuonera, ntchitoyo imangobwereza zotsatirazo posintha magawo. Izi zikusonyeza kuti calculator yathu imagwira bwino ntchito.



18. Koma sitinachite chinthu chimodzi chofunikira. Selo lolowera deta limatetezedwa kuzinthu zowonongeka, koma chinthu cha deta chosatulutsidwa sichingatetezedwe konse. Koma kawirikawiri sitingathe kulowetsa kalikonse mu izo, mwinamwake chiwerengero cha chiwerengerocho chidzachotsedwa basi ndipo calculatoryo idzakhala yosagwiritsidwa ntchito. Mwalakwitsa, mungathenso kulowa deta mu selo ili, osasamala ogwiritsa ntchito apakati. Pankhaniyi, muyenera kulemba zonsezi. Muyenera kutseka chilolezo chilichonse cha deta pano.

    Vuto ndilokuti lolo laikidwa pa pepala lonse. Koma ngati tilephere pepala, sitidzatha kulowetsa deta muzinthu zolembera. Choncho, tifunika kuchotsa mwayi wochotsa kuzinthu zonse za pepalayi muzipangizo za selo, kenaka tibweretseni mwayi umenewu kupatula selo kuti muwonetse zotsatirazo ndipo mutatseke pepala.

    Tinachoka pang'onopang'ono pazomwe zili pamphepete mwa magawo osakanikirana ndi ofunjika a makonzedwe. Izi zikuwonekera pepala lonse. Ndiye tikulumikiza molondola pa kusankha. Mndandanda wamakono umatsegulira kumene timasankha malo. "Sungani maselo ...".



19. Fesitimu yokongoletsa ikuyamba. Pitani kwa izo mu tab "Chitetezero" ndi kusasintha parameter "Selo lotetezedwa". Kenaka dinani pa batani. "Chabwino".



20. Pambuyo pake, sankhani kokha selo kuti muwonetse zotsatirazo ndipo dinani ndi batani lakumanja. Mu menyu yachidule, dinani pa chinthucho "Sezani maselo".



21. Apanso muwindo lakupangidwira, pitani ku tabu "Chitetezero"koma nthawi ino, m'malo mwake, timayika nkhumba pafupi ndi parameter "Selo lotetezedwa". Kenaka dinani pa batani. "Chabwino".



22. Pambuyo pake kusamukira ku tabu "Kubwereza" ndipo dinani pazithunzi "Tetezani Tsamba"yomwe ili mu chida chogwiritsa ntchito "Kusintha".



23. Zowonjezera zowonjezera zowonjezera zimatsegula. Kumunda "Chinsinsi choletsera chitetezo cha pepala" lowetsani mawu achinsinsi omwe, ngati kuli kofunikira, m'tsogolomu zingatheke kuchotsa chitetezocho. Zotsalira zotsalira zingasiyidwe zosasintha. Timakanikiza batani "Chabwino".



24. Kenaka tsamba lina laling'ono limatsegulira zomwe muyenera kubwereza mawu achinsinsi. Chitani ichi ndipo dinani pa batani. "Chabwino".



25. Pambuyo pake, mutayesa kupanga kusintha kwa selo yophatikizapo, zochitazo zidzatsekedwa, zomwe zimafotokozedwa mu bokosi la bokosi lomwe likuwonekera.

Motero, takhala tikupanga chiwerengero chathunthu kuti tisinthe miyeso yambiri mu magawo osiyanasiyana ofunikira.

Kuwonjezera apo, nkhani yapadera imalongosola kulengedwa kwa mtundu wina wa pulojekiti yopapatiza mu Excel kuti awerengere ngongole ya ngongole.

PHUNZIRO: Kuwerengera kwa ndalama zowonjezera ku Excel

Njira 3: Limbikitsani chojambulira chojambulidwa mu Excel

Kuonjezerapo, Excel ili ndi yokha yopanga makina. Zoona, mwachindunji, botani lake loyambitsira silili pa riboni kapena pa bar ya njira. Ganizirani momwe mungachigwiritsire ntchito.

1. Mutatha kuthamanga Excel, pita ku tab "Foni".



2. Kenako, pawindo limene limatsegulira, pitani ku gawoli "Zosankha".



3. Mutangoyamba zenera zotsalira za Excel, pitani ku ndimeyi "Bwalo Lofikira Bwino".



4. Tisanayambe kutsegula zenera, mbali yake yolondola imagawidwa m'madera awiri. M'mbali yake yoyenera ndi zipangizo zomwe zakhala zikuwonjezeredwa ku gulu lofikirapo. Kumanzere kumaimira chida chonse chomwe chilipo mu Excel, kuphatikizapo zomwe zikusowa pa tepi.

   Pamwamba pamunda wakumunda "Sankhani magulu" sankhani chinthu kuchokera mndandanda "Magulu sali pa tepi". Pambuyo pake, mundandanda wa zipangizo kumanzere, fufuzani dzina. "Calculator". Zidzakhala zosavuta kupeza, chifukwa mayina onse akukonzedwa mwadongosolo. Kenaka timapanga dzina lachinsinsi.

   Pamwamba pa malo abwino ndi munda "Kusintha Bwino Toolbar Yopangidwira". Lili ndi magawo awiri:

   • Kwa malemba onse;
   • Kwa bukhu ili.

   Chikhazikitso chosasinthika ndizolembedwa zonse. Izi zimapangidwira kuti zisasinthike ngati palibe zofunikira zotsutsana nazo.

   Pambuyo pazomwe zonsezi zikuchitika ndi dzina "Calculator" onetsetsani, dinani pa batani "Onjezerani"yomwe ili pakati pa malo abwino ndi kumanzere.



5. Atatchulidwa dzina "Calculator" Onetsani kumanja komweko, dinani pa batani "Chabwino" pansipa.



6. Zitatha izi, zenera zotsalira za Excel zidzatseka. Kuti muyambe kujambula, muyenera kudina pa chithunzi cha dzina lomwelo, lomwe tsopano likupezeka pa bar.



7. Pambuyo pa chida ichi "Calculator" idzayambitsidwa. Zimagwira ntchito ngati fano lachibadwa, makataniwo amafunika kupanikizidwa ndi mbewa cholozera, batani lamanzere.

Monga mukuonera, mu Excel pali njira zambiri zowonjezera kupanga zowerengera zosowa zosiyanasiyana. Mbali imeneyi ndi yothandiza makamaka pakuchita zowerengera zochepa. Chabwino, pa zosowa zapadera, mungagwiritse ntchito chida chogwiritsidwa ntchito pulogalamuyi.