Kusuntha Njira Yapakati mu Microsoft Excel

Njira yosuntha yapakati ndi chida chakuwerengera momwe mungathetsere mavuto osiyanasiyana. Makamaka, nthawi zambiri imagwiritsidwa ntchito polosera. Ku Excel, mutha kugwiritsanso ntchito chida ichi kuthana ndi mavuto ambiri. Tiyeni tiwone momwe kuchuluka kosunthira ku Excel kumagwiritsidwira ntchito.

Kusuntha Ntchito Yapakati

Tanthauzo la njirayi ndikuti mothandizidwa, mawonekedwe amomwe amaunikidwa mosinthika amasinthidwa kukhala amitundu yotanthauza ya nyengo inayake ndikonzanso bwino zosowa. Chida ichi chimagwiritsidwa ntchito kuwerengera zachuma, kuneneratu, pogulitsa zamalonda, etc. Kugwiritsa ntchito njira yosunthira ya Excel kumachitika bwino pogwiritsa ntchito chida champhamvu chopangira ziwerengero chotchedwa Phukusi la kusanthula. Muthanso kugwiritsa ntchito ntchito ya Excel pazomwezi. NJIRA.

Njira 1: Phukusi la kusanthula

Phukusi la kusanthula ndi chowonjezera cha Excel chomwe chimalemedwa ndi kusakhulupirika. Chifukwa chake, choyambirira, muyenera kuyilola.

1. Pitani ku tabu Fayilo. Dinani pazinthu. "Zosankha".



2. Pa zenera la magawo lomwe limatseguka, pitani pagawo "Zowonjezera". Pamunsi pazenera m'bokosi "Management" gawo liyenera kukhazikitsidwa Wonjezerani-Ex. Dinani batani Pitani ku.



3. Timalowa pazenera zowonjezera. Chongani bokosi pafupi Mapaketi Osanthula ndipo dinani batani "Zabwino".

Pambuyo pa izi, phukusi "Kusanthula Kwambiri" adachitapo kanthu, ndipo batani lolinganirana lidawonekera pa riboni tabu "Zambiri".

Tsopano tiyeni tiwone momwe mungagwiritsire ntchito mwachindunji mawonekedwe a phukusi. Kusanthula kwa deta njira yosunthira pang'ono. Tiyeni tineneratu za mwezi wakhumi ndi chiwiri kutengera chidziwitso cha chuma cha kampaniyi masiku 11 apitawa. Kuti tichite izi, tidzagwiritsa ntchito tebulo lodzala ndi deta, komanso zida Phukusi la kusanthula.

1. Pitani ku tabu "Zambiri" ndipo dinani batani "Kusanthula Kwambiri", yomwe imayikidwa pa riboni ya chida mu chipika "Kusanthula".



2. Mndandanda wazida zomwe zimapezeka Phukusi la kusanthula. Sankhani dzina kuchokera kwa iwo Kusunthira Pakati ndipo dinani batani "Zabwino".



3. Windo lolowera deta yosuntha pafupifupi

   M'munda Kulowetsa Kuyimitsa sonyezani adilesi yamagulu omwe ndalama zomwe zimapangidwa pamwezi zimapezeka popanda selo momwe deta imayenera kuwerengedwera.

   M'munda Pakatikati Muyenera kutanthauza kuti pakhale njira yokwaniritsira zinthu mwanzeru. Choyamba, tiyeni tiike mtengo wotsekemera mpaka miyezi itatu, motero lowetsani manambala "3".

   M'munda "Patuluka Pakatikati" muyenera kutchula mndandanda wopanda kanthu patsamba pepala lomwe chidziwitsocho chiziwonetsedwa pambuyo pokonzanso, chomwe chiyenera kukhala khungu limodzi kuposa cholowereracho.

   Onaninso bokosi pafupi ndi paramayo. "Zolakwika wamba".

   Ngati ndi kotheka, mutha kuyang'ananso bokosi pafupi "Zithunzi kuchitira chiwonetsero chowoneka, ngakhale kwa ife izi sizofunikira.

   Pambuyo mawonekedwe onse atapangidwa, dinani batani "Zabwino".



4. Pulogalamuyi imawonetsa zotsatira za kukonza.



5. Tsopano tithandizira kuwongolera kwa miyezi iwiri kuwulula zomwe zili zolondola. Pazifukwa izi, yambitsaninso chidacho. Kusunthira Pakati Phukusi la kusanthula.

   M'munda Kulowetsa Kuyimitsa timasiya zofanana ndi zomwe zidachitika kale.

   M'munda Pakatikati ikani nambala "2".

   M'munda "Patuluka Pakatikati" fotokozerani adilesi yatsopano yopanda pake, yomwe, iyeneranso kukhala foni imodzi yayikulupo

   Makonda omwe atsalira asiyidwa osasinthika. Pambuyo pake, dinani batani "Zabwino".



6. Kutsatira izi, pulogalamuyo imawerengera ndikuwonetsa zotsatira zake pazenera. Kuti tidziwe kuti ndi iti mwa mitundu iwiriyi yolondola kwambiri, tiyenera kuyerekezera zolakwika zoyenera. Zocheperako chizindikiro ichi, ndizokulirapo pakuwonetsetsa kwa chotsatira. Monga mukuwonera, pazotsatira zonse, zolakwika zodziwika pakubwezeranso miyezi iwiri ndizochepa kuposa chizindikiritso chomwecho kwa miyezi itatu. Chifukwa chake, mtengo woloseredwa wa Disembala ukhoza kuonedwa ngati mtengo womwe wawerengedwa ndi gawo lotsiriza la nthawi yomaliza. M'malo mwathu, mtengo uwu ndi ma ruble 990.4 zikwi.

Njira 2: kugwiritsa ntchito ntchito ya AVERAGE

Ku Excel pali njira ina yogwiritsira ntchito njira yosuntha yapakati. Kuti mugwiritse ntchito, muyenera kuyika ntchito zingapo za pulogalamu, zoyambirira zomwe cholinga chathu ndi NJIRA. Mwachitsanzo, tikugwiritsa ntchito gome limodzilimodzi la bizinesi monga momwe zinalili poyamba.

Pomaliza, tifunika kupanga nthawi yoyenda bwino. Koma nthawi ino, zomwe tikuchitazi sizingokhala zokha. Muyenera kuwerengera pafupifupi awiri, kenako miyezi itatu, kuti athe kufananitsa zotsatira.

Choyamba, timawerenga kuchuluka kwa magawo awiri apambuyo pogwiritsa ntchito ntchitoyo NJIRA. Titha kuchita izi kuyambira mwezi wa Marichi okha, chifukwa m'masiku amtsogolo palinso kusiyana m'makhalidwe.

1. Sankhani khungu m'mizere yopanda kanthu mu Marichi. Chotsatira, dinani pazizindikiro "Ikani ntchito"yomwe imayikidwa pafupi ndi baramu yamu formula.



2. Zenera limayatsidwa Ogwira Ntchito. Gulu "Zowerengera" kufunafuna tanthauzo SRZNACH, sankhani ndikudina batani "Zabwino".



3. Woyendetsa Window Window Woyambitsa NJIRA. Syntax ndi motere:

   = AVERAGE (nambala1; nambala2; ...)

   Mkangano umodzi wokha ndi wofunikira.

   M'malo mwathu, m'munda "Nambala1" tiyenera kupereka kulumikizana ndi komwe ndalama zomwe zakhala zikugawidwa kale (Januware ndi February) zikuwonetsedwa. Khazikitsani chidziwitso mumunda ndikusankha maselo lolingana pa pepalali Ndalama. Pambuyo pake, dinani batani "Zabwino".



4. Monga mukuwonera, zotsatira za kuwerengera mtengo wapakati panthawi ziwiri zapitazi zinawonetsedwa mchipindamu. Kuti tiwerengere mofananamo kwa miyezi ina yonse ya nthawiyo, tifunika kutsata njira iyi ku maselo ena. Kuti tichite izi, timakhala chidziwitso pakona yakumunsi kwa khungu lomwe lili ndi ntchitoyo. Chopata chimasinthidwa kukhala cholembera, chomwe chimawoneka ngati mtanda. Gwirani pansi batani lakumanzere ndikulikoka mpaka kumapeto kwenikweni kwa mzati.



5. Timalandira kuwerengera kwa zotsatira za mtengo wapakati wamiyezi iwiri yapitayo chaka chisanafike.



6. Tsopano sankhani selo mu mzere wopanda kanthu mu mzere wa Epulo. Imbani zenera yotsutsa ntchito NJIRA momwemonso monga zidafotokozedwera kale. M'munda "Nambala1" lowetsani zolumikizana zama cell mu mzere Ndalama Januwale mpaka Marichi. Kenako dinani batani "Zabwino".



7. Gwiritsani ntchito chodzaza



8. Chifukwa chake, tidawerengera zotsalazo. Tsopano, monga momwe zinalili ndi nthawi yapita, tifunikira kudziwa mtundu wa kusanthula bwino: ndi kuwongola pa miyezi iwiri kapena itatu. Kuti muchite izi, kuwerengera kupatuka komanso zizindikilo zina. Choyamba, timawerengera kupatuka kwathunthu pogwiritsa ntchito mtundu wa Excel ABS, omwe m'malo mwa manambala abwino kapena osalimbikitsa amabwerera modulus. Mtengo uwu udzakhala wofanana ndi kusiyana pakati pa chizindikiritso chenicheni cha mwezi wosankhidwa ndi cholosera. Khazikitsani cholowezera patsamba lotsatira lopanda kanthu mu mzere wa Meyi. Timayimba Fotokozerani Wizard.



9. Gulu "Masamu" sankhani dzina la ntchito "ABS". Dinani batani "Zabwino".



10. Tsamba la mkangano wa ntchito likuyamba ABS. M'munda umodzi "Chiwerengero" Sonyezani kusiyana pakati pazomwe zili m'maselo Ndalama ndi 2 miyezi kwa Meyi. Kenako dinani batani "Zabwino".



11. Pogwiritsa ntchito chikhomo, koperani formula iyi ku mizere yonse ya tebulo kudzera mu Novembala yonse.



12. Timawerengera phindu la kupatuka kotheratu kwa nyengo yonseyo pogwiritsa ntchito ntchito yomwe tikudziwa kale NJIRA.



13. Timachitanso chimodzimodzi kuti tiwone kupatuka kwathunthu kwa omwe akusuntha m'miyezi itatu. Choyamba, ikani ntchitoyo ABS. Pokhapokha pokhapokha timaganizira zakusiyana pakati pazomwe zili m'maselo ndi ndalama zenizeni ndi zomwe zimakonzedwa, kuwerengeka pogwiritsa ntchito njira yosunthira kwa miyezi 3.



14. Chotsatira, timawerengera mtengo wapakatikati wazidziwitso zonse zopatuka pogwiritsa ntchito ntchito NJIRA.



15. Gawo lotsatira ndikuwerengera kupatuka kwa wachibale. Ndizofanana ndi kuchuluka kwa kupatuka kwathunthu kuzizindikiro. Pofuna kupewa zoyipa, tikugwiritsanso ntchito zomwe angathe kuchita ABS. Nthawiyi, pogwiritsa ntchito ntchitoyi, timagawaniza mtengo wokhotakhota tikamagwiritsa ntchito njira ya miyezi iwiri yosakira ndi ndalama zenizeni za mwezi wosankhidwa.



16. Koma kupatuka kwa wachibale nthawi zambiri kumawonetsedwa mwa mawonekedwe. Chifukwa chake, sankhani mtundu woyenera patsamba, pitani tabu "Pofikira"komwe kuli bokosi la chida "Chiwerengero" mu gawo lopanga masanjidwe tikhazikitsa mawonekedwe. Pambuyo pake, zotsatira za kuwerengera kwakupatuka kwawonetsedwa peresenti.



17. Timachitanso ntchito yofanizira kuwerengera kupatuka ndi deta pogwiritsa ntchito yosalala kwa miyezi itatu. Pazomwezi, powerengera ngati gawo logawaniza, timagwiritsa ntchito mzere wina wa tebulo, womwe tili nalo dzinalo "Amayi. (3m)". Kenako timamasulira kuchuluka kwa manambala kukhala fomu.



18. Pambuyo pake, timawerengera za mtengo wapakati wazigawo zonse ziwiri ndikupatuka, monga asanagwiritse ntchito NJIRA. Popeza timatenga kuchuluka kwa magawo awiri ngati mfundo zantchitoyo, sitifunikira kutembenuza kowonjezera. Wogwira ntchitoyo amapereka zotsatira zake kale mumitundu.



19. Tsopano tafika powerengera kupatuka kwakuthupi. Chizindikirochi chitilola kuti tiyerekeze mtundu wa mawerengedwe akamagwiritsa ntchito miyezi iwiri ndi itatu. M'malo mwathu, kupatuka kwofananira kudzakhala kofanana ndi muzu wapakati pazowerengeka zamabwalo pazosiyana pazachidziwikire ndi kuchuluka kosunthika komwe kumagawidwa ndi chiwerengero cha miyezi. Pofuna kuwerengera mu pulogalamuyi, tiyenera kugwiritsa ntchito ntchito zingapo, makamaka MUTHA, SUMMARY ndi ACCOUNT. Mwachitsanzo, kuwerengera njira yolakwika mukamagwiritsa ntchito chingwe chowoneka bwino kwa miyezi iwiri mu Meyi, kwa ife, njira iyi idzagwiritsidwa ntchito:

    = ROOT (SUMMARY (B6: B12; C6: C12) / COUNT (B6: B12))

    Ikolereni ku maselo ena mzerewo ndikuwerengera kupatuka kwakanthawi pogwiritsa ntchito chikhomo chodzaza.



20. Ntchito yofananira kuwerengera kupatuka kwakanthawi kumachitika kwa osunthira oyenda kwa miyezi itatu.



21. Pambuyo pake, timawerengera phindu la nthawi yonse yonse yazisonyezo zonsezi, ndikugwiritsa ntchito ntchitoyo NJIRA.



22. Poyerekeza kuwerengera komwe tikugwiritsa ntchito njira yosunthira yosunthika ndi miyezi iwiri ndi itatu yoyendetsera zofunikira monga kupatuka kotheratu, kupatuka kwachibale komanso kupatuka kwofananira, titha kunena motsimikiza kuti kuwongolera kwa miyezi iwiri kumapereka zotsatira zodalirika kuposa kugwiritsa ntchito kuwongolera kwa miyezi itatu. Izi zikuwonetsedwa ndikuti zowonetsa pamwambapa kwa miyezi iwiri yoyenda ndizochepa poyerekeza ndi mwezi umodzi.



23. Chifukwa chake, chisonyezo cholosera cha kampaniyo cha Disembala chikhala ma ruble 990.4. Monga mukuwonera, phindu limayenderana kwathunthu ndi zomwe tidapeza powerengera zida Phukusi la kusanthula.

Phunziro: Excel Feature Wizard

Tidawerengera zam'mwambowu pogwiritsa ntchito njira yosunthira m'njira ziwiri. Monga mukuwonera, njirayi ndiyosavuta kuchita pogwiritsa ntchito zida. Phukusi la kusanthula. Komabe, ogwiritsa ntchito ena sakhala ndi chidaliro nthawi zonse ndipo amafuna kugwiritsa ntchito ntchitoyo kuti awerengere. NJIRA ndi ogwiritsira ntchito okhudzana kuti atsimikizire njira yodalirika kwambiri. Ngakhale, ngati zonse zachitika molondola, kutulutsa kowerengera kuyenera kukhala chimodzimodzi.