Zitsanzo za ntchito ya RFD mu Excel

Kugwira ntchito ndi tebulo lotentha kumaphatikizapo kukoka mfundo kuchokera ku matebulo ena. Ngati pali matebulo ambiri, kusamutsa kwa maola ambiri kumatenga nthawi yayitali, ndipo ngati detayo imasinthidwa nthawi zonse, ikhala kale gulu la anthu ogwirira ntchito. Mwamwayi, pali ntchito ya HPP, yomwe imapereka kuthekera kochita zinthu zokha. Tiyeni tikambirane zitsanzo za zitsanzo za ntchitoyi.

Tanthauzo la FRR

Dzina la ntchito ya FRP limakanthidwa ngati "chojambula cholumikizira". Mu Chingerezi, dzina lake limamveka - Vookup. Izi zikuyang'ana deta mgawo lamanzere la mitundu yonseyo, kenako imabwezera phindu la selo. Mwachidule, luso limakulolani kuti mukonzenso zomwe zachokera ku chipinda chimodzi patebulo limodzi. Dziwani momwe mungagwiritsire ntchito ntchito ya Volofu kuti ikwaniritsidwe.

Chitsanzo chogwiritsa ntchito UPR

Timayang'anitsitsa momwe ntchito ya Prd imagwiritsira ntchito mwachitsanzo.

Tili ndi matebulo awiri. Oyamba a iwo ndi tebulo la kubereka, lomwe lili ndi mayina a chakudya. Phokoso lotsatirali pambuyo pa dzinalo ndiye mtengo wa chiwerengero cha zinthu zomwe mukufuna kugula. Kenako amatsatira mtengo. Ndipo mu mzere womaliza - mtengo wonse wogula dzina la malonda, omwe amawerengedwa pafoni yazochulukitsa kepulo. Koma mtengo womwe timangolimbitsa pogwiritsa ntchito gulu lankhondo kuchokera pagome lotsatira, lomwe ndi mndandanda wamtengo.

1. Dinani pa cell yapamwamba (C3) mu "mtengo" patebulo loyamba. Kenako, dinani pa "ikani ntchito", yomwe ili kutsogolo kwa chingwe.



2. Pazenera logwiritsira ntchito master of antchito, sankhani zolumikizira "zolumikizira". Kenako, kuchokera ku ntchito zoperekedwa, sankhani "VDP". Dinani pa batani la "OK".



3. Pambuyo pake, zenera limatseguka lomwe muyenera kuyikanso ntchito. Tadidina batani lomwe lili kumanja kwa gawo lolowera la data kuti mupitirize kusankha mfundo ya mtengo womwe mukufuna.



4. Popeza tili ndi mtengo wofunikira pafoni C3, ndi "mbatata", ndiye kuti timagawa mtengo wolingana. Bweretsani ku Phatikizani pazenera la ntchito.



5. Mofananamo, ndimadina pachizindikiro kumanja kwa gawo lolowera deta, kusankha tebulo, kuchokera komwe mfundo zimalimbikitsidwa.



6. Tikuwonetsa gawo lonse la tebulo lachiwiri, pomwe kufufuza mfundo kupatula chipewa chidzapangidwe. Apanso, timabwereranso kukangana.



7. Kuti mudziwe zomwe zasankhidwa kuchokera ku Mtheradi, ndipo izi tikufunika kuti mfundozo sizimasinthana patebulopo, ingosankha ulalo mu gawo la "tebulo", ndikudina F4 kiyi. Pambuyo pake, kulumikizana kwa dola kumawonjezeredwa ku ulalo ndipo kumatembenuka kukhala mtheradi.



8. Chiwerengero chotsatira, tiyenera kutchula kuchuluka kwa mzerewo kuchokera komwe tidzawonetsera. Mzerewu uli pagome lomwe lili pansi. Popeza tebulo lili ndi mizati iwiri, ndipo mzere wokhala ndi mitengo ndi yachiwiri, kenako timakhazikitsa nambala ya "2".
9. Mu consina yomaliza "Kuonera", tiyenera kunena mtengo wake "0" (mabodza) kapena "1" (Choonadi). Poyamba, zongoganiza zokhazo zokha sizidzasiyidwa, ndipo chachiwiri - chofupika kwambiri. Popeza dzina lazogulitsa ndi deta, sangakhale pafupifupi, mosiyana ndi kuchuluka kwa manambala, motero tiyenera kuyika mtengo wake "0". Kenako, kanikizani batani la "OK".

Monga mukuwonera, mtengo wa mbatata adakwera patebulo kuchokera pamndandanda wamtengo. Pofuna kuti musapange njira yovutayi ndi mayina ena othandizira, ingokhalani khoma lakumanja kwa cell, kuti mtanda uoneke. Timanyamula mtanda uku mpaka pansi patebulo.

Chifukwa chake, tidakonza zonse zofunikira kuchokera patebulo limodzi kupita kwina, pogwiritsa ntchito vdp ntchito.

Monga tikuwonera, ntchito yogwirizira siyovuta, monga ikuwonekera poyamba. Sikovuta kumvetsetsa ntchito yake, koma kukula kwa chida ichi kukupulumutsani nthawi yayitali mukamagwira ntchito ndi matebulo.