Excel Onani Ntchito

Excel ndi pulogalamu yokonza deta yomwe ili patebulo. Maganizowo amagwira ntchito yomwe mukufuna kuchokera patebulopo pokonza gawo lomwe limadziwika lomwe lili mu mzere womwewo kapena mzati. Chifukwa chake, mwachitsanzo, mtengo wamtundu ukhoza kuwonetsedwa mu foni yosiyana, kutchula dzina lake. Momwemonso, mutha kupeza nambala yafoni ndi dzina la munthuyo. Tiyeni tiwone mwatsatanetsatane momwe mawonekedwe a malingaliro amagwirira ntchito.

Kuonera Ogwiritsa Ntchito

Musanayambe kugwiritsa ntchito chida chenicheni, muyenera kupanga tebulo pomwe mfundo zomwe zikufunika kupezeka ndipo zomwe zafotokozedwazo zidzakhala. Malinga ndi magawo awa, kusaka kudzachitika. Pali njira ziwiri zogwiritsira ntchito ntchito: vekitala mawonekedwe ndi mawonekedwe a mndandanda.

Njira 1: Fomu ya Vector

Njirayi imagwira ntchito pakati pa ogwiritsa ntchito mukamagwiritsa ntchito wowonera.

1. Kuti tipeze tebulo lachiwiri ndi mzati "mtengo womwe mukufuna" ndi "zotsatira". Izi sizoyenera, chifukwa maselo aliwonse papepala angagwiritsidwe ntchito pazolinga izi. Koma zidzakhala zosavuta.



2. Sankhani foni yomwe zotsatira zomaliza zidzawonetsedwa. Lidzakhala njira yokhayokha. Dinani pa "Aste Adving".



3. Mtsogoleri wa ntchito ya neizard. Pamndandanda wofunafuna "Onani", tikuutsimikizira ndikudina batani la "Ok".



4. Kenako imatsegulira zenera lina. Ogwiritsa ntchito ena sapezeka kawirikawiri. Apa muyenera kusankha imodzi mwazinthu zomwe zimapangidwira zomwe zimayambira: Vector kapena mawonekedwe a mndandanda. Popeza tsopano tikuganizira zamitundu ya vekitala, timasankha njira yoyamba. Dinani pa batani la "OK".



5. Khomo lachikangano limatseguka. Monga tikuwona, izi zili ndi zotsutsana zitatu:
   • Mtengo womwe mukufuna;
   • Vekitala yowonedwa;
   • Vekitor zotsatira.

   Kwa ogwiritsa ntchito omwe akufuna kugwiritsa ntchito mankhwalawa pamanja, osagwiritsa ntchito "mbuye wa ntchito", ndikofunikira kudziwa syntax yolemba. Zikuwoneka kuti:

   = Kuonera (mukufuna_mpangidwe; owonedwa_pamwamba; Vector_Trals)

   Tidzayang'ana kwambiri pamikhalidwe yomwe iyenera kupangidwa pawindo.

   Mu "gawo lachiwiri", timalowetsa mgwirizano wa khungu, komwe tidzalemba paramu kuti kusaka kudzachitika. Tinaitanitsa cele tolekanikirana patebulo lachiwiri. Monga mwachizolowezi, adilesi yolumikizira imapangidwa m'munda kapena pamanja kuchokera pa kiyibodi, kapena popereka malo ofanana. Njira yachiwiri ndiyovuta kwambiri.



6. M'munda wa "Mndandanda wa Vactor", fotokozerani mitundu ya maselo, ndipo kwa ife, khola loti mayina omwe mayinawo alipo, omwe ndi amodzi omwe adzajambulidwe mu khungu la "Mtengo Wapamwamba". Zogwirizanitsa mu gawo ili ndi njira yosavuta kwambiri yosonyezera malowo papepala.



7. The "zotsatira za Vector" zimaphatikizapo mgwirizano wa mitundu yomwe mfundo zomwe tikufuna kupeza zimaphatikizapo.



8. Pambuyo pa zonse zomwe zalembedwa, dinani batani la "OK".



9. Koma, monga tikuwona, mpaka pano ntchito imawonetsa zotsatira zolakwika mu khungu. Kuti iyambe kugwira ntchito, lembani gawo lomwe muyenera kulowa m'dera lomwe mukufuna.

Zambiri zitayambitsidwa, khungu lomwe ntchitoyo lili limakhala lodzaza ndi chizindikiritso chofanana kuchokera kuzomwe zimachitika.

Ngati tilowa dzina lina mu khungu la mtengo womwe mukufuna, ndiye zotsatira zake, motero, zidzasintha.

Ntchito yoona ndiyofanana kwambiri ndi PD. Koma m'khola lowoneka bwino liyenera kukhala lamanzere lamanzere. Kuwona zoletsa izi sikutanthauza kuti tikuwona pa chitsanzo pamwambapa.

Phunziro: Mzere wa Wizard mu Excel

Njira 2: Mzere Wambiri

Mosiyana ndi njira yapitayi, mawonekedwe awa amagwira ntchito ndi mndandanda wonsewo, womwe umaphatikizapo mtundu wowoneka bwino komanso zotsatira zake. Nthawi yomweyo, mtundu womwewo wowonedwa uyenera kukhala wokhudzana kumanzere.

1. Selo isankhidwa, pomwe zotsatirapo zake zidzawonetsedwa, Wizard Wizard ikuyenda ndi kusintha kwa wopanga mawonekedwe amapangidwa, zenera limatsegulidwa kuti musankhe mawonekedwe a wothandizira. Pankhaniyi, sankhani mtundu wa wothandizirayo, ndiye kuti, ndiye malo achiwiri pamndandanda. Dinani "Chabwino".



2. Khomo lachikangano limatseguka. Monga mukuwonera, subtype wa ntchito ili ndi zotsutsana ziwiri zokha - "tanthauzo lofunikira" ndi "gulu". Motero, Syntax yake ili motere:

   = Kuonera (kufuna))

   Mu gawo la "cholakwika", monga njira yapitayi, lowetsani mgwirizano wa selo yomwe pempho lidzalowe.



3. Koma mu gawo la "gulu la" Mufa ", muyenera kutchula malo ogwirizira magulu onsewo, momwe mitundu yonseyo imawonekera ndi zotsatira zingapo zili. Pankhaniyi, mtundu womwewo wowonedwa uyenera kukhala wolunjika kwambiri wa mndandanda, apo ayi formula agwira ntchito molakwika.



4. Pambuyo pa zomwe zidanenedwa zalowetsedwa, dinani batani la "OK".



5. Tsopano, ngati nthawi yotsiriza, kuti mugwiritse ntchito gawo ili, mu cell kuti mupeze mtengo womwe mukufuna, timalowa mayina amodzi.

Monga mukuwonera, zitatha izi, zotsatira zake zimakhala zokha ku malo olingana.

Chidwi! Tiyenera kudziwa kuti njirayi imawonetsera kwa massofera. M'makiibulo atsopano a Excel, alipo, koma amangotsala ogwirizana ndi zikalata zopangidwa m'mitundu yakale. Ngakhale ndizotheka kugwiritsa ntchito nkhuni za mndandanda wamakono wa pulogalamuyi, tikulimbikitsidwa kugwiritsa ntchito gawo latsopano kwambiri la prd m'malo mwake (pofufuza mu mzere woyamba) ndi GPR (pofufuza mzere woyamba wa osiyanasiyana). Samapereka njira zogwirizira kusakako za zilonda za array, koma amagwira ntchito molondola. Koma mawonekedwe opangira vekitala a Vector ndiofunika mpaka pano.

Phunziro: Zitsanzo za ntchito ya RFD mu Excel

Monga mukuwonera, wowonerayo ndi wothandizira wabwino pofunafuna deta pamtengo womwe mukufuna. Izi ndizothandiza kwambiri pamatebulo. Tiyeneranso kudziwa kuti pali mitundu iwiri ya ntchitoyi - vekitala ndi kuchitika. Womaliza ali ndi vuto kale. Ngakhale ogwiritsa ntchito ena amagwiritsidwabe ntchito.